Excel Quiz for Interview
Questions: 16 · 10 minutes
1. Cell A1 contains the text value ""125"". Which formula explicitly converts it to a number?
=TEXT(A1,""0"")
=VALUE(A1)
=TYPE(A1)
=ISTEXT(A1)
2. Which statement about Excel number formatting is correct?
Applying a number format permanently rounds the stored value
Formatting can change how a value appears without changing its underlying value
Changing a format also changes every formula referencing the cell
Applying a date format converts any text into a valid date
3. Which function directly tests whether a cell’s value is numeric?
ISTEXT
ISNUMBER
COUNTIF
NUMBERVALUE
4. A CSV file contains dates such as 03/04/2025, but different teams may mean different day-month orders. What is the best approach before analysis?
Confirm the source convention and import using matching locale or data-type settings
Assume Excel will infer the intended date consistently
Format the entire column as General after import
Sort the dates alphabetically to reveal the intended order
5. A range contains the number 100, the value ""200"" stored as text, a valid Excel date, and TRUE. What does COUNT return for that range?
1
3
4
2
6. A1 contains the number 10, while B1 contains the text word ""ten"". What will =A1+B1 normally return?
#DIV/0!
10
20
#VALUE!
7. Cell A1 contains a formula that returns an empty string: ="""". What does =ISBLANK(A1) return?
TRUE, because nothing is displayed
An empty string
FALSE, because the cell contains a formula
#VALUE!
8. Which pair consists of Excel logical values?
Yes and No
1 and 0
TRUE and FALSE
On and Off
9. You enter '00123 into a cell, including the leading apostrophe. How will Excel normally treat the entry?
As text displayed as 00123, with the apostrophe hidden
As a formula that returns 123
As an invalid number that produces an error
As the number 123 with a custom format
10. Which value is generally best stored as text, even when it contains only digits?
An employee ID that may begin with zero
A monthly sales total
A transaction date used in date calculations
A percentage used in a forecast
11. What error does the formula =25/0 return?
#N/A
#DIV/0!
#VALUE!
#REF!
12. A column contains 1, 2, and 10, all stored as text. What order can a text-based ascending sort produce?
10, 2, 1
2, 10, 1
1, 10, 2
1, 2, 10 in every case because the characters are digits
13. How does Excel normally store a valid date in a worksheet cell?
As a text label containing month, day, and year
As separate day, month, and year fields
As a logical value with a date display rule
As a serial number displayed with date formatting
14. Cells A1:A3 contain the number 5, the value ""7"" stored as text, and the number 3. What does =SUM(A1:A3) return?
15
12
8
#VALUE!
15. An exact-match lookup cannot find the requested key in its lookup table. Which error commonly indicates that no match was found?
#N/A
#NAME?
#NUM!
#NULL!
16. What does the formula =TYPE(TRUE) return?
1
2
16
4