20 questions · 30 minutes · Excel

Advance Excel Practice 3 practice quiz

20 MCQs on Excel Date & Time Functions – TODAY, NOW, DATE, DATEDIF, NETWORKDAYS.

Before you start

Answer all 20 questions. 1 mark each. No negative marking.

You can take this without an account and you will still get the full marked review. Only signed-in attempts are saved — sign in first if you want this one kept in your history.

Questions
20
Time
30 minutes
Marks
20
Subject
Excel
Marking
Server-side

What it asks

The first few questions

  1. Which function returns the current system date?
  2. Which function returns both the current date and time?
  3. What does =DATE(2025,10,12) return?
  4. DATEDIF returns:

16 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.