Advertisement Upgrade to remove ads


Cell references in a formula are called ________.


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


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


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.


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


Extends the fill series to 575,550,525

(Home tab | Alignment group)

Path to the Increase or Decrease Indent button


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


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


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


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


Not a valid format symbol


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.


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


Contains an absolute cell reference


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.


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


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


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

(Home tab | Clipboard group)

Path to the Format Painter button


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


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


________ 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


Reload the page to try again!


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