FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Excel_Module_2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

A) contiguous
B) indexed
C) direct
D) indirect

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

A) 8.43
B) 7.52
C) 11.65
D) 9.43

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

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

A ____ is a prewritten formula that is built into Excel.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Which of the following are valid formulas?

You can press the ____________________ key to quit Range Finder.

Which of the following Option buttons gives options for filling cells following a fill operation?

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Using the Excel spell checker, you can ____.

A ____ is text and graphics that print at the top of each page.

A ____ is text and graphics that print at the bottom of every page.

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?