SpreadSheet Practice Test
Questions 1 through 5 are based on the lawn mowing spreadsheet below
Click on the How did you do button at the bottom to see how many you got right!
1. The address of the first cell in July is
a. 3
b. July 1st
c. a value
d. c4
2. To get the total yards mowed in cell e4 you could
a. position your mouse in cell e4 and enter =b4+c4+d4
b. position your mouse in cell e4 and enter =sum(b4:d4)
c. highlight cells b4, c4 and d4 and click on the sum function icon
d. all of the above
3. To tell the spreadsheet program that a formula is to follow, you must first put what type of sign in front of the formula?
a. #
b. =
c . *
d. /
4. To get Income in column G you would
a. highlight cells B4,C4 and D4 and click on the sum function icon.
b. in cell g4 you would enter =e4*f4 and then =e5*f5 for row 5, =e6*f6 for row 6 and so on.
c in cell g4 you would enter =e4+g4 and then =e5+g5 for row 5, =e6+g6 for row 6 and so on.
d.in cell g4, you would enter =b4+c4+d4*3 and then in g5, =b5+c5+d5*3 and so on.
5. The correct way to get the minimum in cell B10 is to
a. Look in the column and see the answer.
b. highlight all the numbers in column B and click on the Sum function.
c . highlight all the numbers in column B and click on the min function.
d. click in cell B10, select Insert, function, Min and change the range to b4:b8.