the appropriate ranges to compare Arizona totals with Washington totals .
16 To the sparkline in cell B5 , apply the style Sparkline
4.000
Style Accent 2 , ( no dark or light ). To the sparkline in cell B6 , apply the style Sparkline Style Dark # 1 . To the sparkline in cell B7 , apply the style Sparkline Style Accent 1 , Lighter 40 %.
17 Group the three worksheets , and then from the Page
4.000
Setup dialog box , center the worksheets Horizontally on the page . Change the Orientation to Landscape .
18 Insert a custom footer on the grouped sheets in the left 2.000 section with the File Name element .
19 Ensure that the worksheets are correctly named and
0.000 placed in the following order in the workbook : Summary , Arizona , Washington . Save and close the workbook . Exit Excel . Submit the file as directed .