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

Question 7

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

Revolt · Accepted Answer

when all arguments are false

Question 8

Which ways can you locate a function if you cannot remember the specific name? Check all that apply.

Revolt · Accepted Answer

searching in the Tell Me bar; looking it up in the Formula tab; using the Insert Function and typing a description; using the Insert Function and selecting a category

Question 9

Which formula is correct formatting for a nested function?

Revolt · Accepted Answer

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

Question 10

Which variable can you change when using the WEEKDAY function?

Revolt · Accepted Answer

the day of the week that starts a week

Working with Functions Answers

More from this Course

TRY EDGENUITY HACKS