✓ Board-verified
Accountancy · 2025 · 3 marks
CBSE 2025 · Region 2 · Set 3 · Q32
Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.
Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.
Marking-scheme solution
1. Name of the Error is:
Correct a #NAME? Error
This error occurs when Excel doesn't recognize text in a formula.
Solution: (Any two)
(i)
Click the Microsoft office button, click Excel option and then click the Add-ins category.
(ii)
Select Excel Add-ins in the manage list box and then click Go.
(iii)
In the Add-ins available list, select the Euro Currency Tools check box and then click Ok.
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
- 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
- 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
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.