(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 to F41.(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) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. ZU21222324252627282930313233343536373839A3 LargeServerIDServer SizeBMedium2 Large3 Large4 Large5 Large6 Large7 Small8 Small9 Large10 Medium11 Large12 Small13 Small14 Small15 Medium16 Largeс$1.33120Server TypeSpotSpotOn-DemandSpotSpotSpotSpotOn-DemandOn-DemandOn-DemandOn-DemandSpotSpotOn-DemandSpotOn-DemandD40%RentedDate & Time11/25/2020 2:0011/25/2020 9:0011/25/2020 17:0011/25/2020 21:0011/26/2020 9:0011/26/2020 11:0011/26/2020 16:0011/26/2020 23:0011/27/2020 1:0011/27/2020 23:0011/28/2020 1:0011/28/2020 2:0011/28/2020 3:0011/28/2020 9:0011/28/2020 11:0011/28/2020 16:00EReturnedDate & Time11/26/2020 9:0011/27/2020 1:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:0011/30/2020 13:00F# of hoursRentedTable 10GRate perhourHPercentDiscountDiscountAmountJRate per hourafter discountKTotalCostLIs number of hoursrented more thanaverage?MIs cost morethan theaveragecost?

NOTE: As per the student instruction calculate the formulas using excel sheet (a) Write a formula in…

Answered: Server ID Server Size 1 Medium 2 Large…

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

Related questions

Concept explainers

Question

(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 to F41.

(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) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41.

ZU
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A
3 Large
Server
ID
Server Size
B
Medium
2 Large
3 Large
4 Large
5 Large
6 Large
7 Small
8 Small
9 Large
10 Medium
11 Large
12 Small
13 Small
14 Small
15 Medium
16 Large
с
$1.33120
Server Type
Spot
Spot
On-Demand
Spot
Spot
Spot
Spot
On-Demand
On-Demand
On-Demand
On-Demand
Spot
Spot
On-Demand
Spot
On-Demand
D
40%
Rented
Date & Time
11/25/2020 2:00
11/25/2020 9:00
11/25/2020 17:00
11/25/2020 21:00
11/26/2020 9:00
11/26/2020 11:00
11/26/2020 16:00
11/26/2020 23:00
11/27/2020 1:00
11/27/2020 23:00
11/28/2020 1:00
11/28/2020 2:00
11/28/2020 3:00
11/28/2020 9:00
11/28/2020 11:00
11/28/2020 16:00
E
Returned
Date & Time
11/26/2020 9:00
11/27/2020 1:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
11/30/2020 13:00
F
# of hours
Rented
Table 10
G
Rate per
hour
H
Percent
Discount
Discount
Amount
J
Rate per hour
after discount
K
Total
Cost
L
Is number of hours
rented more than
average?
M
Is cost more
than the
average
cost?

Expert Solution

Step by step

Solved in 7 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions