LinkedIn Microsoft Excel Certification

You want to define a reusable process to reshape data (removing blank rows, merging columns, etc.). What toold can you use to accomplush this?

October 30, 2022 Editorial Staff

Power Query
Data Analysis
Power Pivot
Data Modeler

The correct answer is:

Power Query

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

← You want to copy only the cells that are displayed here – not the hidden cells – into another worksheet. After selecting the cells in the worksheet, how do you accomplish this?
You want to be able restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use? →