The person or persons requesting the worksheet should supply their requirements in a ____ document.
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
The ____ is a blinking vertical line that indicates where the next typed character will appear.
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____.
A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ____.
destination area (or paste area)
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
What effect does the Accounting Number format have on the selected cells?
Displays cell contents with two decimal places that align vertically
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE?
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
Point mode allows you to ____, as shown in the accompanying figure below.
select cells for use in a formula using the mouse pointer
Which of the following Option buttons gives options for filling cells following a fill operation: Auto Fill Options, AutoCorrect Options, Insert Options, Paste Options.
Auto Fill Options
The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
You should ____ a function name in the Formula AutoComplete list to select the function.
Clicking the ____ opens the Insert Function dialog box shown in the accompanying figure.
Insert Function box on the formula bar
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Accounting number format
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ____ dollar sign.
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.
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
The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
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.
Which of the following is not a valid format symbol: semi colon (;), percent sign (%), dollar sign ($), comma (,).
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.