CGS 2518 MIDTERM EXAM QUESTIONS
WITH CORRECT ANSWERS
Syntax - Answer-the name and order of arguments for a function
Arguments - Answer-an input of a function presented in a specific order
Algorithm - Answer-a step-by-step procedure that is programmed into a function that
governs how that function works
If you copy the formula =$B$4-SUM(C1:C5) from cell A9 to cell B11, what is the
resulting formula? - Answer-=$B$4-SUM (D3:D7)
Refer to the following worksheet. What formula would you write in cell B2 that can be
copied down the column and across the row to complete the multiplication table?
ABCDEFG
112345
2112345
3 2 2 4 6 8 10
4 3 3 6 9 12 15
5 4 4 8 12 16 20
6 5 5 10 15 20 25
7 - Answer-=$A2*B$1
What new formula results for =A1+A2 if you copy it from cell C10 to cell E12? - Answer-
=C3+C4
What new formula results for =$A$1+A2 if you copy it from cell C10 to cell E12? -
Answer-=$A$1+C4
What new formula results for =$A1+A2 if you copy it from cell C10 to cell E12? -
Answer-=$A3+C4
What new formula results for =A$1+A2 if you copy it from cell C10 to cell E12? -
Answer-=C$1+C4
What formula could you use to add up cell C1 from Sheet1!, Sheet 2!, and Sheet 3! -
Answer-=SUM('Sheet1:Sheet3'!C1)
Cell B1 has been given the range name discount. How would you write a formula in cell
C1 that multiplies discount by cell A1? What new formula results if you copy this formula
into cell C2? - Answer-=discount*A1
=discount*A2
, What formula could you write to calculate the mean of the following data set: 4, 10, 8, 6,
2, 4, 14? ( Note that a resulting value is not required.) - Answer-=AVERAGE (4, 10, 8, 6,
2, 4, 14)
What is the median value of the following data set: 4, 10, 8, 6, 2, 4, 14? - Answer-
=MEDIAN (4,10, 8, 6, 2, 4, 14)
What is the mode of the following data set: 4, 10, 8, 6, 2, 4, 14? - Answer-4
The following data set 4, 10, 8, 6, 2, 4, 14 has a standard deviation of 4.14 compared
with another data set that has the same mean but a standard deviation of 2.5. What
general differences would you expect to find between the two sets of data? - Answer-It
means that the numbers in the first set are more dispersed from the arthritic means than
the second set of numbers. The difference is cause by more or less numbers repeating,
causing the mean to stay the same but the standard variation to differ.
a wider range of value for the data with a bigger STDV
In the chapter, the original labor rate for QC inspectors was $35 per hour. However, due
to a contract renegotiation, this value is now $40. What mathematical expression could
you use to determine the percent increase in labor costs? ( Note that a resulting value is
not required.) - Answer-=(New Value-Old Value)/Old Value
=(40-35)/35
When you use the Increase Decimal button in the Number group on the HOME tab, the
precise value in the cell is modified. True or False? - Answer-False
The formula =ROUND (710.52, -1) results in what precise value? - Answer-710
Write a formula to round down 63.34% to the nearest percent. - Answer-
=ROUNDDOWN(63.34, 0)
What is the symbol for the less than or equal to relational operator in excel? - Answer-
<=(make sure to put in "<=")
What is the symbol for the not equal to relational operator in excel? - Answer-<>(make
sure to put in "<>")
Review the following worksheet, and then use the COUNTIF function to write a formula
that determines the number of Ford Cars on this list.
ABC
1 MAKE PRICE
2 FORD $ 16,929
3 GM 13,999
WITH CORRECT ANSWERS
Syntax - Answer-the name and order of arguments for a function
Arguments - Answer-an input of a function presented in a specific order
Algorithm - Answer-a step-by-step procedure that is programmed into a function that
governs how that function works
If you copy the formula =$B$4-SUM(C1:C5) from cell A9 to cell B11, what is the
resulting formula? - Answer-=$B$4-SUM (D3:D7)
Refer to the following worksheet. What formula would you write in cell B2 that can be
copied down the column and across the row to complete the multiplication table?
ABCDEFG
112345
2112345
3 2 2 4 6 8 10
4 3 3 6 9 12 15
5 4 4 8 12 16 20
6 5 5 10 15 20 25
7 - Answer-=$A2*B$1
What new formula results for =A1+A2 if you copy it from cell C10 to cell E12? - Answer-
=C3+C4
What new formula results for =$A$1+A2 if you copy it from cell C10 to cell E12? -
Answer-=$A$1+C4
What new formula results for =$A1+A2 if you copy it from cell C10 to cell E12? -
Answer-=$A3+C4
What new formula results for =A$1+A2 if you copy it from cell C10 to cell E12? -
Answer-=C$1+C4
What formula could you use to add up cell C1 from Sheet1!, Sheet 2!, and Sheet 3! -
Answer-=SUM('Sheet1:Sheet3'!C1)
Cell B1 has been given the range name discount. How would you write a formula in cell
C1 that multiplies discount by cell A1? What new formula results if you copy this formula
into cell C2? - Answer-=discount*A1
=discount*A2
, What formula could you write to calculate the mean of the following data set: 4, 10, 8, 6,
2, 4, 14? ( Note that a resulting value is not required.) - Answer-=AVERAGE (4, 10, 8, 6,
2, 4, 14)
What is the median value of the following data set: 4, 10, 8, 6, 2, 4, 14? - Answer-
=MEDIAN (4,10, 8, 6, 2, 4, 14)
What is the mode of the following data set: 4, 10, 8, 6, 2, 4, 14? - Answer-4
The following data set 4, 10, 8, 6, 2, 4, 14 has a standard deviation of 4.14 compared
with another data set that has the same mean but a standard deviation of 2.5. What
general differences would you expect to find between the two sets of data? - Answer-It
means that the numbers in the first set are more dispersed from the arthritic means than
the second set of numbers. The difference is cause by more or less numbers repeating,
causing the mean to stay the same but the standard variation to differ.
a wider range of value for the data with a bigger STDV
In the chapter, the original labor rate for QC inspectors was $35 per hour. However, due
to a contract renegotiation, this value is now $40. What mathematical expression could
you use to determine the percent increase in labor costs? ( Note that a resulting value is
not required.) - Answer-=(New Value-Old Value)/Old Value
=(40-35)/35
When you use the Increase Decimal button in the Number group on the HOME tab, the
precise value in the cell is modified. True or False? - Answer-False
The formula =ROUND (710.52, -1) results in what precise value? - Answer-710
Write a formula to round down 63.34% to the nearest percent. - Answer-
=ROUNDDOWN(63.34, 0)
What is the symbol for the less than or equal to relational operator in excel? - Answer-
<=(make sure to put in "<=")
What is the symbol for the not equal to relational operator in excel? - Answer-<>(make
sure to put in "<>")
Review the following worksheet, and then use the COUNTIF function to write a formula
that determines the number of Ford Cars on this list.
ABC
1 MAKE PRICE
2 FORD $ 16,929
3 GM 13,999
