✓ Board-verified
Accountancy · 2025 · 6 marks
CBSE 2025 · Region 5 · Set 1 · Q34
= SUM (B2B3) will give an error while using a spreadsheet. Identify the error and state the steps to correct it.
Marking-scheme solution
The error which will occur is Correct #NULL! Error.
As it was a typing mistake the Comma (,) was not inserted between B2 and B3.
Steps to correct it:
1.Show calculation steps it appears. Incorrect range operator
refer to contiguous range of cells use colon to separate the reference.
• To refer to two areas that don't intersect, use the union operator the comma (,).
Ranges do not intersect.
• If there are no squares at each corner of the color-coded border, then the reference is to a named
range.
• If there are squares at each corner of the color-coded border, then the reference is not to a named
range.
• Double-click the cell that contains the formula to change. Excel highlights each cell or range of cells
with a different color.
• On the Formulas tab, in the Defined Names group, click the arrow next to Define Name and then
click Apply Names.
• In the Apply Names box, click one or more names.
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.