Microsoft Excel 2016 Expert: Interpreting Data for Insights 77-728 Question # 4 Topic 1 Discussion
77-728 Exam Topic 1 Question 4 Discussion:
Question #: 4
Topic #: 1
Exhibit:
Task3:
On the “Available Must” worksheet, use a query to load the cells beginning at A1 from the HarvestLog.xlsx workbook in the documents folder. Include only the “Variety”,”Location” and “Litters of must” Columns.
Put the curser on cell A1 of the “Available Must” worksheet and then go to
Data tab- New Query – from File – from Workbook
Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns
Put the curser on cell A1 of the “Available Must” worksheet and then go to
Data tab- New Query – from File – from Workbook
Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit