Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 63 discussion

Actual exam question from Microsoft's 70-779

Question #: 63
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have the following data.

You need to retrieve a list of the unique ProductName entries.
Solution: Open the Advanced Filter dialog box, select Filter the list, in-place, and then select Unique records only.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by HiJaak at Oct. 22, 2019, 5 a.m.

Comments

Submit Cancel

dinessa

Highly Voted 5 years, 7 months ago

The answer is YES. I tested it and it worked. https://support.office.com/en-us/article/video-advanced-filter-details-bbd0cb0a-8f90-43df-bf77-6ad3774dc420

upvoted 17 times

Gonza967

5 years, 6 months ago

This is right, just spend 1 minute watching the video.

upvoted 6 times

...

HiJaak

Highly Voted 5 years, 8 months ago

Record means an entire row. The rows are all unique so the correct answer should be NO.

upvoted 7 times

Gonza967

5 years, 6 months ago

This is not right

upvoted 4 times

...

Tancredii

Most Recent 4 years, 6 months ago

The answer is YES. I tested it and it worked. https://support.office.com/en-us/article/video-advanced-filter-details-bbd0cb0a-8f90-43df-bf77-6ad3774dc420

upvoted 1 times

...

Vinni14

4 years, 7 months ago

The answer should be B because one more step must be added to select the range i.e. to select the Product column. Otherwise it would select the entire table and no unique value will be available.

upvoted 1 times

...

CDL

4 years, 8 months ago

A is correct, tested. when selecting the range, just include the "headers". Link: https://support.microsoft.com/en-us/office/video-advanced-filter-details-bbd0cb0a-8f90-43df-bf77-6ad3774dc420?ui=en-us&rs=en-us&ad=us

upvoted 3 times

hfgirona

4 years, 7 months ago

YES, when you select de rangelist must include the header. It works is correct but only returns the first distinct value and eliminates the others...has no sense

upvoted 1 times

...

sirex

5 years, 3 months ago

the answer is B -No, by default when you slect the advanced filter it selects the whole range, If you check the soloution - Open the Advanced Filter dialog box, select Filter the list, in-place, and then select Unique records only. If follow this solution it will not give you the unique list, if want to get the unique list, we need to specify the column. In this case after select Filter the list, in-place, we should have one more step "List range" and specify the column - in this case the productname and then select unique records only

upvoted 5 times

Jrestrepo

5 years, 2 months ago

The solution proposed does not mention selecting a range, so the answer should be "NO"

upvoted 2 times

...

Wyman

5 years ago

Technically you are totally correct but I think the question style is not to write all the detailed steps, so the answer should be A

upvoted 1 times

sjonghe

4 years, 7 months ago

In this case selecting the column is not a detail, but an essential, very required step. It's all about selecting unique values in this column, not about the filtering itself.

upvoted 1 times

...

simenva

5 years, 4 months ago

Assuming that you filter for the ProductName column only, then 'Yes' (same as using Remove Duplicates on a specific column). Otherwise 'No' is the correct. Tested.

upvoted 3 times

...

SN22

5 years, 4 months ago

A is correct

upvoted 2 times

...

mohroshdy

5 years, 7 months ago

Answer is A. Yes Tested

upvoted 2 times

...