✓ Board-verified
Accountancy · 2023 · 6 marks
CBSE 2023 · Region 5 · Set 3 · Q34
Name the error which appears when the cell reference is not valid. State how this error can be corrected.
Name the error which appears when the cell reference is not valid. State how this error can be corrected.
Marking-scheme solution
The error is known as ____ REF ! Error.
This error is corrected by:
(i)
Click the cell that displays the error, click the button that appears and
then click Show Calculations Steps if it appears.
(ii)
Review the following possible causes and solutions :
• Deleting cells referred to by other formulas, or pasting moved cells
over cells referred to by other formulas.
• Change the formulas, or restore the cells on the worksheet by clicking
undo immediately after we delete or paste the cells.
• Using an object-linking and Embedding (OLE) link to a program that is
not running.
• Start the program.
• Linking to a Dynamic Data Exchange (DDE) topic such as “system” that
is not available.
• Make sure that we are using the correct DDE topic.
• Running a macro that enters a function that returns # REF!
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 2023 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.