The writer is very fast, professional and responded to the review request fast also. Thank you.
Using excel
SPREAD SHEET 1
For this week’s individual work, please complete the following:
The master sheet used to create the profi t potential analysis workbook is part of the Data Files for Students. Alice Stewart, the company’s accountant, has asked you to use the master sheet to create the profi t potential analysis workbook. Instructions Part 1: Perform the following tasks.
1. Open the workbook Lab 6- 1 A tHome Blu- Ray Master from the Data Files for Students. Save the workbook as a workbook using the fi le name, Lab 6- 1 At Home Blu- Ray Profi t Potential Analysis.
2. Add a worksheet to the workbook between Sheet1 and Sheet2 and then paste the contents of Sheet1 to the three empty sheets.
3. From left to right, rename the sheet tabs Consolidated, Chicago, New York, and Seattle. Color the tabs as shown in Figure 6 – 65. ( The Consolidated tab uses the Tan, Accent 1 color.) On each of the three store sheets, change the subtitle in cell A2 to match the sheet tab name. Change the title style for each title area in the range A1: F1 to match the sheet tab color. Enter the data in Table 6 – 12 into the three store sheets.
4. On the Consolidated worksheet, use the SUM and AVERAGE functions, 3- D references, and copy and paste capabilities of Excel to total the corresponding cells on the three store sheets. First, compute the sum in cell B4 and then compute the average in cell C5. Copy the range B4: C5 to the range B5: C11. The Consolidated sheet should resemble Figure 6 – 65.
PART 2
Instructions Part 2: Complete the following tasks. 1. Start Excel. Open the workbook Lab 6- 1 At Home Blu- Ray Profi t Potential Analysis. 2. Select the range D6: H11 on the Consolidated worksheet. Select all the worksheets. 3. Use the Format Cells dialog box to apply a custom format of #,## 0.00; [ Green](#,## 0.00). 4. Select the cell B12 on the Consolidated worksheet. Select all the worksheets. 5. Use the Format Cells dialog box to apply a custom format of #,## 0 “ Units”. Widen Column B so that contents of cell B12 are visible. 6. Save the workbook and then close the workbook.
SPREAD SHEET 2
Now that you have discussed PivotTables and PivotCharts, it is time to create a spreadsheet that includes both.
For this week’s lab work, please complete the following:
3. If necessary, add two blank lines above the PivotTable, and then change the contents of cell A4 to Supplier and cell B3 to Stores. Apply the Pivot Style Dark 3 style to the PivotTable. Format the values as Currency values with a dollar sign and no decimal places. Apply the chart Style 28 to the PivotChart. Resize the PivotChart to cover the range A20: G37 and then hide the fi eld buttons.
4. Create a second PivotTable and associated PivotChart as shown in Figure 8 – 96b in a separate sheet in the workbook. Name the worksheet Computer Sales By Month.
5. Change the contents of cell A4 to Month and cell B3 to Store. Apply the Pivot Style Dark 3 style to the Pivot Table. Format the values as Currency values with a dollar sign and no decimal places. Turn off the legend for the chart.
6. Filter the category by Computer. Filter the store to Green Spring Club.
7. Change the chart type to Line and then add a linear trendline that forecasts the trend for four more months. Apply the Chart Style 28 to the PivotChart, and hide the fi eld buttons.
8. Change the document properties as specifi ed by your instructor. Change the Computer Sales By Month worksheet header to include your name, course number, and other information as specifi ed by your instructor.
SPREAD SHEET 3
This week’s lab work is to construct a final project.
The final is broken up into two parts.
After reviewing the textbook chapters and links from previous weeks in eCollege, complete the final project as instructed. You will create two workbooks:
Analyzing Profi t Potential Professional You work for HumiCorp, an online retailer of home humidifi ers. Your manager wants to know the profi t potential of their inventory based on the items in inventory listed in Table 2– 12. Table 2– 12 contains the format of the desired report. The required formulas are shown in Table 2– 13. Use the concepts and techniques developed in this chapter to create and format the worksheet. The company just received 67 additional desk- sized humidifiers and shipped out 48 room- sized humidifiers. Update the appropriate cells to reflect the change in inventory.
Apply your creative thinking and problem solving skills to design and implement a solution. 1: Inventory Level Priority Academic Create an Intro to Biology grade table from the data in Table 5 – 6. Also include a Final % fi eld and a Grade fi eld. Both are calculated columns. Final % is calculated with each quiz being worth 10% and each test being worth 35%. Create a Grade table in the range J6: K20 using the data shown in Table 5 – 7. Use the VLOOKUP function to determine the grade to assign to each record. Add the total row to the table. Show the averages of each quiz and test. In cell range A19: B19 show Mark Kennedy’s grade using the MATCH and INDEX functions.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more