Excel Exam
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
two
When working with a large worksheet, you can split the window into ____ panes.
two or four
Which of the following is the path to the Comma Style button?
(HOME tab | Number group)
Which of the following is the path to the Increase or Decrease Indent button?
(HOME tab | Alignment group)
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
To start a new line in a cell, press the ____ keys.
ALT+ENTER
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
Which of the following Auto Fill Options menu options is the same as the Fill Series option?
Fill Months
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
Clicking the ____ opens the Insert Function dialog box.
Insert Function box in the formula bar
The ____ function displays the highest value in a range.
MAX
The ____ function determines the lowest number in a range.
MIN
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
Cell references in a formula are called ____.
assumptions
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL+1
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Thursday, Saturday, Monday
To paste copied cell contents, you can press the ____ keys.
CTRL+V
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
You should use a ____ chart to compare values side by side, broken down by category.
Clustered Column
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
When you decrease the row height to ____, the row is hidden.
0
When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
0
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.
Zoom
A ____ is text and graphics that print at the top of each page.
header
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
Which of the following patterns extends the fill series to 575, 550, 525?
625, 600
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which comparison operator means "not equal to"?
<>
Which of the following formulas contains an absolute cell reference?
=$B$4
Which of the following calculations multiplies 23 by 0.01?
=23%
____ text often provides a strong visual appeal.
Rotated
Error messages begin with the ____ symbol.
#
____ refers to cells not wide enough to display the entire entry.
#####
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#REF!
Which of the following is the path to the Goal Seek button?
(DATA tab | Data Tools group)
Which of the following is the path to the Insert Cells arrow?
(HOME tab | Cells group)
The path to the Format Painter button is ____.
(HOME tab | Clipboard group)
Which of the following is the path to the Copy and Paste buttons?
(HOME tab | Clipboard group)
Which of the following is the path to the Sum arrow?
(HOME tab | Editing group)
Which of the following is the path to the Conditional Formatting button?
(HOME tab | Styles group)
Which of the following is the path to the Spelling button?
(REVIEW tab | Proofing group)
Which of the following is the path to the Zoom button?
(VIEW tab | Zoom group)
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.
Alignment
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
You can press the ____ keys to open the Format Cells dialog box.
CTRL+1
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL+C
To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.
Dialog Box Launcher
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Double-click or double-tap
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
ENTER
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
The default view in Excel is called ____ view.
Normal
If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.
Orientation
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
In a clustered column chart, the names of each column are part of the ____ series.
data
You should ____ a function name in the Formula AutoComplete list to select the function.
double-click or double-tap
Using the mouse to move or copy cells is called ____.
drag and drop
A ____ is text and graphics that print at the bottom of every page.
footer
A ____ is a prewritten formula that is built into Excel.
function
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
Point mode allows you to ____, as shown in the accompanying figure.
select cells for use in a formula using the mouse pointer
Which of the following is not a valid format symbol?
semi-colon (;)
