FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

The range automatically selected by Excel is always correct.

Correct Answer

verified

False

Question 3

Short Answer

Review LaterAdd Note

____________________ colors jump out of a dark background and are easiest to see.

Identify the letter of the choice that best matches the phrase or definition.

The ____ function determines the lowest number in a range.

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.

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

The ____ function displays the highest value in a range.

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.

Identify the letter of the choice that best matches the phrase or definition.

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

The / arithmetic operator indicates ____________________.

You cannot format an entire column at once.

Identify the letter of the choice that best matches the phrase or definition.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

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

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

The most common error when entering a formula is to reference the wrong cell in the formula.

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