General Review Grade 8

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 FORMULA that will add cells c9 and c10?

• =c9+c10
• c9+c10
• sum(c9:c10)
• =sum(c9:c10)

A simple mathematical equation that is used to calculate spreadsheet values is called a 

• value
• formula
• function
• label

A cell range is indicated by which symbol?

• :
• -
• /
• *

A1:D4 is an example of a cell...

• Range
• Selection
• Highlight
• Choice

Putting cells into A-Z order is called?

• Sort Ascending
• Sort Descending
• Filter Ascending
• Filter Descending

Which of the following is a valid formula?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)

G5 is an example of a?

• Relative Cell Reference
• Cell Coordinate
• Absolute Cell Reference
• Cell Specification

This is a multiplication formula

• 8x7
• 8*7
• 8x7=
• =8*7