Excel Exam Quiz Practice

to enter data in a cell, you must first select the ____.

We thoroughly check each answer to a question to provide you with the most correct answers. Found a mistake? Let us know about it through the REPORT button at the bottom of the page.

Excel Quiz

 

Quiz Answers

An Excel ____ allows data to be summarized and charted easily.

  • document
  • presentation
  • workflow
  • worksheet

The first step in creating an effective worksheet is to make sure you ____.

  • enter the data
  • insert a chart
  • understand what is required
  • apply font formatting

To enter data in a cell, you must first select the ____.

  • column
  • cell
  • worksheet
  • row

____ is/are used to place worksheet, column, and row titles on a worksheet.

  • tabs
  • text
  • color
  • links

Clicking the ____ box completes an entry.

  • formula
  • cancel
  • enter

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

  • RIGHT ARROW
  • UP ARROW
  • DOWN ARROW
  • LEFT ARROW

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

  • semi-colon (;)
  • period (.)
  • colon (:)

A ____ reference is an adjusted cell reference in a copied and pasted formula.

  • relative
  • retained
  • recycled

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

  • clear
  • print
  • format

Combining two or more selected cells into one cell is called ____ cells.

  • spanning
  • mixing
  • combining
  • merging

What effect does the Accounting Number Format have on the selected cells?

  • Displays cell contents with two decimal places that align vertically
  • Copies the numbers of one cell to another
  • Performs tax calculations

What effect does the Comma Style format have on the selected cells?

  • Displays cell contents with two decimal places and commas as thousands separators
  • Allows for substitution of selected characters
  • Converts decimals to commas within merged cells

How many chart types does Excel offer?

  • 11
  • 5
  • 30
  • 50

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

  • TAB
  • ESC
  • ALT

The ____ button allows you to erase recent cell entries.

  • bold
  • increase decimal
  • cell style
  • undo

 

Terms to know

worksheet
An Excel ________ allows data easily to be summarized and charted.
requirements
The person or persons requesting the worksheet should supply their requirements in a ________ document.
understand what is required
The first step in creating an effective worksheet is the make sure you ________.
cell
To enter data in a cell, you must first select or activate the ________.
Text
________ is/are used to add worksheet, column, and row titles on a worksheet.
ESC
To cancel an entire entry before entering it into the cell, press the ________ key.
enter
Clicking the _______ box completes an entry.
insertion point
The ________ is a blinking vertical line that indicates where the next typed character will appear.
AutoCorrect
The ________ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
RIGHT ARROW
Pressing the ________ key to complete an entry activates the adjacent cell to the right.
left-aligned
By default, text is ________ in a cell.
0 1 2 3 4 5 6 7 8 9 . $ % E e + – ( ) , /
In Excel, a number can contain the characters ________.
6E15
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 you can type ________.
range
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
colon
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________.
apostrophe
To enter a number as a text, precede it with a(n) ________.
destination area (or paste area)
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________.
relative
A ________ reference is an adjusted cell reference in a copied and pasted formula.
fill handle
The ________ is the small black square located in the lower right corner of the heavy border around the active cell.
Auto Fill Options
The ________ allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
format
You ________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
two
In general, use no more than ________ font types in a worksheet.
CTRL+B
You can apply the Bold font style by pressing the ________ keyboard shortcut keys.
merging
Combining two or more selected cells is called ________ cells.
(Home tab | Styles group)
What is the Ribbon path to the Cell Styles button?
Displays cell contents with two decimal places that align vertically.
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators.
What effect does the Comma Style format have on the selected cells?
CTRL+HOME
Pressing the ________ keyboard shortcut key(s) selects the cell A1.
11
How many chart types does Excel offer?
embedded
A(n) ________ chart is drawn on the same worksheets as the data.
legend
In the accompanying figure, the ________ identifies the colors assigned to each bar in the chart on a worksheet.
Standard
________ properties are associated with all Microsoft Office documents and include author, title, and subject.
Auto Calculate
The ________ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected number in the worksheet.
INSERT
Which key toggles between Insert mode and Overtype mode?
HOME
Which key moves the insertion point to the beginning of data in a cell?
END
Which key moves the insertion point to the end of data in a cell?
F2
Which key is an alternative to double-clicking the cell to edit it?
Undo
The ________ button is located on the Quick Access Toolbar.
100
Excel remembers the last ________ actions you have completed.
click
To remove an embedded chart, you should ________ it and press the DELETE key.
An Excel ____ allows data to be summarized and charted easily.
Worksheet
The person or persons requesting the worksheet should supply their requirements in a ____ document.
Requirements
The first step in creating an effective worksheet is to make sure you ____.
Understand what is required
To enter data in a cell, you must first select the ____.
Cell
____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
Clicking the ____ box completes an entry.
Enter
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Auto-complete
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
Right Arrow
The range of cells receiving copied content is called the ____ area.
Paste
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
The range of cells receiving the content of copied cells is called the ____.
Destination area
A ____ reference is an adjusted cell reference in a copied and pasted formula.
Relative
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Format
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL+B
Combining two or more selected cells into one cell is called ____ cells.
Merging
Which of the following is the Ribbon path to the Cell Styles button?
(HOME tab | Styles group)
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME

Was this helpful?