Computer Applications Excel Chp 3

38 terms by danielmyrick08 

Create a new folder

Advertisement Upgrade to remove ads

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

Which of the following is a suggested decision to make when you plan a workbook?

determine the necessary functions and formulas needed

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

use Excel to create the worksheet

_____ text 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

When you first enter text, its angle is _____ degrees, and it reads from left to right in a cell, as shown in the accompanying figure.

0

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

Fill Formatting Only

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Qrt2

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday

In the accompanying figure, the split double arrow mouse pointer _____.

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

Which of the following is the path to the Increase or Decrease Indent button?

(Home tab | Alignment group)

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

three

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

Clipboard

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

ESC

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

ENTER

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

drag and drop

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

(Home tab | Cells group)

Which of the following is not a valid format symbol?

semi colon ;

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!

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

NOW

Which of the following formulas contains an absolute cell reference?

=$B$4

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

IF

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

Nested

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

Sparkline

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

CTRL+1

The path to the Format Painter button is _____.

(Home tab | Clipboard group)

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

Double-click

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

pie

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

Chart sheet

A Pie chart with one of more slices offset is called a(n) _____.

exploded pie chart

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

(View tab | Zoom group)

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

two or four

Which of the following is the path to the Goal Seek button?

(Data tab | Data Tools group)

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

Goal

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