Question 1

All of the following statements are TRUE about the IF function EXCEPT:

Accepted Answer

A) The [value_if_false] argument may be omitted from the IF function. 
B) The IF function is the most common logical function. 
C) The TRUE argument of the IF function is optional. 
D) Cell references listed in the IF function must be capitalized. 
A) The [value_if_false] argument may be omitted from the IF function. 
B) The IF function is the most common logical function. 
C) The TRUE argument of the IF function is optional. 
D) Cell references listed in the IF function must be capitalized.

Question 2

The IF function provides two outcomes,one when its logical test is true and one when its logical test is false.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Conditional aggregate function
IFERROR function
Conjunction function
Nested IF
Conditional statistical function

Accepted Answer

The Answer of A function that uses IF functions as is...

Question 4

The ________ function returns the value of an element in a table or array selected by the row and column number indexes.

Accepted Answer

The answer of The ________ function returns the value of...

Question 5

The INDIRECT function is valuable because it can change a cell reference to a text string.

Accepted Answer

A) True 
 B)False

Question 6

A ________ IF function uses IF functions as arguments within another IF function.

Accepted Answer

A) multiple 
B) composite 
C) nested 
D) multipart 
A) multiple 
B) composite 
C) nested 
D) multipart

Question 7

The first argument of the AVERAGEIF function is ________.

Accepted Answer

A) average_range 
B) range 
C) criteria 
D) logical_test 
A) average_range 
B) range 
C) criteria 
D) logical_test

Question 8

The ________ argument of the COUNTIF function is the logical statement that will determine which cells to count.

Accepted Answer

A) logical_test 
B) rule 
C) criteria 
D) control 
A) logical_test 
B) rule 
C) criteria 
D) control

Question 9

The ________ function sums data and allows for more than one filtering criteria.

Accepted Answer

The answer of The ________ function sums data and allows...

Question 10

The OR function is used when any combination of logical tests has at least one TRUE outcome.

Accepted Answer

A) True 
 B)False

Question 11

Conditional math functions include SUMIF and SUMIFS functions.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is NOT a common logical function?

Accepted Answer

A) IF 
B) NA 
C) OR 
D) NOT 
A) IF 
B) NA 
C) OR 
D) NOT

Question 13

All of the following statements are TRUE about conditional aggregate functions EXCEPT:

Accepted Answer

A) Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria. 
B) With an aggregate function, a range would still be provided, but the aggregation would only use cells that meet a given criteria. 
C) Elements such as named ranges and cell references should go inside quotes. 
D) The criteria can be on the data that is being aggregated or on associated data. 
A) Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria. 
B) With an aggregate function, a range would still be provided, but the aggregation would only use cells that meet a given criteria. 
C) Elements such as named ranges and cell references should go inside quotes. 
D) The criteria can be on the data that is being aggregated or on associated data.

Question 14

The third argument of the VLOOKUP function is ________.

Accepted Answer

A) lookup_value 
B) col_index_number 
C) range_lookup 
D) table_array 
A) lookup_value 
B) col_index_number 
C) range_lookup 
D) table_array

Question 15

The symbols  are examples of logical ________.

Accepted Answer

The answer of The symbols  are examples of logical...

Question 16

Excel color codes parentheses for each function used in a nested function.

Accepted Answer

A) True 
 B)False

Question 17

The ________ function is a useful tool for detecting an error and displaying something more user friendly than the error message.

Accepted Answer

The answer of The ________ function is a useful tool...

Question 18

The INDEX function works with the MATCH function extremely well because the MATCH function indicates the row where a match was found,and then the INDEX function can go to that row and another column to retrieve associated data.

Accepted Answer

A) True 
 B)False

Question 19

________ functions enable evaluation and choices to be integrated into an Excel spreadsheet.

Accepted Answer

A) Logical 
B) Comparison 
C) Decision 
D) Conditional 
A) Logical 
B) Comparison 
C) Decision 
D) Conditional

Question 20

The third argument of the AVERAGEIF function is only required if one range of data is being averaged based on the ________ of a second range.

Accepted Answer

The answer of The third argument of the AVERAGEIF function...

All of the following statements are TRUE about the IF function EXCEPT:

The IF function provides two outcomes,one when its logical test is true and one when its logical test is false.

The ________ function returns the value of an element in a table or array selected by the row and column number indexes.

The INDIRECT function is valuable because it can change a cell reference to a text string.

A ________ IF function uses IF functions as arguments within another IF function.

The first argument of the AVERAGEIF function is ________.

The ________ argument of the COUNTIF function is the logical statement that will determine which cells to count.

The ________ function sums data and allows for more than one filtering criteria.

The OR function is used when any combination of logical tests has at least one TRUE outcome.

Conditional math functions include SUMIF and SUMIFS functions.

Which of the following is NOT a common logical function?

All of the following statements are TRUE about conditional aggregate functions EXCEPT:

The third argument of the VLOOKUP function is ________.

The symbols < and > are examples of logical ________.

Excel color codes parentheses for each function used in a nested function.

The ________ function is a useful tool for detecting an error and displaying something more user friendly than the error message.

The INDEX function works with the MATCH function extremely well because the MATCH function indicates the row where a match was found,and then the INDEX function can go to that row and another column to retrieve associated data.

________ functions enable evaluation and choices to be integrated into an Excel spreadsheet.

The third argument of the AVERAGEIF function is only required if one range of data is being averaged based on the ________ of a second range.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 5: Complex Conditional and Retrieval Functions

All of the following statements are TRUE about the IF function EXCEPT:

The IF function provides two outcomes,one when its logical test is true and one when its logical test is false.

The ________ function returns the value of an element in a table or array selected by the row and column number indexes.

The INDIRECT function is valuable because it can change a cell reference to a text string.

A ________ IF function uses IF functions as arguments within another IF function.

The first argument of the AVERAGEIF function is ________.

The ________ argument of the COUNTIF function is the logical statement that will determine which cells to count.

The ________ function sums data and allows for more than one filtering criteria.

The OR function is used when any combination of logical tests has at least one TRUE outcome.

Conditional math functions include SUMIF and SUMIFS functions.

Which of the following is NOT a common logical function?

All of the following statements are TRUE about conditional aggregate functions EXCEPT:

The third argument of the VLOOKUP function is ________.

The symbols < and > are examples of logical ________.

Excel color codes parentheses for each function used in a nested function.

The ________ function is a useful tool for detecting an error and displaying something more user friendly than the error message.

The INDEX function works with the MATCH function extremely well because the MATCH function indicates the row where a match was found,and then the INDEX function can go to that row and another column to retrieve associated data.

________ functions enable evaluation and choices to be integrated into an Excel spreadsheet.

The third argument of the AVERAGEIF function is only required if one range of data is being averaged based on the ________ of a second range.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters