Spreadsheet Formulas

What do all formulas begin with?

• %
• [ ]
• =
• :

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

• /
• =
• ^
• *

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

• /
• +
• =
• *

What symbol do we use for subtraction 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 add cells C9 and C10?

• =C9+C10
• C9+C10
• =C9:C10
• =C9*C10

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

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