Home / MS Office Fundamentals / Question
MCQ
Which tool loads, transforms, and combines data in Excel?
MS Office Fundamentals
A Power Query
B Power Pivot
C Solver
D Consolidate
Explanation

Power Query (Get & Transform) imports and cleans data.

Related MCQs

Which tool replaced SharePoint Workspace for syncing?
MS Office Fundamentals View
Which version of Office introduced the Backstage view?
MS Office Fundamentals View
Which Word view displays a document as it would appear online?
MS Office Fundamentals View
Which key opens the Help window in Office apps?
MS Office Fundamentals View
What is the Ribbon in Office?
MS Office Fundamentals View
What is the Ribbon?
MS Office Fundamentals View