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

How many arguments does =ISOWEEKNUM have in total?

Question 2 of 10 2/10

Which function is NOT related to =ISOWEEKNUM?

Question 3 of 10 3/10

How many optional arguments does =ISOWEEKNUM have?

Question 4 of 10 4/10

In =ISOWEEKNUM, which is argument #1?

Question 5 of 10 5/10

Is argument “date” required in =ISOWEEKNUM?

Question 6 of 10 6/10

Is =ISOWEEKNUM volatile?

Question 7 of 10 7/10

What is the output type of =ISOWEEKNUM?

Question 8 of 10 8/10

Does =ISOWEEKNUM return a dynamic array?

Question 9 of 10 9/10

What usually causes #NUM! in =ISOWEEKNUM?

Question 10 of 10 10/10

Which statement about =ISOWEEKNUM is correct?

Click a question to see the answer.

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

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

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

2. Which function is NOT related to =ISOWEEKNUM?

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

Explanation: “TIME” is not related to ISOWEEKNUM.

3. How many optional arguments does =ISOWEEKNUM have?

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

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

4. In =ISOWEEKNUM, which is argument #1?

A. date ✓
B. lookup_value
C. range
D. value

Explanation: Argument #1 is “date”.

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

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

Explanation: “date” is required.

6. Is =ISOWEEKNUM volatile?

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

Explanation: ISOWEEKNUM is not volatile.

7. What is the output type of =ISOWEEKNUM?

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

Explanation: Output is “Number”.

8. Does =ISOWEEKNUM return a dynamic array?

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

Explanation: ISOWEEKNUM does not spill.

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

A. If the date argument is not a valid number, ISOWEEKNUM returns the #NUM! error value. ✓
B. Select entire column for best performance
C. Only works in old versions
D. Text is always ignored

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

10. 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. Output is always a dynamic array
C. Volatile and recalculates every time
D. Select entire column for best performance

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.