excel quiz

To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box.
When an error occurs in a formula in a cell, Excel displays the _____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell
c. Trace Error
Saving the workbook frequently is important for the following reason?
If you lose power, the worksheet could be lost.
As with column widths when you decrease the row height to zero the row is?
Text entered in a cell cannot be realigned.
Every time you enter a value into a cell in the worksheet excel automatically _____ formulas
recalculates all.
if a major error is made when typing data into a cell, click the cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning
when the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area
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.
What is a series of two or more adjacent cells in a column or row or rectangular group of cells?
In Excel, a number can contain the characters _____.
d. all of the above
The blank workbook that opens when Excel first opens is just named
Excel opens a new workbook with _____ worksheets
press the spacebar to clear a cell
What Means that the width of the column will be increased or decreased so the widest entry will fit in the column
best fit
To instruct Excel to display a hidden column,
position the mouse pointer to the right of the column heading boundary where the hidden column is located and drag it to the right
The arithmetic operator, ^, directs Excel to perform the division operation.
The cell being copied is called the source aea (or copy area). The range of cells receiving the copy is called the _______.
destination area
Longer worksheet names also can mean that ____ sheet tabs will show
The intersection of a row and a column in a spread sheet is called a
A smart tag indicator is a block plus sign located in the center of the cell.
To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then _____.
press enter key
When Point mode is used to enter a formula or function, the arrow keys can be used to complete the entry.
What is called changing the font type changing the font style to bold increasing the font size and changing the font color?
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.
What effect does the Accounting Number Format have on the selected cells?
causes cells with two decimal places to align vertically correctly