| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Excel Logical & Date Functions Quiz
Excel Logical & Date Functions Quiz
Question 2
Which formula checks if cell A1 is greater than 10 and B1 is less than 20?
=IF(A1>10 OR B1<20,TRUE,FALSE)
=IF(AND(A1>10,B1<20),TRUE,FALSE)
=AND(A1>10,B1<20,FALSE)
=OR(A1>10,B1<20)
Question 4
Which formula correctly assigns grades: “A” if A1≥80, “B” if A1≥60, otherwise “C”?
=IF(A1>=80,"A","B","C")
=IF(A1>=80,"A",IF(A1>=60,"B","C"))
=IF(A1>=80,"A";A1>=60,"B";"C")
=IF(A1>=80,"A","B")
Question 5
What does the formula =TODAY() return?
Current time only
Current date and time
Current date only
Yesterday’s date
Question 6
How is =NOW() different from =TODAY()?
NOW returns only the date
NOW returns date and time
NOW is for yesterday’s date
Both are the same
Question 7
Which formula calculates the number of days between dates in A1 and B1?
=DATEDIF(A1,B1,"D")
=B1-A1
=DAYS(B1,A1)
All of the above
Question 8
Which formula returns the day of the week as a number for the date in A1?
=DAY(A1)
=TEXT(A1,"DDD")
=WEEKNUM(A1)
=WEEKDAY(A1)
Question 9
What does =EOMONTH("10-Jan-2025",1) return?
28-Feb-2025
31-Jan-2025
10-Feb-2025
29-Feb-2025
Question 10
A score in A1 should return: “Excellent” if ≥90, “Good” if ≥75, “Average” if ≥50, otherwise “Fail”. Which formula works?
=IF(A1>=90,"Excellent","Good","Average","Fail")
=IF(A1>=90,"Excellent",IF(A1>=75,"Good",IF(A1>=50,"Average","Fail")))
=NESTEDIF(A1)
=IF(A1>=90,"Excellent","Good")
There are 10 questions to complete.
