Which functions are examples of logical test arguments used in formulas? Check all that apply.ORIFSUMCOUNTNOTAND
What is the definition of a nested function?
Which rules should be remembered when creating formulas using nested functions? Check all that apply.Use an equal sign at the beginning of the formula.Use open and close parenthesis for each set of nested functions.Use an equal sign before each function.All arguments should be in CAPS.Functions should be in CAPS.Separate functions with commas.
Which types of scenarios would the NETWORKDAYS function help calculate? Check all that apply.days of vacation time leftdays of school left in the yearhours left in the yearyears of service someone performedhow many holidays fall on Mondays
What is the purpose of the ISOWEEKNUM function?
Which ways can you locate a function if you cannot remember the specific name? Check all that apply.searching in the Tell Me barlooking it up in the Formula tablooking it up in the Data tabusing the Insert Function and typing a descriptionusing the Insert Function and selecting a category
What is the definition of delimited text?
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.=A2&“ ”&B2&“ ”C2A2&“ ”&B2&“ ”C2=CONCATENATE(A2&“ ”&B2&“ ”C2)=CONCATENATE(A2,“ ”,B2,“ ”C2)=CONCATENATE(A2)&“ ”&(B2)&“ ”(C2)
Where do you place the logical test argument in an IF function formula?
What is the benefit of using the AND logical function instead of the IF function?
What is unique about the TODAY and NOW functions?
What is the correct syntax to take the first five characters from the cell A2 and place it to its right in cell A3?
Which function would you use to make sure all names are prepared for a mailing label?
Did you find these answers helpful?