How can we help?

You can also find more resources in our Help Center.

excel quiz

STUDY
PLAY
To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box.
true
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?
hidden
Text entered in a cell cannot be realigned.
False
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
true
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
true
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.
a. ALT+ENTER
What is a series of two or more adjacent cells in a column or row or rectangular group of cells?
range
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
Book1
Excel opens a new workbook with _____ worksheets
3
press the spacebar to clear a cell
false
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.
false
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
CELL
A smart tag indicator is a block plus sign located in the center of the cell.
false
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.
false
What is called changing the font type changing the font style to bold increasing the font size and changing the font color?
formating
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.
26
What effect does the Accounting Number Format have on the selected cells?
causes cells with two decimal places to align vertically correctly