(n) Using the SUMIFS function, write a formula in cell F64 to compute Small & Spot servers' average total cost. Copy the formula down to cells F65 to F69. (0) Using the COUNTIFS function, write formula in cell G64 to compute the total number of Small & Spot servers rented. Copy the formula down to cells G65 to G69. (p) Using the SUMIFS function, write a formula in cell H64 to compute the total number of hours for which Small & Spot servers are rented. Copy the formula down to cells H65 to H69. (q) In cell 164, write a formula to compute the Average Hourly Rate for the Spot and Small servers. Average hourly rate= (Total Cost)/(Total Number of hours). Copy the formula down to cells Server Type Spot Spot Spot On-Demand On-Demand On-Demand Table 12 Statistics on the basis of Server Type and Server Size Total Cost Number of Servers Server Size Small Medium Large Small Medium Large Total Number Average hourly rate
(n) Using the SUMIFS function, write a formula in cell F64 to compute Small & Spot servers' average total cost. Copy the formula down to cells F65 to F69. (0) Using the COUNTIFS function, write formula in cell G64 to compute the total number of Small & Spot servers rented. Copy the formula down to cells G65 to G69. (p) Using the SUMIFS function, write a formula in cell H64 to compute the total number of hours for which Small & Spot servers are rented. Copy the formula down to cells H65 to H69. (q) In cell 164, write a formula to compute the Average Hourly Rate for the Spot and Small servers. Average hourly rate= (Total Cost)/(Total Number of hours). Copy the formula down to cells Server Type Spot Spot Spot On-Demand On-Demand On-Demand Table 12 Statistics on the basis of Server Type and Server Size Total Cost Number of Servers Server Size Small Medium Large Small Medium Large Total Number Average hourly rate
Chapter10: Application Development
Section: Chapter Questions
Problem 9VE
Related questions
Question
(n) Using the SUMIFS function, write a formula in cell F64 to compute Small & Spot servers' average total cost. Copy the formula down to cells F65 to F69.
(o) Using the COUNTIFS function, write a formula in cell G64 to compute the total number of Small & Spot servers rented. Copy the formula down to cells G65 to G69.
Screen
shots
attached below
thank
you!!
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 5 images
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.Recommended textbooks for you
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning