Cells
columns
rows
addresses
formulas
100
In Excel, this allows data to be summarized and charted easily.
What is a worksheet?
100
Pressing this key completes an entry.
What is the ENTER key?
100
This reference is an adjusted cell reference in a copied and pasted formula.
What is a relative reference?
100
This is where you find the Cell Styles button on the Ribbon.
What is Home tap - Styles Group?
100
Use this key stroke to erase an entire entry in a cell and then reenter the data from the beginning.
What is the ESC key?
200
Before you attempt to build a worksheet for someone ask them for this document.
What is a requirements document?
200
This feature works behind the scenes, fixing common typing or spelling mistakes.
What is auto-correct?
200
This option or button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
What is the auto-fill option?
200
The accounting number format changes numbers in a cell or group of cells in this manner?
What is - it displays cell contents with two decimal places that align vertically with the $ at the leftmost position?
200
This key moves the insertion point to the beginning of data in a cell.
What is the HOME key?
300
Before creating an effective worksheet, be sure you do this.
What is - understand what is required?
300
When you press this key as you enter data into a worksheet to move one cell to the right.
What is the tab key?
300
You do this to a worksheet to emphasize areas of interest to the reader. It also makes the worksheet easier to read and understand.
What is formatting the worksheet?
300
The comma style has this effect on numbers within a cell.
What is - all numbers will display with two decimal places and commas as thousands separators? No $ will be displayed.
300
This type of pie chart has one or more slices offset or pulled away from the pie.
What is an exploded pie chart?
400
To enter data in a spot on a worksheet, you select this.
What is a cell?
400
The range of cells receiving copied content is called this.
What is the paste area?
400
This is the keyboard shortcut used to BOLD text.
What is Ctrl+B?
400
This keyboard shortcut moves the cursor to cell A1.
What is Ctrl+HOME?
400
This button allows you to erase recent cell entries in the reverse order they were made.
What is the UNDO button?
500
You use this to place column and row titles on a worksheet.
What is type the text?
500
When typing a range of cells in a function, separate the starting and ending address with this.
What is a colon?
500
Combining two or more cells into one larger cell is called this.
What is merging?
500
Number of chart types found in Excel
What is 15?
500
Press this key combination to select the entire worksheet.
What is Ctrl+A?
M
e
n
u