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.