Chid Abuse
HSP Computer Superstore
Project Description:
In this project, you will modify a workbook for the HSP Computer Superstore to track the sales totals for 2011. You will use functions to calculate total sales, average sales, and median, minimum, and maximum sales values. Additionally, you will create a summary worksheet using values from the other spreadsheets in the workbook.
Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Open the downloaded Excel workbook named GO_e02_Grader_IR.xlsx. | 0 | 2 | On the Main St. worksheet, in cell B25, insert a function that will total all of the sales for Quarter 1 in the range B6:B23. Copy the function in cell B25 to the range C25:F25. | 6 | 3 | On the Main St. worksheet, adjust the column widths for columns C, D, and E to 13.57 (100 pixels). | 3 | 4 | On the Main St. worksheet, in cell B26, insert a function that will calculate the average sales for Quarter 1. Copy the function in cell B26 to the range C26:E26. | 6 | 5 | On the Main St. worksheet, in cell B27, insert a function that will display the median sales value for Quarter 1. Copy the function in cell B27 to the range C27:E27. | 6 | 6 | On the Main St. worksheet, in cell B28, insert a function that will display the minimum sales value for Quarter 1. Copy the function in cell B28 to the range C28:E28. | 6 | 7 | On the Main St. worksheet, in cell B29, insert a function that will display the maximum sales value for Quarter 1. Copy the function in cell B29 to the range C29:E29. | 6 | 8 | On the Main St. worksheet, in cell B30, insert a function that will count the number of sales agents with sales greater than $75,000 in Quarter 1 (B6:B23). Copy the function in cell B30 to the range C30:E30. | 6 | 9 | Group the Main St. and Franklin Ave. worksheet tabs. With both worksheets selected, click in cell F6 and insert a function that will total
Project Description:
In this project, you will modify a workbook for the HSP Computer Superstore to track the sales totals for 2011. You will use functions to calculate total sales, average sales, and median, minimum, and maximum sales values. Additionally, you will create a summary worksheet using values from the other spreadsheets in the workbook.
Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Open the downloaded Excel workbook named GO_e02_Grader_IR.xlsx. | 0 | 2 | On the Main St. worksheet, in cell B25, insert a function that will total all of the sales for Quarter 1 in the range B6:B23. Copy the function in cell B25 to the range C25:F25. | 6 | 3 | On the Main St. worksheet, adjust the column widths for columns C, D, and E to 13.57 (100 pixels). | 3 | 4 | On the Main St. worksheet, in cell B26, insert a function that will calculate the average sales for Quarter 1. Copy the function in cell B26 to the range C26:E26. | 6 | 5 | On the Main St. worksheet, in cell B27, insert a function that will display the median sales value for Quarter 1. Copy the function in cell B27 to the range C27:E27. | 6 | 6 | On the Main St. worksheet, in cell B28, insert a function that will display the minimum sales value for Quarter 1. Copy the function in cell B28 to the range C28:E28. | 6 | 7 | On the Main St. worksheet, in cell B29, insert a function that will display the maximum sales value for Quarter 1. Copy the function in cell B29 to the range C29:E29. | 6 | 8 | On the Main St. worksheet, in cell B30, insert a function that will count the number of sales agents with sales greater than $75,000 in Quarter 1 (B6:B23). Copy the function in cell B30 to the range C30:E30. | 6 | 9 | Group the Main St. and Franklin Ave. worksheet tabs. With both worksheets selected, click in cell F6 and insert a function that will total