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

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

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

Rotated text allows you to fit more text into a smaller column width.

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

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

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

Which of the following is not a valid format symbol?

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

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.

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

Excel includes four types of sparkline charts: line,column,win / loss,and stock.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

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 arguments in an IF function are ____.

The underline format underlines the entire cell,not just the characters in the cell.

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 wants to copy the contents and format of a source area but transpose,or swap,the rows and columns.What keyboard shortcut can she use to do this?

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

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns a number that corresponds to the system date and time beginning with December 31,1899.