excel-exercise-formulas-and-charting

AcademicWritersDen.com boasts a team of highly skilled and experienced writers who specialize in various academic fields. The company carefully selects its writers through a rigorous screening process to ensure that they possess the necessary qualifications and expertise. Whether it’s an essay, research paper, or any other homework assignment, students can rely on AcademicWritersDen.com to connect them with professionals who have an in-depth understanding of the subject matter. This ensures that the work delivered is of high quality and meets the academic standards set by educational institutions.

Formulas and Charting

Instructions:

  • Copy the following data into a new Excel spreadsheet.Be sure to keep the cell data the same.
  • Save the workbook as yourname_P3
  • Beginning with cell A10 add the following information:
    • TAX (cell A10)7.3% (cell B10)
    • Suits(cell A11) $ 15.22 (cell B11)
    • Pants (cell A12)$ 3.14 (cell B12)
    • Shirts (cell A13)$ 2.79 (cell B13)
    • Jackets (cell A14)$ 5.87 (cell B14)
  • In Column F add the column title Total Items
    • Calculate the number items to be cleaned
  • At A6 add the row title Subtotal
    • calculate the subtotal amounts for each Customer
    • use the information from step 3
    • Be sure to use ABSOLUTE REFERENCE to calculate the subtotals
      • Use the Fill Handle to copy the formulas
  • At A7 add the row title Taxes
    • Calculate the taxes
      • Use cell ABSOLUTE REFERENCE to calculate TAX
  • At A8 add the row title Amount Due
    • Show the total amount due for each Customer
  • Insert 2 rows above the column titles
  • In cell A1 add the title Very Clean Dry Cleaners
  • Change the Font, Font Size and Color of your Title
    • Format the title to your liking
  • Center the Title across the table
  • Change the font of table cells
    • You choose color, size and fonts
  • Place a Border around all the cells in the table like above
    • Format the rest of the table to your liking
  • Center all of the data except for column A
  • Adjust column widths as needed
  • Change the name of the worksheet to Dry Cleaners and color the tab RED
  • Create a Column Chart showing the amount due by each of the Customers
  • Move the Graph to a new worksheet
    • Call this new worksheet Total Due
    • Color the tab BLUE
  • Enter your name and Student ID # in the Header of the worksheet
  • Complete the Page Properties
    • Include your name
    • Tags (use a minimum of 3, separated by commas)

A

B

C

D

E

1

Customer A

Customer B

Customer C

Customer D

2

Suits

3

Pants

4

Shirts

5

Jackets


1GRAPH

  • Create a Column Chart showing the amount due by each of the Customers
  • Move the Graph to a new worksheet
    • Call this new worksheet Total Due
    • Color the tab BLUE
  • Enter your name and Student ID # in the Header of the worksheet
  • Complete the Page Properties
    • Include your name
    • Tags (use a minimum of 3, separated by commas)


 

 
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.