Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To successfully complete this lab assignment, perform the following tasks: Premise: You have decided to sign up for a new internet service provider (ISP).
To successfully complete this lab assignment, perform the following tasks: Premise: You have decided to sign up for a new internet service provider (ISP). You would like to maximize services while keeping costs low. You create an Excell worksheet to compare costs. Perform the following tasks: Note: To complete this assignment, you will be required to create a new Excell workbook. Save your new Excell workbook using this file naming scheme: Week-3_your student ID#_your first name_ your last name (Example: Week-3_0123456_Jon_Doe). Part 1: For each ISP listed in the table below, find the best basic & premium service packages. Using the cost figures from the table below, calculate the cost per month for each service for 12 months. Include totals, minimum, maximum, and average values. Use the concepts and techniques presented in this and previous modules to create and format your worksheet to contain: 1. Proper title, subtitle, and headings; 2. Pertinent information about the three ISPs; 3. Correct formulas and proper cell references--accurately determine the total costs, minimum costs, maximum costs, and average values Part 2: You made several decisions while creating your worksheet in this assignment: how to display the data, how to format the worksheet, and which formulas to use. What was the rationale behind each of these decisions? Post your reply in a blank cell of your worksheet. Explain why you made your decisions in creating your worksheet, such as: 1. How to display the data 2. How to format the worksheet 3. Which formulas did you use? Internet service provider packages Basic Package Premium Package Monthly Monthly Week 3 | Apply Your Knowledge | Lab ISP 1 $49.99 $99.99 ISP 2 $46.97 $87.95 ISP 3 $62.35 $105.92 Criteria Ratings Pts Determine the workbook structure. The worksheet should be organized in a manner that is readable and makes sense. 10 to >0.0 pts Full Marks O pts No 10 pts Marks Create the worksheet. The worksheet contains proper title, subtitle, and headings. The worksheet contains information about three ISPs. Formulas are correct and reference proper cells, and accurately determine the total cost for 12 months, minimum costs, maximum costs, and average values Format the worksheet. The worksheet title and subtitle are formatted appropriately (the title may be slightly larger than the subtitle) Column headings are formatted so that they stand out. Numbers are formatted appropriately as currency style or comma style Text is formatted so that it is readable and fits in with other worksheet contents Critical Thinking | Rationale This assignment requires students to explain why they made these decisions in creating their worksheet: How to display the data, how to format the worksheet, and which formulas to use. Responses should be grammatically correct with little to no spelling errors. The response should he original it in lengthy lanprox 1 colid paragraph) that roerende 15 to >0.0 pts Full Marks Opts No Marks 15 pts 15 to >0.0 pts Full Marks O pts No Marks 15 pts 10 to >0.0 pts Full Marks O pts No Marks 10 pts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started