Answered step by step
Verified Expert Solution
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?
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
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