BIS-155 Final Exam Practical Problems
Car Parts Service (v-5)
Name:
Jennifer Nichols
Date:
1/27/2017
Purpose: To offer recommendation's to increase business profits.
Car Parts Service - Sales by Product
Category
Auto Parts
Auto Supplies
Auto Supplies
Auto

Excel Data Exchange (graded)
Excel 2013 provides the capability to exchange data with other applications. Discuss the
different types of ways to exchange data between Excel and other Microsoft applications.
Are there limitations to the exchange process? T

Getting Familiar With Excel (graded)
Excel was introduced in 1985. Since then, it has become a standard business tool.
1. Discuss and explain at least six different (unique) features of Excel that make it a
valuable business tool.
2. Discuss what type of

X A B E C D 6. a) If , which angle of corresponds to of
? b) If , which side of corresponds to side of ? 7. A
sphere is the three-dimensional surface that
contains all points in space lying at a fixed distance
from a point known as the center of the spher

with six elements. Solution The number of subsets is
26 , or 64. NOTE: There are 32 subsets for a set
containing five elements; consider cfw_a, b, c, d, e. In
closing, we note that only a few of the principles
based upon Pascals Triangle have been explore

Congruent Polygons Corresponding Vertices, Angles,
and Sides 5.2 Similar Polygons KEY CONCEPTS When
two geometric figures have exactly the same shape,
they are similar; the symbol for is similar to is '.
When two figures have the same shape (') and all
co

second triangle ( ) is constructed so that and . a) Is
congruent to ? b) Using intuition (appearance), does
it seem that is similar to ? ABC XTN T B X A
N C ABC XTN AE BF / AB! 7 DC! 7 EF! BF AE /
AB! 7 DC! 7 EF! 10 10 6 B C A T N X R S T U W 36.
Given ,

15. In (not shown), and . a) Name the shortest side.
b) Name the longest side. 16. In (not shown), and .
List the sides in order of their lengths, starting with
the smallest side. ABC mA = 40 mB = 65 PQR
mP = 67 mQ = 23 D A B C 80 55 30 19.
Which of the f

particular recipe, the statement below is an
extended proportion comparing numbers of eggs to
numbers of cups of milk: 2eggs 3cups = 4eggs 6cups
= 6eggs 9 cups a b = c d = e f = . . . - B 1 3 A 2 - 3 3 =
8 - 12 12 B 5 3 A 2 + 3 3 = 8 + 12 12 2 3 = 8 12 Ex

intersects at point D. Now construct perpendicular
to and with E on . In terms of a, b, and c, find the
length of . EA DE AB AB B CA mC = 90 BD CD
AB AC Q R m S P M A B D C D A B C Lemma
Inequality of Sides and Angles in a Triangle The
Triangle Inequality

CD! AB! CD! 1. Given 2. Given 3. If two lines are
to the same line, they are parallel 4. If both pairs of
opposite sides of a quadrilateral are , the
quadrilateral is a 5. Opposite sides of a are
congruent Geometry in the Real World Exs. 711
An altitude

Data Analysis Tools (graded)
1. Excel provides many different ways in which to analyze data. Discuss the different
methods by which you can analyze data in your spreadsheet. That is, try an Internet
search for "data analysis with excel" or use some of the

Data Consolidation and What-If Analysis (graded)
1. Discuss and compare the group summations and What-If analysis (Consolidation) Excel
tools. You may need to look up (research) the group summations.
2. Under what circumstances would you use each of these

Uses and Applications of Statistics (graded)
More than 100 years ago, H.G. Wells commented that "statistical thinking will one day be as
necessary as the ability to read and write." If you were to google "statistics for managers", you
will see a list of a

Upper Saddle River Marching Band - Fundraising Event
Jennifer Nichols
3/5/2016
Board of Directors Presentation on Fundraising Sales to date
Upper Saddle River Marching Band - Fundraising Event
Band Booster Equipment Sales through Day 10
Item
Tee Shirt
Bas

Student Education Trust Fundraiser
Author
Date
Purpose
Jennifer Nichols
1/27/2017
Create letters, and mailing labels for
a fundraising event.
FirstName
Shelly
Kelly
Kim
Donna
Huong
George
Marion
Catherine
Christopher
G
George
Kristen
Kim
Dan
Huong
Robert

Shelly Martin
123 North Street
Pittsburgh, PA 15697
Kelly Kripton
456 North Street
Pittsburgh, PA 15697
Kim Jansen
678 North Street
Pittsburgh, PA 15697
Donna Reed
901 North Street
Pittsburgh, PA 15697
Huong Pham
P.O. Box ABC
Pittsburgh, PA 15697
George M

Regional Realty Association Data Analysis
Author
Date
Purpose
Jennifer Nichols
1/27/2017
Analyze the claim made by Luke Liberty Realty
that "we get your price" by analyzing three
months of sales data.
Analysis
At Luke Liberty Realty you definitely get you

Quest Financials
Memo
To:
Main Branch
From:
Jennifer Nichols
cc:
San Francisco, Denver, & Boston Branch
Date:
04/23/2016
Re:
Top/Lowest Sales
As you can see by our analysis your two top selling products are Tires, and Car Jacks which I
have highlighted in

First national Bank New Loan Report
Author
Date
Jennifer Nichols
27-Jan-17
Monthly "New Loan Report for the Board of Directors to list and summarize
Purpose all new loans for residential housing in the past month.
First National Bank - New Loans
Customer

Summit Ridge Mountain Resort
Village Shop Sales
Created By
Date
Purpose
Documentation
Sales Data
Daily Sales
Total Quantity Sold
Percentage of Sales
Weekly Profits
April Nash
10/27/2016
Workbook On Village Shop Sales To Date
Contains Sales Data and Calcul

Summit Ridge Mountain Resort
Village Shop Sales
Created By
Date
Purpose
Documentation
Sales Data
April Nash
10/27/2016
Workbook On Village Shop Sales To Date
Contains Sales Data and Calculations From Sales Data
Professor Christie Rush
April Nash
Summit Ri

Bringing It All Together (graded)
This week will be an opportunity to share ideas and approaches to the Excel course project due
this week.
1. What are some spreadsheet features you will use to make your spreadsheet professional,
readable, reliable, and r

Formulas and Functions (graded)
One of the benefits of Excel is the ability to use formulas and functions.
Discuss the differences between formulas and functions. Pick a function in Excel and discuss
how that function is used to calculate results in your

DE mA 6 mD ABC DEF 34. Prove by the indirect
method: The length of a diagonal of a square is not
equal in length to the length of any of the sides of
the square. 35. Prove by the indirect method:
Given: is not isosceles Prove: 36. Prove by the
indirect me

angles have measures of 36 and 54. Alternative
Solution Because the measures of the angles are in
the ratio 2:3, let their measures be 2x and 3x.
Because the angles are complementary, Now and ,
so the measures of the two angles are 36 and 54.
2x = 36 3x =

7 AB AC 7 BC LEMMA 3.5.1 PROOF By the SegmentAddition Postulate, . According to the Ruler
Postulate, (meaning BC is positive); it follows that .
Similarly, . These relationships follow directly from
the definition of . a 7 b BC 7 0 AC 7 AB AC 7 BC AC =
AB

the length of . Applying the Means-Extremes
Property, To have a permissible length for , the
geometric mean is the positive solution. Thus, or AD
= 216 AD L 4.90. AD x = ;124 = ;14 # 6 = ;14 # 16 = ;
216 x2 = 24 AD 4 x = x 6 DC = BC - BD DC = 10 - 4 = 6
B

similar polygons in the same order. For instance, if
pentagon ABCDE is similar to pentagon MNPQR,
then we know that , , , , , , , , , and . Because of the
indicated correspondence of vertices, we also know
that AB MN = BC NP = CD PQ = DE QR = EA RM C
P D

in. to 15 in. d) 1 ft to 18 oz 2. a) 20 to 36 c) 20 oz to
2 lb (1 lb = 16 oz) b) 24 oz to 52 oz d) 2 lb to 20 oz 3.
a) 15:24 c) 2 m:150 cm (1 m = 100 cm) b) 2 ft:2 yd (1
yd = 3 ft) d) 2 m:1 lb 4. a) 24:32 c) 150 cm:2 m b) 12
in.:2 yd d) 1 gal:24 mi In Exe