Question 1

The ____ function returns the current date and time based on the computer's date and time settings.

Accepted Answer

A)  NOW( ) 
B)  WHEN( ) 
C)  CURRENT( ) 
D)  DATE( )

Question 2

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?

Accepted Answer

A)  Type the first letters in a cell 
B)  Click Formula AutoComplete on the Ribbon 
C)  Open the AutoComplete Wizard by right-clicking on the active cell 
D)  None of the above

Question 3

An example of a square root function written correctly is ____.

Accepted Answer

A)  SQRT(C4) 
B)  =SQROOT(C4) 
C)  =SQRT(C4) 
D)  SQROOT(C4)

Question 4

The AND function returns the result of ____ if any or all of the arguments are false.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  none of the above

Question 5

The rounding operation requires two arguments, which are separated by a comma.

Accepted Answer

A) True 
 B)False

Question 6

The ____ function replaces existing text in a specified cell with new text.

Accepted Answer

A)  FIND AND REPLACE 
B)  WRITE OVER 
C)  SUBSTITUTE 
D)  REPLACE

Question 7

In a PMT function, the argument indicated by fv refers to ____.

Accepted Answer

A)  future value 
B)  past value 
C)  favorite value 
D)  fixed value

Question 8

The function ____ returns the estimated variance of the numbers in the range.

Accepted Answer

A)  VAR(number1,number2...) 
B)  EVAR(number1,number2...) 
C)  ESTVAR(number1,number2...) 
D)  EV(number1,number2...)

Question 9

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.

Accepted Answer

A)  date and time 
B)  financial 
C)  mathematical 
D)  statistical

Question 10

An example of the function of the natural logarithm of a number written correctly is ____.

Accepted Answer

A)  =LOG(50) 
B)  =LN(50) 
C)  =NL(50) 
D)  =(NL,50,2)

Question 11

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

Accepted Answer

The answer of The ____________________(text) function converts the first letter...

Question 12

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

Accepted Answer

A)  Formula Complete 
B)  Formula Now 
C)  Formula Selector 
D)  Formula AutoComplete

Question 13

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

Accepted Answer

The answer of The ____________________ is the value the function...

Question 14

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

Accepted Answer

A) True 
 B)False

Question 15

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?

Accepted Answer

A)  =AVG(E4,E9) 
B)  =AVERAGE(E4:E9) 
C)  =AVG(E4:E9) 
D)  +AVERAGE(E4:E9)

Question 16

The ____ function repeats the text in the specified cell a specified number of times.

Accepted Answer

A)  MIRROR 
B)  REPT 
C)  AGAIN 
D)  OVER

Question 17

In the IF function, the first argument sets a condition for comparison, called a relative test.

Accepted Answer

A) True 
 B)False

Question 18

If a function contains more than one argument, semicolons separate the arguments.

Accepted Answer

A) True 
 B)False

Question 19

The selection is the body of numbers the statistics will describe.

Accepted Answer

A) True 
 B)False

Question 20

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.

Accepted Answer

A)  Function Library 
B)  Formula 
C)  Data 
D)  Calculations

Exam 11: Excel Lesson 5: Using Functions

The ____ function returns the current date and time based on the computer's date and time settings.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?

An example of a square root function written correctly is ____.

The AND function returns the result of ____ if any or all of the arguments are false.

The rounding operation requires two arguments, which are separated by a comma.

The ____ function replaces existing text in a specified cell with new text.

In a PMT function, the argument indicated by fv refers to ____.

The function ____ returns the estimated variance of the numbers in the range.

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.

An example of the function of the natural logarithm of a number written correctly is ____.

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

Case EX 5-2 Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?

The ____ function repeats the text in the specified cell a specified number of times.

In the IF function, the first argument sets a condition for comparison, called a relative test.

If a function contains more than one argument, semicolons separate the arguments.

The selection is the body of numbers the statistics will describe.

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.