Modern Art in Context Answers

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?

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=CONCAT(A2&“ ”&B2&“ ”C2)=CONCAT(A2,“ ”,B2,“ ”C2)=CONCAT(A2)&“ ”&(B2)&“ ”(C2)

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

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

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.

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

What is the purpose of the ISOWEEKNUM function?

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 of the following are delimiters available in the Convert Text to Columns Wizard? Check all that apply.tabsemicolonandspacecommaor