Question 1

The MIN and MAX functions can be used with ________ as well as numbers.

Accepted Answer

dates, var...

Question 2

The default calculation using the PMT function will produce a negative number.

Accepted Answer

A) True 
 B)False

Question 3

When working with dates, Excel actually assigns ________ numbers to each date.

Accepted Answer

The answer of When working with dates, Excel actually assigns...

Question 4

Functions can be selected by using the ________.

Accepted Answer

A)   Add Function dialog box
B)   Format Function dialog box
C)   Insert Function dialog box
D)   Create Function dialog boxE) B) and C)
F) All of the above

Question 5

The ROUND function requires how many arguments?

Accepted Answer

A)   2
B)   3
C)   4
D)   1E) All of the above
F) B) and C)

Question 6

Which status bar statistic can you not enable?

Accepted Answer

A)   SUM
B)   MIN
C)   Range Name
D)   Page NumberE) B) and C)
F) B) and D)

Question 7

If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?

Accepted Answer

A)   E$14
B)   $E$14
C)   B16
D)   B$16E) All of the above
F) A) and B)

Question 8

When entering functions, the square brackets, [], indicate required values.

Accepted Answer

A) True 
 B)False

Question 9

A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.

Accepted Answer

A) True 
 B)False

Question 10

What will you see if you enter the TODAY function without the parenthesis?

Accepted Answer

A)   #VALUE?
B)   Nothing. It will fill in the parenthesis for you.
C)   #FUNCTION?
D)   #NAME?E) B) and C)
F) None of the above

Question 11

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

Accepted Answer

The answer of When you use the VLOOKUP function, the...

Question 12

In a lookup table, the number of the column which contains the return values is called the ________.

Accepted Answer

The answer of In a lookup table, the number of...

Question 13

This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)

Accepted Answer

A) True 
 B)False

Question 14

Which Excel function changes the value to a desired number of decimal places?

Accepted Answer

A)   truncate
B)   Round
C)   Decrease decimal
D)   Increase decimalE) C) and D)
F) A) and B)

Question 15

Which keyboard shortcut toggles through the types of reference options?

Accepted Answer

A)   F2
B)   F3
C)   F4
D)   F5E) C) and D)
F) B) and D)

Question 16

What punctuation is used to separate the two cell references in a range?

Accepted Answer

A)   Period (.) 
B)   Semi-colon (;) 
C)   Comma (,) 
D)   Colon (:) E) A) and D)
F) B) and C)

Question 17

Which of the following is not an argument associated with the IF function?

Accepted Answer

A)   Test
B)   Value if true
C)   Value if false
D)   Value if neither true nor falseE) A) and C)
F) B) and C)

Question 18

The test in an IF function must evaluate to either a True or a False.

Accepted Answer

A) True 
 B)False

Question 19

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) None of the above
F) A) and B)

Question 20

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

Accepted Answer

A)   =F18
B)   =$F$18
C)   =B14
D)   =$B$14E) A) and D)
F) B) and C)

Exam 7: Excell: Formulas and Functions

Which keyboard shortcut toggles through the types of reference options?

Correct AnswerverifiedShow Answer

The MIN and MAX functions can be used with ________ as well as numbers.

Correct Answerverifieddates, var...View AnswerShow Answer

This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)

Correct AnswerverifiedShow Answer

A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.

Correct AnswerverifiedShow Answer

The ROUND function requires how many arguments?

Correct AnswerverifiedShow Answer

Which Excel function changes the value to a desired number of decimal places?

Correct AnswerverifiedShow Answer

What will you see if you enter the TODAY function without the parenthesis?

Correct AnswerverifiedShow Answer

Which of the following is not an argument associated with the IF function?

Correct AnswerverifiedShow Answer

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

Correct AnswerverifiedShow Answer

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

Correct AnswerverifiedShow Answer

When entering functions, the square brackets, [], indicate required values.

Correct AnswerverifiedShow Answer

The test in an IF function must evaluate to either a True or a False.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What punctuation is used to separate the two cell references in a range?

Correct AnswerverifiedShow Answer

Functions can be selected by using the ________.

Correct AnswerverifiedShow Answer

If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?

Correct AnswerverifiedShow Answer

When working with dates, Excel actually assigns ________ numbers to each date.

Correct AnswerverifiedShow Answer

The default calculation using the PMT function will produce a negative number.

Correct AnswerverifiedShow Answer

Which status bar statistic can you not enable?

Correct AnswerverifiedShow Answer

In a lookup table, the number of the column which contains the return values is called the ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
dates, var...
View 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

Correct Answer
verified