Excel Ch. 3
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.
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.
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.