Question 1

Which function would you use to find the oldest date in a range?

Accepted Answer

A) MIN 
B) MAX 
C) OLDEST 
D) MEDIAN 
A) MIN 
B) MAX 
C) OLDEST 
D) MEDIAN

Question 2

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the blank cells,which function would you use?

Accepted Answer

A) COUNT 
B) COUNTA 
C) COUNTBLANK 
D) COUNTIF 
A) COUNT 
B) COUNTA 
C) COUNTBLANK 
D) COUNTIF

Question 3

In the HLOOKUP function,the third argument is the column index number.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not an argument associated with the IF function?

Accepted Answer

A) Test 
B) Value if true 
C) Value if false 
D) Value if neither true nor false 
A) Test 
B) Value if true 
C) Value if false 
D) Value if neither true nor false

Question 5

The COUNTA function only counts text entries.It does not count calculable values or blank cells.

Accepted Answer

A) True 
 B)False

Question 6

When working with dates,Excel actually assigns ________ numbers to each date.

Accepted Answer

The answer of When working with dates,Excel actually assigns ________...

Question 7

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 8

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 9

Which of the following is not a valid lookup function?

Accepted Answer

A) HLOOKUP 
B) VLOOKUP 
C) LLOOKUP 
D) LOOKUP 
A) HLOOKUP 
B) VLOOKUP 
C) LLOOKUP 
D) LOOKUP

Question 10

In a mixed reference you can put the dollar sign ($)in front of the column or row indicator.

Accepted Answer

A) True 
 B)False

Question 11

A lookup table should contain at least two rows and two columns,not counting headings.

Accepted Answer

A) True 
 B)False

Question 12

If the annual interest rate is 12% and payments are made monthly,then you would enter ________ in the RATE argument in the PMT function.

Accepted Answer

The answer of If the annual interest rate is 12%...

Question 13

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 14

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

Accepted Answer

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

Question 15

What actually changes the value Excel stores to a user determined number of decimal places?

Accepted Answer

A) Decrease decimal setting 
B) Increase decimal setting 
C) ROUND function 
D) DECIMAL function 
A) Decrease decimal setting 
B) Increase decimal setting 
C) ROUND function 
D) DECIMAL function

Question 16

The ________ function finds the smallest value in a range.

Accepted Answer

The answer of The ________ function finds the smallest value...

Question 17

What do you use to separate arguments in a function?

Accepted Answer

A) Period (. ) 
B) Semi-colon (;) 
C) Comma (,) 
D) Colon (:) 
A) Period (. ) 
B) Semi-colon (;) 
C) Comma (,) 
D) Colon (:)

Question 18

How many functions does Excel provide?

Accepted Answer

A) Over 40 
B) Over 400 
C) Over 4,000 
D) Unlimited 
A) Over 40 
B) Over 400 
C) Over 4,000 
D) Unlimited

Question 19

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 20

The PMT function uses three required arguments and no optional arguments.

Accepted Answer

A) True 
 B)False

Which function would you use to find the oldest date in a range?

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the blank cells,which function would you use?

In the HLOOKUP function,the third argument is the column index number.

Which of the following is not an argument associated with the IF function?

The COUNTA function only counts text entries.It does not count calculable values or blank cells.

When working with dates,Excel actually assigns ________ numbers to each date.

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

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.

Which of the following is not a valid lookup function?

In a mixed reference you can put the dollar sign ($)in front of the column or row indicator.

A lookup table should contain at least two rows and two columns,not counting headings.

If the annual interest rate is 12% and payments are made monthly,then you would enter ________ in the RATE argument in the PMT function.

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.

What actually changes the value Excel stores to a user determined number of decimal places?

The ________ function finds the smallest value in a range.

What do you use to separate arguments in a function?

How many functions does Excel provide?

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

The PMT function uses three required arguments and no optional arguments.

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters

Exam 2: Formulas and Functions

Which function would you use to find the oldest date in a range?

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the blank cells,which function would you use?

In the HLOOKUP function,the third argument is the column index number.

Which of the following is not an argument associated with the IF function?

The COUNTA function only counts text entries.It does not count calculable values or blank cells.

When working with dates,Excel actually assigns ________ numbers to each date.

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

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.

Which of the following is not a valid lookup function?

In a mixed reference you can put the dollar sign ($)in front of the column or row indicator.

A lookup table should contain at least two rows and two columns,not counting headings.

If the annual interest rate is 12% and payments are made monthly,then you would enter ________ in the RATE argument in the PMT function.

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.

What actually changes the value Excel stores to a user determined number of decimal places?

The ________ function finds the smallest value in a range.

What do you use to separate arguments in a function?

How many functions does Excel provide?

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

The PMT function uses three required arguments and no optional arguments.

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters