✓ Board-verified
Accountancy · 2023 · 3 marks
CBSE 2023 · Region 1 · Set 1 · Q31
Which error occurs when Excel does not recognise 'text' in the formula? State the steps to correct it.
Which error occurs when Excel does not recognise 'text' in the formula ? State the steps to correct it.
Marking-scheme solution
The name of the error is correct a # Name ? Error.Steps or solution to correct it :
1. Click the Microsoft Office Button. Click Options and then click the Add –
ins category.
2. Select Excel Ad - ins in the Manage list box and click Go.
3. 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
- 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.