Working with Functions

Question 1

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

Revolt · Accepted Answer

✔ Logical; Click the Formula tab on the ribbon and look in the gallery.: Logical; Then, begin the formula with the , click , and click OK.: =; Then, begin the formula with the , click , and click OK.: IF

Question 2

&$✔ =#

Revolt · Accepted Answer

✔ =

Question 3

NOT✔ IFORSUM

Revolt · Accepted Answer

✔ IF

Question 4

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 5

SUMLEFT✔ MIDRIGHT

Revolt · Accepted Answer

✔ MID

Question 6

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

Revolt · Accepted Answer

✔ A2,4,2

Working with Functions Answers

More from this Course

TRY EDGENUITY HACKS