✓ Board-verified
Accountancy · 2023 · 4 marks
CBSE 2023 · Region 1 · Set 3 · Q33
What is data formatting? What tools are used to format a given data? Explain.
What is data formatting ? What tools are used to format a given data ? Explain.
OR
List eight uses of accounting software.
Marking-scheme solution
(a)
The use of following formatting tools to make the reading spreadsheet
understandable is known as Data Formatting.
Following tools with appropriate explanation :
• Number formatting
• Currency
• Percentage
• Dates
Q. (b) List eight uses……………
Ans. Following are the eight uses of accounting software: (Any eight)
(1)
Do all the basic accounting functions
(2)
Manage stores
(3)
Do the job costing
(4)
Manage payroll
(5)
Get MIS reports
(6)
Fill tax returns, prepare balance sheet and profit and loss statement, VAT
form, TDS returns etc.
(7)
Manage, maintain budget scenario.
(8)
Manage data over different locations and synchronize it.
(9)
Calculate interest on pending amount.
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.