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

You can create your own _________________________ for use with the fill handle.

Cell references in a formula are called _____.

You know Excel is in copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

Excel displays the error message _________________________ in cells to indicate a cell reference error in a formula.

Error messages begin with the _____ symbol.

When you change a value on which a chart is dependent, Excel immediately _________________________ the chart.

The Formula Auditing group on the Formulas tab on the Ribbon also can be helpful when verifying ____________________.

In the accompanying figure, worksheet titles are frozen above and to the left of cell B13.

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

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

An alternative to clicking the Paste button is to press the _____ key.

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

The _____ function is useful when you want to assign a value to a cell based on a logical test.

The use of multiple _________________________ charts in the worksheet will provide the user with a visual comparison of the various data items.

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

You can specify the style and color for the parts of a Sparkline chart by selecting a style in the Styles group on the _________________________.

You should use a _____ chart to show the relationship or proportion of parts to a whole.

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