FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

The AVERAGE function requires that the argument be included within parentheses following the function name.

The range automatically selected by Excel is always correct.

You can use the arrow keys to complete an entry in Point mode.

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

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Cooler colors tend to pull away from the reader._________________________

You can press the ____________________ key to quit Range Finder.

You cannot format an entire column at once.

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

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

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

When you click the Decrease Font Size button,Excel assigns the next highest font size in the Font Size gallery.

All of the following are valid Excel arithmetic operators EXCEPT ____.

A(n)____________________ is a dot on the screen that contains a color.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

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

The adjusted cell references in a copied and pasted formula are called ____ cell references.

The ____ function determines the lowest number in a range.