Spreadsheet Vocabulary

Match the following spreadsheet Functions with their definitions

• the average of a data set

• Range

• the value that appears most frequently in a data set

• Mode

• the middle value of a data set

• Mean

• the total of all the values in a data set

• Sum

• difference between the highest and lowes

• Median

Match the following spreadsheet definitions

• Cell that has been selected

• Active Cell

• Function that adds ranges of cells

• AutoSum

• the rectangular shaped area

• Cell

• feature that allows you copy contents to

• Cell Address

• The name of the cell by column and row

• AutoFill

Match the following spreadsheet definitions

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

• Formula

• Mathematical expression used to perform calculations

• Row

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

• Column

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

• Drag

• Lines that separate columns and rows

• Cell Grid

Match the following spreadsheet definitions

• Edit cell contents

• Function

• Extend data horizontally

• Fill Right

• Predefined formula

• Formula Bar

• Organize documents

• Fill Down

• Extend data vertically

• File

Match the following spreadsheet definitions

• Column titles in a spreadsheet

• Workbook

• Navigation tool for different sheets in a workbook

• Headings

• Single sheet within a workbook

• Label

• Name or description for a cell or range of cells

• Worksheet

• Entire file containing multiple sheets

• Sheet Tabs