NEW
Font size
WorksheetsMicrosoft Excel Vocabulary and Functions
Total questions: 20
Worksheet time: 10mins
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
Cell Grid
Cell Address
Headings
Active Cell
A document that is stored on your computer. In Excel, a file is also known as a workbook.
File
AutoFill
AutoSum
Cell
A feature that allows you to copy information in an active cell to another cell or range of cells selected vertically.
Function
Fill Right
AutoFill
Fill Down
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.
Fill Right
AutoFill
Fill Down
Function
The lines on your worksheet that separate the columns and rows.
Fill Down
Cell Grid
Cell Address
Active Cell
The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date.
Headings
Cell
File
Label
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
File
Cell
Label
Drag
A combination of numbers and symbols used to express a calculation.
Formula Bar
Formula
Workbook
AutoSum
A function that automatically identifies and adds ranges of cells in your worksheet.
AutoFill
AutoSum
Workbook
Formula
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
Fill Right
AutoSum
Fill Down
AutoFill
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.
Fill Down
Sheet Tabs
Fill Right
Headings
In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
Drag
Workbook
Column
Row
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
Active Cell
Cell Address
Cell Grid
Formula Bar
A 'page' within an Excel workbook that contains columns, rows, and cells.
Workbook
AutoSum
Formula
Worksheet
When you move the mouse while holding down the mouse button (usually the left) to select a range of cells.
Drag
Cell
File
Row
The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.
Label
AutoFill
Headings
Cell Address
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
Fill Right
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.
Cell Address
An Excel file that contains individual worksheets. Also called a spreadsheet file.
Worksheet
Formula
AutoSum
Workbook
In a worksheet, the vertical spaces with headings A, B, C, and so on. AutoSum Row Column Formula
AutoSum
Row
Column
Formula
