Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


Excelling with Excel

Excelling with Excel

Excelling with Excel

Question Description

Assignment 2 enables hands-on practice with presenting, organizing, and calculating data. You can also use MS Excel to create budgets, track your weekly spending, or create detailed project plans. This assignment gives you an opportunity to reflect upon your recent school supply purchases while producing a professional looking spreadsheet.

Grading ( Click Here to View Rubric )

There are five (5) main items addressed in Assignment 2:

  1. Did you enter all 21 data points into the required cells? Weight 20.00%
  2. Did you use the multiplication formula provided or a multiplication function to correctly calculate cell range D3:D7? Weight 15.00%
  3. Did you use the SUM function as directed or a similar formula to correctly calculate cell D8? Weight 15.00%
  4. Did you generate a pie chart by selecting the correct data ranges, display the appropriate data, and relocate the chart correctly? Weight 10.00%
  5. Did you follow all of the proper formatting for the cells including the use of a theme, merge and center, autofit of columns, Accounting number format, table format, and cell styles? Weight 40.00%

Click the above link to view the rubric detail so that you know exactly what is expected.


Do (Click here for a sample of what Assignment 2 looks like completed)

  1. Open MS Excel on your computer:
  2. Open a new Blank Workbook:
  3. Save the blank workbook with the following nomenclature: CIS105_Assignment2_FirstName_Last Name_Date:
  4. Type and enter the title My School Supply Purchases in cell A1:
  5. Type and enter the following headings into the appropriate cells as indicated:
    • Cell A2: School Supplies
    • Cell B2: Quantity
    • Cell C2: Price
    • Cell D2: Cost
  6. Type and enter the following school supplies into the appropriate cells as indicated:
    • Cell A3: TestOut Access Code
    • Cell A4: Spiral Notebook
    • Cell A5: Pencils
    • Cell A6: Pens
    • Cell A7: Highlighters
    • Cell A8: Total Cost
  7. Type and enter the following quantities into the appropriate cells as indicated:
    • Cell B3: 1
    • Cell B4: 2
    • Cell B5: 10
    • Cell B6: 5
    • Cell B7: 4
  8. Type and enter the following prices into the appropriate cells as indicated:
    • Cell C3: 115.00
    • Cell C4: 1.50
    • Cell C5: 2.00
    • Cell C6: 1.50
    • Cell C7: 2.50
  9. In cell D3, type and enter =B3*C3 to calculate the price OR use the multiplication function in Excel to calculate the price (DO NOT use a calculator and type the total cost into each cell as this is incorrect and this will be graded using the formula bar inputs):
  10. Use the Fill Handle to fill in from cell D3 to cells D4 through D7:
  11. In cell D8, use the SUM function to get the total cost of all school supplies:
  12. Apply your favorite theme to the spreadsheet using the Page Layout tab:
  13. Select range A1:D1 and use the Merge and Center button on the Home tab to merge and center the title of the spreadsheet over the data:
  14. Select range A8:C8 and use the Merge and Center button on the Home tab to merge and center the Total Cost label under the data:
  15. Select the entire spreadsheet and autofit the columns so that the information is showing:
  16. Select columns C and D and change the number format to Accounting:
  17. Select range A2:D7 and apply a table formatting that you like:
  18. Select range A8:D8 and apply the Total format under Cell Styles:
  19. Select cell A1 and apply the Title format under Cell Styles:
  20. Create a pie chart by selecting the School Supplies range, A2:A7, and the Cost range, D2:D7, (use the CTRL key to highlight each range separately) to generate the chart:
  21. With the above ranges selected, click on the Insert tab and insert a pie chart under the Charts section:
  22. With the pie chart selected, select a chart style on the Chart Tools menu that shows each school supply item and the percentage of the cost:
  23. Add the name Total School Supply Costs above the pie chart:
  24. Drag and drop the chart underneath the data contents of the spreadsheet in columns A through D with any formatting changes necessary and save your changes to submit your Excel file type (.xlsx) to Blackboard for grading:

We offer the best custom essay writing services at an affordable rate. We have done this assignment before, we can also do it for you.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Essay Pillars only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Essay Pillars are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Essay Pillars is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Essay Pillars, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.