✓ Board-verified
Accountancy · 2025 · 4 marks
CBSE 2025 · Region 1 · Set 2 · 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 cell. Name and state these data types.ORWhat is meant by 'Data Validation' ? What is facilitated by 'Error Alert Tab' ?
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 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.