HW 3留学生讲解、辅导Python/C编程、讲解Python语言、辅导Python设计

HW 3

1)Start Excel 2016

2)Do the following exercises:

I.Complete the following steps in Module 5 (starting on page EX 257), Working with Excel Tables, PivotTable, and PivotCharts, from the Excel 2016 book.

i.Download file June.xlsx onto your computer.

ii.Complete steps on pages EX 262-271, skipping steps 1 and 2 on the bottom of page 263 (keep the top row frozen).

iii.Complete steps on pages EX 278-285, skipping the steps on the bottom half of page 285 (stop after you clear the filters).

iv.Go to the Sales Data worksheet and change the 6/28/2017 sales for Individual from $54.73 to $154.73

v.Complete steps on pages EX 301-318.

vi.Upon completion of the indicated steps, save and store file June Sales Data.xlsx in a secure location on your computer or removable disk.

II.Complete Module 6 (starting on page EX 327), Managing Multiple Worksheets and Workbooks, from the Excel 2016 book only up to page EX 347.

i.Download files Michigan.xlsx onto your computer.

ii.Do not forget to create custom headers and footers, as described on pages EX 346 and 347.

iii.Upon completion of the indicated steps, save and store file Jackson.xlsx in a secure location on your computer or removable disk.

Submit files June Sales Data.xlsx and Jackson.xlsx to Sakai.