Spreadsheet Basics Quiz

Light gray lines that divide each of the cells, rows, and columns in a spreadsheet

• Cell Location

• Worksheet

• Gridlines

• Sparkline

To combine into one

• Merge

• Filter

• Import

• Sort

A formula or equation used to generate an answer

• Autofill

• Function

• Cell Reference

• AutoSum

A tool which fills in a field or cells automatically

• AutoSum

• Import

• Merge

• Autofill

The vertical parts of a spreadsheet denoted by capital letters

• Rows

• Cell Reference

• Cell Location

• Columns

The horizontal parts of a spreadsheet denoted by numbers

• Cell

• Rows

• Relative Reference

• Columns

Referring to a rectangle on a spreadsheet by naming the column and then row in which it lies

• Sparkline

• Absolute Reference

• Cell Reference

• Cell Location

The rectangular fields you can type in on a spreadsheet formed when a column and row intersect

• Painter

• Worksheet

• Cell

• Workbook

The entire spreadsheet file you are working in. It can contain one or more worksheets

• Workbook

• Painter

• Cell Reference

• Worksheet

A part/page on a spreadsheet file you are working in

• Workbook

• Sparkline

• Cell Location

• Worksheet