Office 2010 – myitlab:grader – Instructions GO! Excel Ch01 - EOC
In this project, you will add data to a worksheet, format cells and numeric values, and create formulas and
functions. You will also create and format a column chart and sparklines. Additionally, you will prepare the
workbook for printing.
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Possible
1 Start Excel. Download and open the workbook named GO_e01_Grader_EOC.xlsx. 0
Merge and center the title over the range A1:H1 and then apply the Title cell style. Merge and
center the subtitle over the range A2:H2 and then apply the Heading 1 cell style.
In cell F4, enter a function to sum the values in cells B4:E4. Copy the function down to cells
Format the ranges B4:F4 and B7:F7 with the Accounting Number Format. Format the range
4 B5:F6 with the Comma style. 8
Insert a new row between rows 5 and 6. Enter Dallas in cell A6, 105985.12 in cell B6,
5 98674.38 in cell C6, 100548.22 in D6, and 106222.17 in E6. Copy the function in cell F5 10
down to cell F6 to sum the values in the new row.
In cell G4, enter a formula to divide the Total Sales for Austin (F4) by The Total Sales (F8).
6 Set F8 as an absolute cell reference in the formula. Copy the formula down to cells G5:G7. 8
Select the range H4:H7 and insert Line sparklines. Set the data range for the sparklines as