Spreadsheet Revision

What does every formula in a spreadsheet start with?

• +

• A number

• =

• (

Which software would be used to create a spreadsheet?

• Access

• Excel

• Word

• Powerpoint

Which formula is the best (and correct) for adding up a selection of numbers

• sum(A1+A10)

• =sum(A1+A10)

• =sum(A1:A10)

• sum(A1:A10)

Each box on a spreadsheet is called a ...

• row
• column
• cell
• box

Rows on a spreadsheet are identified by a ...

• number
• letter
• symbol
• smiley face

Columns on a spreadsheet are identified by a ...

• number
• letter
• space
• smiley face

Select ___________________ from the functions menu to find the smallest value in a group.

• max
• min
• sum
• average

The location of a cell on a spreadsheet. It is a column letter followed by a row number.

• Cell range
• Cell reference
• Active cell
• Row

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM