5. What function could be used to assign consecutive values (1, 2, 3, …) to the customer names based on the profit of each customer, with lower values assigned to customers with higher profit?
It is stated that correct answer is the 2nd one. But how is lower values assigned to customers with higher profit with ‘Desc’ attribute in the formula?
Lower values assigned to the customers with higher profit means that rank 1 will be assigned to the customer with the highest profit, rank 2 to the with the second highest profit and so on. This is why we have the ‘desc’ parameter so we can start with the highest profit and have the lowest profit the last one in the list.
Option a) is correct since we want to filter only the worksheets that use the current data source, not all worksheets that use related data sources as well.
Immediately showed me holes in my base knowledge.
Glad it was helpful!
ok
5. What function could be used to assign consecutive values (1, 2, 3, …) to the customer names based on the profit of each customer, with lower values assigned to customers with higher profit?
RANK (sum([Profit]),’desc’)
RANK _UNIQUE(sum([Profit]),’desc’)
RANK _MODIFIED(sum([Profit]),’asc’)
RANK (sum([Profit]), ‘asc’)
It is stated that correct answer is the 2nd one. But how is lower values assigned to customers with higher profit with ‘Desc’ attribute in the formula?
Hello,
Lower values assigned to the customers with higher profit means that rank 1 will be assigned to the customer with the highest profit, rank 2 to the with the second highest profit and so on. This is why we have the ‘desc’ parameter so we can start with the highest profit and have the lowest profit the last one in the list.
Hope this makes it clearer.
Narcis
Number 6 is not correct. On the Filters shelf, right-click the field and select Apply to Worksheets > All Using Related Data Sources.
Hi Tammie,
Option a) is correct since we want to filter only the worksheets that use the current data source, not all worksheets that use related data sources as well.
Hope this makes it clearer.
Narcis