Date & Time =ISOWEEKNUM(date)

Quiz =ISOWEEKNUM — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

What usually causes #VALUE! in =ISOWEEKNUM?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which category does =ISOWEEKNUM belong to?

Question 4 of 15 4/15

How many required arguments does =ISOWEEKNUM have?

Question 5 of 15 5/15

Which formula is a valid example of =ISOWEEKNUM?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which statement about =ISOWEEKNUM is correct?

Question 8 of 15 8/15

Is argument “date” required in =ISOWEEKNUM?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

What is the output type of =ISOWEEKNUM?

Question 11 of 15 11/15

Which function is NOT related to =ISOWEEKNUM?

Question 12 of 15 12/15

Which use case fits =ISOWEEKNUM?

Question 13 of 15 13/15

Is =ISOWEEKNUM volatile?

Question 14 of 15 14/15

Which function is related to =ISOWEEKNUM?

Question 15 of 15 15/15

How many optional arguments does =ISOWEEKNUM have?

Click a question to see the answer.

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

A. If the date argument is not a valid date type, ISOWEEKNUM returns the #VALUE! error value. ✓
B. Text is always ignored
C. Select entire column for best performance
D. آرگومان date عدد معتبری نیست.

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

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

A. Text is always ignored
B. Use a real date instead of text ✓
C. آرگومان date عدد معتبری نیست.
D. Only works in old versions

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

3. Which category does =ISOWEEKNUM belong to?

A. Cube
B. Date & Time ✓
C. Financial
D. Information

Explanation: Category is “Date & Time”.

4. How many required arguments does =ISOWEEKNUM have?

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

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

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

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

Explanation: Correct example: =ISOWEEKNUM(A2)

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

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

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

7. Which statement about =ISOWEEKNUM is correct?

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

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

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

Explanation: “date” is required.

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

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

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

10. What is the output type of =ISOWEEKNUM?

A. Array
B. Mixed
C. Value
D. Number ✓

Explanation: Output is “Number”.

11. Which function is NOT related to =ISOWEEKNUM?

A. OCT2DEC ✓
B. WEEKDAY
C. YEAR
D. WEEKNUM

Explanation: “OCT2DEC” is not related to ISOWEEKNUM.

12. Which use case fits =ISOWEEKNUM?

A. Date & Time Calculations ✓
B. Conditional Aggregation
C. Numbering & Sample Data
D. Conditional Logic

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

13. Is =ISOWEEKNUM volatile?

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

Explanation: ISOWEEKNUM is not volatile.

14. Which function is related to =ISOWEEKNUM?

A. ISNONTEXT
B. YEAR ✓
C. PRICEDISC
D. COPILOT

Explanation: “YEAR” is related to ISOWEEKNUM.

15. How many optional arguments does =ISOWEEKNUM have?

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

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