Date & Time =ISOWEEKNUM(date)

Quiz =ISOWEEKNUM — 10 Questions

10 quiz questions about =ISOWEEKNUM — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← ISOWEEKNUM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “date” required in =ISOWEEKNUM?

Question 2 of 10 2/10

Which use case fits =ISOWEEKNUM?

Question 3 of 10 3/10

Is =ISOWEEKNUM volatile?

Question 4 of 10 4/10

How many arguments does =ISOWEEKNUM have in total?

Question 5 of 10 5/10

How many required arguments does =ISOWEEKNUM have?

Question 6 of 10 6/10

How many optional arguments does =ISOWEEKNUM have?

Question 7 of 10 7/10

What is the type of argument “date” in =ISOWEEKNUM?

Question 8 of 10 8/10

Which formula is a valid example of =ISOWEEKNUM?

Question 9 of 10 9/10

Which statement about =ISOWEEKNUM is correct?

Question 10 of 10 10/10

What is the fix for #NUM! in =ISOWEEKNUM?

Click a question to see the answer.

1. Is argument “date” required in =ISOWEEKNUM?

A. Yes
B. Yes ✓
C. —
D. No

Explanation: “date” is required.

2. Which use case fits =ISOWEEKNUM?

A. Investment Appraisal
B. Date & Time Calculations ✓
C. Dynamic Ranges & Dashboards
D. Reshape Tables

Explanation: Use case “Date & Time Calculations” fits ISOWEEKNUM.

3. Is =ISOWEEKNUM volatile?

A. —
B. No
C. Yes
D. No ✓

Explanation: ISOWEEKNUM is not volatile.

4. How many arguments does =ISOWEEKNUM have in total?

A. 2
B. 1 ✓
C. 3
D. 4

Explanation: =ISOWEEKNUM has 1 required, 0 optional (1 total).

5. How many required arguments does =ISOWEEKNUM have?

A. 3
B. 0
C. 2
D. 1 ✓

Explanation: =ISOWEEKNUM has 1 required, 0 optional (1 total).

6. How many optional arguments does =ISOWEEKNUM have?

A. 0 ✓
B. 2
C. —
D. 1

Explanation: =ISOWEEKNUM has 1 required, 0 optional (1 total).

7. What is the type of argument “date” in =ISOWEEKNUM?

A. Reference
B. Array
C. Date ✓
D. Text

Explanation: Type of “date” is “Date”.

8. Which formula is a valid example of =ISOWEEKNUM?

A. ISOWEEKNUM(A2)
B. =ISOWEEKNUM(A2, 0)
C. =YEAR(A2)
D. =ISOWEEKNUM(A2) ✓

Explanation: Correct example: =ISOWEEKNUM(A2)

9. Which statement about =ISOWEEKNUM is correct?

A. Microsoft Excel stores dates as sequential numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. Text is always ignored

Explanation: Correct: Microsoft Excel stores dates as sequential numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

10. What is the fix for #NUM! in =ISOWEEKNUM?

A. آرگومان date از نوع تاریخ معتبر نیست.
B. یک شماره سریال تاریخ معتبر یا سلول حاوی تاریخ وارد کنید. ✓
C. Only works in old versions
D. Requires add-in

Explanation: If the date argument is not a valid number, ISOWEEKNUM returns the #NUM! error value. — Fix: یک شماره سریال تاریخ معتبر یا سلول حاوی تاریخ وارد کنید.