Top Posters
Since Sunday
y
2
m
2
m
2
u
2
m
2
B
2
M
2
e
2
k
2
N
2
y
2
m
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
JohnAmera JohnAmera
wrote...
Go to Answer
Posts: 432
Rep: 0 0
6 years ago
You would like to see both average sales and total sales for a category in a pivot table. Which of these would best accomplish both a Total and an Average column on the field Sales?
A) Add sales to the VALUES area once and select both AVERAGE and SUM functions.
B) Add sales to the COLUMNS area.
C) Add sales to the ROWS area and then choose Average.
D) Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 69 times
1 Reply
Exploring Microsoft Office Excel
Replies
Answer verified by a subject expert
anicidanicid
wrote...
#1
Top Poster
Posts: 694
Rep: 32 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

JohnAmera Author
wrote...

6 years ago
Helped a lot
halyna
wrote...

Yesterday
Smart ... Thanks!
Kstan109
wrote...

2 hours ago
Thanks
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  496 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 373
  
 292
  
 335
Your Opinion
How often do you eat-out per week?
Votes: 81
Previous poll results: Do you trust social media networks with protecting your privacy?