Question 1: Assume that you are going to create a spreadsheet template for the monthly supply order. Use Ms Excel to create the worksheets according to the following requirements. Open a new work book. Rename Sheet1 tab to “Suppliers”. This worksheet should include three tables (one for each supplier) Consisting of the Items and Price. Rename Sheet2 tab to “Flower Stalks Gallery”. This worksheet should include Flower Types (default values: Rose, Carnation, and Statice), Blue Stalks (default values: N/A for Rose and Carnation, 0 for Statice), Pink Stalks (default values: 0 for Rose, Carnation, and Statice), Purple Stalks (default values: N/A for Rose, and 0 for Carnations and Statice), Red Stalks (default values: 0 for Rose and Carnation, and N/A for Statice), White Stalks (default values: 0 for Rose, Carnation, and Statice), and Yellow Stalks (default values: N/A for Rose, and 0 for Carnation and Statice). Rename Sheet3 tab to “Gifts Accessories Supply”. This worksheet should include Accessory Type (default values: Plastic Wraps, Basket, Ribbons, and Cards) and Package Qty (default values: 0 for Plastic Wraps, Basket, Ribbons, and Cards). Rename Sheet4 tab to “Sweet Factory”. This worksheet should include Items (default values: Chocolates, Chocolate-Chip Cookies, and Candies) and Package Qty (default values: 0 for Chocolates, Chocolate-Chip Cookies, and Candies). Column titles should be in UPPER CASE, bold and italicized. Format each column according to the right data type. Include a small logo of the gift shop designed on your own using Ms Word software on the top row of every worksheet created. Include the current date and time below the logo for every worksheet created using a specific function. Make the spreadsheet presentable. Save the spreadsheet as template.

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

Related questions

Concept explainers

Question

Question 1:

Assume that you are going to create a spreadsheet template for the monthly supply order. Use Ms Excel to create the worksheets according to the following requirements.

Open a new work book. Rename Sheet1 tab to “Suppliers”. This worksheet should include three tables (one for each supplier) Consisting of the Items and Price. Rename Sheet2 tab to “Flower Stalks Gallery”. This worksheet should include Flower Types (default values: Rose, Carnation, and Statice), Blue Stalks (default values: N/A for Rose and Carnation, 0 for Statice), Pink Stalks (default values: 0 for Rose, Carnation, and Statice), Purple Stalks (default values: N/A for Rose, and 0 for Carnations and Statice), Red Stalks (default values: 0 for Rose and Carnation, and N/A for Statice), White Stalks (default values: 0 for Rose, Carnation, and Statice), and Yellow Stalks (default values: N/A for Rose, and 0 for Carnation and Statice). Rename Sheet3 tab to “Gifts Accessories Supply”. This worksheet should include Accessory Type (default values: Plastic Wraps, Basket, Ribbons, and Cards) and Package Qty (default values: 0 for Plastic Wraps, Basket, Ribbons, and Cards). Rename Sheet4 tab to “Sweet Factory”. This worksheet should include Items (default values: Chocolates, Chocolate-Chip Cookies, and Candies) and Package Qty (default values: 0 for Chocolates, Chocolate-Chip Cookies, and Candies).
Column titles should be in UPPER CASE, bold and italicized.
Format each column according to the right data type.
Include a small logo of the gift shop designed on your own using Ms Word software on the top row of every worksheet created.
Include the current date and time below the logo for every worksheet created using a specific function.
Make the spreadsheet presentable.
Save the spreadsheet as template.

Expert Solution

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON