Question 1

Match between columns
                        Premises: Return 30 from the list: 29, 47, 21, 52, 1
Return 52 from the list: 29, 47, 21, 52, 1
1,2,3,4,5
Return 29 from the list: 29, 47, 21, 52, 1
Winona Lake, Winchester, Perrysburg, Clear Spring

Accepted Answer

The Answer of Sort descending and AVERAGE and MEDIAN and is...

Question 2

The ________ function is similar to the TODAY()function, except that it also returns the system time.

Accepted Answer

The answer of The ________ function is similar to the...

Question 3

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 4

The most used logical function is the IF function.

Accepted Answer

A) True 
 B)False

Question 5

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 6

The MIN and MAX functions can be used with ________ as well as numbers.

Accepted Answer

dates, var

Question 7

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

Accepted Answer

A) Fixed 
B) Relative 
C) Mixed 
D) Absolute 
A) Fixed 
B) Relative 
C) Mixed 
D) Absolute

Question 8

In a lookup table, the number of the column which contains the return values is called the ________.

Accepted Answer

The answer of In a lookup table, the number of...

Question 9

Functions can be selected by using the ________.

Accepted Answer

A) Add Function dialog box 
B) Format Function dialog box 
C) Insert Function dialog box 
D) Create Function dialog box 
A) Add Function dialog box 
B) Format Function dialog box 
C) Insert Function dialog box 
D) Create Function dialog box

Question 10

The test in an IF function must evaluate to either a True or a False.

Accepted Answer

A) True 
 B)False

Question 11

What will you see if you enter the TODAY function without the parenthesis?

Accepted Answer

A) #VALUE? 
B) Nothing. It will fill in the parenthesis for you. 
C) #FUNCTION? 
D) #NAME? 
A) #VALUE? 
B) Nothing. It will fill in the parenthesis for you. 
C) #FUNCTION? 
D) #NAME?

Question 12

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 13

Match between columns
                        Premises: Quick Analysis
Logical test
Function ScreenTip
Syntax
Formula AutoComplete

Accepted Answer

The Answer of Matches letters as you type and Evaluates is...

Question 14

If A9>B7 is the test in an IF function, ________ would result in the same results as long as the value if true and the value if false arguments are switched.

Accepted Answer

The answer of If A9>B7 is the test in an...

Question 15

What function computes the value in which one-half of the data is above and one-half is below.

Accepted Answer

A) MIDDLE 
B) MODE 
C) AVERAGE 
D) MEDIAN 
A) MIDDLE 
B) MODE 
C) AVERAGE 
D) MEDIAN

Question 16

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 17

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

Accepted Answer

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

Question 18

________ is a set of analytical tools that appears when you select a range.

Accepted Answer

The answer of ________ is a set of analytical tools...

Question 19

The two optional arguments in the PMT function allows the function to be used with variable loans.

Accepted Answer

A) True 
 B)False

Question 20

What type of cell reference should be used when a value remains constant?

Accepted Answer

A) Absolute 
B) Relative 
C) Mixed 
D) Constant 
A) Absolute 
B) Relative 
C) Mixed 
D) Constant

The ________ function is similar to the TODAY()function, except that it also returns the system time.

What do you use to separate arguments in a function?

The most used logical function is the IF function.

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

The MIN and MAX functions can be used with ________ as well as numbers.

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

In a lookup table, the number of the column which contains the return values is called the ________.

Functions can be selected by using the ________.

The test in an IF function must evaluate to either a True or a False.

What will you see if you enter the TODAY function without the parenthesis?

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

If A9>B7 is the test in an IF function, ________ would result in the same results as long as the value if true and the value if false arguments are switched.

What function computes the value in which one-half of the data is above and one-half is below.

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

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

________ is a set of analytical tools that appears when you select a range.

The two optional arguments in the PMT function allows the function to be used with variable loans.

What type of cell reference should be used when a value remains constant?

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

The ________ function is similar to the TODAY()function, except that it also returns the system time.

What do you use to separate arguments in a function?

The most used logical function is the IF function.

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

The MIN and MAX functions can be used with ________ as well as numbers.

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

In a lookup table, the number of the column which contains the return values is called the ________.

Functions can be selected by using the ________.

The test in an IF function must evaluate to either a True or a False.

What will you see if you enter the TODAY function without the parenthesis?

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

If A9>B7 is the test in an IF function, ________ would result in the same results as long as the value if true and the value if false arguments are switched.

What function computes the value in which one-half of the data is above and one-half is below.

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

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

________ is a set of analytical tools that appears when you select a range.

The two optional arguments in the PMT function allows the function to be used with variable loans.

What type of cell reference should be used when a value remains constant?

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