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

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

With bar charts,you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

When you change a value on which a chart is dependent,Excel immediately redraws the chart based on the new value.

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

In a clustered column chart,the names of each column are part of the ____ series.

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?

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

Which of the following is not a valid format symbol?

Which comparison operator means "not equal to"?

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

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.