FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

A) Find Error
B) Explain Error
C) Fix Error
D) Trace Error

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

You can click the ____ button to undo an automatic correction.

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

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

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

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

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

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

You can press the ____________________ key to quit Range Finder.

In designing a worksheet,visual aesthetics should come first._________________________

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Wraps text in a cell.

Clicking the Create Function box opens the Function Arguments dialog box.

A formula in a cell that contains a reference back to itself is called a(n)____________________.

Cooler colors tend to pull away from the reader._________________________

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The range automatically selected by Excel is always correct.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Pastes a formula.

Which of the following actions are provided by the Paste Options button?