When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.
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
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.
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?
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.
The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory.
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.
When assigned to a cell, the _____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
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.
_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges