Advertisement Upgrade to remove ads

assumptions

Cell references in a formula are called ________.

constant

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

Range Finder

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

determine the necessary functions and formulas needed

Suggested decision to make when you plan a workbook

use Excel to create the worksheet

With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ________.

Rotated

________ text often provides a strong visual appeal.

Dialog Box Launcher

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

0

When you first enter a text, its angle is ________ degrees, and it reads from left to right in a cell.

Fill Formatting Only

The ________ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Qtr2

Extended to Qtr3, Qtr4, and Qtr 1 by dragging the fill handle

625,600

Extends the fill series to 575,550,525

(Home tab | Alignment group)

Path to the Increase or Decrease Indent button

three

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

Clipboard

The Copy button copies the contents and format of the source area to the Office ________, a reserved place in the computer's memory.

ESC

Pressing the ________ key(s) removes the marquee from the source area.

ENTER

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

drag and drop

Using the mouse to move or copy cells is called ________.

(Home tab | Cells group)

Path to the Insert button

semi-colon

Not a valid format symbol

#REF!

In 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.

NOW

When assigned to a cell, the ________ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

=$B$4

Contains an absolute cell reference

IF

The ________ function is useful when you want to assign a value to a cell based on a logical test.

<>

Means "not equal to"

#####

________ refers to cells not wide enough to display the entire entry.

#

Error messages begin with the ________ symbol.

nested

A(n) ________ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Sparkline

A(n) ________ chart provides a simple way to show trends and variations in a range of data within a single cell.

CTRL+!

You can press the ________ keys to open the Format Cells dialog Box.

(Home tab | Clipboard group)

Path to the Format Painter button

Double-click

________ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Pie

You should use a ________ chart to show the relationship or proportion of parts to a whole.

chart sheet

A(n) ________ is a separate sheet in a workbook that contains only a chart.

exploded Pie chart

A pie chart with one of more slices offset is called a(n) _______.

(View tab | Zoom group)

Path to the Zoom button

two or four

When working with a large worksheet, you can split the window into ________ panes.

(Data tab | Data Tools group)

Path to the Goal Seek button

Goal

________ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

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