Chapter - 14 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 is a formula that will add cells C9 and C10?

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

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

Cells that run horizontally on a spreadsheet

• Row
• Column
• Workbook
• Range

A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________

• CELL

• SELECTED RANGE

• ACTIVE CELL

• NONE