To start a new line in a cell, press_________ after each line, except for the last line, which is completed by clicking the enter box, pressing the ENTER key, or pressing one of the arrow keys.
click Save As on the File menu
To save a previously saved workbook with a new name or on a different drive, ________.
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ________.
Every time you enter a value into a cell in the worksheet, Excel automatically ______ formulas.
The ________ button lists formatting options following an insertion of cells, rows, or columns.
Double-click in the cell
How do you activate Range Finder to verify a formula in a cell?
Using the ______ button on the Ribbon instructs Excel to display additional decimal places in a cell.
Click ________ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.
______ means that the width of the column will be increased or decreased so the widest entry will fit in the column.
As with column widths, when you decrease the row height to 0, the row is _________.
Selection option button
In the Print dialog box, the _________ instructs Excel to print the selected range.
Active sheet(s) option button
In the Print dialog box, the _________ instructs Excel to print the worksheet currently on the screen.
CTRL key while pressing the ACCENT MARK (`)
To toggle between the values version and the formulas version of a worksheet, hold down the _____ key.
The formulas version verifies that you entered formulas, rather than _____, in formula-based cells.
The ________ of the worksheet shows the actual formulas you have entered, rather than the resulting values.
The process of finding and correcting errors in a worksheet is called _________.
To import data stored on a Web site use a _________.
What name does Excel give the first blank worksheet?
press the ENTER key
To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then __________.
The arithmetic operator, ____, directs Excel to perform the division operation.
True or False: The arithmetic operator, ^, directs Excel to perform the division operation.
True or False: Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.
True or False: When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values.
True or False: The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.
True or False: One of the least common mistakes made with Excel is to include the wrong cell reference in a formula.
True or False: The Comma Style button is located on the Ribbon.
True or False: When using conditional formatting, if the condition is true, then Excel applies the formattting.
True or False: With conditional formatting, if the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting.
The _________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
smart tag indicator
Excel places a small purple triangle, called a(n) ________, in a cell to indicate that a smart tag is available.
A blank cell in Excel has a numerical value of _________.
The values used with a function are called ______________.
The ________ function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
The __________ function displays the highest value in a range.
The __________ function determines the lowest value in a range.
Comma Style Format
The _________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
Floating dollar sign
A(n) __________ is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces.
Formatting that appears only when the value in a cell meets specified conditions is called ______________.
The _________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.
The __________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.
A ________ takes a value or values, performs an operation, and returns a result to the cell.
order of operations
When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation, following the ___________.
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.
If a _______ is true, then Excel applies the formatting. If false, then Excel suppresses the formatting.
_______ are values that are used with a function.