✓ Board-verified
Accountancy · 2024 · 3 marks
CBSE 2024 · Region 5 · Set 2 · Q31
Explain various 'Data tables' used in 'Pivot Table.
Marking-scheme solution
There are two types of data tables which are used in Pivot table:
(i)
One-variable data table:
The table in which formula used must refer to an input cell. The input cell is a cell used by Excel in which
each input value from a data table is substituted.
(ii)
Two-variable data table:
Where two input two cells are used to generate a new table that table is known as two variable data table.
These are required for the analysis of information and to create a tabulation summary of data in which
heading can subsequently moved to give different views of the data.
More from Spreadsheet
- Explain the two syntax f2024
- 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
- Home Calibri 'e Wrap Text 425 Copy Paste I u~. Y v Merge 81 Center v v 4 liormat Painter Clipboard Vi Font…2024
CBSE Class 12 Accountancy past-paper question from the 2024board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.