Working with Functions

Question 1

Select the correct navigational path to create the function syntax to use the IF function. Click the Formula tab on the ribbon and look in the gallery. Select the range of cells. Then, begin the formula with the , click , and click OK. Add the arguments into the boxes for Logical Test, Value_if_True, and Value_if_False.

Revolt · Accepted Answer

Logical; Selection 1: Logical; Selection 2: =; Selection 3: 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,2A2&4&2A2,”4”,2

Revolt · Accepted Answer

✔ A2,4,2

Working with Functions Answers

More from this Course

TRY EDGENUITY HACKS