1. Select the worksheet you want to apply the margin changes to.

2. Select Margins in the Page Setup group from the Page Layout tab.

3. Click Custom Margins , then in the Top and Bottom dialog box enter 1.0’’ (2,54cm), in the Left and Right dialog box enter 0.75’’(1.90cm), and enter 0.5’’(1.27cm) in the Header and Footer dialog box.

References:

https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-9166-99FBD22B963A

1. On the “Customers” worksheet, click the Select All button OR press Ctrl+A.

2. Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule .

3. Click Select a Rule Type in the New Formatting Rule dialog box, then select Use a formula to determine which cells to format .

4. In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.

5. Click on Format .

6. Click the Fill tab from the Format Cells dialog box.

7. Select the desired shade background and then click OK , you are able to view how the background would look in the Preview window in the New Formatting Rule dialog box.

8. Once satisfied, apply the formatting to the cells by clicking OK .

References:

https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-2025-42F6-9099-5DE09C05E880

1. Select the cell J2 where you want the highest “OrderTotal” value to be.

2. Type in the formula: =MAX(G1:G550).

References:

https://support.office.com/en-us/article/calculate-the-smallest-or-largest-number-in-a-range-45fe249f-96c3-443b-8e9f-87f16c48462c

1. On the “Adult Program” worksheet, select the area you want the sparkline to be inserted.

2. Click Column in the Sparklines group from the Insert tab.

3. Enter the range of cells in the Data Range box, in this case A10:A19 .

OR

3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.

4. Click OK and the Sparkline Tools will appear, the Design tab can be used to customize the sparklines.

References:

https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-873614413ce1

1. Click Find & Select from the Home tab then click on Go To .

OR

1. Press Ctrl+G on the keyboard.

2. Double-click the name range you want, in this case “Oregon”.

3. Delete the contents in the selected cells by pressing Delete on your keyboard.

References:

https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

1. Select the “Top Sellers” column chart.

2. Click on the particular data point you want to label, click Add Chart Element + , from the upper right corner next to the chart, then select Data Labels .

3. Then click Format Data Labels .

4. The Data Label Range dialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn for “Fruits”, “Vegetables”, and “Jams & Honey”, then click OK .

References:

https://support.office.com/en-us/article/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d

1. Select a cell in the “CountryOrRegion” field on the “Customers” worksheet.

2. Select Sort from the Sort & Filter group in the Data tab.

3. In the Sort dialog box, under Column in the Sort by box, Select the “CountryOrRegion” field.

4. Under the Sort On option, select the type of sort desired, in this case Values , to sort by text.

5. Under Order , select Custom List , then set it for customers in the United States to appear first, then the customers in Canada.

6. Then to add another column to sort by, click Add Level .

7. In the Sort dialog box, under Column in the Sort by box, Select the “StateOrProvince” field.

8. Under the Sort On option, select Values .

9. Under Order , select A to Z .

10. Add a final column by clicking Add Level .

11. In the Sort dialog box, under Column in the Sort by box, Select the “PostalCode” field.

12. Under Sort On , select Values .

13. Under Order , select Smallest to Largest .

14. Click OK .

References:

https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

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. Click Freeze Panes from the Freeze Panes group in the View tab.

References:

https://support.office.com/en-ie/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

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. Select the cells in the “OrderTotal” column which is the data range you are required to highlight the cells which are above-average.

2. Click Conditional Formatting from the Home tab, then select Top/Bottom Rules , then select the Above Average option.

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

4. Click OK .

References:

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