Free Microsoft 77-727 Practice Test & Real Exam Questions
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.
Correct Answer:
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
Project 2 of 7: Donor List
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
Arrange the worksheets so that "$5,000 Donors" is first.
Overview
You are an executive assistant for a non-profit organization named Bellows College. You are updating a
workbook containing lists of donors.
Arrange the worksheets so that "$5,000 Donors" is first.
Correct Answer:
See explanation below.
Explanation
1. ClickSort Sheetsfrom theWorksheetgroup in theKutools Plustab.
2. Click theAlpha sortbuttonORtheAlpha Numeric Sortbutton in theSort Sheetsdialog box, the results can be
previewed in theNew sheets tab orderlist box.
3. Use theMove uporMove downbutton to manually change the order of the sheets so that the "$5,000 Donors"
worksheet is first in theNew sheet tabs orderlist.
4. ClickOKonce satisfied with the results.
References:
https://www.extendoffice.com/product/kutools-for-excel/sort-worksheets-in-one-workbook-in-alphabetical-order
Explanation
1. ClickSort Sheetsfrom theWorksheetgroup in theKutools Plustab.
2. Click theAlpha sortbuttonORtheAlpha Numeric Sortbutton in theSort Sheetsdialog box, the results can be
previewed in theNew sheets tab orderlist box.
3. Use theMove uporMove downbutton to manually change the order of the sheets so that the "$5,000 Donors"
worksheet is first in theNew sheet tabs orderlist.
4. ClickOKonce satisfied with the results.
References:
https://www.extendoffice.com/product/kutools-for-excel/sort-worksheets-in-one-workbook-in-alphabetical-order
Project 5 of 7: City Sports
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and
youth sports programs. You have been tasked to prepare tables for the analysis.
On the "Youth Program" worksheet, create a table from the cell range A9:G19. Include row 9 as headers.
Overview
The city events manager wants to analyze the enrollment changes over the past five years for various adult and
youth sports programs. You have been tasked to prepare tables for the analysis.
On the "Youth Program" worksheet, create a table from the cell range A9:G19. Include row 9 as headers.
Correct Answer:
See explanation below.
Explanation
1. On the "Youth Program" worksheet, selectFormat as Tablefrom theHometab.
2. Choose the desired style for the table.
3. Select the desired cell range of A9:G19 in theFormat as Tabledialog box.
4. Mark row 9 as a header.
5. ClickOK.
References:
https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
Explanation
1. On the "Youth Program" worksheet, selectFormat as Tablefrom theHometab.
2. Choose the desired style for the table.
3. Select the desired cell range of A9:G19 in theFormat as Tabledialog box.
4. Mark row 9 as a header.
5. ClickOK.
References:
https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
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.
Configure the "Car Inventory" worksheet so the column headings in row 9 appear on all printed pages.
Overview
You manage the office of a used car business. You have been asked to prepare the inventory list for a big
annual sale.
Configure the "Car Inventory" worksheet so the column headings in row 9 appear on all printed pages.
Correct Answer:
See explanation below.
Explanation
1. On the "Car Inventory" worksheet, clickPrint Titlesfrom thePage Setupgroup, situated on thePage
Layouttab.
2. UnderPrint Titles, on theSheettab, type the reference of the row you want to reappear (row 9) in theRows to
repeat at topbox.
References:
https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-
Explanation
1. On the "Car Inventory" worksheet, clickPrint Titlesfrom thePage Setupgroup, situated on thePage
Layouttab.
2. UnderPrint Titles, on theSheettab, type the reference of the row you want to reappear (row 9) in theRows to
repeat at topbox.
References:
https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-
