Question 1

The VLOOKUP function has four required arguments.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is not a valid =IF statement?

Accepted Answer

A)  =IF(A5>19,"Greater","Not Greater") 
B)  =IF(A5>19,b7,b9) 
C)  =IF(A5>19,1,9) 
D)  =IF(A5>19,Greater,Not Greater) E) B) and C)
F) A) and D)

Question 3

All IF functions have three arguments.

Accepted Answer

A) True 
 B)False

Question 4

What is the default method of referencing cells in formulas?

Accepted Answer

A)  Absolute
B)  Relative
C)  Mixed
D)  DefaultE) None of the above
F) A) and C)

Question 5

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

Accepted Answer

function screen-tip,...

Question 6

To look up an exact match,what should you enter in the range_lookup argument?

Accepted Answer

A)  FALSE
B)  TRUE
C)  EXACT
D)  Leave it blankE) A) and B)
F) None of the above

Question 7

Which function would you use if you wanted to count the number of values,but ignore cells that have text or are empty?

Accepted Answer

A)  COUNT
B)  COUNTA
C)  COUNTBLANK
D)  COUNTVALUESE) All of the above
F) None of the above

Question 8

What two functions compute the central tendency of values?

Accepted Answer

A)  AVERAGE and MODE
B)  AVERAGE and MEDIAN
C)  MIN and MAX
D)  AVERAGE and CENTERE) A) and B)
F) B) and D)

Question 9

Which of the following is not a valid test in an =IF statement?

Accepted Answer

A)  A4-B4
B)  A4<b4
C)  A4>A4
D)  B4<=B4E) B) and C)
F) A) and C)

Question 10

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 11

Match between columns
                        Premises: Return 30 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
Return 52 from the list: 29, 47, 21, 52, 1

Accepted Answer

The Answer of Sort descending and Sort ascending and MAX is...

Question 12

Excel assigns date number 1 to January 1,1900.

Accepted Answer

A) True 
 B)False

Question 13

________ 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 14

What is not a direct option on the AutoSum drop down menu?

Accepted Answer

A)  Median
B)  Sum
C)  Count numbers
D)  MaxE) A) and C)
F) B) and C)

Question 15

A function's ________ defines the rules by which the function operates.

Accepted Answer

The answer of A function's ________ defines the rules by...

Question 16

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

Accepted Answer

A)  COUNT
B)  COUNTA
C)  COUNTBLANK
D)  COUNTIFE) A) and B)
F) A) and C)

Question 17

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

Accepted Answer

The answer of The ________ function counts the number of...

Question 18

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)  MEDIANE) A) and B)
F) A) and C)

Question 19

Match between columns
                        Premises: Relative cell references
Mixed cell references
Absolute cell references
Function
Argument

Accepted Answer

The Answer of Simplifies complex calculations and Does not change is...

Question 20

Which of the following does not comply with the preferred way of using the SUM function?

Accepted Answer

A)  =SUM(A4:A11) 
B)  =SUM(A4:A11,B9:E11) 
C)  =SUM(A4,B8,D14) 
D)  =SUM(A4/A11) E) B) and C)
F) B) and D)

Exam 2: Formulas and Functions

Excel assigns date number 1 to January 1,1900.

Correct Answer
verified

Which of the following is not a valid =IF statement?

Correct Answer
verified

Which function would you use if you wanted to count the number of values,but ignore cells that have text or are empty?

Correct Answer
verified

All IF functions have three arguments.

Correct Answer
verified

What is not a direct option on the AutoSum drop down menu?

Correct Answer
verified

Which of the following is not a valid test in an =IF statement?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Match the example with the function or feature:

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

Correct Answer
verified

What is the default method of referencing cells in formulas?

Correct Answer
verified

The VLOOKUP function has four required arguments.

Correct Answer
verified

To look up an exact match,what should you enter in the range_lookup argument?

Correct Answer
verified

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

Correct Answer
verified

Match the following terms with their description:

A function's ________ defines the rules by which the function operates.

Correct Answer
verified

What two functions compute the central tendency of values?

Correct Answer
verified

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

Correct Answer
verified

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

Correct Answer
verified
function screen-tip,...
View Answer

Which of the following does not comply with the preferred way of using the SUM function?

Correct Answer
verified

Exam 2: Formulas and Functions

Excel assigns date number 1 to January 1,1900.

Correct AnswerverifiedShow Answer

Which of the following is not a valid =IF statement?

Correct AnswerverifiedShow Answer

Which function would you use if you wanted to count the number of values,but ignore cells that have text or are empty?

Correct AnswerverifiedShow Answer

All IF functions have three arguments.

Correct AnswerverifiedShow Answer

What is not a direct option on the AutoSum drop down menu?

Correct AnswerverifiedShow Answer

Which of the following is not a valid test in an =IF statement?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Match the example with the function or feature:

The ________ function counts the number of calculable values,but ignores cells that have text or are empty.

Correct AnswerverifiedShow Answer

What is the default method of referencing cells in formulas?

Correct AnswerverifiedShow Answer

The VLOOKUP function has four required arguments.

Correct AnswerverifiedShow Answer

To look up an exact match,what should you enter in the range_lookup argument?

Correct AnswerverifiedShow Answer

If you wanted to count the number of entries in a list that contained numbers,text,and blank cells,but ignore the text and blank cells,which function would you use?

Correct AnswerverifiedShow Answer

Match the following terms with their description:

A function's ________ defines the rules by which the function operates.

Correct AnswerverifiedShow Answer

What two functions compute the central tendency of values?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

Correct Answerverifiedfunction screen-tip,...View AnswerShow Answer

Which of the following does not comply with the preferred way of using the SUM function?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
function screen-tip,...
View Answer

Correct Answer
verified