Question 1

Which of the following is not a valid test in an =IF statement?

Accepted Answer

A) A4-B4 B) A4A4 D) B4<=B4 A) A4-B4 B) A4A4 D) B4<=B4 A

Question 2

Functions can be nested inside the arguments in the various lookup functions.

Accepted Answer

A) True 
 B)False  True

Question 3

It is very important to sort the first column in a table lookup array in descending order.

Accepted Answer

A) True 
 B)False  False

Question 4

In the PMT function, the PV argument refers to the ________ of the loan.

Accepted Answer

The answer of In the PMT function, the PV argument...

Question 5

Match between columns
                        Premises: =???(12%/12,360,-120000)
=???(B7>9,"Bigger","Smaller")
=???(A4,B4:F9,2)
=???(B9:E21)
=???()

Accepted Answer

The Answer of IF and PMT and VLOOKUP and SUM is...

Question 6

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

Accepted Answer

A) =PMT(6%,60,-13000) 
B) =PMT(.5%,60,-13000) 
C) =PMT(.5%,5*12,-13000) 
D) =PMT(6%/12,60,-13000) 
A) =PMT(6%,60,-13000) 
B) =PMT(.5%,60,-13000) 
C) =PMT(.5%,5*12,-13000) 
D) =PMT(6%/12,60,-13000)

Question 7

In military time, 15:00 is ________ in non-military time.

Accepted Answer

3:00 PM, 3

Question 8

Which of the following would not give the same result for "=(5+32+75+21)/4"?

Accepted Answer

A) =SUM(5,32,75,21)/4 
B) =MEDIAN(5,32,75,21)+7.25 
C) =AVERAGEIF(5+32+75+21,4) 
D) =AVERAGE(5,32,75,21) 
A) =SUM(5,32,75,21)/4 
B) =MEDIAN(5,32,75,21)+7.25 
C) =AVERAGEIF(5+32+75+21,4) 
D) =AVERAGE(5,32,75,21)

Question 9

The ________ is the lowest value for a category in the table lookup table.

Accepted Answer

breakpoint

Question 10

The range that contains the lookup table is called the ________.

Accepted Answer

The answer of The range that contains the lookup table...

Question 11

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

Accepted Answer

A) =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) 
B) =IF(A720,"Much Greater","Not Greater than 20")) 
C) =IF(A720,"Much Greater","Not Greater than 20")) 
D) =IF(A720,"Much Greater","Not Greater than 20") 
A) =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) 
B) =IF(A720,"Much Greater","Not Greater than 20")) 
C) =IF(A720,"Much Greater","Not Greater than 20")) 
D) =IF(A720,"Much Greater","Not Greater than 20")

Question 12

________ references change when formulas are copy and pasted.

Accepted Answer

The answer of ________ references change when formulas are copy...

Question 13

If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.

Accepted Answer

A) True 
 B)False

Question 14

Excel assigns date number 1 to January 1, 1900.

Accepted Answer

A) True 
 B)False

Question 15

It is called a(n)________ function when a function is used inside of another function.

Accepted Answer

The answer of It is called a(n)________ function when a...

Question 16

What does the AVERAGE function not ignore?

Accepted Answer

A) Text 
B) Empty cells 
C) Dates 
D) Cells with N/A 
A) Text 
B) Empty cells 
C) Dates 
D) Cells with N/A

Question 17

If you will be paying monthly for six years to pay off a car, then you would enter ________ in the NPER argument in the PMT function.

Accepted Answer

The answer of If you will be paying monthly for...

Question 18

The default calculation using the PMT function will produce a negative number.

Accepted Answer

A) True 
 B)False

Question 19

What describes a function's purpose?

Accepted Answer

A) Arguments 
B) Name 
C) Category 
D) Variables 
A) Arguments 
B) Name 
C) Category 
D) Variables

Question 20

Match between columns
                        Premises: =A54
=$A54
"Ohio"
=SUM(A54:B97)
=$A$54

Accepted Answer

The Answer of Absolute reference and Mixed reference and Function is...

Which of the following is not a valid test in an =IF statement?

Functions can be nested inside the arguments in the various lookup functions.

It is very important to sort the first column in a table lookup array in descending order.

In the PMT function, the PV argument refers to the ________ of the loan.

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

In military time, 15:00 is ________ in non-military time.

Which of the following would not give the same result for "=(5+32+75+21)/4"?

The ________ is the lowest value for a category in the table lookup table.

The range that contains the lookup table is called the ________.

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

________ references change when formulas are copy and pasted.

If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.

Excel assigns date number 1 to January 1, 1900.

It is called a(n)________ function when a function is used inside of another function.

What does the AVERAGE function not ignore?

If you will be paying monthly for six years to pay off a car, then you would enter ________ in the NPER argument in the PMT function.

The default calculation using the PMT function will produce a negative number.

What describes a function's purpose?

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 2: Formulas and Functions

Which of the following is not a valid test in an =IF statement?

Functions can be nested inside the arguments in the various lookup functions.

It is very important to sort the first column in a table lookup array in descending order.

In the PMT function, the PV argument refers to the ________ of the loan.

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

In military time, 15:00 is ________ in non-military time.

Which of the following would not give the same result for "=(5+32+75+21)/4"?

The ________ is the lowest value for a category in the table lookup table.

The range that contains the lookup table is called the ________.

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

________ references change when formulas are copy and pasted.

If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.

Excel assigns date number 1 to January 1, 1900.

It is called a(n)________ function when a function is used inside of another function.

What does the AVERAGE function not ignore?

If you will be paying monthly for six years to pay off a car, then you would enter ________ in the NPER argument in the PMT function.

The default calculation using the PMT function will produce a negative number.

What describes a function's purpose?

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters