Exam 4: 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.

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.

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

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

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

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.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

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

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

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

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

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

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

With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

Cell references in a formula are called ____.

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

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?

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

You can select nonadjacent ranges using the SHIFT key.