Spreadsheet Vocabulary

Match the following spreadsheet Functions with their definitions

• difference between the highest and lowes

• Median

• the middle value of a data set

• Sum

• the average of a data set

• Range

• the total of all the values in a data set

• Mean

• the value that appears most frequently in a data set

• Mode

Match the following spreadsheet definitions

• Cell that has been selected

• AutoSum

• The name of the cell by column and row

• Cell Address

• feature that allows you copy contents to

• Cell

• the rectangular shaped area

• Active Cell

• Function that adds ranges of cells

• AutoFill

Match the following spreadsheet definitions

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

• Row

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

• Column

• Mathematical expression used to perform calculations

• Drag

• Lines that separate columns and rows

• Cell Grid

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

• Formula

Match the following spreadsheet definitions

• Extend data vertically

• Fill Right

• Organize documents

• Formula Bar

• Extend data horizontally

• Function

• Predefined formula

• File

• Edit cell contents

• Fill Down

Match the following spreadsheet definitions

• Name or description for a cell or range of cells

• Sheet Tabs

• Entire file containing multiple sheets

• Headings

• Single sheet within a workbook

• Workbook

• Navigation tool for different sheets in a workbook

• Worksheet

• Column titles in a spreadsheet

• Label