Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set