‹ PrevQuestion 183 / 183 · latest first
✓ Board-verified
Accountancy · 2022 · 3 marks
CBSE 2022 · Region 1 · Set 3 · Q11
Explain the formula to calculate 'Total Earnings.
Explain the formula to calculate 'Total Earnings`.
OR
Explain the terms 'Data Audit and 'Data Vault'.
Marking-scheme solution
The formula to calculate ‘Total Earnings’ is:
TE= BPE + DA + HRA + TRA
BPE= BP * NOEDP/NODM
NOEDP (Number Of Effective Days Present) is the number of days in a month minus
Leave without Pay – unauthorized absence.
NODM ( Number of Days in a month) – ( Leave without Pay)- (Unauthorised absence).
DA ( Dearness Allowance)=BPE * (Applicable rate of DA for the month)
HRA ( House Rent Allowance)= BPE * (Applicable rate of HRA for the month)
TRA( Transport Allowance)= (Fixed amount) or (on percentage basis)
Q. Explain the terms ‘Data Audit’ and ‘Data Vault’.
Ans.
Data Audit: Audit feature of accounting software provides the user with administrator
right in order to keep track of unauthorized access. It audits for the correctness of entries.
Once the entries are audited with alternations, if any, the software displays all entries
along with the name of the auditor user and date and time of alteration.
Data Vault: Software provides additional security for the inputed data and this feature
is referred as data vault. Data Vault ensures that original information is presented and
not tampered. Data vault password cannot be broken.
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 2022 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.