Spreadsheet Vocabulary

Match the following spreadsheet Functions with their definitions

• the average of a data set

• Mean

• the value that appears most frequently in a data set

• Sum

• the total of all the values in a data set

• Mode

• the middle value of a data set

• Median

• difference between the highest and lowes

• Range

Match the following spreadsheet definitions

• feature that allows you copy contents to

• AutoFill

• Cell that has been selected

• AutoSum

• Function that adds ranges of cells

• Cell Address

• the rectangular shaped area

• Active Cell

• The name of the cell by column and row

• Cell

Match the following spreadsheet definitions

• Lines that separate columns and rows

• Row

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

• Drag

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

• Formula

• Mathematical expression used to perform calculations

• Cell Grid

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

• Column

Match the following spreadsheet definitions

• Extend data horizontally

• Formula Bar

• Organize documents

• File

• Extend data vertically

• Function

• Predefined formula

• Fill Right

• Edit cell contents

• Fill Down

Match the following spreadsheet definitions

• Name or description for a cell or range of cells

• Worksheet

• Navigation tool for different sheets in a workbook

• Label

• Entire file containing multiple sheets

• Headings

• Single sheet within a workbook

• Sheet Tabs

• Column titles in a spreadsheet

• Workbook