Question

What is a 'Pivot table'? State any three of its advantages.

Accepted Answer

A ‘Pivot table’ is an interactive way to quickly summarise large amounts of data. It is used to analyse numerical data in depth and to answer unanticipated questions about data. Advantages: (Any three) (i) Querying large amounts of data in user-friendly way and creating custom calculations and formulas. (ii) Expanding and collapsing levels of data to focus on results and providing from details to the summary of data for areas of interest. (iii) Moving rows to columns or columns to rows to see different summaries of source data. (iv) Filtering, sorting, grouping and conditionally formatting the most useful and the interesting subset of data to enable to focus on useful information. (v) Presenting concise, attractive and annotated online or printed reports. (vi) Facilitating analysis of long list of figures and to compare several facts. Or Q. (b) List eight uses of……………………………. Ans. Following are the uses: (Any eight) (i) Do all basic accounting functions (ii) Manage stores (iii) Do the job costing (iv) Manage payroll (v) Get useful MIS reports (vi) File tax return and prepare final accounts (vii) Maintain budgets (viii) Calculate interest on pending amount (ix) Manage data over different locations and synchronize it

Marking-scheme solution

More from Spreadsheet