Global Web Forum

Muhammad

بِسمِ اللَّهِ الرَّحمٰنِ الرَّحيمِ

From: Sahiwal Division

Registered: 2012-03-22

Posts: 22,197

Website

Table Analysis Quiz Question.

Analysis Quizzes Table Analysis

Question:
While using a pivot table in Excel, when you drop information into the "Values" area in the lower-right corner, the default summarization is by summation. Which of the following tools will you use to change the default summarization?

Option A):
Value Field Settings
Option B):
What-If Analysis
Option C):
Column Labels
Option D):
PivotTable Field List

Correct Answer is Option A):
Value Field Settings

Explanation:
When you drop information into the "Values" area in the lower-right corner, the default aggregation or summarization is by summation. To change this, perform the following steps:
1. Click on the pull-down arrow in the Values area in the lower-right portion of the screen.
2. Click on Value Field Settings.
3. Click on Count in the Summarize Values by tab of the Value Field Settings dialog box.
4. Click on OK in the same dialog box.

---

Online Web Tutorials And Interview Questions With Answers Forum:
https://globalguideline.com/forum/