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

Explore all topics

Apply styles to cells,such as Headings and Titles and Data and Model,by using the ________ command in the Styles group.

(Multiple Choice)

4.8/5

(42)

Question 81

The ________ command checks for common errors that occur when using formulas.

(Multiple Choice)

4.9/5

(25)

Question 82

The ________ function looks up values in a table array arranged in horizontal rows.

(Multiple Choice)

4.9/5

(35)

Question 83

Data tables are useful to to view and compare the results of using different values in a formula.

(True/False)

4.9/5

(42)

Question 84

The amount charged for the use of borrowed money is called ________.

(Multiple Choice)

4.8/5

(42)

Question 85

A method to find a specific value for a cell by adjusting the value of another cell is ________.

(Short Answer)

4.7/5

(40)

Question 86

Goal Seek is part of a suite of data tools used for What-If Analysis.

(True/False)

4.8/5

(43)

Question 87

The Future value (Fv)at the end of the time period in an Excel function is usually ________ for loans.

(Multiple Choice)

4.8/5

(41)

Question 88

The Watch Window is useful to monitor cells in one part of a workbook while working on another part of the workbook.

(True/False)

4.9/5

(35)

Question 89

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

(Multiple Choice)

4.8/5

(40)

Question 90

An indicator that shows the relationship between the active cell and its related cell is called a(n)________.

(Multiple Choice)

4.9/5

(47)

Question 91

A one-variable data table will allow you to see how different interest rates and different payment periods will affect a monthly payment.

(True/False)

4.9/5

(39)

Question 92

Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.

(Multiple Choice)

4.9/5

(34)

Question 93

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.

(Multiple Choice)

4.9/5

(40)

Question 94

When using a validation list,any value not on the list is considered ________.

(Short Answer)

4.8/5

(34)

Question 95

For lookup functions to work properly,the data in the table array must be sorted ________.

(Multiple Choice)

4.8/5

(42)

Question 96

The location within which a defined name is recognized without qualification is referred to as the ________.

(Multiple Choice)

4.9/5

(32)

Question 97

In a cell that contains a function,to copy the VALUE to another to cell-rather than the function-use the ________.

(Multiple Choice)

4.7/5

(34)

Question 98

A ________ is a list of values that are acceptable for a range of cells.

(Multiple Choice)

4.9/5

(44)

Question 99

Showing 81 - 99 of 99

Apply styles to cells,such as Headings and Titles and Data and Model,by using the ________ command in the Styles group.

The ________ command checks for common errors that occur when using formulas.

The ________ function looks up values in a table array arranged in horizontal rows.

Data tables are useful to to view and compare the results of using different values in a formula.

The amount charged for the use of borrowed money is called ________.

A method to find a specific value for a cell by adjusting the value of another cell is ________.

Goal Seek is part of a suite of data tools used for What-If Analysis.

The Future value (Fv)at the end of the time period in an Excel function is usually ________ for loans.

The Watch Window is useful to monitor cells in one part of a workbook while working on another part of the workbook.

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

An indicator that shows the relationship between the active cell and its related cell is called a(n)________.

A one-variable data table will allow you to see how different interest rates and different payment periods will affect a monthly payment.

Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.

When using a validation list,any value not on the list is considered ________.

For lookup functions to work properly,the data in the table array must be sorted ________.

The location within which a defined name is recognized without qualification is referred to as the ________.

In a cell that contains a function,to copy the VALUE to another to cell-rather than the function-use the ________.

A ________ is a list of values that are acceptable for a range of cells.

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