Excel Information Function Quiz
Question 1
If a cell contains the formula ="", what does ISBLANK return for that cell?
Question 2
What is the result of =ISEVEN(2.9)?
Question 3
Which code does the TYPE function return for a modern LAMBDA function or a Compound Data Entity?
Question 4
How does ISERR differ from ISERROR in industrial diagnostic modeling?
Question 5
What does ISREF("A1") return, and why?
Question 6
Which function returns TRUE for numbers, logical values, and error codes simultaneously?
Question 7
To find the total number of worksheets in a '3D Range' (e.g., Sheet1 through Sheet5), which syntax is correct?
Question 8
Why is the logical test =A1=NA() considered a 'Comparison Masking Trap'?
Question 9
What numeric code does TYPE return for a truly empty, blank cell?
Question 10
Which function returns only a 1-indexed number representing a sheet's physical position in the workbook?
Question 11
Which core Information function is the standard for protecting leading zeros in hardware-serial bitstreams?
Question 12