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

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.

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.

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

AND,OR,and NOT are called ____________________ operators.

Which of the following formulas contains an absolute cell reference?

The path to the Format Painter button is ____.

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

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

You can click the Logical button (FORMULAS tab | Function Library group)and tap or click IFERROR to insert the IF function._________________________

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. -If sales reach a certain amount by the end of April,George will purchase a desk,chair,computer,and software upgrade for the receptionist.Otherwise,George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

Which of the following is the path to the Zoom button?

Identify the letter of the choice that best matches the phrase or definition. -Fills a destination area using the format of the source area;no content is copied.

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

You should use a ____ chart to compare values side by side,broken down by category.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

A sensitivity analysis is another name for a(n)____________________ analysis.

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

You can select nonadjacent ranges using the SHIFT key.

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