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

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true).

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.

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.

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.

____________________ are values in cells that can be changed to determine new values for formulas.

Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea wants to add a 3-D Pie chart to her workbook in which each slice represents the popularity of different types of pies she plans to sell.Bea finished adding the results of her survey to a worksheet in her new workbook, including the number of people who voted for each type of pie.In a Pie chart that indicates the popularity of each type of pie, which statement is true about the number of votes for each type of pie, called the data series?

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

Which of the following is a valid rotation (counterclockwise)value for text in a cell in the Alignment sheet in the Format Cells dialog?

If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

Error messages in Excel always begin with a(n)& character.

Cell references in a formula are called ____.

To assign a Currency style with a floating dollar sign, use the ____________________ dialog rather than the Accounting Style button in the Number group on the Home tab, which assigns a fixed dollar sign.

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

Which of the following are formatting symbols?

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 show the relationship or proportion of parts to a whole.

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

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