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!

picture of lawn spreadsheet

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

position your mouse in cell e4 and enter =b4+c4+d4

position your mouse in cell e4 and enter =sum(b4:d4)

highlight cells b4, c4 and d4 and click on the sum function icon sum function

 

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?

#

=

*

/

 

4. To get Income in column G you would

icon. sum function

in cell g4 you would enter =e4*f4 and then =e5*f5 for row 5, =e6*f6 for row 6 and so on.

in cell g4 you would enter =e4+g4 and then =e5+g5 for row 5, =e6+g6 for row 6 and so on.

5. The correct way to get the minimum in cell B10 is to

highlight all the numbers in column B and click on the Sum function.

click in cell B10, select Insert, function, Min and change the range to b4:b8.