Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

someone can help me? Question Overview Compu-Global-Hyper-Mega-Net is an Internet Service Provider (ISP) for the local Springfield market. Although their service offering is poorly defined,

someone can help me?
image text in transcribed
Question Overview Compu-Global-Hyper-Mega-Net is an Internet Service Provider (ISP) for the local Springfield market. Although their service offering is poorly defined, their customer base is growing. The company's junior vice-president has hired you to complete a spreadsheet that tracks the charges for each customer. Perform the following tasks on the Internet Customers Worksheet: 1. Take a minute to review the spreadsheet so that you are familiar with it. 2. Merge and Center the contents of cell A2 across the range A2:K2 3. Use a function to add today's date in cell B3 4. Use a VLOOKUP function to determine the Basic Monthly Cost that each customer will pay. Be sure to name your Table Array with a suitable name before you use it in the function. 5. Use a second VLOOKUP function to determine the Modem Rental charge for each customer. 6. Next, you will calculate the Monthly Cost for each customer. If a customer has ordered the optional Wi-Fi Extender, then the monthly cost is the Basic Monthly Cost plus the Modem Rental plus the Wi-Fi Extender Rental cost. If a customer has not ordered the Wi-Fi Extender, then the Monthly Cost is the Basic Monthly Cost plus the Modem Rental. Use an IF Function to determine the Monthly Cost for each customer. 7. Now that you have the Monthly Cost, calculate the Annual Cost for each customer. 8. Add a total for the Annual Costs in cell G15 9. Complete the Summary Statistics section of the worksheet. 10. Format all monetary values as Accounting, with 0 decimal places

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

More Books

Students also viewed these Databases questions

Question

Prove {x1x2xtt>1,xi{a,b}, and xi,xj with i=j but xi=xj} is not

Answered: 1 week ago