Computer practice question for SSC. Review the correct answer and explanation, then continue with related practice below.
'Pivot Table' is a feature of which of the following software?
Correct Answerसही उत्तर
A. Microsoft ExcelA. माइक्रोसॉफ्ट एक्सेल
Explanationव्याख्या
The correct answer is Microsoft Excel.
According to the source, Pivot Table is a feature of Microsoft Excel.
The book defines a pivot table as a data summarisation tool used in the context of data processing.
It states that pivot tables can be used to summarise, sort, reorganise, group, count, total or average data stored in a database.
The source further explains that a pivot table can transform columns into rows and rows into columns and allows grouping by any data field.
Therefore the complete source-supported revision chain is: Pivot Table — Microsoft Excel — Data Summarisation Tool — Data Processing — Summarise — Sort — Reorganise — Group — Count — Total — Average — Columns to Rows — Rows to Columns — Grouping by Data Field.
Microsoft Word, Microsoft Access and Microsoft PowerPoint are distractors.
This is an important practical-computing question because Pivot Tables are associated with organising and analysing datasets rather than merely entering data.
The source does not discuss Pivot Charts, slicers, formulas, calculated fields, newer Excel versions or advanced analytics.
Therefore those details have not been added.
Students should remember not only that Pivot Table belongs to Excel but also its purpose: summarising and reorganising data.
A description-based question may ask which tool can group, count or average database data and rotate rows
columns; according to the source, the answer is Pivot Table.
Therefore option (a), Microsoft Excel, is correct.
सही उत्तर Microsoft Excel है। स्रोत के अनुसार Pivot Table Microsoft Excel की एक feature है। Book Pivot Table को data processing के context में use होने वाला data summarization tool बताती है। Source के अनुसार Pivot Tables का उपयोग data को summarize, sort, reorganize, group, count, total या average करने के लिए किया जाता है। यह columns को rows और rows को columns में transform कर सकती है तथा किसी data field के आधार पर grouping की सुविधा देती है। इसलिए complete source-supported revision chain है: Pivot Table — Microsoft Excel — Data Summarization — Data Processing — Summarize — Sort — Reorganize — Group — Count — Total — Average — Columns ↔ Rows — Data Field Grouping। Microsoft Word, Microsoft Access और Microsoft PowerPoint distractors हैं। यह practical computer knowledge का important question है क्योंकि Pivot Table का main purpose large data को organise और summarise करना है। Source Pivot Charts, slicers, formulas, calculated fields या advanced analytics की discussion नहीं करती। इसलिए ऐसी outside details नहीं जोड़ी गई हैं। Students केवल 'Excel' answer याद न रखें, बल्कि Pivot Table के functions भी याद करें। Description-based question में पूछा जा सकता है कि कौन-सा tool data को group, count, total या average कर सकता है और rows तथा columns को transform कर सकता है। Source के अनुसार answer Pivot Table है। इसलिए विकल्प (a), Microsoft Excel, सही उत्तर है।
Practice More Like This
Vitorr selects questions using the same topic, subject, exam and overlapping concepts—not just database order.
Related Quizzes
Continue with quizzes connected to Computer and Static GK. Sign up is required only when you start a quiz.