How can we help?

You can also find more resources in our Help Center.

Computer Applications Excel Chp 3

STUDY
PLAY
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