Spreadsheet Basics

A rectangular group of cells treated as a unit is a spreadsheet

• cell reference
• column
• range
• row

The intersection of a row and a column and is identified by a cell reference

• cell range
• cell
• cell reference
• active cell

Text, symbols, dates, or numbers not used in calculations are called

• functions
• labels
• values
• formulas

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:g12) does what?

• finds the average in a range of cells
• finds the lowest value in a range of cells
• add up a range of cells
• finds the highest value in a range of cells

Which of the following is a value?

• B6
• 37
• Cost
• =B2+C3

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 called

• value
• formula
• function
• label