CBSE 2025, Compartment, Set 1

Question

Which error occurs when a column is not wide enough or a negative date or time is used?
How can this error be corrected, if :
(i) Error is due to the width of the column ?
(ii) Date and time are negative numbers?

Edvaya · Accepted Answer

The correct answer is Subjective. The error that occurs is the `#####` Error. **(i) Correction if due to the width of the column:** *Reason:* The column is not wide enough to display the full numeric content. *How to correct:* 1. Select the column by clicking the column header. 2. On the Home tab, in the Cells group, click Format, and then click "AutoFit Column Width". Alternatively, double-click the boundary to the right of the column heading. 3. Another method: Select the column, go to Format Cells -> Alignment tab, and select the "Shrink to fit" check box. **(ii) Correction if dates and times are negative numbers:** *Reason:* In the 1900 date system (the default in Excel), dates and times must be positive values. Negative results from subtraction cause this error. *How to correct:* 1. Make sure the formula subtracting dates/times is built correctly (larger date minus smaller date). 2. If the formula is mathematically correct but intentionally negative, you can display the value by formatting the cell with a standard number format instead of a date/time format. (Go to Format Cells -> Number tab, and select a non-date/time format).

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Accountancy > Computerised Accounting > Accounting Application Of Electronic Spreadsheet

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy