✓ 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 1…
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.
• 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 forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.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 it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.