G-8 Spreadsheet Formula and Functions

What do all formulas begin with?

• %
• [ ]
• =
• :

What symbol do we use for multiplication in a Spreadsheet program? 

• /
• =
• ^
• *

What symbol do we use for division in a Spreadsheet program? 

• /
• *
• +
• =

Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?

• A4-A3=
• A3-A4=
• =A4-A3
• =A3-A4

Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?

• =27/A3
• = A3/27
• = 27^A3
• =A3*27

Which of the following formulas will add cells A1 thru A5?

• =SUM(A2+A5)
• =A1+A2+A3+A4+A5
• =A1:A5
• =A1-A2-A3-A4-A5

Which of the following is a formula that will multiply cells A1 and A2?

• A1*A2
• =A1:A2
• =A1*A2
• =Multiply(A1:A2)

Which of the following is a formula that will divide cell D10 by 2?

• =D10/A2
• 10/2
• =D10*2
• =D10/2

Which of the following is a correct example using the AUTOSUM function?

• sum(D14:D19)
• =D14:d19
• =sum(D14:D19)
• =D14+D15+D16+D17+D18+D19

__________ function that counts the number of cells that contains numeric value.

• IF

• MAX

• COUNT

• LEN