Problem: You are shopping for a new laptop and want to compare the prices of three laptops. You will compare laptops with similar specifications, but where the brands and/or models are different. Perform the following tasks:
Part 1: Create a worksheet that compares:
· Laptop Brand
· Laptop Model
· Screen size
· Screen Resolution
· CPU Model
· Memory RAM
· Total storage capacity
· Laptop price
· Costs to add an extended warranty
· Using the SUM function, calculate Total Cost for each laptop (price + warranty).
· Use the concepts and techniques presented in this module to calculate the average of laptop price and average cost of an extended warranty using the Average function.
· Format the spreadsheet to make it look sleek and professional
· Add a column chart to compare the different laptop costs.
Part 2: You made several decisions while creating the worksheet in this assignment: how to organize the data, how to display the text, which calculations to use, and which chart to use. What was your rationale behind each of these decisions?
Would you like to discuss this project or get it done?
Reach out on WHATSapp at +1 (240) 389-5520
Or
Place an order on our website for quick help
Guarantees
A+ Paper
Timely Delivery
Zero Plagiarism
Zero AI

Leave a Reply