A
B
C
D
E
100
This cell contains the cell pointer. There is a dark outline around this cell.
What is Active Cell
100
Tabs that appear at the bottom of the workbook window. These display the name of each worksheet.
What is Sheet Tabs
100
A feature used to complete an entry based on previous entries made in the column containing the active cell.
What is AutoComplete
100
A style that vertically aligns with dollar signs ($), thousands separators (,), and decimal points.
What is Accounting Format
100
A set of instructions that Excel uses to calculate a result
What is Formula
200
The intersection of a column and row on a worksheet. You enter data in this to create a worksheet.
What is Cell
200
The work area for entering and calculating data made up of columns and rows. This is also commonly called a spreadsheet.
What is Worksheet
200
A shortcut used to insert repeated information by right clicking on the cell.
What is Pick From List
200
A feature that causes long cell entries to appear on multiple lines
What is Word Wrap
200
A cell address in a formula that will not change when you copy the formula to another cell.
What is Absolute Reference
300
The location of a cell in a worksheet is identified by its column letter and row number. This is also known as the cell’s reference.
What is Cell Address
300
An Excel file with one or more worksheets.
What is Workbook
300
A combination of a font, text color, cell color, and other font attributes applied to a single cell.
What is Cell Style
300
A black box on the lower-right corner of the selected cell or range that you can use to fill (copy) a series or formula.
What is Fill Handle
300
A built-in calculation used to add a range of values together.
What is SUM Function
400
A graphical representation of data that enables you to identify comparisons and trends
What is Chart
400
A new, empty workbook that contains three worksheets
What is Blank Workbook
400
A style that displays decimal numbers as a percentage.
What is Percent Format
400
A list of sequential numbers, dates, times, or text.
What is Series
400
A command that enables you to display the formulas in a worksheet so that you can check them.
What is Show Formula
500
As you enter data in a cell, it simultaneously appear in this, which is located above the worksheet.
What is Formula bar
500
A feature used to automate the correction of common typing errors.
What is AutoCorrect
500
A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell.
What is Merge and Center
500
The feature that enables Excel to create a series automatically.
What is AutoFill
500
The default chart type that displays each data point as a vertical column.
What is Column Chart