Need Help For homework about excel

Need help creating my website
August 11, 2020
Capstone Course Assignment Details Week 4 Discussion Forum 1 help
August 11, 2020

Need Help For homework about excel

In this project, you will create a worksheet to summarize the total inventory of a retail store. You will calculate the total category value, the inventory total value, the East Valley store as a percent of the total quantity, and the total quantity minus the amount of inventory on customer layaway. You will also format and rename the worksheet.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx.

0

2

Add the file name in the worksheet’s left footer. Return to Normal view.

6

3

Select the range A1:H1 and then merge and center the text.

6

4

Select the range A2:H2 and then apply the Heading 3 cell style.

8

5

Select columns A:B and adjust the column width to 20.

6

6

In cell F3, enter a formula that adds the values in cells D3 and E3.

8

7

In cell G3, enter a formula that multiples the values in cell C3 and F3.

8

8

In cell H3, enter a formula the divides cell D3 by cell F3.

8

9

Select the range F3:H3 and then AutoFill the formulas down through row 14.

6

10

In cells D15:G15, enter functions that sum each column.

6

11

Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style.

6

12

Format the range H3:H14 with the Percent Style with one decimal place displayed.

6

13

Format the range D15:G15 using the Total cell style.

6

14

In cell C20, enter the formula that subtracts the value in cell B20 from cell F3. AutoFill the formula down through cell C31.

8

15

Rename the Sheet1 tab as Inventory.

6

16

Use the Spelling and Grammar dialog box to correct any spelling errors.

6

17

Save the workbook, close the workbook window, and then submit the workbook as directed.

0

Total Points

100

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.