Exam 5: Working With Multiple Worksheets and Workbooks

Explore all topics

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Excel continually reviews the workbook for errors in formulas.

(Multiple Choice)

4.7/5

(26)

Question 101

If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.

(True/False)

4.9/5

(37)

Question 102

To prevent round-off errors, use the ____ function.

(Multiple Choice)

4.9/5

(35)

Question 103

In general, all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.

(Short Answer)

4.9/5

(38)

Question 104

Excel is case sensitive with respect to names of cells.

(True/False)

4.8/5

(33)

Question 105

Data tables have multiple purpose(s).

(True/False)

4.9/5

(35)

Question 106

Data tables must be built in a(n) ____ area of a worksheet.

(Multiple Choice)

4.9/5

(28)

Question 107

A cell name often is created from column and row titles.

(True/False)

4.9/5

(31)

Question 108

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns the present value of an investment or annuity.

(Multiple Choice)

4.8/5

(38)

Question 109

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

(True/False)

4.8/5

(31)

Question 110

You can use ____________________ to separate sections of a worksheet.

(Short Answer)

4.7/5

(34)

Question 111

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

(Short Answer)

4.7/5

(32)

Question 112

Showing 101 - 112 of 112

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Excel continually reviews the workbook for errors in formulas.

If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.

To prevent round-off errors, use the ____ function.

In general, all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.

Excel is case sensitive with respect to names of cells.

Data tables have multiple purpose(s).

Data tables must be built in a(n) ____ area of a worksheet.

A cell name often is created from column and row titles.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns the present value of an investment or annuity.

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

You can use ____________________ to separate sections of a worksheet.

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

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