Exam 4: Financial Functions,Data Tables,and Amortization Schedules

Explore all topics

When Range Finder is active,you can drag the outlines from one cell to another cell to change the cells referenced in the formula,provided the cells have not been named.

(True/False)

4.8/5

(35)

Question 101

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Invoked by clicking the Error Checking button.

(Multiple Choice)

4.9/5

(30)

Question 102

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

(True/False)

4.8/5

(39)

Question 103

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

(34)

Question 104

Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.

(Short Answer)

4.8/5

(28)

Question 105

You can add only a maximum of five conditional formats to a range.

(True/False)

4.9/5

(34)

Question 106

Which of the following is the path to the Cell Styles button?

(Multiple Choice)

4.8/5

(45)

Question 107

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

(True/False)

4.7/5

(25)

Question 108

In a process called ____,Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

(Multiple Choice)

4.7/5

(29)

Question 109

To select noncontiguous ranges,after selecting the first range,hold down the ____ key an drag through the additional ranges of cells to select them.

(Multiple Choice)

4.7/5

(35)

Question 110

Showing 101 - 110 of 110

When Range Finder is active,you can drag the outlines from one cell to another cell to change the cells referenced in the formula,provided the cells have not been named.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Invoked by clicking the Error Checking button.

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

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

Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.

You can add only a maximum of five conditional formats to a range.

Which of the following is the path to the Cell Styles button?

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

In a process called ____,Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

To select noncontiguous ranges,after selecting the first range,hold down the ____ key an drag through the additional ranges of cells to select them.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

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

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters