Working with Functions

Question 1

When would the OR logical function produce a false in the formula result?

Revolt · Accepted Answer

when all arguments are false

Question 2

SUMLEFT✔ MIDRIGHT

Revolt · Accepted Answer

✔ MID

Question 3

✔ A2,4,2 A2&4&2 A2,”4”,2

Revolt · Accepted Answer

✔ A2,4,2

Question 4

Select the correct navigational path to create the function syntax to use the IF function.

Revolt · Accepted Answer

Then, begin the formula with the , click , and click OK.: =; Then, begin the formula with the , click , and click OK.: IF

Question 5

&$✔ =#

Revolt · Accepted Answer

✔ =

Question 6

NOT✔ IFORSUM

Revolt · Accepted Answer

✔ IF

Question 7

Which formula is correct formatting for a nested function?

Revolt · Accepted Answer

=IF(AND(B2>3000,C2>2000),“Bonus”,“No Bonus”)

Question 8

Which variable can you change when using the WEEKDAY function?

Revolt · Accepted Answer

the day of the week that starts a week

Question 9

Sarah wants to separate the employee ID numbers from its middle letters. Help her use the MID function to set up her formula.

Revolt · Accepted Answer

Type to begin the formula, and use the function .: =; Type to begin the formula, and use the function .: MID; Within parentheses, add the argument .: A2,4,2

Question 10

Sarah wants to separate the employee ID numbers from its middle letters. Help her use the MID function to set up her formula.

Revolt · Accepted Answer

✔ =; Type to begin the formula, and use the function .: =; Type to begin the formula, and use the function .: MID; Within parentheses, add the argument .: A2,4,2

Working with Functions Answers

More from this Course

TRY EDGENUITY HACKS