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?
Leave a Reply