Write a formula to find the Average Hours Rented and Average total costscreenshot is attached below thank u ABсDEFGHIJL1 2020 cyber week (during the thanksgiving period) saw a spike in e-commerce sales throughout the USA. A2Z eCommerz LLC website and app also witnessed a surge in traffic.During the cyber week, the IT team rented some temporary servers. Two types of servers were rented, (i) On-demand servers and (ii) Spot servers.Spot servers are idle servers in the cloud service provider's inventory, and they come at a discounted rate.However, you can not use spot servers for the long term because when the provider's idle server inventory reduces, some of the spot servers may be terminated.Hence, there is a termination risk in using spot servers. However, on-demand servers can't be terminated by the provider.23The servers are available in different sizes, but the firm rented only Small, Medium, and Large servers.4 Table 8 has the pricing and spot server discounts for the servers of various sizes. Table 10 has details on the servers which the firm rented.5(a) Write a formula in cell F24 to compute the # of hours the firm rented the server. The number of hours rented = (Returned Date & Time - Rented Date and Time) * 24. Copy the formula to F25 to6 (b) Using VLOOKUP, write a formula in cell G24 to find the rate per hour from Table 8 for the given server size. Copy the formula to G25 to G41.(c)r's discount rate. ForUsing IF and VLOOKUP functions, write a formula in cell H24 to find the spot server confor on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41.Len net to me ane8 (d) Write a formula in cell 124 to compute the discount amount on the server. Discount Amount = Percent Discount Rate per hour. Copy the formula to 125 to 141.9 (e) Write a formula in cell J24 to compute the rate per hour after the discount. Rate per hour after discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41.10(f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from K25 to K41.11 (g) Write a formula in cell G17 to compute the average hours Rented. Average hours rented is the average of the # of hours Rented (F24:F41).12 (h) Write a formula in cell G18 to calculate the average total cost. The average total cost is the average of the total cost (K24:K41).13 (i) Using the IF function, write a formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 to K41.14 (j) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41.15161718192021Server Size1 Small2 Medium3 LargeTable 8On-DemandInstanceHourly Rate$0.33280$0.66560$1.33120KDiscount for SpotServers20%30%40%Table 9Average HoursRentedAverage TotalCostMNO

In this question, it is asked to calculate the average number of hours and average total cost in…

(e) Write a formula in cell J24 to compute the rate per hour after the discount. Rate per hour after discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41. (f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from K25 to K41. (g) Write a formula in cell G17 to compute the average hours Rented. Average hours rented is the average of the # of hours Rented (F24:F41). (h) Write a formula in cell G18 to calculate the average total cost. The average total cost is the average of the total cost (K24:K41). (i) Using the IF function, write formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 to K41. (j) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. Server Size 1 Small 2 Medium 3 Large Table 8 On-Demand Instance Hourly Rate $0.33280 $0.66560 $1.33120 Discount for Spot Servers 20% 30% 40% Table 9 Average Hours Rented Average Total Cost

(e) Write a formula in cell J24 to compute the rate per hour after the discount. Rate per hour after discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41. (f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from K25 to K41. (g) Write a formula in cell G17 to compute the average hours Rented. Average hours rented is the average of the # of hours Rented (F24:F41). (h) Write a formula in cell G18 to calculate the average total cost. The average total cost is the average of the total cost (K24:K41). (i) Using the IF function, write formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 to K41. (j) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. Server Size 1 Small 2 Medium 3 Large Table 8 On-Demand Instance Hourly Rate $0.33280 $0.66560 $1.33120 Discount for Spot Servers 20% 30% 40% Table 9 Average Hours Rented Average Total Cost

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Below, we'll break down the differences between MonthCalendar and DateTimerPicker.
How would you create that chart up top with the destination,reg price, reduced and sales price using that same flight_sales text file?
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Excel date fields have the date to the right of the decimal point, and time to the left of the decimal point. True False
10. Using the INDEX function only, write a formula in cell H10 to find the state name having the minimum "Sum of Percentage". The formula should include the value(row number) that is calculated in G10. Thank you screenshot attached
With the frmTutorSearch form still open in Design View, use the Title button to add a title to the form. Replace the default title text with Tutor Information Form. (Hint: Do not include the period.) Save and close the frmTutorSearch
when you do following $("table") what it will select last table from the document all tables from the document first table from the document
"""Q3: Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable.Use the 'directors' series to find the average rating for Steven Spielberg. Print the value.""" Please help I keep getting series are different!!
Create a flow chart on how to solve the average of three grades.