Excel Lesson 5

Question 0

The argument identifies the function to be performed. True or False

Answer 0

False

Question 1

Formulas with functions have three parts: an equal sign, a function name, and usually an argument. True or False

Answer 1

True

Question 2

You select the function you want to use in the Function Arguments dialog box. True or False

Answer 2

False

Question 3

The COUNTA function returns the number of cells in the range identified in the argument that contain data. True or False

Answer 3

True

Question 4

The OR function displays one value if the specified condition is true and a different value if the condition is false. True or False

Answer 4

False

Question 5

The ________ is (are) enclosed in parentheses in a formula with a function.

Answer 5

Arguments

Question 6

The Insert Function dialog box specifies arguments to be included in the function. True or False

Answer 6

True

Question 7

Mathematical functions manipulate quantitative data in a worksheet. True or False

Answer 7

True

Question 8

_______ functions displays text or values if certain conditions exist.

Answer 8

Logical

Question 9

_______ functions are used to analyze loans and investments.

Answer 9

Financial