最新的Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727免費考試真題
問題1
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Configure the worksheet so that row 9 and the WordArt remain visible as you scroll vertically.
Overview
You are updating the inventory worksheet for a local tree farm.
Configure the worksheet so that row 9 and the WordArt remain visible as you scroll vertically.
正確答案:
See explanation below.
Explanation
1. Select the cells below the rows and to the right of the columns you want to keep visible, which in this case
is row 10 and column H.
2. ClickFreeze Panesfrom theFreeze Panesgroup in theViewtab.
References:
https://support.office.com/en-ie/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd
Explanation
1. Select the cells below the rows and to the right of the columns you want to keep visible, which in this case
is row 10 and column H.
2. ClickFreeze Panesfrom theFreeze Panesgroup in theViewtab.
References:
https://support.office.com/en-ie/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd
問題2
Project 4 of 7: Car Inventory
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Apply the Rose, Table Style Light 17 (Table Style Light 17) to the "Inventory" table.
正確答案:
See explanation below.
Explanation
1. On the "Inventory" table, click on any cell.
2. Click onFormat as Tablefrom theHometab.
3. Select the Rose, Table Style Light 17 as desired.
References:
https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370
Explanation
1. On the "Inventory" table, click on any cell.
2. Click onFormat as Tablefrom theHometab.
3. Select the Rose, Table Style Light 17 as desired.
References:
https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370
問題3
Project 1 of 7: Tailspin Toys
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
On the "Customers" worksheet,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.
Overview
You recently opened an online toy store. You have sold products to 500 individual customers. You are
evaluating customer data and order data.
On the "Customers" worksheet,sortthe table to order the records by the "CountryOrRegion" field, with
customers in the United States first and customers in Canada second.
Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field.
Finally, sort the customers in each state or province in ascending order by the 'PostalCode" field.
正確答案:
See explanation below.
Explanation
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from theSort & Filtergroup in theDatatab.
3. In theSortdialog box, underColumnin theSort bybox, Select the "CountryOrRegion" field.
4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.
5. UnderOrder, selectCustom List, then set it for customers in the United States to appear first, then the
customers in Canada.
6. Then to add another column to sort by, clickAdd Level.
7. In theSortdialog box, underColumnin theSort bybox, Select the "StateOrProvince" field.
8. Under theSort Onoption, selectValues.
9. UnderOrder, selectA to Z.
10. Add a final column by clickingAdd Level.
11. In theSortdialog box, underColumnin theSort bybox, Select the "PostalCode" field.
12. UnderSort On, selectValues.
13. UnderOrder, selectSmallest to Largest.
14. ClickOK.
References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
Explanation
1. Select a cell in the "CountryOrRegion" field on the "Customers" worksheet.
2. Select Sort from theSort & Filtergroup in theDatatab.
3. In theSortdialog box, underColumnin theSort bybox, Select the "CountryOrRegion" field.
4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.
5. UnderOrder, selectCustom List, then set it for customers in the United States to appear first, then the
customers in Canada.
6. Then to add another column to sort by, clickAdd Level.
7. In theSortdialog box, underColumnin theSort bybox, Select the "StateOrProvince" field.
8. Under theSort Onoption, selectValues.
9. UnderOrder, selectA to Z.
10. Add a final column by clickingAdd Level.
11. In theSortdialog box, underColumnin theSort bybox, Select the "PostalCode" field.
12. UnderSort On, selectValues.
13. UnderOrder, selectSmallest to Largest.
14. ClickOK.
References:
https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
問題4
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Check the spreadsheet for accessibility problems. Correct the error by adding "Tree Nursery Inventory" as an
alternative text file. You do not need to fix the warning.
Overview
You are updating the inventory worksheet for a local tree farm.
Check the spreadsheet for accessibility problems. Correct the error by adding "Tree Nursery Inventory" as an
alternative text file. You do not need to fix the warning.
正確答案:
See explanation below.
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39
Explanation
1. To check the accessibility select theReviewtab from the ribbon.
2. SelectCheck Accessibility.
3. Review the results.
4. Exit theAccessibility Checker.
5. Right-click on the worksheet then clickFormatand then clickAlt Text.
6. Type "Tree Nursery Inventory" in theDescriptionbox.
7. ClickOK.
References:
https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39
