EXCEL Test 3
The _____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled
Fill Formatting Only
Typing =av in a cell displays the _____, as shown in the accompanying figure
Formula AutoComplete list
Pressing the _____ keyboard shortcut key(s) selects cell A1
HOME
The _____ function is useful when you want to assign a value to a cell based on a logical test
IF
The _____ Option button lists formatting options following an insertion of cells, rows, or columns
Insert
Clicking the _____ opens the Insert Function dialog box
Insert Function box in the formula bar
The ____ function determines the lowest number in a range
MIN
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY
True
The date you change a file is an example of a(n) _____ property
automatically updated
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 _____ preceding a formula alerts Excel that you are entering a formula or function and not text
equal sign(=)
A pie chart with one or more slices offset is referred to as a(n) _____ pie chart
exploded
A cell reference with only one dollar sign before either the column or the row is called an absolute reference
false
A thin red border indicates the active cell
false
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation
false
Excel can display characters in only three font colors: black, red, and blue.
false
The _____ is a blinking vertical line that indicates where the next typed character will appear
insertion point
The person or persons requesting the worksheet should supply their requirements in a _____ document
requirements
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
The type of chart shown in the accompanying figure is a(n) _____ chart
Clustered column
Excel includes four types of sparkline charts: line, column, win/loss, and stock
False
A company or department may standardize with a specific _____ so that all of their documents have a similar appearance
theme
A character with a point size of 10 is about 10/72 of one inch in height
true
A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function
true
Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data
true
Excel has more than 400 functions that perform just about every type of calculation you can imagine
true
A _____ is text and graphics that print at the top of each page
header
If you do not assign a format to a cell or cells, in a column, the column within will remain _____ characters
8.43
Error messages begin with the _____ symbol
#
The path to the Format Painter button is _____
(Home tab | Clipboard group)
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
AutoCorrect
Press _____ to select the entire worksheet
CTRL + A
If you wish to sign out of your Microsoft account, tap or click _____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.
FILE
A cell is selected, or _____, when a heavy border surrounds the cell as shown in the accompanying figure
active
In Excel, a number can contain the characters
all of the above
In a clustered column chart, the names of each column are part of the _____ series
data
A _____ is text and graphics that print at the bottom of every page
footer
One of the reasons EXCEL is such a valuable tool is that you can assign a(n) _____ to a cell, and Excel will calculate the result
formula
The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign
formula
In the accompanying figure, the split double arrow mouse pointer _____
is the result of moving the mouse pointer to the boundary between column heading A and column heading B indicates the proposed width of column A
Combining two or more selected cells into one cell is called _____ cells
merging
A(n) _____ IF function is one I which the action to be taken for the true or false case includes yet another IF function
nested
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
A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure
range
A _____ reference is an adjusted cell reference in a copied and pasted formula
relative
The adjusted cell reference in a copied and pasted formula are called _____ cell references
relative
Point mode allows you to _____, as shown in the accompanying figure
select cells for use in a formula using the mouse pointer
The Increase Indent button indents the content of a cell to the right by _____ spaces each time you click it
two
first step in crating an effective worksheet is to make sure you _____
understand what is required