Exam 10: Excel_Module_3

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

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

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. -In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

Which comparison operator means "not equal to"?

The arguments in an IF function are ____.

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

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

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.

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

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 you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.​

Which of the following formulas contains an absolute cell reference?

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 ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.