Spreadsheets Interim Homework

What are the individual boxes on a spreadsheet called?

• Squares

• Cells

• Entry boxes

• Boxes

What can be used to uniquely identify each cell in a spreadsheet?

• Cell reference

• Column heading

• Row number

• Row heading

What are the separate pages of a spreadsheet called?

• Spreadsheets

• Pages

• Worksheets

• Workbooks

What do you write to perform calculations in a spreadsheet?

• Computer programs

• Formulas

• Instructions

• Sums

What is "SUM" an example of?

• Instruction

• Formula

• Operation

• Function

If you are writing a formula in Excel what do you type at the start?

• =

• #

• :

• +

All the cells going across are called?

• Column

• Row

• Labels

• Fields

All the cells going down are called?

• Row

• Label

• Record

• Column

=SUM(A5:A14) Could also be calculated in Excel by which formula?

• =A5+A14

• =SUM A5:A14

• =A5+A6+A7+A8+A9+A10+A11+A12+A13+A14

• =A6+A13

Which feature allows a formula to be copied to another cell yet adjusting the cell reference to match?

• Copy and paste

• Autofill

• Sum

• Fill