Excel Ch. 2 Review
Pixel
A ___ is a dot on the screen that contains a color.
Theme
A ___ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
Function
A ____ is a prewritten formula that is built into Excel.
Blank
A ______ cell in Excel has a numerical value of zero.
True
A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces. (True or False)
Circular Reference
A formula in a cell that contains a reference back to itself is called a _____.
False
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation (True or False)
False
As in algebra, you can use brackets to override the order of operations Excel follows to perform the formula calculations. (True or False)
True
Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting. (True or False)
>
Is not a valid excel arithmetic operator.
Division
The / arithmetic operator indicates ____.
True
The Insert Options buttons lists formatting options. (True or False)
True
The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. (True or False)
True
The Sum button menu allows you to enter on of five often-used functions easily into a cell. (True or False)
Insert
The ___ Option button lists formatting options following an insertion of cells, rows, or columns.
MAX
The ___ function displays the highest value in a range.
AVERAGE
The ___ function sums the numbers in the specified range then divides the sum by the number of cells with numeric values in the range.
Trace Error
The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Excel assigns the value in cell G15 to the active cell
What happens when you enter the formula =G15 into a cell?
Home tab - Editing Group
What is the path to Sum Button?
26
When Excel follows the order of operations, the formula, 8*3+2, equals ____.
CTRL+C
To copy cell contents, you can select the cell and then press the ___ keys.
True
Excel has more than 400 additional functions that perform just about every type of calculation you can imagine. (True or False)
Spell Checker
Excel includes a _____ you can use to check a worksheet for spelling errors.
CTRL+V
To paste copied cell contents, you can press the ____ keys.
Print Selection
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.
Double Click
To set row height to best fit, _____ the bottom boundary of the row heading.
ALT+ENTER
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 or False)
Rows
Worksheet ___ typically contain items analogous to items in a list.
True
You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers appear. (True or False)
ESC (Escape)
You can press _____ key to quit rangefinder.
F8
You can select a range using the keyboard by pressing the ___ key and then an arrow key.
Range Finder
You can use the ____ to check which cells are reference in the formula assigned to the active cell.
False
You cannot format an entire column at once. (True or False)
Double-Click
You should ____ a function name in the Formula AutoComplete 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 not see.
Formulas
Always take time to check the ______ of a worksheet before submitting it to your supervisor.
False
Best fit means that the width of the column will be increased or decreased by a percentage you specify. (True or False)
Addition and Subtraction
In the order of operations, the last operation Excel performs is _____.
Formula
One of the reasons Excel is such a valuable tool is that you can assign a ____ to a cell, and Excel will calculate the result.
Accounting Number Format
The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to nearest cent.
MIN
The ____ function determines the lowest number in a range.
Relative
The adjusted cell references in a copied and pasted formula are called ____ references.
False
The arithmetic operator,^, directs Excel to perform the division operation. (True or False)
True
The equal sign (=) precedes a formula (True or False)
False
When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery. (True or False)
0
When you decrease the row height to ____, the row is hidden.
20xx
When you enter a two-digit year that is less than 30, Excel changes the year to _____.
Home tab - Number group
Which of the following is the path to the Comma Styles button?