050623

Which is the correct way to write this function:

IF F1 is greater than or equal to 60, show "Senior", otherwise, show "X"

• 1. =IF(F1>=60,"Senior",X)

• 1. =IF(F1>=60,"Senior","X")

• 1. =IF(F1=>60,"X","Senior")

• 1. =IF(F1>60,"Senior","X")

Which function to use to convert the first character of each word to an uppercase character in a cell that contains a string type data type (Text) 

• Trim

• Lower

• Upper

• Proper

This description refers to which function: “Returns TRUE if all of the arguments evaluate to TRUE.”

• 1.  OR

• 1. AND

• XOR

• NOT

 Which function is used to trap and handle errors?

• 1. IFERROR()

• 1. ERROR()

• 1. IFNA()

• 1. IFTRAP()

At a cell address, we perform a calculation function but with the wrong function name, the error message will appear

• #N/A

• #VALUE!

• #NAME?

•  FALSE

Which of the following scenarios would NOT be suitable for using the IFS function in Excel?

• Assigning letter grades (A, B, C, etc.) based on a student's numeric score

• Calculating the shipping cost based on the weight and destination of a package.

• Determining the commission percentage based on the sales amount achieved by a salesperson.

• Sorting a list of values in ascending order.

Which formula, when entered into cell C2, would correctly apply the XOR function to check if either cell A2 or cell B2 (or both) contains a non-zero value?

• =XOR(A2<>0, B2<>0)

• =XOR(A2=0, B2=0)

• =XOR(A2>0, B2>0)

•  =XOR(A2=0, B2<>0)

For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

•  OR(B3=>15,B3<=20)

• •  AND(B3>=15,B3<=20)

• • OR(B3>15,B3<20)

•  AND(B3>15, B3<20)

Which function to use to convert the left contents to the right results?

• LEN

• LOWER

• TRIM

• UPPER

Which function returns the leftmost five characters in cell A1?

• =FIND(A1,1,5)

• =SEARCH(A1,5)

•  =LEFT(A1,5)

• =A1-RIGHT(A1,LEN(A1)-5)