Weekly Assignments Content

Keystone Assignment

Create a Worksheet Comparing Laptops:

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:

Create a worksheet that compares the type, specifications, and the price for each laptop, as well as the costs to add an extended warranty. Use the concepts and techniques presented in this module to calculate the average price of a laptop and average cost of an extended warranty and to format the worksheet. Include a chart to compare the different laptop costs. Submit your assignment in Excel format $($xlsx$).$

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. Describe your rationale behind each of these decisions.