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

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

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

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

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

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

Which of the following formulas contains an absolute cell reference?

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

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

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

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?

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.

You can create your own ____________________ fill sequences for use with the fill handle.

You can press the ____ keys to open the Format Cells dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.

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

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

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

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

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