Need Help For homework(about excel)
Description
Having Trouble Meeting Your Deadline?
Get your assignment on Need Help For homework(about excel) completed on time. avoid delay and – ORDER NOW
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 |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.