B. Computer Exam (Task 17)

_____ refers to cells not wide enough to display the entire entry.​

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

Panes created using the vertical split bar scroll together horizontally. ________________________

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

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

You can replace a formula with its function so it remains constant.​__________

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

You should use a ____ chart to compare values side by side, broken down by category.

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

The <= comparison operator means less than or equal to

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key

Error messages begin with the _____ symbol.​

_____ text often provides a strong visual appeal.​

Cell references in a formula are called ____.

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

You use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.​

The path to the Logical button is (FORMULAS tab | Function Library group).

Which of the following are formatting symbols?

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

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.

Which of the following formulas contains an absolute cell reference?

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

You can click the Logical button (FORMULAS tab | Function Library group) and click IFERROR to insert the IF function. _________________________

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

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

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

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.