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?
We can handle this paper for you
We Guarantee ZERO Plagiarism ZERO AI
Done by Professional writers from scratch

Leave a Reply