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

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

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

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

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

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

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

You can replace a formula with its function so it remains constant._________________________

The incorrect use of copying,deleting,inserting,and moving ranges of cells has the potential to render a worksheet useless.

Explain in detail the utility of freezing worksheet columns and rows.

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

Which of the following are formatting symbols?

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

Which of the following patterns extends the fill series to 575,550,525?

Discuss how you should format the various elements of a worksheet.

Identify the letter of the choice that best matches the phrase or definition. -Determines the value of a cell on which the formula depends.

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

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 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 type of chart shown in the accompanying figure is a(n)____________________ chart.

The arguments in an IF function are ____.