Chapter 2 Excel test
Formula
The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign
Trace error
The _____ Options button lists error-checking options following the assignment of an invalid formula to a cell
MIN
The _____ function determines the lowest number in a range
Insert
The _______ Options button lists formatting options following an insertion of cells, rows, or columns
relative
The adjusted cell references in a copied and pasted formula are called
False
The arithmetic operator, ^, directs Excel to perform the division operator
True
The equal sign precedes a formula
Standard
Which of the following is the toolbar that contains the Copy and Paste buttons
document window
You can click the Page Layout view button in the lower left of the _____ _____ to switch to Page Layout view
Paste Options
You can click the _____ button to determine how moved items should appear, for example
Esc
You can press the ____ key to quit the Range Finder
Range Finder
You can use the ___ ____ to check which cells are referenced in the formula assigned to the active cell
False
You cannot format an entire column at once
click
You should ____ a function name in the Formula Auto Complete list to select the function
hiding cells
____ _____ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should use
Margins
____ are those portions of a printed page outside the main body of the printed document and always are blank when pritned
page layout
_____ ____ shows the worksheet divided into pages
best fit
______ _____ means that the width of a column will be increases or decreased so the widest entry will fit in the column
Pixel
A _____ is a dot on the screen that contains a color
theme
A _____ is a predefines set of colors, fonts, chart styles, cell styles, and fill effects
Blank
A ______ cell in Excel has a numerical value of zero
Function
A ______ is a prewritten formula that is built into Excel
True
A floating dollar sign appear immediately to the left of the first digit in a dollar value with no spaces
True
Moving from left to right, the first calculation in the order of operations is negation
select cells for use in a formula using the mouse
Point mode allows you to
False
Point mode allows you to select cells for use in a formula by using the keyboard
True
Pressing the COMMAND-= keys instructs Excel to recalculate all formulas
Entry validation
All of the following are automatic features that Excel displays as option buttons in a workbook while you are working on it EXCEPT
>
All of the following are valid Excel arithmetic operators EXCEPT
formulas
Always take time to check the _____ of a worksheet before submitting it to your supervisor
False
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation
False
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations
two-digit
By default, Excel for Mac uses a ____ year value
formula bar
Clicking the Formula Builder button in the _____ ____opens the Formula Builder
False
Cooler colors (red and orange) tend to pull away from the reader
False
Dates that include years both before and after the war 2000 should be formatted with a two-digit year
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
right paranthesis
Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter button or press the RETURN key
True
Excel has more than 400 additional functions that perform just about every type of calculation you can imagine
spell checker
Excel includes a ______ ______ you can use to check a worksheet for spelling errors
True
The AutoSum pop-up menu allows you to enter one of five often-used functions easily into a cell
True
The Insert Options button lists formatting options
False
The MAX function can only be entered using the formula builder in the formula bar
MAX
The ____ function displays the highest value in a range
AVERAGE
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
True
The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eyes toward the cell or range
Command-C
To copy cell contents, you can select the cell and then press the ___ keys
Command-V
To paste copied cell contents, you can press the _____ keys
double click
To set column width to best fit, _____-_______ the right boundary of the right boundary of the column heading
Control-Option-Return
To start a new line in a cell, press the _____ keys
False
To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check
True
Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula
9
What is the value when Excel calculates the average of three cells with values of 10, blank, and 8
26
When Excel follows the order of operations, the formula, 8*3+2, equals _____
Operations
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of operations you used in algebra
False
When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation
=23%
Which of the following calculations multiplies 23 by 0.01
Excel assigns the value in cell G15 to the active cell
Which of the following happens when you enter the formula =G15 into a cell
Intelligence
Which of the following is not connoted by the color blue