CGS 2518 MODULE #2 EXAM
QUESTIONS AND ANSWERS
probability between 0 and 1 - Answer-the formula= RAND() gives what result
=ROUND(AVERAGE(A10:A20), -1 - Answer-what formula could you write to find the
average values in cells a10-a20, excluding blank cells, rounding to the nearest 10
=AVERAGEIF(A2:A11, "Ford", B2:B11) - Answer-write formula from worksheet on page
153 to determine only the average price of only ford vehicles
=RANDBETWEEN(10,20) - Answer-write a formula to generate a random integer value
between 10 and 20
=MEAN(2,5,4,3,1,2,7) - Answer-What formula could you write to calculate the mean of
the following data set: 2 5 4 3 1 2 7
the data set with the lesser deviation is more closely compact, and there is less
variation from the median - Answer-A certain data set is given a standard deviation of
1.58 and its compared to another data set with the same mean but a standard deviation
of 2.5. What general differences would you expect to find between the two sets of data
=(37.5-35)/35 - Answer-if a change occurs from getting paid $35 a hour to getting paid
$37.50 what algebraic formula could you write to determine the percent change in wage
False - Answer-when using the increase decimal button on the toolbar, the precise
value in the cell is modified. True or false
345 - Answer-the formula =ROUND(345.43, 0) results in what precise value
=ROUNDUP(0.6334,2) - Answer-write a formula to round up 63.34% to the nearest
percent
>= - Answer-what is the symbol for the greater than or equal to relational operation in
excel
<> - Answer-what is the symbol for the not equal to relational operator in excel
=COUNTIF(A2:A11,"GM") - Answer-look at bottom of page 153 and write a formula to
determine the number of GM cars on this list
=COUNTIF(B2:B11 , <20,000) - Answer-use sheet on page 153 and write a formula
determining how many cars cost less than $20,000
QUESTIONS AND ANSWERS
probability between 0 and 1 - Answer-the formula= RAND() gives what result
=ROUND(AVERAGE(A10:A20), -1 - Answer-what formula could you write to find the
average values in cells a10-a20, excluding blank cells, rounding to the nearest 10
=AVERAGEIF(A2:A11, "Ford", B2:B11) - Answer-write formula from worksheet on page
153 to determine only the average price of only ford vehicles
=RANDBETWEEN(10,20) - Answer-write a formula to generate a random integer value
between 10 and 20
=MEAN(2,5,4,3,1,2,7) - Answer-What formula could you write to calculate the mean of
the following data set: 2 5 4 3 1 2 7
the data set with the lesser deviation is more closely compact, and there is less
variation from the median - Answer-A certain data set is given a standard deviation of
1.58 and its compared to another data set with the same mean but a standard deviation
of 2.5. What general differences would you expect to find between the two sets of data
=(37.5-35)/35 - Answer-if a change occurs from getting paid $35 a hour to getting paid
$37.50 what algebraic formula could you write to determine the percent change in wage
False - Answer-when using the increase decimal button on the toolbar, the precise
value in the cell is modified. True or false
345 - Answer-the formula =ROUND(345.43, 0) results in what precise value
=ROUNDUP(0.6334,2) - Answer-write a formula to round up 63.34% to the nearest
percent
>= - Answer-what is the symbol for the greater than or equal to relational operation in
excel
<> - Answer-what is the symbol for the not equal to relational operator in excel
=COUNTIF(A2:A11,"GM") - Answer-look at bottom of page 153 and write a formula to
determine the number of GM cars on this list
=COUNTIF(B2:B11 , <20,000) - Answer-use sheet on page 153 and write a formula
determining how many cars cost less than $20,000
