✓ Board-verified
Accountancy · 2025 · 3 marks
CBSE 2025 · Region 2 · Set 1 · Q32
State the advantages of 'Pivot Table' report.
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 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 2025 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.