Question 1

Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

Accepted Answer

A) ##### 
B) #Value 
C) #N/A 
D) Value not found

Question 2

Which of the following is not a date function? ____

Accepted Answer

A) YEAR 
B) NOW 
C) AND 
D) TODAY

Question 3

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

Accepted Answer

A) True 
 B)False

Question 4

When you copy a formula that contains an absolute reference to a new location,the reference ____.

Accepted Answer

A) is updated automatically 
B) does not change 
C) becomes bold 
D) has a dotted outline in its cell

Question 5

=IF(G22="x",SUM(H22:J22),  " ")with display ______ if G22 is not equal to "x".

Accepted Answer

A) a blank cell 
B) the result of the SUM 
C) dashes 
D) False

Question 6

By default,AutoFill copies only the content not the formatting of the original range to the selected range._______________

Accepted Answer

A) True 
 B)False

Question 7

TODAY is an example of a(n)____________________ function.

Accepted Answer

The answer of TODAY is an example of a(n)____________________ function....

Question 8

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.

Accepted Answer

A) Data Validation 
B) Goal Seek 
C) Goal Set 
D) If Conditional

Question 9

Absolute references are marked with a ____.

Accepted Answer

A) < 
B) : 
C) $ 
D) !

Question 10

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function._______________

Accepted Answer

A) True 
 B)False

Question 11

A logical function is a function that works with values that are either ____.

Accepted Answer

A) right or wrong 
B) absolute or relative 
C) positive or negative 
D) true or false

Question 12

Functions are organized in the Function Library group on the FORMULAS tab._______________

Accepted Answer

A) True 
 B)False

Question 13

The ____ function returns the maximum value in the range.

Accepted Answer

A) TOP 
B) FIRST 
C) MAX 
D) MOST

Question 14

Using AutoFill,what would be the extended series of the initial entry Jan? ___

Accepted Answer

A) uary 
B) Feb, Mar, Apr 
C) Kan, Lan, Man, Nan 
D) Jan1, Jan2, Jan3

Question 15

____________________ is a set of rules which specifies how a function should be written.

Accepted Answer

The answer of ____________________ is a set of rules which...

Question 16

Which of the following is not a comparison operator? ____

Accepted Answer

A) = 
B)

Question 17

Lookup tables can be constructed for exact match or approximate match lookups._______________

Accepted Answer

A) True 
 B)False

Question 18

An error value indicates that some part of a function is preventing Excel from returning a calculated value.________________

Accepted Answer

A) True 
 B)False

Question 19

In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____

Accepted Answer

A) The average of the values in the range A1:A100 is added to the integer. 
B) The average of the integer value is calculated. 
C) The average of the values in the range A1:A100 is calculated. 
D) The integer portion of the value is extracted.

Question 20

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

Accepted Answer

A) #VALUE 
B) #N/A 
C) #ERROR 
D) #NULL

Exam 9: Performing Calculations With Formulas and Functions

Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

Which of the following is not a date function? ____

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

When you copy a formula that contains an absolute reference to a new location,the reference ____.

=IF(G22="x",SUM(H22:J22) , " ") with display ______ if G22 is not equal to "x".

By default,AutoFill copies only the content not the formatting of the original range to the selected range._______________

TODAY is an example of a(n)____________________ function.

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.

Absolute references are marked with a ____.

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function._______________

A logical function is a function that works with values that are either ____.

Functions are organized in the Function Library group on the FORMULAS tab._______________

The ____ function returns the maximum value in the range.

Using AutoFill,what would be the extended series of the initial entry Jan? ___

____________________ is a set of rules which specifies how a function should be written.

Which of the following is not a comparison operator? ____

Lookup tables can be constructed for exact match or approximate match lookups._______________

An error value indicates that some part of a function is preventing Excel from returning a calculated value.________________

In the formula =INT(AVERAGE(A1:A100) ) ,which would occur first? ____

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.