Microsoft 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation

1. ClickFind & Selectfrom theEditinggroup situated on theHometab.

2. ClickReplace.

3. Type the text “Pickup” in theFine whatbox.

4. ClickOptionsto further define the search, specify the “Car Inventory” worksheetselect Sheet in theWithinbox.

5. Type “Truck” in theReplace withbox.

6. ClickFind All, and then clickReplace All.

7. Finalize by clickingOK.

References:

https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

1. Select the data you would like to use, in this case it would be the data in the “Products” and “Total” columns from the “Summer Sales” worksheet.

2. Click onInsert Pie Chartsituation on theInserttab then pick the 3-D Pie chart as desired.

3. Format the chart as desired by usingChart Elements, theChart Styles, or theChart Filters.

4. Drag the Pie Chart to the desired location which is to the right of the column charts.

References:

https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863

1. Select the cells in the “OrderTotal” column which is the data range you are required to highlight the cells which are above-average.

2. ClickConditional Formattingfrom theHometab, then selectTop/Bottom Rules, then select theAbove Averageoption.

3. A popped up dialog box will then appear, select the Green Fill with Dark Green Text option as desired.

4. ClickOK.

References:

https://www.extendoffice.com/documents/excel/2195-excel-highlight-above-average.html

1. Right-click the text title “Adult_Program” and clickFormat Objectthen clickAlt Text.

2. Type “Adult Enrollment” in theTitlebox as desired.

3. ClickOK.

References:

https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

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-4C72-AD70-5309A2E8FE8C

1. On the “Summer Bookings” worksheet, clickHeader & Footerfrom theTextgroup situation on theInserttab.

2. ClickClick to add footerwhich would display theHeader & Footertools which gets added to theDesigntab.

3. Specify where the page number should be by selecting theCenter sectionbox.

4. On theDesigntab in theHeader & Footer Elementsgroup, clickPage Number.

5. The placeholder&[Page]will appear in the selected section, to add the total numberofpages type the word of followed by the space in theHeader & Footer Elementsgroup after clickingNumber of Pages, then the placeholder&[Page] of &[Pages]appear.

6. Click anywhere outside the header or footer area to display the page numbers inPage Layout View.

7. Once you are done working in thePage Layout View, clickNormalin theWorkbook Viewsgroup situated on theViewtab. OR You can also clickNormalon the status bar.

References:

https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7-BF957C6CE29C

1. Click on cell C3.

2. Enter the following formula: “=HYPERLINK(john@bellowsollege.com, C3)

References:

https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F

1. ClickDesignfrom the Ribbon onTable Tools.

2. In theToolsgroup, click onConvert to Range.

OR

1. Right-click thetablethen click on Table then pressConvert to Range.

References:

https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77?redirectSourcePath=%252fen-us%252farticle%252fRemove-a-table-without-losing-the-data-or-table-format-ADF88635-90F5-4FAA-9417-19862F38CCE8 &ui=en-US&rs=en-US&ad=US

1. SelectFormatfrom theHometab then chooseHide and Unhidethen selectUnhide.

OR

1. Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose theUnhideoption in the right menu.

2. Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last worksheet tab, then choose theUnhideoption.

OR

1. From theViewtab, clickCustom Viewsin theWorkbook Viewsgroup.

2. Click the “Summary” view which is hidden, then clickShow.

References:

https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/