Download Excel 2016: Core Data Analysis, Manipulation, and Presentation.77-727.ActualTests.2019-05-18.11q.tqb

1. To check the accessibility select the Review tab from the ribbon. 2. Select Check Accessibility. 3. Review the results. 4. Exit the Accessibility Checker. 5. Right-click on the worksheet then click Format and then click Alt Text. 6. Type “Tree Nursery Inventory” in the Description box. 7. Click OK. References:https://support.office.com/en-us/article/Use-the-Accessibility-Checker-to-find-accessibility-issues-a16f6de0-2f39-4a2b-8bd8-5ad801426c7f

1. On the “Car Inventory” worksheet, click Print Titles from the Page Setup group, situated on the Page Layout tab. 2. Under Print Titles, on the Sheet tab, type the reference of the row you want to reappear (row 9) in the Rows to repeat at top box. References:https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-4C72-AD70-5309A2E8FE8C

1. Click Find & Select from the Editing group situated on the Home tab. 2. Click Replace. 3. Type the text “Pickup” in the Fine what box. 4. Click Options to further define the search, specify the “Car Inventory” worksheet select Sheet in the Within box. 5. Type “Truck” in the Replace with box. 6. Click Find All, and then click Replace All. 7. Finalize by clicking OK. References:https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

1. Right-click the text title “Adult_Program” and click Format Object then click Alt Text. 2. Type “Adult Enrollment” in the Title box as desired. 3. Click OK. 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. In cell M9, on the “Summer Bookings” worksheet, insert the following COUNTIF formula: “=COUNTIF(G6:G24, >= 12”)”References:https://support.office.com/en-us/article/count-numbers-greater-than-or-less-than-a-number-453b0ccc-cfaa-4332-ad02-6e148e01aa0a

1. In cell M10 on the “Summer Bookings”, insert the following SUMIF formula: “=SUMIF(G6:G24, “>= 12”, I6:I24).”’References:https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B

1. In cell C8 on the “Summer Bookings” worksheet, insert the following CONCAT function: “=CONCAT(E6 “, “D6)” OR “=E6& “, “, D6”.References:https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6

1. Click Design from the Ribbon on Table Tools. 2. In the Tools group, click on Convert to Range. OR 1. Right-click the table then click on Table then press Convert 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. On the “Summer Bookings” worksheet, click Header & Footer from the Text group situation on the Insert tab. 2. Click Click to add footer which would display the Header & Footer tools which gets added to the Design tab. 3. Specify where the page number should be by selecting the Center section box. 4. On the Design tab in the Header & Footer Elements group, click Page Number. 5. The placeholder &[Page] will appear in the selected section, to add the total number of pages type the word of followed by the space in the Header & Footer Elements group after clicking Number of Pages, then the placeholder &[Page] of &[Pages] appear. 6. Click anywhere outside the header or footer area to display the page numbers in Page Layout View. 7. Once you are done working in the Page Layout View, click Normal in the Workbook Views group situated on the View tab. OR You can also click Normal on the status bar. References:https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7-BF957C6CE29C

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 on Insert Pie Chart situation on the Insert tab then pick the 3-D Pie chart as desired. 3. Format the chart as desired by using Chart Elements, the Chart Styles, or the Chart 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