Exam 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

When creating a data table to calculate a payment,the PMT function must be entered in the upper left corner of the range of data.

(True/False)

4.9/5

(38)

Question 61

When a new row is inserted into a named range,Excel adjusts formulas accordingly.

(True/False)

4.8/5

(34)

Question 62

Naming cells has no effect on the displayed or underlying values.

(True/False)

4.8/5

(49)

Question 63

Match the following five terms to their meanings: i.validation list II.data validation III.defined name IV.Watch Window v.scope

(Multiple Choice)

4.8/5

(31)

Question 64

Match the following five terms to their meanings: i.What-If Analysis II.Goal Seek III.data table IV.one-variable data table v.two-variable data table

(Multiple Choice)

4.8/5

(42)

Question 65

A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n)________.

(Multiple Choice)

4.9/5

(32)

Question 66

The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.

(True/False)

4.9/5

(32)

Question 67

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ________.

(Multiple Choice)

4.8/5

(36)

Question 68

The Error Checking command checks for common errors that occur in formulas.

(True/False)

4.9/5

(41)

Question 69

A data tables is useful for all of the following except for ________.

(Multiple Choice)

4.9/5

(47)

Question 70

________ look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.

(Short Answer)

4.9/5

(35)

Question 71

________ are prebuilt formulas that perform common business calculations such as calculating a loan payment on a vehicle.

(Short Answer)

4.8/5

(35)

Question 72

The Error Checking button displays as a ________.

(Multiple Choice)

4.7/5

(41)

Question 73

Excel includes a group of Formula Auditing features,which consists of tools and commands that help you to check a worksheet for errors.

(True/False)

4.9/5

(36)

Question 74

When borrowing money,the interest rate and number of periods is quoted in months.

(True/False)

4.8/5

(33)

Question 75

When you use a(n)________ in a formula,the result is the same as if you typed the cell reference.

(Short Answer)

4.8/5

(40)

Question 76

Data tables make it easy to calculate multiple versions in one operation,and then to view and compare the results of all the different variations.

(True/False)

4.9/5

(37)

Question 77

Use the ________ command to locate and resolve an error in a formula.

(Multiple Choice)

4.7/5

(38)

Question 78

In a lookup formula,the defined range is referred to as the ________.

(Short Answer)

4.8/5

(43)

Question 79

Present value (Pv)-the total amount that a series of future payments is worth now-is also referred to as the ________.

(Short Answer)

4.8/5

(40)

Question 80

Showing 61 - 80 of 99

When creating a data table to calculate a payment,the PMT function must be entered in the upper left corner of the range of data.

When a new row is inserted into a named range,Excel adjusts formulas accordingly.

Naming cells has no effect on the displayed or underlying values.

Match the following five terms to their meanings: i.validation list II.data validation III.defined name IV.Watch Window v.scope

Match the following five terms to their meanings: i.What-If Analysis II.Goal Seek III.data table IV.one-variable data table v.two-variable data table

A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n)________.

The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ________.

The Error Checking command checks for common errors that occur in formulas.

A data tables is useful for all of the following except for ________.

________ look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.

________ are prebuilt formulas that perform common business calculations such as calculating a loan payment on a vehicle.

The Error Checking button displays as a ________.

Excel includes a group of Formula Auditing features,which consists of tools and commands that help you to check a worksheet for errors.

When borrowing money,the interest rate and number of periods is quoted in months.

When you use a(n)________ in a formula,the result is the same as if you typed the cell reference.

Data tables make it easy to calculate multiple versions in one operation,and then to view and compare the results of all the different variations.

Use the ________ command to locate and resolve an error in a formula.

In a lookup formula,the defined range is referred to as the ________.

Present value (Pv)-the total amount that a series of future payments is worth now-is also referred to as the ________.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters