Basics
Worksheet Elements
Functions
Keyboard Shortcuts
Features
100
The horizontal and vertical lines that define the cells in a worksheet area are referred to as this
What are Gridlines?
100
Data being typed in a cell displays in the cell as well as here
What is the Formula bar?
100
Press this function key to display the Excel Help window
What is the F1 function key?
100
First cell in a worksheet
What is CTRL + Home?
100
The Accounting Number Format button is located in this group on the HOME tab
What is the number group?
200
Columns in a worksheet are labeled with these
What are letters of the alphabet?
200
The Area containing the tabs with commands and buttons
What is the Ribbon?
200
With this function, a range of cells are added together and then divided by number of cell entries.
What is the Average Function?
200
Last Cell in a Worksheet
What is CTRL + End?
200
This feature automatically inserts words, numbers, or formulas in a series
What is AutoFill
300
Rows in a worksheet are labeled with these
What are numbers?
300
Display the active cell address or name assigned to the active cell
What is the Name box?
300
Click this button to obtain a total from a row or column
What is AutoSum?
300
Press this key on the keyboard to move the insertion point to the next cell
What is the "Tab" Key?
300
Click this button to merge selected cells and center data within the merged cells
What is the Merge & Center Button?
400
A file created in Excel is referred to as a
What is Workbook?
400
Displays the workbook name followed by the application name
What is Title bar?
400
The percent format button is located in this group on the Home Tab
What is the number group
400
Press these keys on the keyboard to move the insertion point to the previous cell
What are “Shift” + “Tab”?
400
This feature automatically correct many common typing errors
What is AutoCorrect?
500
The area containing the grid lines in the Excel window is called
What is Worksheet Area?
500
Contains buttons for commonly used commands that can be executed with a single mouse click
What is Quick Access Toolbar?
500
The AutoSum button is located in this group on the Home Tab
What is the Editing Group?
500
To select nonadjacent columns using the mouse, hold down this key on the keyboard while clicking the column headers.
What is the CTRL Key?
500
If a number entered in a cell is too long to fit inside the cell, the number is changed to this
What are number symbols? / pound signs / Hashtag ####?
M
e
n
u