Microsoft Core Data Analysis, Manipulation, and Presentation - 77-727 Exam Practice Test
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, enter a formula in cell N2 that uses an Excel function to return the average age
of the customers based on the values in the "CurrentAge" column.
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, enter a formula in cell N2 that uses an Excel function to return the average age
of the customers based on the values in the "CurrentAge" column.
Correct Answer:
See explanation below.
Explanation
1. Select cell N2 on the "Customers" worksheet, which is where you want the Excel function to return the
result to.
2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).
References:
https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6
Explanation
1. Select cell N2 on the "Customers" worksheet, which is where you want the Excel function to return the
result to.
2. In theAddressbar, type the average function syntax;=AVERAGE(K1:K101).
References:
https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6
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 "Products" worksheet, apply a number format to display the numbers in the "Weight" column to three
decimal places.
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 "Products" worksheet, apply a number format to display the numbers in the "Weight" column to three
decimal places.
Correct Answer:
See explanation below.
Explanation
1. Select the cells in the "Weight" column which you want to apply the number formatting to.
2. ClickIncrease Decimaltill the desired decimal places of three is selected, this is found on theHometab.
OR
1. Select the cells in the "Weight" column which you want to apply the number formatting to.
2. On theHometab, in theNumbergroup, click the arrow next to the list of number formats, then selectMore
Number Formats.
3. Select the type of data you have in theCategorylist, in this case it would beScientific.
4. Enter the desired amount ofdecimal placesyou want to display in the Decimal places box, in this case it
would be three.
References:
https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-49B936F9-6904-425D-A
Explanation
1. Select the cells in the "Weight" column which you want to apply the number formatting to.
2. ClickIncrease Decimaltill the desired decimal places of three is selected, this is found on theHometab.
OR
1. Select the cells in the "Weight" column which you want to apply the number formatting to.
2. On theHometab, in theNumbergroup, click the arrow next to the list of number formats, then selectMore
Number Formats.
3. Select the type of data you have in theCategorylist, in this case it would beScientific.
4. Enter the desired amount ofdecimal placesyou want to display in the Decimal places box, in this case it
would be three.
References:
https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-49B936F9-6904-425D-A
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Overview
You are updating the inventory worksheet for a local tree farm.
Hiderows 29 and 30.
Correct Answer:
See explanation below.
Explanation
1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.
2. Right-click on the selected rows then click Hide.
References:
https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f
Explanation
1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.
2. Right-click on the selected rows then click Hide.
References:
https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f
Project 3 of 7: Tree Inventory
Overview
You are updating the inventory worksheet for a local tree farm.
Change themarginsto 1.0'' (2.54 cm) on the top and bottom, 0.75'' (1.90 cm) on the left and right, with a 0.5''
(1.27 cm) header and footer.
Overview
You are updating the inventory worksheet for a local tree farm.
Change themarginsto 1.0'' (2.54 cm) on the top and bottom, 0.75'' (1.90 cm) on the left and right, with a 0.5''
(1.27 cm) header and footer.
Correct Answer:
See explanation below.
Explanation
1. Select the worksheet you want to apply the margin changes to.
2. Select Margins in thePage Setupgroup from thePage Layouttab.
3. ClickCustom Margins, then in theTopandBottomdialog box enter 1.0'' (2,54cm), in theLeftandRightdialog
box enter 0.75''(1.90cm), and enter 0.5''(1.27cm) in theHeaderandFooterdialog box.
References:
https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-91
Explanation
1. Select the worksheet you want to apply the margin changes to.
2. Select Margins in thePage Setupgroup from thePage Layouttab.
3. ClickCustom Margins, then in theTopandBottomdialog box enter 1.0'' (2,54cm), in theLeftandRightdialog
box enter 0.75''(1.90cm), and enter 0.5''(1.27cm) in theHeaderandFooterdialog box.
References:
https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-91