Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Change cell to 20pt in excel

29/03/2021 Client: saad24vbs Deadline: 2 Day

EXCEL PRACTICAL EXERCISE – 4

Formulas and Charting

Instructions:

1. Copy the following data into a new Excel spreadsheet. Be sure to keep the cell data the same.

A

B

C

D

E

1

Items

Batman

The Hulk

Captain America

Thor

2

Capes

17

0

0

12

3

Suits/Body Armor

6

0

13

5

4

Masks

6

0

5

0

5

Other Articles of Clothing

5

18

4

9

2. Save the workbook as yourname_P4

3. Beginning with cell A10 add the following information:

a. Capes (cell A10) $ 9.32 (cell B10)

b. Suits/Body Armor (cell A11) $ 14.43 (cell B11)

c. Masks (cell A12) $ 3.68 (cell B12)

d. Other Articles of clothing (cell A13) $ 4.81 (cell B13)

e. Tax: (A14) 8.23% (cell b14)

4. In Column F (F1) add the column title No. of Items

5. In Row 6 (A6) add the row title Item Costs

6. In Row 7 (A7) add the row title Tax

7. In Row 8 (A8) add the row title Total Due

8. In column F

a. Calculate the total number of items brought in for laundry service

9. In Row 6 calculate the total amount due for all items

a. use the information from step 3

b. Be sure to use ABSOLUTE REFERENCE to calculate the Item Totals

i. Use the Fill Handle to copy the formulas

10. In Row 7 calculate the tax amount that is due for all items

11. In Row 8 calculate the Total Due for items and tax

12. Insert 2 rows above the table

13. In cell A1 add the title Superhero Dry Cleaners

14. Change the Font, Font Size and Color of your Title

a. Size 20

b. Font: Ravie

c. Color: (You Choose)

15. Center the Title across the table

16. Change the font of table cells

a. Font: (You choose)

b. Size: 20pt

c. Color: (You Choose)

17. Place a Border around all the cells in the table

a. Format the rest of the table to your liking

18. Center all of the data except for column A

19. Adjust column widths as needed

20. Change the name of the worksheet to Dry Cleaners and color the tab RED

GRAPH

21. Create a Column Chart showing the Total Due by each of the Superheroes

22. Move the Graph underneath the Table

FINISHING TOUCHES

23. Change the page orientation to landscape

24. Enter your name, Course ID, Date and Instructor Name underneath the chart

25. Complete the Document Properties with your name, subject and Tags (use a minimum of 3 key words, separate with commas)

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Financial Hub
Quick Finance Master
Engineering Mentor
Quality Homework Helper
A+GRADE HELPER
Professor Smith
Writer Writer Name Offer Chat
Financial Hub

ONLINE

Financial Hub

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$49 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I have read and understood all your initial requirements, and I am very professional in this task.

$25 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

Give me a chance, i will do this with my best efforts

$36 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$40 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$49 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I have read and understood all your initial requirements, and I am very professional in this task.

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Mike israetel book pdf - Cricket life cycle diagram - Corrective advertising - Barium chloride flame color - Optical illusions in art - Linear vs semi log graph - When were stone keep castles built - How to win friends and influence people kmart - Performance lawn equipment case study - Lpc grades commendation distinction - Does piracy hurt the economy - Regulation eu no 1007 2011 - Royal melbourne hospital pharmacy - Animal farm chapter 1 4 questions and answers - Vector addition experiment lab report - Nova absolute zero worksheet answers - Motorola's global strategy case study answers - Find an initial solution to the following transportation problem - Week 11 - Negotiation preparation worksheet - Direct and indirect compensation in hrm - Ford business level strategies and corporate level strategy - Secret code for sheep bounce - David von drehle triangle the fire that changed america pdf - What is 2 8 in simplest form - Magdeburg crossing of waterways - Counting strides between jumps - How to write a chemistry lab report introduction - Philip markoff girlfriend - Http www codeblocks org downloads - Substantive and procedural democracy - Hypothesis for heat transfer - Alprim 300mg and alcohol - Ways to play beer pong - Legal aid mount isa - Loot crate financials - Airspace Capacity Challenges 3 Page APA Paper - The norton introduction to literature portable 12th edition online - Blintz frog base origami - What are the seven biomes - Difference between a monologue and a soliloquy - Plan - Milestone One Assignment - Data structure and algorithm - Fundamental principles of servant leadership in nursing - Minimum insulation resistance value for motors - Umuc math 107 final exam answers - Magdalen gates primary school - Plc timing diagram examples - Gas gas gas poem - Cry - Week 5 - Delinquency - The sash my father wore chords - Davis v monroe county board of education synopsis - A regular insulin drip at 7 units hour is ordered - 530 mils to degrees - Lausanne conference on world evangelism - Hhd study design 2017 - The trouble we re in privilege power and difference - Bailey and burch ethics scenarios - What is recommendation in report writing - PAAS and IAAS - Maternity hesi - What sentence clarifies the focus of a paragraph - Week 6 data mining - Script - The auto repair shop of quality motor company uses standards - Indian railway bridge code - Perkins restaurant online ordering - Dr david meldrum paediatrician - Help us improve this course for future students - Catholic church riverview fl - Borderlands 2 caustic caverns ever blow bubbles - Cell homeostasis virtual lab worksheet - Data mining - Abc iview error code 240000 - Art homework - Atomic radius of diamond cubic structure - 3 Papers. (Cloud)(Ethical Hacking)(12 hours) - Hydraulic gear motor torque - Whistleblowers heroes or disloyal employees - Internal control case study with answer - Vsm sipoc - Payback agreements require an employee ________ - Organizational behavior managing people and organizations pdf - Importance of project screening - Sap jam successfactors login - Ob gyn soap note template - Hilti cast in sockets - Windows server 2016 disable unnecessary services - Blanket overhead absorption rate formula - Hansel and gretel bruno bettelheim summary - Strategic management frank rothaermel pdf - Caterpillar organizational structure - Integrate 1 sqrt x 2 1 - The glass castle discussion questions and answers - Uts census date 2021 - Need Help Writing a comparative Essay - Real time physics lab 2 homework answers