CGS 2518 CHAPTER #2 ARMSTRONG
EXAM QUESTIONS AND ANSWERS
Write a formula to automatically determine the total value of all GM cars - Answer-
=SUMIF(A2:A10, "GM", B2:B10)
Explain the different between "what-if" analysis and Goal Seek - Answer--"what-if" gives
you various values for the formulas
-Goal Seek will find the right input when you know the result you want
Write a formula to determine the value of the third least expensive car - Answer-
=LARGE(B2:B10, 3)
If each car is marked up between $100 and $200 in dollar increments, what function
could be used to randomly assign the amount to be added to the car price in the
formula? =B2+_______ - Answer-=SUM((RANDBETWEEN(100,200)))
The formula =RAND() gives what results? - Answer-Gives a random value between 0
and 1
What formula could you write to average the values in cells B2 through B10, excluding
blank cells, rounded to the nearest whole number? - Answer-
=ROUND(AVERAGE(B2:B10), -1)
Write a formula to automatically determine the average price of only GM vehicles. -
Answer-=AVERAGEIF(A2:A10, "GM", B2:B10)
Write a formula to determine the total value of only vehicles priced below $20,000 -
Answer-=COUNTIF(B2:B10, "<20000")
What formula could you write to calculate the mean of the following data set: 4, 10, 8, 6,
2, 4, 14? - Answer-=MEAN(4+10+8+6+2+4+14)
What is the median value of the data set:4, 10, 8, 6, 2, 4, 14? - Answer-
=MEDIAN(4+10+8+6+2+4+14)
What is the mode of the data set:4, 10, 8, 6, 2, 4, 14? - Answer-
=MODE(4+10+8+6+2+4+14)
With a standard deviation of 4.14 compared to another set of data with the same mean
and a standard deviation of 2.5, what general differenced would you expect to find
between the two sets of data? - Answer-The standard deviation is a measure of how
widely the data values are dispersed from the arithmetic mean. There is going to be a
wider range of value.
EXAM QUESTIONS AND ANSWERS
Write a formula to automatically determine the total value of all GM cars - Answer-
=SUMIF(A2:A10, "GM", B2:B10)
Explain the different between "what-if" analysis and Goal Seek - Answer--"what-if" gives
you various values for the formulas
-Goal Seek will find the right input when you know the result you want
Write a formula to determine the value of the third least expensive car - Answer-
=LARGE(B2:B10, 3)
If each car is marked up between $100 and $200 in dollar increments, what function
could be used to randomly assign the amount to be added to the car price in the
formula? =B2+_______ - Answer-=SUM((RANDBETWEEN(100,200)))
The formula =RAND() gives what results? - Answer-Gives a random value between 0
and 1
What formula could you write to average the values in cells B2 through B10, excluding
blank cells, rounded to the nearest whole number? - Answer-
=ROUND(AVERAGE(B2:B10), -1)
Write a formula to automatically determine the average price of only GM vehicles. -
Answer-=AVERAGEIF(A2:A10, "GM", B2:B10)
Write a formula to determine the total value of only vehicles priced below $20,000 -
Answer-=COUNTIF(B2:B10, "<20000")
What formula could you write to calculate the mean of the following data set: 4, 10, 8, 6,
2, 4, 14? - Answer-=MEAN(4+10+8+6+2+4+14)
What is the median value of the data set:4, 10, 8, 6, 2, 4, 14? - Answer-
=MEDIAN(4+10+8+6+2+4+14)
What is the mode of the data set:4, 10, 8, 6, 2, 4, 14? - Answer-
=MODE(4+10+8+6+2+4+14)
With a standard deviation of 4.14 compared to another set of data with the same mean
and a standard deviation of 2.5, what general differenced would you expect to find
between the two sets of data? - Answer-The standard deviation is a measure of how
widely the data values are dispersed from the arithmetic mean. There is going to be a
wider range of value.
