Exam 3: Formulas, Functions, and Formatting

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

(True/False)

4.8/5

(27)

Question 41

-Typing =av in a cell displays the ____________________, as shown in the accompanying figure.

(Short Answer)

4.8/5

(45)

Question 42

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

(True/False)

4.9/5

(26)

Question 43

Which of the following are valid formulas?

(Multiple Choice)

4.9/5

(32)

Question 44

When you decrease the row height to ____, the row is hidden.

(Multiple Choice)

4.9/5

(42)

Question 45

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

(Short Answer)

4.9/5

(30)

Question 46

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Copies a formula.

(Multiple Choice)

4.8/5

(33)

Question 47

Using the Excel spell checker, you can ____.

(Multiple Choice)

4.8/5

(25)

Question 48

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

(Short Answer)

4.9/5

(41)

Question 49

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

(Multiple Choice)

5.0/5

(33)

Question 50

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

(Multiple Choice)

4.9/5

(29)

Question 51

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

(Multiple Choice)

4.8/5

(39)

Question 52

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____________________ colors.

(Short Answer)

4.9/5

(33)

Question 53

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

(True/False)

4.7/5

(36)

Question 54

The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

(Short Answer)

4.7/5

(43)

Question 55

The Accounting number format assigns a floating dollar sign.

(True/False)

4.8/5

(37)

Question 56

Clicking the ____ opens the Insert Function dialog box.

(Multiple Choice)

4.9/5

(28)

Question 57

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

(True/False)

4.8/5

(34)

Question 58

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

(Multiple Choice)

4.9/5

(34)

Question 59

Briefly discuss the order of operations.

(Essay)

4.9/5

(44)

Question 60

Showing 41 - 60 of 111

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

-Typing =av in a cell displays the ____________________, as shown in the accompanying figure.

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

Which of the following are valid formulas?

When you decrease the row height to ____, the row is hidden.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Copies a formula.

Using the Excel spell checker, you can ____.

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

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

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

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

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____________________ colors.

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

The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

The Accounting number format assigns a floating dollar sign.

Clicking the ____ opens the Insert Function dialog box.

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

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Briefly discuss the order of operations.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters