Introduction to Information Technology-DBX-DL05
Keystone Assignment
Create a Worksheet (Excel document) Comparing Three Laptops.
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 (Excel document) 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 (Excel document).
• Include a Chart to compare the different laptop costs. Submit your assignment in the Excel format document (not in Word format or other formats).
Part 2: You made several decisions while creating the worksheet (Excel document) 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?