Unit 6 | Spreadsheet Vocabulary

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

• Sparkline

• Gridlines

• Worksheet

• Cell Location

A tool that allows you to copy animations or formatting easily from one object to another

• Painter

• Function

• Autofill

• Workbook

To format data in such a way that it can be used by another application

• Autofill

• Export

• Import

• Merge

To use data produced by another program

• Filter

• Import

• Export

• Sort

To combine into one

• Sort

• Filter

• Import

• Merge

A formula or equation used to generate an answer

• Cell Reference

• Function

• Autofill

• AutoSum

A tool which fills in a field or cells automatically

• AutoSum

• Import

• Autofill

• Merge

The vertical parts of a spreadsheet denoted by capital letters

• Cell Location

• Columns

• Rows

• Cell Reference

The horizontal parts of a spreadsheet denoted by numbers

• Rows

• Columns

• Cell

• Relative Reference

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

• Cell Location

• Absolute Reference

• Cell Reference

• Sparkline