MS Excel Vocab

The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!

• Label
• Headings
• Function
• Formula Bar

The lines in your worksheet that separate the columns and rows.

• Cell Grid
• Cell Address
• Cell
• AutoSum

The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

• Cell
• AutoSum
• AutoFill
• Active Cell

A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.

• Function
• Formula Bar
• Formula
• Fill Down

In a worksheet, the vertical spaces with letter headings.

• Columns
• Cell Grid
• Cell Address
• Cell

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

• Active Cell
• Sheet Tabs
• Worksheet
• Workbook

A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.

• Formula Bar
• Formula
• Fill Down
• File

An Excel file that contains individual worksheets. Also called a spreadsheet file or file.

• Workbook
• Fill Right
• Rows
• Label

In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.

• Rows
• Label
• Headings
• Function

Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. Each represents a worksheet within the workbook.

• Sheet Tabs
• Worksheet
• Workbook
• Fill Right