exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 94 discussion

Actual exam question from Microsoft's 70-779
Question #: 94
Topic #: 1
[All 70-779 Questions]

You have a PivotChart template named Template1.
You add a PivotChart to a worksheet.
You need to apply the template to the PivotChart.
What should you do?

  • A. On the Format tab, click Format Selection
  • B. Right-click the chart, and then click Format Chart Area
  • C. On the Design tab, click Change Chart Type
  • D. Right-click the chart, and then click PivotChart Options
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
Reference:
https://support.office.com/en-us/article/change-the-chart-type-of-an-existing-chart-c686d8c2-b294-43c0-b744-f54000f51454?ns=EXCEL&version=19&ui=en-
US&rs=en-US&ad=US

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
FrdFrd
4 years, 3 months ago
C is the correct answer TESTED After clicking "Change Chart Type" a "Template" option will show just like if it were another chart. When you select it, your previously created templates will appear on the right side where you can any of them to apply to your chart
upvoted 1 times
...
Waltmas
4 years, 9 months ago
B and c are both correct
upvoted 1 times
Waltmas
4 years, 9 months ago
Actually it's C
upvoted 1 times
...
...
r8d1
4 years, 10 months ago
Tricky! You can also Right click and Change Chart Type https://www.excelcampus.com/charts/chart-templates-default-formatting/
upvoted 1 times
Carol181188
4 years, 9 months ago
That is true. Either way works. C is correct.
upvoted 3 times
...
...
Jrestrepo
5 years, 1 month ago
https://www.google.com/search?q=how+do+I+apply+a+templeate+to+a+pivotchart+in+excel&oq=how+do+I+apply+a+templeate+to+a+pivotchart+in+excel&aqs=chrome.0.69i59.7663j1j8&sourceid=chrome&ie=UTF-8#kpvalbx=_0SiJXs6fCcOyggfl6bu4Ag54
upvoted 4 times
Mounira
4 years, 3 months ago
Thanks for the link. C is correct
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago