Spreadsheets Homework

Which of the following describes a cell reference?

• Displaying the data in the cell

• Naming a cell with column letter and row number

• Gives a cell a specific name

• Referring to a cell that is used once

What is an example of a cell reference?

• MRG

• 6A

• A6

• 555

Columns are named with?

• Numbers

• Letters

• Symbols

Rows are named with?

• Numbers

• Letters

• Symbols

A formula starts with?

• Equals ( = )

• Cell Reference (eg. A6)

• Brackets ( )

• Colon ( : )

Which symbol allows us to multiply in Excel?

• x

• +

• *

• -

• /

A white single square is known as?

• square

• column

• reference

• cell

• row

A SUM function...

• Adds values in selected cells

• Finds the smallest value

• Finds the largest value

• Finds the average value

A MAX function...

• Adds values in selected cells

• Finds the smallest value

• Finds the largest value

• Finds the average value

A MIN function...

• Adds values in selected cells

• Finds the smallest value

• Finds the largest value

• Finds the average value

• Subtracts the selected cells from each other (eg. D3-D4)