✓ Board-verified
Accountancy · 2025 · 3 marks
CBSE 2025 · Region 2 · Set 3 · Q31
State the advantages of 'Pivot Table' report.
Marking-scheme solution
Any three of the following:
(i)
Querying large amounts of data in user-friendly ways. Sub totalling and aggregating numeric data,
summarizing data by categories and subcategories and creating custom calculations and formulas.
(ii)
Expanding and collapsing level of data to focus on results and providing from details to the
summary of data for areas of interest.
(iii)
Moving rows to column or columns to rows (or pivoting) to see different summaries of the source
data.
(iv)
Filtering, sorting, grouping and conditionally formatting the most useful and the interesting subset
of data to enable us to focus on the information that we want.
(v)
Presenting concise, attractive and annotated online or printed reports.
(vi)
The use of a Pivot table report is to analyse related totals, when we have a long list of figures to
sum and to compare several facts about each figure.
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.