Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Set the font size into Century Gothic, 11, Regular Change column width to fit contents Center-align all column headings Set the font size of all column headings into Century Gothic, 12, B Insert 3 columns before column A and type the following:

Set the font size into Century Gothic, 11, Regular Change column width to fit contents Center-align all column headings Set the font size of all column headings into Century Gothic, 12, B Insert 3 columns before column A and type the following:

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Hi does anyone here knows how excel works? thank you!

1. Open a new excel workbook. 2. Type the following data to the corresponding cell address: A В C E F 1 Product Selling Price Product Freight Cost 2 Tax and Markup Selling Price Cost Tariff 3 23.50 5.25 2.35 4 19.00 3.40 1.9 5 22.35 1.25 2.235 6. 24.15 2.10 2.415 7 18.25 3.30 1.825 3. Set the font size into Century Gothic, 11, Regular 4. Change column width to fit contents 5. Center-align all column headings 6. Set the font size of all column headings into Century Gothic, 12, Boldface 7. Insert 3 columns before column A and type the following: Line Item Product Name Date of Last Purchase Bath Soap Lotion (Sachet) Detergent Bar Shampoo (Sachet) Dishwashing Paste 04/15/2008 05/10/2008 05/15/2008 05/25/2008 06/09/2008 1 8. Fill the Line Item column with a number series starting at 1. Use the Fill Series 9. Move the content of cell C2 to A2. 10. Set the font size of the main heading into Century Gothic, 14, Boldface 11. Merge cells across A1 to H1. 12. Compute for the markup at 5% based on the sum of Product Cost, Freight Cost, and Tax and Tariff. 13. Compute for the Selling Price. (Formula: get the sum of columns D to G) 14. Change date format (date of last purchase) to this format: April 15, 2007
Transcribed Image Text:1. Open a new excel workbook. 2. Type the following data to the corresponding cell address: A В C E F 1 Product Selling Price Product Freight Cost 2 Tax and Markup Selling Price Cost Tariff 3 23.50 5.25 2.35 4 19.00 3.40 1.9 5 22.35 1.25 2.235 6. 24.15 2.10 2.415 7 18.25 3.30 1.825 3. Set the font size into Century Gothic, 11, Regular 4. Change column width to fit contents 5. Center-align all column headings 6. Set the font size of all column headings into Century Gothic, 12, Boldface 7. Insert 3 columns before column A and type the following: Line Item Product Name Date of Last Purchase Bath Soap Lotion (Sachet) Detergent Bar Shampoo (Sachet) Dishwashing Paste 04/15/2008 05/10/2008 05/15/2008 05/25/2008 06/09/2008 1 8. Fill the Line Item column with a number series starting at 1. Use the Fill Series 9. Move the content of cell C2 to A2. 10. Set the font size of the main heading into Century Gothic, 14, Boldface 11. Merge cells across A1 to H1. 12. Compute for the markup at 5% based on the sum of Product Cost, Freight Cost, and Tax and Tariff. 13. Compute for the Selling Price. (Formula: get the sum of columns D to G) 14. Change date format (date of last purchase) to this format: April 15, 2007
15. Set decimal places to 2. (Markup and Selling Price only) 16. Move the contents of cell A1 to H8, to cell B5 to I12 17. Copy contents of cell B5 to I12 and paste in cell B15 to I22 18. Change the name of the worksheet to "Selling Price" 19. Delete any unnecessary worksheets (Sheet 2 and Sheet3)
Transcribed Image Text:15. Set decimal places to 2. (Markup and Selling Price only) 16. Move the contents of cell A1 to H8, to cell B5 to I12 17. Copy contents of cell B5 to I12 and paste in cell B15 to I22 18. Change the name of the worksheet to "Selling Price" 19. Delete any unnecessary worksheets (Sheet 2 and Sheet3)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 18 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS