The error ##### occurs when?
(A) Column is not wide enough
(B) Negative date
(C) Negative time
(D) Row is not wide enough
Choose the correct answer from the options given below:
The error ##### occurs when?
(A) Column is not wide enough
(B) Negative date
(C) Negative time
(D) Row is not wide enough
Choose the correct answer from the options given below:
Solution
The ##### error in spreadsheet applications (like MS Excel) appears under specific circumstances:
Analyzing each statement:
(A) Column is not wide enough → Correct
When numerical or date values are too wide to fit in the current column width, the cell displays ##### instead of truncating the data. This is the most common cause.
(B) Negative date → Correct
Dates are stored as serial numbers in spreadsheets. Since the date system starts from a base date (like 1-1-1900), any calculation resulting in a negative date value cannot be displayed and shows ##### error.
(C) Negative time → Correct
Time values are stored as decimal fractions of a day. When time calculations result in negative values (for example, subtracting a later time from an earlier time without proper handling), the ##### error appears as negative times cannot be displayed.
(D) Row is not wide enough → Incorrect
Row height doesn't cause the ##### error. If a row is too short, content may be cut off or hidden, but it doesn't trigger this specific error. The ##### error is specifically related to column width, not row height.
Therefore, statements (A), (B), and (C) are correct causes of the ##### error.
Correct Answer: Option 1
Related questions:
2026: 31 May Shift 1
2025: 3 June Shift 1
2025: 14 May Shift 2
2023: 20 June Shift 2
2025: 3 June Shift 1