Tin học kinh tế

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,"X","Senior")

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

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

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

• 1.  OR

• 1. AND

• 1. XOR

• 1. NOT

 Which function is used to trap and handle errors?

• 1. IFERROR()

• 1. ERROR()

• 1. IFNA()

• 1. IFTRAP()

  
  

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 of the following statements about the logical NOT function in Excel is TRUE?

• The NOT function in Excel reverses the logical value of a given expression or condition.

• The NOT function in Excel is used to combine multiple logical conditions and returns TRUE if all conditions are met.

  
  

• The NOT function in Excel is used to perform mathematical operations on numerical values.

• The NOT function in Excel is represented by the symbol "~" when used in formulas.

  
  

Which of the following statements about the OR function in Excel is TRUE?

• The OR function returns TRUE if any of the conditions provided are TRUE.

  
  

• The OR function can only be used with numerical values in Excel.

  
  

• The OR function requires at least three conditions to be evaluated.

  
  

•  The OR function in Excel is equivalent to the addition operation (+) for logical values.

  
  

Consider the following data in an Excel worksheet:
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)

  
  

Consider the following example in Excel:
In cell A1, the value is 10.

In cell B1, the value is 5.

In cell C1, the value is 15.

Which of the following formulas correctly utilizes the IF function with AND in Excel to check if all three cells (A1, B1, C1) contain values greater than 0?

• =IF(AND(A1>0, B1>0, C1>0), "All values are greater than 0", "Not all values are greater than 0")

  
  

• =IF(AND(A1>0, OR(B1>0, C1>0)), "At least one value is greater than 0", "No value is greater than 0")

• =IF(AND(A1>0, B1>0, C1>0), "No value is greater than 0", "At least one value is greater than 0")

  
  

• =IF(AND(A1>0, B1>0), "All values are greater than 0", "Not all values are greater than 0")

  
  

Consider the following example in Excel:

In cell A1, the value is 10.

In cell B1, the value is 5.

In cell C1, the value is 15.

Which of the following formulas correctly utilizes the IF function with NOT in Excel to check if cell A1 does not equal 0?

•  =IF(NOT(A1=0), "A1 is not equal to 0", "A1 is equal to 0")

  
  

• =IF(NOT(A1<>0), "A1 is equal to 0", "A1 is not equal to 0")

  
  

• =IF(NOT(A1>0), "A1 is not greater than 0", "A1 is greater than 0")

  
  

• =IF(NOT(A1<0), "A1 is greater than or equal to 0", "A1 is less than 0")