Font size
WorksheetsExcel Quiz-IF, AND, OR
Total questions: 11
Worksheet time: 12mins
Full Name
Email ID
Student ID (ID No)
What formula should be used to return "Good" if all the values are >30?
=If(A2>30, "Good", "Bad")
=If(AND(A2>30, B2>30), "Good","Bad")
=If(OR(A2>30, B2>30), "Good","Bad")
=IF(A2<30, B2<30, "Good", "Bad")
Which formula should be used such that if at least one number is greater than 30, the result returned should be "Good" else "Bad"?
=If(OR(A2>30, B2>30), "Good", "Bad")
=If(A2>30, B2<30), "Good", "Bad")
=If(OR(A2>30, B2<30), "Good", "Bad")
=If(OR(A2<30, B2<30), "Good", "Bad")
Which formula should be used to extract the year from the date mentioned
=date(A1)
=year(A1)
=2019
=DATE(2019)
What formula should be used to find the last date of the month after a period of 5 months from the date 02/04/2022?
=EOMONTH(02/04/2022, 5)
=MONTH(02/04/2022)
=MONTH(02/04/2022,5)
=EOMONTH(02/04/2022)
The result of an IF function is
Cell Range
Specific Text
Additional Formula
All of the above
In Database Functions every condition in a row is connected with an _____ logic and every row is connected with an _____ logic
AND, OR
OR, OR
OR, AND
AND, AND
When does a #VALUE! error pop up?
Undefined range
Blank spaces
Incorrect function
Invalid numeric data
An error value in a cell can be masked with the help of ____ function
IF ELSE
IFERROR
IF
ERRORIF
