Spreadsheet Basics Quiz

Cells that run vertically in a spreadsheet are known as a

• row

• column

• table

• workbook

All formulas in a spreadsheet begin with a?

• Cell reference

• Label

• Equals sign

• Number

How can you merge multiple cells into one cell?

• Select the cells, right-click, and choose "Merge Cells"

• Select the cells, right-click, and choose "Insert Cells"

• Select the cells, right-click, and choose "Delete Cells"

• Select the cells, right-click, and choose "Format Cells"

What is the correct formula to add the values in cells A1 and B1 in a spreadsheet?

• `=A1*B1`

• `=A1+B1`

• `=A1-B1`

• `=A1/B1`

An individual address for a cell in a spreadsheet is called a?

• Co-ordinate

• Cell reference

• Cell location

• Box address

How do you change the background colour of a cell?

• Right-click the cell, select "Format Cells", and choose "Font"

• Right-click the cell, select "Format Cells", and choose "Border"

• Right-click the cell, select "Format Cells", and choose "Fill"

• Right-click the cell, select "Format Cells", and choose "Alignment"

What is the correct formula to divide the value in cell E1 by the value in cell F1?

• `=E1+F1`

• `=E1-F1`

• `=E1*F1`

• `=E1/F1`

Which is an example of a cell reference in a spreadsheet?

• 6C

• 45

• AC

• A5

A single page in a spreadsheet file is called a?

• Workbook

• Worksheet

• Spreadsheet

• Work page

What is the purpose of the Autofill handle?

• Copy data

• Move cells

• Delete rows

• Fill series