Exam 10: Excel_Module_3

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

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

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

The path to the Logical button is (FORMULAS tab | Function Library group).

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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. -To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____.​

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

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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. -_____ text often provides a strong visual appeal.​ ​

When working with a large worksheet, you can split the window into ____ panes.

Using the mouse to move or copy cells is called ____.

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

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

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.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Which of the following are formatting symbols?

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

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?

Which of the following is not a valid format symbol?

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

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