Page 1 of 1

You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.)Exhibit:You need to transform the data by

Posted: Wed Aug 17, 2022 7:02 am
by answerhappygod
You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.)Exhibit:You need to transform the data by using Query Editor.What should you do first?
You Have The Ex 1
You Have The Ex 1 (90.31 KiB) Viewed 74 times
A. From the Data tab, click Flash Fill
B. From the Insert tab, click Store
C. From the Data tab, click From Table/Range
D. From the Data tab, click Consolidate