FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel_Module_3

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Column
B) Bar
C) Line
D) Clustered Column

E) All of the above
F) B) and C)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which comparison operator means "not equal to"?

A) <=
B) >
C) <
D) <>

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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.

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.​

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

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

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.

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?

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

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

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.

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?

The arguments in an IF function are ____.

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

Which of the following formulas contains an absolute cell reference?