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

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.

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

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

____ text often provides a strong visual appeal.

Which of the following is the path to the Increase or Decrease Indent button?

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

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

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

Case 3-2 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 is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work. -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.If in manipulating the worksheet she wants to copy the contents and formatting of a source area but not the formula,which keyboard shortcut will she use?

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.

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

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

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

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. -In George's Sales Data worksheet,the result for a formula in cell H14 is ######.What should George do?

Error messages begin with the ____ symbol.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

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

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.