ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam
Go to Exam

Exam 70-779 topic 1 question 87 discussion

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

HOTSPOT -
You need to create a combo chart to display the count of orders by month and profit by month as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the combo chart? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Reference:
https://www.excel-easy.com/examples/combination-chart.html
https://www.howtogeek.com/434259/how-to-create-a-combo-chart-in-excel/
by imran at Oct. 10, 2019, 3:33 a.m.

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
Submit Cancel
tho
Highly Voted 5 years, 5 months ago
It should be stacked column & line.
upvoted 24 times
...
imran
Highly Voted 5 years, 7 months ago
THESE ARE NOT BARS. THESE ARE COLUMNS
upvoted 15 times
Samewiss
5 years, 6 months ago
I agree as per : https://www.fusioncharts.com/blog/bar-charts-or-column-charts/ both 100%... are incorrect as they dont fill up to 100% nor is there a percentage axis
upvoted 2 times
...
...
Robc79
Most Recent 4 years, 5 months ago
Stacked column and no Line and yes
upvoted 1 times
...
P_S09
4 years, 5 months ago
clustered column and line graph are the excel choices for combo graphs.
upvoted 1 times
...
MummyG
4 years, 5 months ago
The chart displays a combo chart comprising a clustered column chart and a line chart. So answer proposals should be modified.
upvoted 1 times
...
CDL
4 years, 6 months ago
Tested, correct answer as below: Value field: 1. Order count: Cluster Column (1st Axis) 2. Profit: Line (2nd Axis)
upvoted 4 times
...
ammu
4 years, 10 months ago
Answer is correct, there is nothing stacked over, so it is clustered bar and line
upvoted 4 times
kannn
4 years, 5 months ago
totally agree. nothing is stacked over.so,its clustered bar
upvoted 1 times
...
...
SN22
5 years, 3 months ago
The correct answer should be stacked column and line
upvoted 6 times
...
mohroshdy
5 years, 5 months ago
It should be Stacked Column not Clustered Bar
upvoted 10 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago