✓ Board-verified
Accountancy · 2022 · 3 marks
CBSE 2022 · Region 5 · Set 3 · Q11
What is meant by 'Data Validation' ? Give two examples, when cell will give error, if the value does not meet the condition.ORExplain three components of Account group 'Current Assets'.
OR
Explain three components of Account group 'Current Assets'.Marking-scheme solution
Data validation is a feature to define restrictions on type of data entered into a
cell.
Example $\displaystyle 1$
We can prevent duplicate entries in a range on the worksheet (Figure $\displaystyle 2.50$) i.e.
suppose we check duplicate employee number or duplicate product code in the
asset ledger or duplicate account code for the same item entered by user it shows
the error.
Example $\displaystyle 2$
We can limit the sum value for a range which will cause error if sum of the
values exceeds the given total, i.e. suppose the total amount of budget is fixed
and sum of the distribution of the amount for different items in the range
exceeds then it shows the error.
Q. (b) Explain three components of Account group ‘Current Assets’.
Ans.
Components of the accounts group ‘Assets’: (Any three)
(i)
Stock in hand
(ii)
Loans and Advances
(iii)
Sundry Debtors
(iv)
Bank Account
(v)
Cash in Hand
(vi)
Miscellaneous Expenditure
Q. State the steps to construct Bank- Reconciliation using Tally.
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 2022board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.