Question 1

The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted.

Accepted Answer

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

Question 2

________ is code that uses the structure of functions but with wording that is for logical understanding.

Accepted Answer

The answer of ________ is code that uses the structure...

Question 3

In the VLOOKUP function below,which of the following statements is NOT true?
=VLOOKUP(A6,Shifts,5,FALSE)

Accepted Answer

A) The content of A6 is compared to the contents of first column of the table array. 
B) Shifts is the name assigned to the table array being used by the function. 
C) The number in the third argument stands for how many columns exist in the table array. 
D) The contents of the fourth argument requires an exact match with the first argument. 
A) The content of A6 is compared to the contents of first column of the table array. 
B) Shifts is the name assigned to the table array being used by the function. 
C) The number in the third argument stands for how many columns exist in the table array. 
D) The contents of the fourth argument requires an exact match with the first argument.

Question 4

The ability to use MATCH and INDEX together is a powerful capability within Excel.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) An advantage of using the DSUM function is that you can see the criteria on the worksheet and understand the calculation much easier. 
B) The DSUM function is a database function that is ideal for setting up a criteria range and then calculating the sum based on the filters within that criteria range. 
C) The criteria can be modified on the worksheet and the result is updated automatically. 
D) The syntax of the DSUM function is =DSUM(database, field, [criteria])where criteria is optional. 
A) An advantage of using the DSUM function is that you can see the criteria on the worksheet and understand the calculation much easier. 
B) The DSUM function is a database function that is ideal for setting up a criteria range and then calculating the sum based on the filters within that criteria range. 
C) The criteria can be modified on the worksheet and the result is updated automatically. 
D) The syntax of the DSUM function is =DSUM(database, field, [criteria])where criteria is optional.

Question 6

Which of the following is the correct syntax for the INDEX function?

Accepted Answer

A) =INDEX(array, row_number, [column_number]) 
B) =INDEX(column_number, row_number, array) 
C) =INDEX(array, column_number, [row_number]) 
D) =INDEX([column_number], row_number, array) 
A) =INDEX(array, row_number, [column_number]) 
B) =INDEX(column_number, row_number, array) 
C) =INDEX(array, column_number, [row_number]) 
D) =INDEX([column_number], row_number, array)

Question 7

The following function is an example of a(n)________ function.
=IF(SUM(H2:J7)>Total_Sales,.05,"No Commission")

Accepted Answer

A) integrated 
B) complex 
C) detailed 
D) compound 
A) integrated 
B) complex 
C) detailed 
D) compound

Question 8

A(n)________ is the strategic advantage that a business has over its competition.

Accepted Answer

competitiv

Question 9

All of the following statements are TRUE about nested IF functions EXCEPT:

Accepted Answer

A) Each nested function needs a pair of parentheses. 
B) Excel color codes parentheses to indicate which parentheses are paired. 
C) Nested IF functions permit more than two outcomes. 
D) The outcome of a nested IF function is limited to numeric or text values. 
A) Each nested function needs a pair of parentheses. 
B) Excel color codes parentheses to indicate which parentheses are paired. 
C) Nested IF functions permit more than two outcomes. 
D) The outcome of a nested IF function is limited to numeric or text values.

Question 10

The COUNTIFS function allows for multiple criteria in multiple ranges to be evaluated and counted.

Accepted Answer

A) True 
 B)False

Question 11

If numbers appear for the column headings,the reference style for Excel is currently A1.

Accepted Answer

A) True 
 B)False

Question 12

A conditional ________ function can calculate on a subset of data that meets specified criteria.

Accepted Answer

The answer of A conditional ________ function can calculate on...

Question 13

The VLOOKUP function is the more commonly used LOOKUP function.

Accepted Answer

A) True 
 B)False

Question 14

AND,OR,and NEVER are all examples of conjunction functions.

Accepted Answer

A) True 
 B)False

Question 15

The second argument of the IF function is ________.

Accepted Answer

A) [value_if_true] 
B) [value_if_false] 
C) [logical_test] 
D) [criteria] 
A) [value_if_true] 
B) [value_if_false] 
C) [logical_test] 
D) [criteria]

Question 16

If letters appear for the column headings,the reference style for Excel is currently R1C1.

Accepted Answer

A) True 
 B)False

Question 17

The DSUM function is a database function that is great for setting up a criteria range and then calculating the sum based on the filters within that criteria range.

Accepted Answer

A) True 
 B)False

Question 18

________ code is a tool used to understand the logic of conjunctive functions where words are entered in the function structure.

Accepted Answer

A) Pseudo 
B) Simulated 
C) Text 
D) Statement 
A) Pseudo 
B) Simulated 
C) Text 
D) Statement

Question 19

A(n)________ function is used to look up a value in a column to the left of the data you want to find,and then return data that is associated with that value.

Accepted Answer

The answer of A(n)________ function is used to look up...

Question 20

Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.

Accepted Answer

A) True 
 B)False

The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted.

________ is code that uses the structure of functions but with wording that is for logical understanding.

In the VLOOKUP function below,which of the following statements is NOT true? =VLOOKUP(A6,Shifts,5,FALSE)

The ability to use MATCH and INDEX together is a powerful capability within Excel.

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

Which of the following is the correct syntax for the INDEX function?

The following function is an example of a(n)________ function. =IF(SUM(H2:J7)>Total_Sales,.05,"No Commission")

A(n)________ is the strategic advantage that a business has over its competition.

All of the following statements are TRUE about nested IF functions EXCEPT:

The COUNTIFS function allows for multiple criteria in multiple ranges to be evaluated and counted.

If numbers appear for the column headings,the reference style for Excel is currently A1.

A conditional ________ function can calculate on a subset of data that meets specified criteria.

The VLOOKUP function is the more commonly used LOOKUP function.

AND,OR,and NEVER are all examples of conjunction functions.

The second argument of the IF function is ________.

If letters appear for the column headings,the reference style for Excel is currently R1C1.

The DSUM function is a database function that is great for setting up a criteria range and then calculating the sum based on the filters within that criteria range.

________ code is a tool used to understand the logic of conjunctive functions where words are entered in the function structure.

A(n)________ function is used to look up a value in a column to the left of the data you want to find,and then return data that is associated with that value.

Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.

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

The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted.

________ is code that uses the structure of functions but with wording that is for logical understanding.

In the VLOOKUP function below,which of the following statements is NOT true? =VLOOKUP(A6,Shifts,5,FALSE)

The ability to use MATCH and INDEX together is a powerful capability within Excel.

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

Which of the following is the correct syntax for the INDEX function?

The following function is an example of a(n)________ function. =IF(SUM(H2:J7)>Total_Sales,.05,"No Commission")

A(n)________ is the strategic advantage that a business has over its competition.

All of the following statements are TRUE about nested IF functions EXCEPT:

The COUNTIFS function allows for multiple criteria in multiple ranges to be evaluated and counted.

If numbers appear for the column headings,the reference style for Excel is currently A1.

A conditional ________ function can calculate on a subset of data that meets specified criteria.

The VLOOKUP function is the more commonly used LOOKUP function.

AND,OR,and NEVER are all examples of conjunction functions.

The second argument of the IF function is ________.

If letters appear for the column headings,the reference style for Excel is currently R1C1.

The DSUM function is a database function that is great for setting up a criteria range and then calculating the sum based on the filters within that criteria range.

________ code is a tool used to understand the logic of conjunctive functions where words are entered in the function structure.

A(n)________ function is used to look up a value in a column to the left of the data you want to find,and then return data that is associated with that value.

Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.

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