✓ Board-verified
Accountancy · 2025 · 4 marks
CBSE 2025 · Region 1 · Set 3 · Q33
Each and every data from Notepad file can be saved as an Excel data file. This provides a lead that Excel worksheet consists of four types of data in…
Each and every data from Notepad file can be saved as an Excel data file. This provides a lead that Excel worksheet consists of four types of data in cell. Name and state these data types.
OR
What is meant by 'Data Validation' ? What is facilitated by 'Error Alert Tab' ?
Marking-scheme solution
(1)
Labels: (Text) are descriptive data such as names, months and usually include alphabetic characters.
Excel aligns text to the left side of the cell.
(2)
Values: (Numbers) are generally raw numbers or dates.
• Whole Value: If the data is a whole value such as $\displaystyle 34$ or $\displaystyle 5763$, Excel aligns the data to the right side of
the cell.
• Value with a decimal: If the data is a decimal value, Excel aligns the data to the right side of the cell
including the decimal point, with exception of a trailing 0. If we enter $\displaystyle 3.75$ then $\displaystyle 3.75$ displays; such as
3.$\displaystyle 70$ will display as 3.7. We can change the display appearance column width and alignment of data.
(3)
Formulas are instructions for Excel to perform calculations.
(4)
Date: This format is dependent to country specific format.
Q. (b) What is meant by ………
Ans. Data Validation is a feature to define restriction on type of data entered into a cell. It is invaluable
because it is necessary that data must be accurate and consistent.
Error Alert Tab Enables:
(a)
To display the error alert after invalid data is entered in the box.
Enter message allows to type the desired message for user and title for reference purpose.
(c)
In style drop-down menu select information, warning or stop as per the severity and accuracy
requirement for data where
(i)
Information displays a message but will prevent entry of invalid data.
(ii)
Warning: displays a warning message but will not prevent entry of invalid data.
(iii)
Stop: will prevent invalid entry of data.
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.