Working with Functions

1. Not equal to 2. Less than 3. Equal to 4. Greater than 5. Greater than or equal to 6. = 7. > 8. < 9. >= 10. <>

1-10 2-8 3-6 4- 7 5-9

Sarah wants to separate the employee ID numbers from its middle letters. Help her use the MID function to set up her formula. Employee ID numbers are in the format 123AB6789 and begin in cell A2. Select the cell where you want the information to be placed. Type _____ to begin the formula, and use the function ______. Within parentheses, add the argument _______. Press Enter to complete the formula.

1. = 2. MID 3. A2,4,2

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.

1. Logical 2. = 3. IF

Javier wants to copy the last four digits of ID numbers from A2. Order the steps for the formula

=RIGHT(A2,4)

Which formulas would work to combine cells with first, middle, and last names from columns A through C and row 2 into a new cell? Check all that apply.

A. =A2&" "&B2&" "C2 D. =CONCATENATE(A2," ",B2," "C2)

What is the definition of delimited text?

A. Characters are separated by commas or tabs.

Which functions are examples of logical test arguments used in formulas? Check all that apply.

A. OR B. IF E. NOT F. AND

What is unique about the TODAY and NOW functions?

A. The formula does not require arguments.

Which rules should be remembered when creating formulas using nested functions? Check all that apply.

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

Which types of scenarios would the NETWORKDAYS function help calculate? Check all that apply.

A. days of vacation time left B. days of school left in the year D. years of service someone performed

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

A. searching in the Tell Me bar B. looking it up in the Formula tab D. using the Insert Function and typing a description E. using the Insert Function and selecting a category

What is the correct syntax to take the first five characters from the cell A2 and place it to its right in cell A3?

B. =LEFT(A2,5)

Which variable can you change when using the WEEKDAY function?

B. the day of the week that starts a week

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

B. the first argument listed after IF

Which formula is correct formatting for a nested function?

B.=IF(AND(B2>3000,C2>2000),"Bonus","No Bonus")

Which function would you use to make sure all names are prepared for a mailing label?

C. PROPER

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

C. when all arguments are false

What is the definition of a nested function?

D. a function defined inside of another function

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

D. determines true or false based on variety of conditions

What is the purpose of the ISOWEEKNUM function?

D. determines what week of the year that date is