Exam 11: Excel: Working With Large Worksheets, Charting, and What-If Analysis

Modified Multiple Choice Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

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

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

Critical Thinking Questions Case 3-1 George runs a mid-size accounting practice and recently upgraded to Excel 2013.He expects sales to grow in the next few months during tax season.After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area, which has the most visibility.If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist.Otherwise, George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

A sensitivity analysis is another name for a(n) ____________________ analysis.

Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of absolute, relative, and mixed cell references.

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

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

You can select nonadjacent ranges using the SHIFT key.

AND, OR, and NOT are called ____________________ operators.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

Which of the following is the path to the Goal Seek button?

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

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

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

When Excel cannot calculate a formula, it displays an error message in a cell.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.