Excel’s Information Functions are a category of built-in formulas that provide details about cells, data types, errors, and the workbook environment. They are essential for data validation, error checking, and building dynamic spreadsheets.
Key Information Functions and Their Uses
– CELL(info_type, reference): Retrieves information about the formatting, location, or contents of a specified cell. For example, it can return the cell’s address, format, or value type.
– INFO(type_text): Returns information about the current operating environment, such as the Excel version or system settings.
– ISBLANK(value): Checks if a cell is empty and returns TRUE if it is blank, FALSE otherwise.
– ISERROR(value): Determines if a value is any error type (like #DIV/0! or #VALUE!) and returns TRUE if an error exists.
– ISNA(value): Specifically checks for the #N/A error and returns TRUE if the value is #N/A.
– ISNUMBER(value): Verifies if a value is a number and returns TRUE if it is numeric.
– ISTEXT(value): Confirms if a value is text and returns TRUE if it is a string.
– ISNONTEXT(value): Returns TRUE if the value is not text (e.g., numbers or errors).
– ISLOGICAL(value): Checks if a value is a logical value (TRUE or FALSE).
– ISEVEN(value): Returns TRUE if a number is even.
– ISODD(value): Returns TRUE if a number is odd.
– TYPE(value): Indicates the data type of a value by returning a number code (e.g., 1 for numbers, 2 for text, 16 for errors).
These functions can be combined with other formulas for conditional logic, such as in IF statements, to enhance spreadsheet functionality and accuracy. For instance, they help in creating error-proof calculations or automated data checks.
Table of Contents
- Part 1: Create An Amazing Excel Information Functions Quiz Using AI Instantly in OnlineExamMaker
- Part 2: 20 Excel Information Functions Quiz Questions & Answers
- Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic
Part 1: Create An Amazing Excel Information Functions Quiz Using AI Instantly in OnlineExamMaker
The quickest way to assess the Excel Information Functions knowledge of candidates is using an AI assessment platform like OnlineExamMaker. With OnlineExamMaker AI Question Generator, you are able to input content—like text, documents, or topics—and then automatically generate questions in various formats (multiple-choice, true/false, short answer). Its AI Exam Grader can automatically grade the exam and generate insightful reports after your candidate submit the assessment.
Overview of its key assessment-related features:
● Create up to 10 question types, including multiple-choice, true/false, fill-in-the-blank, matching, short answer, and essay questions.
● Automatically generates detailed reports—individual scores, question report, and group performance.
● Instantly scores objective questions and subjective answers use rubric-based scoring for consistency.
● API and SSO help trainers integrate OnlineExamMaker with Google Classroom, Microsoft Teams, CRM and more.
Automatically generate questions using AI
Part 2: 20 Excel Information Functions Quiz Questions & Answers
or
1. Question: What is the primary function of the ISBLANK function in Excel?
A. Checks if a cell contains a number
B. Checks if a cell is empty
C. Checks if a cell contains text
D. Checks if a cell has an error
Answer: B
Explanation: ISBLANK returns TRUE if the cell is empty, helping to identify blank cells in formulas.
2. Question: Which Information function is used to check if a value is a number?
A. ISNUMBER
B. ISTEXT
C. ISERROR
D. ISREF
Answer: A
Explanation: ISNUMBER returns TRUE if the value is a number, useful for validating numeric inputs.
3. Question: What does the ISERROR function do in Excel?
A. Checks for specific error types like #N/A
B. Checks if a cell is blank
C. Checks for any error value in a cell
D. Checks if a value is text
Answer: C
Explanation: ISERROR returns TRUE if the value is any error, such as #DIV/0! or #VALUE!, for error handling.
4. Question: Which function checks if a value is text?
A. ISNUMBER
B. ISTEXT
C. ISLOGICAL
D. ISNONTEXT
Answer: B
Explanation: ISTEXT returns TRUE if the value is text, aiding in data type verification.
5. Question: What is the purpose of the ISNA function?
A. Checks if a cell is not text
B. Checks for the #N/A error specifically
C. Checks if a value is a number
D. Checks if a cell contains a formula
Answer: B
Explanation: ISNA returns TRUE only for the #N/A error, which is useful in lookup operations.
6. Question: Which Information function returns TRUE if a value is not text?
A. ISNONTEXT
B. ISTEXT
C. ISNUMBER
D. ISERROR
Answer: A
Explanation: ISNONTEXT returns TRUE if the value is not text, such as numbers or errors.
7. Question: What does the ISERR function check for?
A. All errors including #N/A
B. Only #N/A errors
C. All errors except #N/A
D. Blank cells
Answer: C
Explanation: ISERR returns TRUE for any error except #N/A, allowing for targeted error checking.
8. Question: Which function is used to determine if a reference is valid?
A. ISREF
B. ISFORMULA
C. TYPE
D. INFO
Answer: A
Explanation: ISREF returns TRUE if the argument is a valid cell reference, useful in advanced formulas.
9. Question: What does the ISLOGICAL function do?
A. Checks if a value is a number
B. Checks if a value is TRUE or FALSE
C. Checks for errors
D. Checks if a cell is blank
Answer: B
Explanation: ISLOGICAL returns TRUE if the value is a logical value (TRUE or FALSE).
10. Question: Which Information function returns a number indicating the data type?
A. ISBLANK
B. TYPE
C. ISERROR
D. INFO
Answer: B
Explanation: TYPE returns a number code for the data type, like 1 for numbers or 2 for text.
11. Question: What is the role of the INFO function in Excel?
A. Checks if a cell contains a formula
B. Provides system information like operating environment
C. Verifies if a value is a number
D. Detects errors in a cell
Answer: B
Explanation: INFO returns information about the Excel environment, such as the operating system.
12. Question: Which function checks if a cell contains a formula?
A. ISREF
B. ISFORMULA
C. ISNUMBER
D. ISERROR
Answer: B
Explanation: ISFORMULA returns TRUE if the cell contains a formula, not just a value.
13. Question: What does ISNONTEXT return for a numeric value?
A. FALSE
B. TRUE
C. #N/A
D. Blank
Answer: B
Explanation: ISNONTEXT returns TRUE for non-text values, like numbers, confirming data type.
14. Question: Which Information function is most useful for error trapping in formulas?
A. ISBLANK
B. ISERROR
C. ISTEXT
D. TYPE
Answer: B
Explanation: ISERROR helps trap and handle errors, preventing formula breakdowns.
15. Question: What does the TYPE function return for a text string?
A. 1
B. 2
C. 4
D. 16
Answer: B
Explanation: TYPE returns 2 for text strings, indicating the data type in numeric form.
16. Question: Which function would you use to check if a cell is empty before performing a calculation?
A. ISNUMBER
B. ISBLANK
C. ISERR
D. ISNA
Answer: B
Explanation: ISBLANK ensures no calculation is attempted on empty cells, avoiding errors.
17. Question: What is returned by ISNUMBER for the value “ABC”?
A. TRUE
B. FALSE
C. #VALUE!
D. Blank
Answer: B
Explanation: ISNUMBER returns FALSE for non-numeric values like text.
18. Question: Which Information function can help identify if a lookup result is an error?
A. ISTEXT
B. ISNA
C. ISLOGICAL
D. ISREF
Answer: B
Explanation: ISNA specifically checks for #N/A errors, common in VLOOKUP or MATCH functions.
19. Question: What does the ISREF function require as an argument?
A. A text string
B. A cell reference
C. A number
D. A formula
Answer: B
Explanation: ISREF needs a cell reference to verify if it’s valid, ensuring formula integrity.
20. Question: Which function is least likely to be used for data validation in a worksheet?
A. INFO
B. ISBLANK
C. ISNUMBER
D. ISTEXT
Answer: A
Explanation: INFO provides system details rather than validating data, making it less common for cell checks.
or
Part 3: OnlineExamMaker AI Question Generator: Generate Questions for Any Topic
Automatically generate questions using AI