Information =SHEET(value)

Quiz =SHEET — 10 Questions

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

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

← SHEET ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #REF! in =SHEET?

Question 2 of 10 2/10

Which statement about =SHEET is correct?

Question 3 of 10 3/10

What is the output type of =SHEET?

Question 4 of 10 4/10

Which category does =SHEET belong to?

Question 5 of 10 5/10

How many optional arguments does =SHEET have?

Question 6 of 10 6/10

What is the type of argument “value” in =SHEET?

Question 7 of 10 7/10

How many arguments does =SHEET have in total?

Question 8 of 10 8/10

Which function is related to =SHEET?

Question 9 of 10 9/10

In =SHEET, which is argument #1?

Question 10 of 10 10/10

Does =SHEET return a dynamic array?

Click a question to see the answer.

1. What usually causes #REF! in =SHEET?

A. Text is always ignored
B. Only works in old versions
C. If the value argument is not a valid reference, SHEET returns the #REF! error. For example, =SHEET(Sheet1!#REF) will return the #REF! error value. ✓
D. Volatile and recalculates every time

Explanation: If the value argument is not a valid reference, SHEET returns the #REF! error. For example, =SHEET(Sheet1!#REF) will return the #REF! error value. — Fix: مرجع واردشده را بررسی کنید که معتبر باشد و به سلول یا محدوده حذف‌شده اشاره نکند؛ برای مثال از Sheet1!#REF استفاده نکنید.

2. Which statement about =SHEET is correct?

A. Only works in old versions
B. SHEET locating/identification capability includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets). ✓
C. Requires add-in
D. Select entire column for best performance

Explanation: Correct: SHEET locating/identification capability includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets).

3. What is the output type of =SHEET?

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

Explanation: Output is “Number”.

4. Which category does =SHEET belong to?

A. Information ✓
B. Cube
C. Compatibility
D. Engineering

Explanation: Category is “Information”.

5. How many optional arguments does =SHEET have?

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

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

6. What is the type of argument “value” in =SHEET?

A. Mixed
B. Any type ✓
C. Value
D. Date

Explanation: Type of “value” is “Any type”.

7. How many arguments does =SHEET have in total?

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

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

8. Which function is related to =SHEET?

A. COLUMN ✓
B. COUNTIF
C. FIXED
D. BITXOR

Explanation: “COLUMN” is related to SHEET.

9. In =SHEET, which is argument #1?

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

Explanation: Argument #1 is “value”.

10. Does =SHEET return a dynamic array?

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

Explanation: SHEET does not spill.