Compatibility =SEC(number)

Quiz =SEC — 10 Questions

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

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

← SEC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #VALUE! in =SEC?

Question 2 of 10 2/10

Which is the correct syntax of =SEC?

Question 3 of 10 3/10

Is =SEC volatile?

Question 4 of 10 4/10

Is argument “number” required in =SEC?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which function is NOT related to =SEC?

Question 7 of 10 7/10

Since which Excel version is =SEC available?

Question 8 of 10 8/10

What usually causes #NUM! in =SEC?

Question 9 of 10 9/10

Which use case fits =SEC?

Question 10 of 10 10/10

What is the output type of =SEC?

Click a question to see the answer.

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

A. If number is a non-numeric value, SEC returns the #VALUE! error values. ✓
B. Requires add-in
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: If number is a non-numeric value, SEC returns the #VALUE! error values. — Fix: برای آرگومان number یک مقدار عددی وارد کنید و مطمئن شوید سلول ارجاعی حاوی متن نیست.

2. Which is the correct syntax of =SEC?

A. =FORECAST(number)
B. =SEC(number, 0)
C. SEC(number)
D. =SEC(number) ✓

Explanation: Correct syntax: =SEC(number)

3. Is =SEC volatile?

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

Explanation: SEC is not volatile.

4. Is argument “number” required in =SEC?

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

Explanation: “number” is required.

5. What is the fix for #NUM! in =SEC?

A. Volatile and recalculates every time
B. Text is always ignored
C. مطمئن شوید قدر مطلق number کمتر از 2^27 باشد؛ مقدار زاویه را کاهش دهید یا ورودی را بررسی کنید. ✓
D. Output is always a dynamic array

Explanation: If number is outside of its constraints, SEC returns the #NUM! error value. — Fix: مطمئن شوید قدر مطلق number کمتر از 2^27 باشد؛ مقدار زاویه را کاهش دهید یا ورودی را بررسی کنید.

6. Which function is NOT related to =SEC?

A. FORECAST
B. MODE
C. PERCENTILE
D. DECIMAL ✓

Explanation: “DECIMAL” is not related to SEC.

7. Since which Excel version is =SEC available?

A. Excel 2007 (Compatibility) ✓
B. All versions
C. Excel 2019
D. Excel 365

Explanation: Version: “Excel 2007 (Compatibility)”.

8. What usually causes #NUM! in =SEC?

A. Requires add-in
B. اگر number مقدار غیرعددی باشد، تابع SEC خطای #VALUE! را برمی‌گرداند.
C. Text is always ignored
D. If number is outside of its constraints, SEC returns the #NUM! error value. ✓

9. Which use case fits =SEC?

A. Reporting ✓
B. Dynamic Ranges & Dashboards
C. Text Manipulation
D. Lookup & Retrieval

Explanation: Use case “Reporting” fits SEC.

10. What is the output type of =SEC?

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

Explanation: Output is “Number”.