Advertisement Upgrade to remove ads

To cancel an entire entry before entering it into the cell, press the ______ key

ESC

To enter a number as text, precede it with a(n)

Apostrophe (')

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto Fill Options

Which of the following is the Ribbon path to the Cell Styles button?

(Home tab| Styles group)

What keyboard shortcut key(s) selects cell A1?

Control Home

How many chart types does Excel offer?

11

A(n) ____ chart is drawn on the same worksheet as the data.

Embedded

The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.

AutoCalculate

Which of the following keys is an alternative to double-clciking the cell to edit?

F2

Excel remembers the last ___ actions you have completed.

100

A ___ is a prewritten formula that is built into Excel.

function

When you enter a two-digit year that is less than 30, Excel changes the year to ___.

20xx

All of the following are valid Excel arithmetic operators except ___.

>

The ___ Options button lists error-checking options following the assignment of an invalid formula to a cell.

Trace Error

You can select a range using the keyboard by pressing the ___ key and then an ARROW key.

F8

Excell automatically appends the ___ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Right Parenthesis

Which of the following is the path to the Sum button?

(Home tab| Editing group)

You should ___ a function name in the Formula AutoComplete list to select the function.

double-click

Clicking the ___ opens the Insert Function dialog box.

Insert Function box on the formula bar

You can use the ___ to check which cells are referenced in the formula assignement to the active cell.

Range Finder

You can open the Format Cells dialog box by pressing the ___ keys.

CTRL + 1

The most popular background color is ___.

Blue

Which of the following is the path to the Conditional Formatting button?

(Home tab| Styles group)

If you do not assign a format to a cell or cells in a column, the column width will remain___ characters.

8.43

Cell references in a formula are called ___.

Assumptions

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ___ values.

constant

You can ensure correctness in your formulas by carefully checking them using ___.

Range Finder

___ test often provides a strong visual appeal.

Rotated

To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ___.

Dialog box launcher

The ____ Auto Fill Options that fills the destination area using the format of the sourse area; no content is filled

Fill Formatting Only

Which of the following cell contents is extended to Qtr 3, Qtr 4 and Qtr1 by dragging the fill handle?

Qtr 2

The split double arrow mouse pointer ___.

is the result of moving the mouse pointer to the boundry between the column heading A and column heading B.

The Increase indent button indents the contents of a cell to the right by ___ spaces each time you click it.

3

An alternative to clicking the Paste button is to press the ___ key.

Enter

Which of the following path to the insert button?

(Home Tab| Cells Group)

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ___ error message.

#REF!

You can press the ___ keys to open the Format Cells dialog box.

CRTL +1

___ the Format Painter button and then drag through the nonadjacent ranges to paing the formats to the ranges.

Double-click

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