Introduction to Functions Answers

11 verified answers
1
Free Preview

Where do you place the logical test argument in an IF function formula?

A
before the IF function
B
the first argument listed after IF
C
the second argument listed after IF
D
the third argument listed after IF
2
Free Preview

What is the benefit of using the AND logical function instead of the IF function?

A
determines true based on single criteria
B
determines true if both conditions are met
C
determines false if no conditions are met
D
determines true or false based on variety of conditions
4

What is the definition of a nested function?

A
a cell that is used in two different functions
B
arguments defined inside of two functions
C
arguments defined inside of arguments inside of a function
D
a function defined inside of another function
5

Which rules should be remembered when creating formulas using nested functions? Check all that apply.Use an equal sign at the beginning of the formula.Use open and close parenthesis for each set of nested functions.Use an equal sign before each function.All arguments should be in CAPS.Functions should be in CAPS.Separate functions with commas.

A
Use an equal sign at the beginning of the formula.
B
Use open and close parenthesis for each set of nested functions.
C
Use an equal sign before each function.
D
All arguments should be in CAPS.
E
Functions should be in CAPS.
F
Separate functions with commas.
6

What is unique about the TODAY and NOW functions?

A
The formula does not require arguments.
B
The formula does not require an equal sign.
C
The formula always returns both date and time.
D
The formula is absolute and will only keep the first date used.
9

What is the definition of delimited text?

A
Characters are separated by commas or tabs.
B
Characters are separated by spaces.
C
Characters run together without separation.
D
Characters have no limit.

Did you find these answers helpful?