Excel Summative (Last)

Which of the following is required in creating an IF function?

• Cell reference
• Value if false
• Logical test
• Value if true

Which of the following symbols can be used in IF function?

• ?

• ~

• <>

• ;

Which of the following returns a value you specify if a formula evaluates to an error?

• IFERROR
• VALUEERROR
• ERRORIF
• IFERRORR

IF function is an example of _____.

• Statistical function
• Logical function
• Mathematical function
• Text function

Which functions requires Logical Test?

• AVERAGE

• ERROR

• OR

• SUM

Which of the following IS function returns TRUE if Value refers to any error value except #N/A?

• ISNA
• ISERROR
• ISBLANK
• ISERR

The function ISERROR returns TRUE if _____.

• Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).

• Value refers to the #N/A (value not available) error value.

• Value refers to any error value except #N/A.

• Value refers to an empty cell.

In Which function will display “PASSED” if grade in D3 is 85 or above and “FAILED” when the total grade is below 85?

• =IF(D3<85,"PASSED","FAILED")

• =IF(D3<=85,"PASSED","FAILED")

• =IF(D3<85,"FAILED","PASSED")

• =IF(D3<=85,”FAILED","PASSED")

Which of the following function will display blank in column D3 if  A3 to C3 has a missing grade and will compute if the grades are complete?

• =IF(OR(ISBLANK(A3),ISBLANK(B3),ISBLANK(C3)),"", AVERAGE(A3:C3))

• =IF(OR(ISBLANK(A3),ISBLANK(B3),ISBLANK(C3)), AVERAGE(A3:C3),””)

• =IF(AND(ISBLANK(A3),ISBLANK(B3),ISBLANK(C3)),"", AVERAGE(A3:C3))

• =IF(AND(ISBLANK(A3),ISBLANK(B3),ISBLANK(C3)), AVERAGE(A3:C3),””)

Which of the following will display blank if D3 is blank, and will display “Passed” if D3 is greater than or equal to 85 otherwise “Failed”?

• =IF(ISBLANK(D3),"",If(D3<85,"Failed","Passed"))

• =IF(ISBLANK(D3),"",If(D3<85,"Passed","Failed"))

• =IF(ISBLANK(D3),"",If(D3>85,"Failed","Passed"))

• =IF(ISBLANK(D3),"",If(D3>85,"Failed","Passed"))