Answered step by step
Verified Expert Solution
Link Copied!

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).

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Analysis

Authors: Richard L. Burden, J. Douglas Faires

9th edition

538733519, 978-1133169338, 1133169333, 978-0538733519

More Books

Students also viewed these Mathematics questions

Question

Define self-discipline and cite its benefits.

Answered: 1 week ago