CGS 2518 MIDTERM 1 FSU EXAM
QUESTIONS AND ANSWERS
Chapter 1 #7
Referring to the preceding worksheet, if you wrote the formula =B1*5, what value would
result, assuming the displayed value is the precise value - Answer-.5
Chapter 1 #8
Referring to the preceding worksheet, if you wrote the formula =B1*5, what value would
result, assuming the displayed value is the precise value.58. What formula would you
write to do each of the following?
A.Add a range of numbers in cells B2:B12
B.Find the largest value in cells C2:F2
C.Find the smallest value in cells A1 through X10
D.Find the average value in cells C1 through C10, assuming blank cells will be ignored
E.Find the total number of values listed in cells A1 through F1, excluding any that
contain text - Answer-A. =SUM(B2:B12)
B.=MAX(C2:F2)
C.=MIN(A1:X10)
D.=AVERAGE(C1:C10)
E.=COUNT(A1:F1)
Chapter 1 #9
Define the following terms
A.Syntax
B.Arguments
C.Algorithm - Answer-A. The specific format of a function including the function name
and the order of the arguments
B. A function input
C. A rule that governs how a function works. A systematic set of procedures that the
computer always steps through to calculate the results of a function
Chapter 1 #10
, 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)
Chapter 1 #11
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? (see
number 11 in chapter 1 review for chart) - Answer-=B$1*$A2
Chapter 1 #12
What new formula results for each of the following formulas if you copy it from cell C10
to cell E12? A.=A1+A2
B.=$A$1+A2
C.=$A1+A2
D.=A$1+A2 - Answer-A.=C3+C4
B. =$A$1+C4
C. =$A3+C4
D. =C$1+C4
Chapter 1 #13
What formula could you use to add up cell C1 from Sheet1!, Sheet2!, and Sheet 3!
(assuming the worksheets are adjacent and in the same workbook? - Answer-=Sheet1!
C1+Sheet2!C1+Sheet3!C1
Chapter 1 #14
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 the
formula into cell C2? - Answer-A.=discount*A1
B.=discount*A2
Chapter 2 #1
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)
Chapter 2 #2
What is the median value of this data set? - Answer-=MEDIAN(4,10,8,6,2,4,14)
Chapter 2 #3
What is the mode of this data set? - Answer-=MODE(4,10,8,6,2,4,14)
Chapter 2 #4
The 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
QUESTIONS AND ANSWERS
Chapter 1 #7
Referring to the preceding worksheet, if you wrote the formula =B1*5, what value would
result, assuming the displayed value is the precise value - Answer-.5
Chapter 1 #8
Referring to the preceding worksheet, if you wrote the formula =B1*5, what value would
result, assuming the displayed value is the precise value.58. What formula would you
write to do each of the following?
A.Add a range of numbers in cells B2:B12
B.Find the largest value in cells C2:F2
C.Find the smallest value in cells A1 through X10
D.Find the average value in cells C1 through C10, assuming blank cells will be ignored
E.Find the total number of values listed in cells A1 through F1, excluding any that
contain text - Answer-A. =SUM(B2:B12)
B.=MAX(C2:F2)
C.=MIN(A1:X10)
D.=AVERAGE(C1:C10)
E.=COUNT(A1:F1)
Chapter 1 #9
Define the following terms
A.Syntax
B.Arguments
C.Algorithm - Answer-A. The specific format of a function including the function name
and the order of the arguments
B. A function input
C. A rule that governs how a function works. A systematic set of procedures that the
computer always steps through to calculate the results of a function
Chapter 1 #10
, 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)
Chapter 1 #11
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? (see
number 11 in chapter 1 review for chart) - Answer-=B$1*$A2
Chapter 1 #12
What new formula results for each of the following formulas if you copy it from cell C10
to cell E12? A.=A1+A2
B.=$A$1+A2
C.=$A1+A2
D.=A$1+A2 - Answer-A.=C3+C4
B. =$A$1+C4
C. =$A3+C4
D. =C$1+C4
Chapter 1 #13
What formula could you use to add up cell C1 from Sheet1!, Sheet2!, and Sheet 3!
(assuming the worksheets are adjacent and in the same workbook? - Answer-=Sheet1!
C1+Sheet2!C1+Sheet3!C1
Chapter 1 #14
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 the
formula into cell C2? - Answer-A.=discount*A1
B.=discount*A2
Chapter 2 #1
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)
Chapter 2 #2
What is the median value of this data set? - Answer-=MEDIAN(4,10,8,6,2,4,14)
Chapter 2 #3
What is the mode of this data set? - Answer-=MODE(4,10,8,6,2,4,14)
Chapter 2 #4
The 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
