Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the primary purpose of a PivotTable in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A PivotTable is an interactive tool for summarizing and analyzing worksheet or external data.
• Fields can be rearranged to view the same source data from different perspectives.
• It can calculate summaries such as totals, counts and averages without altering the original source records.
• Fields can be rearranged to view the same source data from different perspectives.
• It can calculate summaries such as totals, counts and averages without altering the original source records.
వివరణ:
Question 2
ప్రశ్న 2
Which source-data arrangement is generally most suitable before creating a PivotTable from worksheet data?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PivotTable source data should be organized in a clear tabular structure.
• Each column should represent a field and should have a meaningful heading.
• Consistent rows and columns allow Excel to identify fields and records correctly for analysis.
• Each column should represent a field and should have a meaningful heading.
• Consistent rows and columns allow Excel to identify fields and records correctly for analysis.
వివరణ:
Question 3
ప్రశ్న 3
Which command path is normally used to create a PivotTable from selected worksheet data in current desktop Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PivotTables are normally created from the Insert tab in Excel.
• The user selects or identifies the source table/range and chooses where the PivotTable should be placed.
• Excel can place the new PivotTable in a new worksheet or an existing worksheet.
• The user selects or identifies the source table/range and chooses where the PivotTable should be placed.
• Excel can place the new PivotTable in a new worksheet or an existing worksheet.
వివరణ:
Question 4
ప్రశ్న 4
In the PivotTable Fields pane, which area is primarily used for fields that should appear as row labels down the left side of the PivotTable?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Fields placed in the Rows area are displayed as row labels in the PivotTable.
• Text or categorical fields such as Department or District are commonly placed there.
• Values is used primarily for summarized data, while Columns creates column labels.
• Text or categorical fields such as Department or District are commonly placed there.
• Values is used primarily for summarized data, while Columns creates column labels.
వివరణ:
Question 5
ప్రశ్న 5
A field named Sales_Amount must be summarized numerically in a PivotTable. Into which field area should it normally be placed?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Values area contains fields whose data is summarized in the PivotTable.
• Numeric fields such as Sales_Amount can be summarized by Sum, Average, Count, Max, Min and other supported functions.
• Row and Column areas primarily organize how categories are displayed.
• Numeric fields such as Sales_Amount can be summarized by Sum, Average, Count, Max, Min and other supported functions.
• Row and Column areas primarily organize how categories are displayed.
వివరణ:
Question 6
ప్రశ్న 6
A PivotTable should allow the user to choose one Department and display the report only for that Department. Which field area is designed for such a report-level selection?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field placed in the Filters area appears as a report-level filter above the PivotTable.
• The user can select one or more permitted items to restrict the displayed PivotTable results.
• This is useful when the same summary must be viewed for different categories without rebuilding the PivotTable.
• The user can select one or more permitted items to restrict the displayed PivotTable results.
• This is useful when the same summary must be viewed for different categories without rebuilding the PivotTable.
వివరణ:
Question 7
ప్రశ్న 7
In a PivotTable, which field area is used when categories such as Quarter 1, Quarter 2, Quarter 3 and Quarter 4 should appear across the top as column labels?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Fields in the Columns area are displayed across the top of the PivotTable as column labels.
• A Quarter field can therefore create separate columns for Q1, Q2, Q3 and Q4.
• The Rows area instead displays field items vertically down the left side.
• A Quarter field can therefore create separate columns for Q1, Q2, Q3 and Q4.
• The Rows area instead displays field items vertically down the left side.
వివరణ:
Question 8
ప్రశ్న 8
A field containing only valid numeric sales values is placed in the Values area of a standard Excel PivotTable and is recognized as numeric. Which summary function does Excel normally use by default?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel normally summarizes a numeric field placed in the Values area by using Sum.
• The resulting field may appear with a label such as Sum of Sales.
• The summary function can later be changed through Value Field Settings or Summarize Values By.
• The resulting field may appear with a label such as Sum of Sales.
• The summary function can later be changed through Value Field Settings or Summarize Values By.
వివరణ:
Question 9
ప్రశ్న 9
A text field such as Employee_Name is placed in the Values area of a PivotTable. Which summary operation does Excel normally use for such nonnumeric values?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel normally summarizes nonnumeric values in the Values area by using Count.
• Count determines the number of nonempty entries represented by the PivotTable grouping.
• Sum and Average require meaningful numeric values for arithmetic summarization.
• Count determines the number of nonempty entries represented by the PivotTable grouping.
• Sum and Average require meaningful numeric values for arithmetic summarization.
వివరణ:
Question 10
ప్రశ్న 10
A PivotTable currently displays Sum of Salary, but the requirement is to show the mean salary for each department. Which operation is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The summary calculation for a value field can be changed through Value Field Settings or Summarize Values By.
• Selecting Average causes Excel to calculate the arithmetic mean for each PivotTable group.
• Sorting changes display order and does not change a Sum calculation into an Average calculation.
• Selecting Average causes Excel to calculate the arithmetic mean for each PivotTable group.
• Sorting changes display order and does not change a Sum calculation into an Average calculation.
వివరణ:
Question 11
ప్రశ్న 11
What is one major advantage of the PivotTable Fields pane?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PivotTable fields can be rearranged interactively among the four principal areas.
• This makes it easy to examine the same data from different analytical perspectives.
• Rearranging PivotTable fields changes the report layout, not the underlying source records.
• This makes it easy to examine the same data from different analytical perspectives.
• Rearranging PivotTable fields changes the report layout, not the underlying source records.
వివరణ:
Question 12
ప్రశ్న 12
A field is no longer required in a PivotTable report. Which action can remove that field from the PivotTable without deleting its source-data column?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field can be removed from the PivotTable by dragging it out of the relevant Fields area or using the field-removal option.
• This changes only the PivotTable report configuration.
• The corresponding source-data column and its values remain intact.
• This changes only the PivotTable report configuration.
• The corresponding source-data column and its values remain intact.
వివరణ:
Question 13
ప్రశ్న 13
A value in an existing PivotTable source range has been changed from 500 to 800. Which standard operation can be used to make the PivotTable retrieve and display the updated source information?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Refresh updates a PivotTable from its connected source data.
• It is a standard method for incorporating changed source values into the PivotTable results.
• A PivotTable can be refreshed individually, and Excel also provides Refresh All for multiple applicable objects.
• It is a standard method for incorporating changed source values into the PivotTable results.
• A PivotTable can be refreshed individually, and Excel also provides Refresh All for multiple applicable objects.
వివరణ:
Question 14
ప్రశ్న 14
A PivotTable was originally created from the fixed range A1:D100. New records have been added down to Row 150, but the original static source range has not been expanded. Which operation is appropriate to make the PivotTable use A1:D150?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A PivotTable based on a fixed cell range analyzes the range defined as its source.
• Change Data Source can redefine that range from A1:D100 to A1:D150.
• The PivotTable can then be refreshed or updated so that the newly included records participate in the analysis.
• Change Data Source can redefine that range from A1:D100 to A1:D150.
• The PivotTable can then be refreshed or updated so that the newly included records participate in the analysis.
వివరణ:
Question 15
ప్రశ్న 15
A PivotTable contains hundreds of individual transaction dates. The user wants to analyze them by months or quarters rather than by every separate date. Which PivotTable operation is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PivotTable grouping can combine date values into useful periods such as months, quarters or years.
• Grouping reduces a long list of individual dates into higher-level categories for easier analysis.
• Grouping changes the analytical presentation without requiring the original date values to be deleted.
• Grouping reduces a long list of individual dates into higher-level categories for easier analysis.
• Grouping changes the analytical presentation without requiring the original date values to be deleted.
వివరణ:
Question 16
ప్రశ్న 16
A PivotTable contains several departments, but the user wants to display only the 'Forensics' and 'Administration' items in the Department field. Which operation is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PivotTable filtering allows selected field items to be displayed while other items are hidden from the current report view.
• The underlying source records remain available and are not deleted.
• Clearing or changing the filter can restore the other Department items later.
• The underlying source records remain available and are not deleted.
• Clearing or changing the filter can restore the other Department items later.
వివరణ:
Question 17
ప్రశ్న 17
A PivotTable currently shows total expenditure amounts. The user wants each category to be displayed as its percentage contribution to the overall PivotTable total while retaining the same underlying source values. Which feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Show Values As can display summarized values using alternative analytical presentations.
• % of Grand Total expresses each value as a percentage of the overall PivotTable total.
• This changes how the summarized result is displayed rather than replacing the underlying source values.
• % of Grand Total expresses each value as a percentage of the overall PivotTable total.
• This changes how the summarized result is displayed rather than replacing the underlying source values.
వివరణ:
Question 18
ప్రశ్న 18
A worksheet contains the fields Region, Quarter and Sales. The required PivotTable must show one row for each Region, separate columns for each Quarter, and total Sales at each intersection. Which field arrangement is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Region belongs in Rows because each region must appear as a row category.
• Quarter belongs in Columns because the quarters must appear across the top.
• Sales belongs in Values because the numeric sales figures must be summarized at each Region-Quarter intersection.
• Quarter belongs in Columns because the quarters must appear across the top.
• Sales belongs in Values because the numeric sales figures must be summarized at each Region-Quarter intersection.
వివరణ:
Question 19
ప్రశ్న 19
Assertion (A): Refresh is a standard method for updating a PivotTable after values in its connected source data have changed.
Reason (R): Refresh causes the PivotTable to retrieve updated information from its defined data source and recalculate its displayed summaries.
Choose the correct answer.
Reason (R): Refresh causes the PivotTable to retrieve updated information from its defined data source and recalculate its displayed summaries.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Refresh is an established PivotTable operation for updating the report from its source data.
• Updated source information is retrieved and the PivotTable summaries are recalculated accordingly.
• Both statements are true, and the Reason correctly explains the purpose of Refresh.
• Updated source information is retrieved and the PivotTable summaries are recalculated accordingly.
• Both statements are true, and the Reason correctly explains the purpose of Refresh.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Rows area
(b) Columns area
(c) Values area
(d) Filters area
List II
1. Displays summarized calculations
2. Creates report-level filtering
3. Displays categories vertically as row labels
4. Displays categories horizontally as column labels
Choose the correct matching code.
List I
(a) Rows area
(b) Columns area
(c) Values area
(d) Filters area
List II
1. Displays summarized calculations
2. Creates report-level filtering
3. Displays categories vertically as row labels
4. Displays categories horizontally as column labels
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Rows area produces row labels, giving (a)-3, while the Columns area produces column labels, giving (b)-4.
• The Values area contains summarized calculations, giving (c)-1.
• The Filters area provides report-level filtering, giving (d)-2.
• The Values area contains summarized calculations, giving (c)-1.
• The Filters area provides report-level filtering, giving (d)-2.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: A. To summarize, reorganize and analyze large sets of data interactively సమాధానం: A.
-
Question 2 ప్రశ్న 2Answer: C. Tabular data organized in columns with a single header row containing unique, nonblank field names సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: D. Insert > PivotTable సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. Rows సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Values సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: A. Filters సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: C. Columns సమాధానం: C.
-
Question 8 ప్రశ్న 8Answer: D. Sum సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: D. Count సమాధానం: D.
-
Question 10 ప్రశ్న 10Answer: B. Use Value Field Settings or Summarize Values By and select Average. సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: A. Fields can be dragged between Rows, Columns, Values and Filters to reorganize the analysis without rewriting the source data. సమాధానం: A.
-
Question 12 ప్రశ్న 12Answer: C. Drag the field out of its PivotTable area or deselect/remove it from the Field List. సమాధానం: C.
-
Question 13 ప్రశ్న 13Answer: C. Refresh సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: D. Use Change Data Source to expand the source range and then update the PivotTable. సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: B. Group the date field సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: A. Apply a PivotTable filter to the Department field and select the required items. సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: B. Show Values As > % of Grand Total సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: C. Region in Rows; Quarter in Columns; Sales in Values సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. (a)-3, (b)-4, (c)-1, (d)-2 సమాధానం: D.