Spreadsheet Vocabulary

Match the following spreadsheet Functions with their definitions

• the average of a data set

• Sum

• the middle value of a data set

• Median

• the total of all the values in a data set

• Mean

• difference between the highest and lowes

• Mode

• the value that appears most frequently in a data set

• Range

Match the following spreadsheet definitions

• Cell that has been selected

• Active Cell

• Function that adds ranges of cells

• Cell Address

• feature that allows you copy contents to

• AutoFill

• the rectangular shaped area

• Cell

• The name of the cell by column and row

• AutoSum

Match the following spreadsheet definitions

• Lines that separate columns and rows

• Formula

• Move an item by selecting it and then moving it while holding the mouse button down

• Column

• Horizontal spaces with numbers 1,2,3...

• Drag

• Vertical spaces with headings A,B,C...

• Row

• Mathematical expression used to perform calculations

• Cell Grid

Match the following spreadsheet definitions

• Extend data vertically

• Formula Bar

• Organize documents

• Function

• Extend data horizontally

• File

• Edit cell contents

• Fill Down

• Predefined formula

• Fill Right

Match the following spreadsheet definitions

• Navigation tool for different sheets in a workbook

• Workbook

• Column titles in a spreadsheet

• Label

• Single sheet within a workbook

• Worksheet

• Entire file containing multiple sheets

• Sheet Tabs

• Name or description for a cell or range of cells

• Headings