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

Detroit 60 series running rough - Writing apus style guides - Micro-Econ Essay - Naplan year 7 persuasive writing topics - The case for short words richard lederer - Patch adams angel scene - What is a nursing diagnosis for diabetes - In praise of the new knighthood - You hear: maría te hace ensalada. you say: maría te la hace. - Alpha cell deep cycle battery - Jessica ho hong kong - Autopsy frankie lymon dead body - Energy bar market segmentation - Rebekah age when she married isaac - Gcu effective communication - Cultural heritage management plan tool - The reading tutor program - Cert 3 individual support aged care - Service facility design and layoutdata mining goals and objectives - The balance in the supplies account before adjustment - Ppt - Lewis dot structure formal charge - Security architecture 10 - Visual analysis essay pictures - How to find the sample size in a histogram - Naseer halal meat coventry - Melbourne fringe vcr fest - Sap tdms installation guide - Experiment wise error rate - Punctuation and grammar - Cp3 - Final exams - Dehydration of 2 butanol lab report - Chapter 18 renewable energy test answers - Budgeted cost of goods sold formula - Conjugate base of nitroethane - Myumuc - Ikea invades america - The artichoke version of the self - Jg pears market harborough - Coke bottle and mentos rocket - Aim of the report - Article summary - Ns-final-p - Shell oil in nigeria case study answers - Baudrillard desert of the real - Colleges prepare for life freeman hrabowski - Homemade european wasp bait - Ada student disability insurance - Economics-Microecon theory: Give two examples of insurance that you would or would not consider buying right now. Explain - Characteristics of moses in animal farm - A researcher wishes to estimate with 99 confidence - Http www learner org courses envsci interactives carbon - 500 words in APA format, with reference article on Exploring Social Media in Health Care: Beyond Its Pervasiveness - Pine ridge medical - Harley points wiring diagram - Mod 12 synchronous counter using d flip flop - Esri software authorization wizard - Research paper Medical Terminology - I heart ny more than ever - Sandia medical devices case study answers - The arlington reader themes for writers pdf - As nzs 4836 2011 pdf - Technopoly - Lasik eye surgery spokane wa - Was the scarlet pimpernel a real person - Event management policy template - Fraud detection using r language - Campsite wilsons promontory national park - System Architecture & Authentication System - Deans gym murrysville pa - Tim bicycle shop sells 21 speed bicycles - Basic concepts of nuclear physics - Justin lorrimer net worth - Certificate iii in bicycle workshop operations melbourne - Factors to consider when developing an website - Mole richardson 20k led - Activity series review worksheet answers - Why is the capability to relocate processes desirable - Wyong shire council v shirt - Combining like terms and distributive property worksheet - Trade terms quiz module 7 - Apple Co - Gung ho movie questions and answers - Bay of pigs cuba map - Nutrition Discussion - Personality inventories are designed to assess several ________ at once - Websphere 9.0 end of support - Hub managers org uk - Big Data and Internet of Things - Excel 2019 in practice ch 2 independent project 2 5 - Champneys foot spa products - Mgmt - Is melting zinc a physical or chemical change - Cryptocurrencies - 1100 words advanced health IT system in health informatics. - Nova cloud lab worksheet answers - Us history essay - Performed services for patients who had dental plan - Contemporary dance class lesson plan