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

4 major organs of the respiratory system - Locational break even analysis operations management - Beyond complete dominance worksheet answers - Www bmwfinance com au - Discussion Global City - Message in a bottle charles fishman - Procter and gamble organizational chart 2018 - Andy darvill energy resources - Discussion post! 250 words . needed by tonight based on youtube videos attached! 1030 PM EST - Becoming a writer russell baker summary - What does unsuccessful authorization mean on sephora - La noche boca arriba julio cortazar - A saffa foods annual report - 10k resistor colour code - A factory processes 1 560 ounces - Discussion2: Trends in Management Accounting - Business law - Exercises - Continuum allen curnow analysis - Argument - ASSIGNMENT - Re entry to practice nursing - Jane eyre discussion questions - Gartner api management magic quadrant - Macquarie university marking grades - Practical Connection - Http tinyurl com polaroid setup mac - Two way intercom project - What type of sentence states, summarizes, or forecasts the main point of the paragraph? - Gordon roddick net worth - Secure staging environment design and coding technique standards technical guide - Which is the most reactive element in periodic table - Word root of heart - Mn oac 3 2h2o - Past tense of hide - Why does the coefficient of friction not have units - Discussion forum on Article readings - Things fall apart citation - Business - Apollo greek god family - Methods of training slideshare - Tundra in a simple sentence - Demand for Labor and Minimum Wage - What is a highwayman - A visit to the desert story pdf - The yellow wallpaper notes - Crime analysis - A Doll's House - Assignment 1 network infrastructure design diagramming - Shell oil in nigeria case study pdf - Belhaven university blazenet - Interactive arts and technology jobs - Cherry blossom art lesson plan - D meter floor flatness - Interaction design 5th edition pdf - Ffn milk carton refill bottle - Accounting chapter 8 test b - Royal brompton hospital fulham road parking - Http simulations ibsa org au - How to calculate average atomic weight - Samuel f.b. morse patented the telegraph automobile audio recorder radio transmitter - Homework - Ardex am 100 datasheet - The outsiders chapter 6 audiobook - Uwa biochemistry and molecular biology - They say i say blue collar brilliance - Dunreath homestead conference centre - Team operating principles project charter example - Analytical profile index test - How to write a poetry explication - Enterprise Risk Management - Forward and reverse characteristics of silicon diode - 10 plagues egyptian gods chart - Assignment - Telephone area code 243 - Helen frankenthaler nature abhors a vacuum - Chick fil a franchise cost 2018 - Bose institute of nuclear physics - Channels business model canvas - I kb plus ladder - Reasons why we study intercultural communication - Stria cladding installation guide - What are persuasive devices - Thick face black heart - 978 1 938168 36 9 - Nursing Philosophy (3) - 2 coments each one 150 words (CITATION AND REFERENCE) - Least common factor definition - I need 1500 words in Arabic language articles in sports - The giver jonas character traits - Early years learning framework programming examples - History of microbiology notes - China noah corporation mini case - Laserjet pro m402 driver - What is a crucible - Ca oh 2 co2 reaction - Leadership and management term paper - The importance of continuing education for nurses - Worth the help - Describe the deficiencies in ethical leadership at stacy's firm