Question 1

All of the following are methods to define a name for a cell or group of cells except: ________.

Accepted Answer

A) Select the range,open Name Manager,click New,and then type the name. 
B) Select the range,click in the Formula bar,and then type the name. 
C) Select the range,click in the Name box,and then type the name. 
D) Select the range,click the Define Name button,and then type the name. 
A) Select the range,open Name Manager,click New,and then type the name. 
B) Select the range,click in the Formula bar,and then type the name. 
C) Select the range,click in the Name box,and then type the name. 
D) Select the range,click the Define Name button,and then type the name. B

Question 2

When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.

Accepted Answer

A) table array 
B) Formula AutoComplete list 
C) defined name 
D) AutoFill 
A) table array 
B) Formula AutoComplete list 
C) defined name 
D) AutoFill B

Question 3

In the Excel PMT function,the term used to indicate the interest rate for a loan is called ________.

Accepted Answer

A) Present value (Pv) 
B) rate 
C) Future value (Fv) 
D) payment period 
A) Present value (Pv) 
B) rate 
C) Future value (Fv) 
D) payment period B

Question 4

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

Accepted Answer

A) lookup 
B) protection 
C) Goal Seek 
D) validation 
A) lookup 
B) protection 
C) Goal Seek 
D) validation

Question 5

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

Accepted Answer

A) Financial 
B) Lookup 
C) Statistical 
D) Logical 
A) Financial 
B) Lookup 
C) Statistical 
D) Logical

Question 6

Match the following five terms with their descriptions:
i.Trace Precedents command
II.Dependent cells
III.Trace Dependents command
IV.Trace Error command
v.Error checking command

Accepted Answer

A) Cells that contain formulas that refer to other cells 
B) Checks for common errors that occur in formulas 
C) Locates and resolves errors by tracing the selected error value 
D) Displays arrows that indicate what cells affect the value of the selected cell 
E) displays arrows that indicate what cells affect the value of the selected cell 
A) Cells that contain formulas that refer to other cells 
B) Checks for common errors that occur in formulas 
C) Locates and resolves errors by tracing the selected error value 
D) Displays arrows that indicate what cells affect the value of the selected cell 
E) displays arrows that indicate what cells affect the value of the selected cell

Question 7

________ is a technique in which you control the data or the values that are entered into a cell.

Accepted Answer

The answer of ________ is a technique in which you...

Question 8

A defined name that is distinctive and easy to remember,typically describes the ________ of the selected cells.

Accepted Answer

The answer of A defined name that is distinctive and...

Question 9

You cannot insert new data into a named range.

Accepted Answer

A) True 
 B)False

Question 10

Excel includes a group of ________ features,which consist of tools and commands accessible from the formulas tab that help you check your worksheet for errors.

Accepted Answer

The answer of Excel includes a group of ________ features,which...

Question 11

A(n)________ data table changes the value in only one cell.

Accepted Answer

The answer of A(n)________ data table changes the value in...

Question 12

The Watch Window displays the results of specified cells.

Accepted Answer

A) True 
 B)False

Question 13

To see how different interest rates and different payment periods will affect a monthly payment,use a ________.

Accepted Answer

A) two-variable data table 
B) one-variable data table 
C) defined name 
D) table array 
A) two-variable data table 
B) one-variable data table 
C) defined name 
D) table array

Question 14

An advantage to naming a range of cells is that you can use the name in a ________.

Accepted Answer

A) data table 
B) formula 
C) table array 
D) lookup table 
A) data table 
B) formula 
C) table array 
D) lookup table

Question 15

________ displays arrows that indicate what cells are affected by the value of the currently selected cell.

Accepted Answer

A) Trace Dependents command 
B) Trace Precedents command 
C) Tracer Arrow 
D) Trace Error command 
A) Trace Dependents command 
B) Trace Precedents command 
C) Tracer Arrow 
D) Trace Error command

Question 16

Using various interest rates to determine the amount of loan payments is an example of using ________.

Accepted Answer

A) What-If Analysis 
B) Protection 
C) Validation 
D) Lookup 
A) What-If Analysis 
B) Protection 
C) Validation 
D) Lookup

Question 17

________ is the process of examining a worksheet for errors in formulas.

Accepted Answer

A) Segmenting 
B) Tracing 
C) Defining 
D) Auditing 
A) Segmenting 
B) Tracing 
C) Defining 
D) Auditing

Question 18

The ________ command displays arrows that indicate what cells are affected by the value of the selected cell.

Accepted Answer

The answer of The ________ command displays arrows that indicate...

Question 19

Match the following five terms to their meanings:
i.Future value (Fv)
II.Nper
III.PMT
IV.principal
v.arguments

Accepted Answer

A) prebuilt function that calculates payments on a loan 
B) initial amount of the loan 
C) abbreviation for number of time periods 
D) the value at the end of the time period 
E) values that an Excel function uses to perform calculations or operations 
A) prebuilt function that calculates payments on a loan 
B) initial amount of the loan 
C) abbreviation for number of time periods 
D) the value at the end of the time period 
E) values that an Excel function uses to perform calculations or operations

Question 20

________ is a method to find a specific value for a cell by adjusting the value of one other cell.

Accepted Answer

The answer of ________ is a method to find a...

All of the following are methods to define a name for a cell or group of cells except: ________.

When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.

In the Excel PMT function,the term used to indicate the interest rate for a loan is called ________.

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

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

Match the following five terms with their descriptions: i.Trace Precedents command II.Dependent cells III.Trace Dependents command IV.Trace Error command v.Error checking command

________ is a technique in which you control the data or the values that are entered into a cell.

A defined name that is distinctive and easy to remember,typically describes the ________ of the selected cells.

You cannot insert new data into a named range.

Excel includes a group of ________ features,which consist of tools and commands accessible from the formulas tab that help you check your worksheet for errors.

A(n)________ data table changes the value in only one cell.

The Watch Window displays the results of specified cells.

To see how different interest rates and different payment periods will affect a monthly payment,use a ________.

An advantage to naming a range of cells is that you can use the name in a ________.

________ displays arrows that indicate what cells are affected by the value of the currently selected cell.

Using various interest rates to determine the amount of loan payments is an example of using ________.

________ is the process of examining a worksheet for errors in formulas.

The ________ command displays arrows that indicate what cells are affected by the value of the selected cell.

Match the following five terms to their meanings: i.Future value (Fv) II.Nper III.PMT IV.principal v.arguments

________ is a method to find a specific value for a cell by adjusting the value of one other cell.

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

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

All of the following are methods to define a name for a cell or group of cells except: ________.

When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.

In the Excel PMT function,the term used to indicate the interest rate for a loan is called ________.

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

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

Match the following five terms with their descriptions: i.Trace Precedents command II.Dependent cells III.Trace Dependents command IV.Trace Error command v.Error checking command

________ is a technique in which you control the data or the values that are entered into a cell.

A defined name that is distinctive and easy to remember,typically describes the ________ of the selected cells.

You cannot insert new data into a named range.

Excel includes a group of ________ features,which consist of tools and commands accessible from the formulas tab that help you check your worksheet for errors.

A(n)________ data table changes the value in only one cell.

The Watch Window displays the results of specified cells.

To see how different interest rates and different payment periods will affect a monthly payment,use a ________.

An advantage to naming a range of cells is that you can use the name in a ________.

________ displays arrows that indicate what cells are affected by the value of the currently selected cell.

Using various interest rates to determine the amount of loan payments is an example of using ________.

________ is the process of examining a worksheet for errors in formulas.

The ________ command displays arrows that indicate what cells are affected by the value of the selected cell.

Match the following five terms to their meanings: i.Future value (Fv) II.Nper III.PMT IV.principal v.arguments

________ is a method to find a specific value for a cell by adjusting the value of one other cell.

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