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?
Which functions are examples of logical test arguments used in formulas? Check all that apply.ORIFSUMCOUNTNOTAND
What is the definition of a nested function?
What is unique about the TODAY and NOW functions?
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
Which function would you use to make sure all names are prepared for a mailing label?
Did you find these answers helpful?