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?