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

Since which Excel version is =ISOWEEKNUM available?

Question 2 of 10 2/10

Is =ISOWEEKNUM volatile?

Question 3 of 10 3/10

What usually causes #VALUE! in =ISOWEEKNUM?

Question 4 of 10 4/10

What is the output type of =ISOWEEKNUM?

Question 5 of 10 5/10

Is argument “date” required in =ISOWEEKNUM?

Question 6 of 10 6/10

What usually causes #NUM! in =ISOWEEKNUM?

Question 7 of 10 7/10

Which use case fits =ISOWEEKNUM?

Question 8 of 10 8/10

How many arguments does =ISOWEEKNUM have in total?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which statement about =ISOWEEKNUM is correct?

Click a question to see the answer.

1. Since which Excel version is =ISOWEEKNUM available?

A. Excel 365
B. All versions
C. Excel 2013 ✓
D. Excel 2019

Explanation: Version: “Excel 2013”.

2. Is =ISOWEEKNUM volatile?

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

Explanation: ISOWEEKNUM is not volatile.

3. What usually causes #VALUE! in =ISOWEEKNUM?

A. Requires add-in
B. If the date argument is not a valid date type, ISOWEEKNUM returns the #VALUE! error value. ✓
C. Only works in old versions
D. Select entire column for best performance

Explanation: If the date argument is not a valid date type, ISOWEEKNUM returns the #VALUE! error value. — Fix: Use a real date instead of text

4. What is the output type of =ISOWEEKNUM?

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

Explanation: Output is “Number”.

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

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

Explanation: “date” is required.

6. What usually causes #NUM! in =ISOWEEKNUM?

A. Only works in old versions
B. If the date argument is not a valid number, ISOWEEKNUM returns the #NUM! error value. ✓
C. Requires add-in
D. Output is always a dynamic array

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

7. Which use case fits =ISOWEEKNUM?

A. Date & Time Calculations ✓
B. Advanced Formulas
C. Forecasting & Trends
D. Conditional Formatting & Validation

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

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

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

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

9. What is the fix for #VALUE! in =ISOWEEKNUM?

A. Use a real date instead of text ✓
B. Select entire column for best performance
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: If the date argument is not a valid date type, ISOWEEKNUM returns the #VALUE! error value. — Fix: Use a real date instead of text

10. Which statement about =ISOWEEKNUM is correct?

A. Text is always ignored
B. Volatile and recalculates every time
C. Only works in old versions
D. 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. ✓

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.