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

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.

_____ text often provides a strong visual appeal.

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?

AND, OR, and NOT are called _________________________ operators.

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

A(n)_________________________ is a good way to compare visually a small set of numbers.

_________________________ allows you automatically to modify values in a what-if area of a worksheet based on a goal that you have for another cell in the worksheet.

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

George runs a mid-size accounting practice and recently upgraded to Excel 2010.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.In George's Sales Data worksheet, the result for a formula in cell H14 is ######.What should George do?

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

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 _____.

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

Pressing the _____ key(s)removes the marquee from the source area.

Which of the following is the path to the Zoom button?

_____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

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

Many Ribbon commands, galleries, and shortcut keys function as toggles or switches.