✓ Board-verified
Accountancy · 2025 · 6 marks
CBSE 2025 · Region 6 · Set 1 · Q34
Name the error which occurs when the column is not wide enough or a negative date or time is used. How can it be corrected if (i) Error is due to $\displaystyle 1$ the width of column, and (ii) Date or time is negative ? $\displaystyle 1$+$\displaystyle 2$ +$\displaystyle 2$ $\displaystyle 2$ $\displaystyle 2$
Marking-scheme solution
The error : Correct a # # # # # Error occurs when the column is not wide enough or
negative date or time is used.
(i)
When length of the column is not wide enough then:
(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 also we can double click the boundary to the right of the column
heading.
(3)
Select the column.
(4)
On the ‘HOME’ tab, in the Cells group, click format, click format Cells, and then click
Alignment tab.
(5)
Select the shrink to fit.
(ii)
Dates and times are negative numbers, then:
When a date or time is typed in a cell, it appears in a default date and time format which is based
on regional date and time setting that is specified in Windows Control Panel and changes when
changes are made to those settings.
Page $\displaystyle 16$ of $\displaystyle 17$
•
If we are using the $\displaystyle 1900$ date system, dates and times in Excel must be positive.
• To subtract date and time be sure to make formula correctly.
•
If the formula is correct but result is still a negative value, display the value by
formatting the cell with a format that is not a date or time format.
More from Spreadsheet
- Explain the two syntax f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.