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?

NEED ASSIGNMENT HELP?

We guarantee plagiarism-free and AI-free writing services. Every assignment is crafted with originality, precision, and care to meet your academic needs.

Ready to get started? Place your order directly on this post!

Let us help you achieve excellence—authentic work, every time.