Excel Exercise Formulas and Charting

in /by

Excel Exercise Formulas and Charting

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)


"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper