Question 1

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

Accepted Answer

A) VLOOKUP 
B) VAVERAGE 
C) VMATCH 
D) VAPPROXIMATE 
A) VLOOKUP 
B) VAVERAGE 
C) VMATCH 
D) VAPPROXIMATE

Question 2

When using VLOOKUP, the _____argument is optional.

Accepted Answer

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

Question 3

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Each time you create a conditional format, you are defining a conditional formatting _____.

Accepted Answer

A) theme 
B) object 
C) condition 
D) rule 
A) theme 
B) object 
C) condition 
D) rule

Question 5

In a fully qualified structured reference, the table name follows the column qualifier. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The _____ error value means that a value is not available to a function or formula.

Accepted Answer

A) #NAME? 
B) #N/A 
C) #NULL! 
D) #NUM! 
A) #NAME? 
B) #N/A 
C) #NULL! 
D) #NUM!

Question 7

The VLOOKUP function searches vertically down the first column of the lookup table for the value you entered, and then retrieves the corresponding value from another column of the table. _________________________

Accepted Answer

A) True 
 B)False

Question 8

When you want to reference an entire column of data in a table, you create a column _____.

Accepted Answer

A) label 
B) name 
C) variable 
D) qualifier 
A) label 
B) name 
C) variable 
D) qualifier

Question 9

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n)_____ column.

Accepted Answer

A) concatenated 
B) calculated 
C) autofilled 
D) custom 
A) concatenated 
B) calculated 
C) autofilled 
D) custom

Question 10

The _____ function calculates the difference between two dates and shows the result in months, days, or years.

Accepted Answer

A) nested IF 
B) CALIF 
C) DATEDIF 
D) DATE 
A) nested IF 
B) CALIF 
C) DATEDIF 
D) DATE

Question 11

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

Accepted Answer

A) True 
 B)False

Question 12

With the DATEDIF function, the _____ interval code means months.

Accepted Answer

A) m 
B) mo 
C) mon 
D) mth 
A) m 
B) mo 
C) mon 
D) mth

Question 13

Duplicate value highlighting helps to verify that columns of data have unique entries. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

Accepted Answer

The answer of The ____________________ function is a logical function...

Question 15

____________________ formatting changes a cell's formatting when its contents match a specified condition.

Accepted Answer

The answer of ____________________ formatting changes a cell's formatting when...

Question 16

Case-Based Critical Thinking Questions Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

Accepted Answer

A) TRUE 
B) FALSE 
C) PT 
D) PT, 2 
A) TRUE 
B) FALSE 
C) PT 
D) PT, 2

Question 17

Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

Accepted Answer

A) the first column 
B) any column 
C) the first row 
D) any row 
A) the first column 
B) any column 
C) the first row 
D) any row

Question 18

The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

Accepted Answer

The answer of The ____________________ function can determine if a...

Question 19

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​ You implement the VLOOKUP formula at your colleague's suggestion, but you get the #VALUE! error as the result of the formula. Which of the following is likely true?

Accepted Answer

A) You might have entered a table name for the table_array value instead of the cell reference of the lookup table. 
B) You might have indicated that the compare values are a range of values instead of an exact match. 
C) You might have entered a number for the col_index_num instead of a letter. 
D) You might have entered a letter for the col_index_num instead of a number. 
A) You might have entered a table name for the table_array value instead of the cell reference of the lookup table. 
B) You might have indicated that the compare values are a range of values instead of an exact match. 
C) You might have entered a number for the col_index_num instead of a letter. 
D) You might have entered a letter for the col_index_num instead of a number.

Question 20

You can include up to _____ logical conditions in the AND function.

Accepted Answer

A) 25 
B) 50 
C) 225 
D) 255 
A) 25 
B) 50 
C) 225 
D) 255

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

When using VLOOKUP, the _____argument is optional.

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table. _________________________

Each time you create a conditional format, you are defining a conditional formatting _____.

In a fully qualified structured reference, the table name follows the column qualifier. _________________________

The _____ error value means that a value is not available to a function or formula.

The VLOOKUP function searches vertically down the first column of the lookup table for the value you entered, and then retrieves the corresponding value from another column of the table. _________________________

When you want to reference an entire column of data in a table, you create a column _____.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n)_____ column.

The _____ function calculates the difference between two dates and shows the result in months, days, or years.

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

With the DATEDIF function, the _____ interval code means months.

Duplicate value highlighting helps to verify that columns of data have unique entries. _________________________

The ____________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

____________________ formatting changes a cell's formatting when its contents match a specified condition.

Case-Based Critical Thinking Questions Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

You can include up to _____ logical conditions in the AND function.

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 3: Creating Custom Reports

Access 4: Sharing Integrating and Analyzing Data

Excel 1: Working With Excel Tables Pivottables and Pivotcharts

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters

Exam 8: Excel 4: Working With Advanced Functions

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

When using VLOOKUP, the _____argument is optional.

In most cases, when manually creating a conditional formatting formula, the formula should use absolute references and point to the first row of data in a table. _________________________

Each time you create a conditional format, you are defining a conditional formatting _____.

In a fully qualified structured reference, the table name follows the column qualifier. _________________________

The _____ error value means that a value is not available to a function or formula.

The VLOOKUP function searches vertically down the first column of the lookup table for the value you entered, and then retrieves the corresponding value from another column of the table. _________________________

When you want to reference an entire column of data in a table, you create a column _____.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a(n)_____ column.

The _____ function calculates the difference between two dates and shows the result in months, days, or years.

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

With the DATEDIF function, the _____ interval code means months.

Duplicate value highlighting helps to verify that columns of data have unique entries. _________________________

The ____________________ function is a logical function that returns a TRUE value if all the logical conditions are true and a FALSE value if any or all of the logical conditions are false.

____________________ formatting changes a cell's formatting when its contents match a specified condition.

Case-Based Critical Thinking Questions Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

You can include up to _____ logical conditions in the AND function.

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 3: Creating Custom Reports

Access 4: Sharing Integrating and Analyzing Data

Excel 1: Working With Excel Tables Pivottables and Pivotcharts

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters