You have a table that contains sales data. You need to create a Pivot Table that will display the sales by country as shown in the following exhibit. What should you use to display the icons?
Yes, C is undoubtedly the correct answer, but the main and decisive reason for choosing C and not B is because you always need a measure (i.e. an explicit measure) to create a KPI. This pivot table is built upon the "Sales" column from the table of data. This is evident because Power Pivot creates an implicit measure "Sum of Sales" which happens to be the header of the value column). Only conditional formatting can be used in this scenario.
Select the column (all the associated rows) > Home tab > Conditional Formatting> Icon Sets and pick Shapes.The colors are implicitly assigned based on the existing values of the data set but if you want to configure specific numbers then click on more rules under Icon Sets. No need of KPI.
Tested c works, you go to conditional formating, you choose the icons and edit the rule putting the numbers we have there it really works, green or max greater or equal to 2000000 and orange greater or equal to 1000000
I also think it's B. You need KPI for this specific icon. Conditional formatting formats the whole cells based on a threshold.
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
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.
mohroshdy
Highly Voted 5 years, 6 months agoFrdFrd
4 years, 5 months agoSumanthB
Highly Voted 5 years, 5 months agoVinni14
Most Recent 4 years, 7 months agoCDL
4 years, 8 months agoTobi999
4 years, 9 months agoWaltmas
4 years, 11 months agopanal
4 years, 11 months agor8d1
4 years, 11 months agoDev28
5 years, 1 month agoShlok
5 years, 1 month agoFrdFrd
4 years, 5 months agoMelvin11
5 years, 4 months agoSN22
5 years, 4 months agocubo
5 years, 7 months agodinessa
5 years, 7 months agocubo
5 years, 7 months agoThe_Marv
5 years, 7 months agoFiko
5 years, 6 months ago