Free Microsoft 77-727 Practice Test & Real Exam Questions
Project 7 of 7: Farmers Market
Overview
You are the Directorof a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.
On the "Summer Sales" worksheet, switch the rows with the columns on the first column chart.
Overview
You are the Directorof a local farmers' market. You are creating and modifying charts for a report which
shows the amounts and variety of products sold during the season.
On the "Summer Sales" worksheet, switch the rows with the columns on the first column chart.
Correct Answer:
See explanation below.
Explanation
1. Select the first row OR column on the "Summer Sales" worksheet andCopyeither from theHometabORby
pressing Ctrl+C on the keyboard.
2. Select the first cell where you want topastethe data, then click on the arrow next to Paste situated on
theHometab, then selectTranspose.
3. Pick a spot with enough space to paste your data, the copied data will overwrite the already existing data
that is already there.
4. Once completed, you can delete the original data if desired.
References:
https://support.office.com/en-us/article/Transpose-data-from-rows-to-columns-or-vice-versa-in-Excel-for-Mac-9
Explanation
1. Select the first row OR column on the "Summer Sales" worksheet andCopyeither from theHometabORby
pressing Ctrl+C on the keyboard.
2. Select the first cell where you want topastethe data, then click on the arrow next to Paste situated on
theHometab, then selectTranspose.
3. Pick a spot with enough space to paste your data, the copied data will overwrite the already existing data
that is already there.
4. Once completed, you can delete the original data if desired.
References:
https://support.office.com/en-us/article/Transpose-data-from-rows-to-columns-or-vice-versa-in-Excel-for-Mac-9
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
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
