Correct Answer: Removes duplicates from the range that is highlighted based on selected criteria
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
There is only ONE way to group a pivot table item.
How do you change all positive numbers in a sheet to negatives?
In Sheet1, column A is January's sales numbers. In Sheet2, column A is February's sales numbers. Which equation on Sheet 3 totals both columns, in row 5?
To insert a character that is not part of an alphabetic font sent (such as copyright ©) use the:
Which worksheet function returns the average of selected database entries?
Which formula is NOT equivalent to all of the others?
A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?
When using Goal Seek, you can find a target result by varying _ at most.
Which format will display the value 27,500,000 as 27.5?
What is the best way to activate the Excel Help system?