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

Your email address will not be published. Required fields are marked *