Excel Chapter 2 Test Review
A(n) _______________________ sign is the arithmetic operator that directs Excel to perform the multiplication operation.
* asterick
If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last?
+
Moving from left to right, the first calculation in the order of operations is ______________________.
- (negation)
The _______________ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
AVERAGE
To start a new line in a cell, press the __________________ keys.
Alt + enter
_______________________ shows the actual formulas you have entered, instead of the resulting values.
Formula version
_________________ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page layout
To use Range Finder to verify that a formula contains the intended cell reference, double-click the cell containing the formula you want to check. (True or False)
True
When a formula is entered into a cell, Excel will calculate the result. (True or False)
True
_____________ shows the results of the formulas you have entered, rather than the actual formula.
Values version
The _____________ Number format inserts a comma every three positions to the left of the decimal point, and causes numbers to be displayed to the nearest hundredth.
comma
A _________________ is made up of two values and relational operator, is true or false for each cell in the range.
condition
Formatting that appears only when the value in a cell meats conditions that you specify is called ________________ formatting.
conditional
Pressing the ____________________ keys on the keyboard will display formulas on the worksheet instead of values.
ctrl + `
The ________________________________ Format displays numbers with a floating dollar sign to the immediate left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
currency number
You can enter functions _______________. a. with the keyboard or mouse b. with the insert function c. with the SUM menu d. all of the above
d. all of the above
The / arithmetic operator represents ________________.
division
To set the row height or column width to best fit, _____________ click the boundary of the row heading or column heading.
double
You should ______________ click a function name in the Formula AutoComplete list to select the function.
double
To alert that you are entering a formula and not text. type a(n) ___________________ preceding the formula.
equal sign (=)
The use of a __________ color in a cell or range of cells sets off the cell or range of cells sets off the cell or range from other portions of the worksheet by changing the background color of the cell.
fill
A ____________ dollar sign is displayed to the far left in the cell, often with spaces between it and the first digit.
fixed
To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a __________________________.
floating dollar sign
Typing =av in a cell and having AVEDEV, AVERAGE, etc. pop up displays the _______________________________ feature.
formula autocomplete
A(n) ______________ formula is a prewritten formula that is built into Excel.
function
Clicking the ________________ opens the Insert Function dialog box.
fx button to the left of the formula bar
Clicking the _______________________ button to the left of the formula bar opens the Insert Function dialog box-it allows you to create function formulas and learn more about Excel's functions.
insert function (fx)
The > (is, is not) a valid Excel arithmetic operator.
is not
The default view in Excel is ______________ view.
normal
You can choose a category in the ______________ 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 should appear.
number
The order in which formula calculations are performed when there is more than one operator in the formula is called the ____________________________.
order of operations
You can use ______________________ to override the Order of Operations in order to calculate certain operators first - no matter how low on the Order of Operations they fall.
parentheses
The _______________ 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.
percent
A(n) ___________ is a measure of cell height and width.
pixel
To print a range of cells in the active worksheet, click _____________________ option in the Settings area in the Print gallery.
print section
An easy way to verify that a formula references the cells that you want it to reference is to use Excel's ___________________.
range finder
When you copy a formula with relative cell references down a row, _____________________________.
row references change in formula
Excel has a(n) _____________ feature that allow you to check the worksheet for spelling errors.
spell checker
In the order of operations, the last operation Excel performs is ________________________.
subtraction
The ________ button menu allows you easy access to five often-used functions.
sum
A ____________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
theme
___________________ Number Format displays numbers with a fixed dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. (hundredths place).
Accounting
When Excel follows the order of operations, the formula, 6 + 3 * 8, equals ______________.
30
_________________ means that the width of a column will be increased or decreased so the widest entry will fit.
Best fit
______________ is the process of finding and correcting errors in a worksheet.
Debugging
A condition for a cell can only be true or false. (True or False)
False
A style is a predefined set of colors, fonts, chart styles, and fill effects that can be applied to the entire workbook. (True or False)
False
In the formula = 4 * 6 - 8, the subtraction operation (-) is completed before the multiplication operation (*). (True or False)
False
Normal view is the default Excel view that allows you to create or modify a worksheet while viewing how it will look in the printed format. (True or False)
False
The Currency Style format cannot be used with a floating dollar sign. (True or False)
False
You can instruct Excel to display fewer decimals than are currently shown in the cell with the Increase Decimal Button. (True or False)
False
the order of operations works from right to left. (True or False)
False
Use the _______________ functions to display the highest value in a range.
MAX
The ______________ function is used to determine the lowest number in a given range.
MIN
_______________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.
Margins
Point mode allows you to create formulas more accurately and more quickly using the mouse to enter cell references. (True or False)
True
Currency Number format displays floating dollar signs in the selected number. (True or False)
True
Excel attempts to guess which cells you want to include in the function by looking for ranges that are touching or ____________________ to the selected cell and that contain numeric data.
adjacent
When Excel automatically sets the width of a column based on the widest entry in the column, it is called __________________.
best fit
Which of the following happens when you enter =G15 into a cell? a. Excel recalculates the worksheet b. Excel assigns the sum of the values in the previous 15 cells to the active cell c. Excel assigns the value in cell G15 to the active cell d. Nothing; =G15 is an invalid entry
c. Excel assigns the value in cell G15 to the active cell
You (can, cannot) format an entire column at once.
can