Spreadsheet Formulas & Functions

All functions and formulas begin with which symbol?

• #
• /
• :
• =

What is the FUNCTION that will add cells D14, D15, D16, D17, D18, and D19?

• =sum(D14:D19)

• =D14:d19

• =sum(D14-D19)

• =D14+D15+D16+D17+D18+D19

In a spreadsheet, =max(B3:B10) is called a

• function

• cell range

• formula

• value

=sum(F4:F12) does what?

• finds the average in a range of cells

• finds the lowest value in a range of cells

• adds up a range of cells

• finds the highest value in a range of cells

Which of the following is a FORMULA that will add cells C9 and C10?

• =C9+C10

• C9+C10

• sum(C9:C10)

• =sum(C9:C10)

In a spreadsheet, =B3*B4 is a

• value

• formula

• function

• label

A worksheet instruction that performs a calculation is called a

• value

• formula

• function

• label

A cell range is indicated by which symbol?

• :
• -
• /
• *

The cell that is currently clicked

• cell
• active cell
• cell range
• cell reference

The column letter followed by the row number

• range
• cell reference
• value
• function