Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
43 You would like to present the server usage statistics to help create a server renting strategy for the future. 14 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size. 45 (k) Using the AVERAGEIF function, write a formula in cell E52 to compute Small servers' average total cost. Copy the formula across to cells F52 and G52 to compute for Medium & Large servers, respectively. 46 (1) Using the COUNTIF function, write a formula in cell ES3 to calculate the total number of Small servers rented. Copy the formula across to cells F53 and G53 to compute for Medium & Large servers, respective 47 (m) Using the SUMIF function, write a formula in cell E54 to calculate the total number of Small servers rented. Copy the formula across to cells F54 and G54 to compute for Medium & Large servers, respectivel 48 19 50 51 52 53 Table 11 Statistics on the basis of Server Size Small Medium Average Total Cost Number of Servers Total Number of hours Rented Instructions Q1 Q2 Q3 54 55 56 (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. 57 (0) 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. 58 (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: 59 (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 165 to 169. 60 Q3-SampleAnswer Large + E

43 You would like to present the server usage statistics to help create a server renting strategy for the future. 14 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size. 45 (k) Using the AVERAGEIF function, write a formula in cell E52 to compute Small servers' average total cost. Copy the formula across to cells F52 and G52 to compute for Medium & Large servers, respectively. 46 (1) Using the COUNTIF function, write a formula in cell ES3 to calculate the total number of Small servers rented. Copy the formula across to cells F53 and G53 to compute for Medium & Large servers, respective 47 (m) Using the SUMIF function, write a formula in cell E54 to calculate the total number of Small servers rented. Copy the formula across to cells F54 and G54 to compute for Medium & Large servers, respectivel 48 19 50 51 52 53 Table 11 Statistics on the basis of Server Size Small Medium Average Total Cost Number of Servers Total Number of hours Rented Instructions Q1 Q2 Q3 54 55 56 (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. 57 (0) 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. 58 (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: 59 (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 165 to 169. 60 Q3-SampleAnswer Large + E

Database System Concepts
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
icon
Related questions
Question
43 You would like to present the server usage statistics to help create a server renting strategy for the future. 44 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size. 45 (k) Using the AVERAGEIF function, write a formula in cell E52 to compute Small servers' average total cost. Copy the formula across to cells F52 and G52 to compute for Medium & Large servers, respectively. 46 (1) Using the COUNTIF function, write a formula in cell E53 to calculate the total number of Small servers rented. Copy the formula across to cells F53 and G53 to compute for Medium & Large servers, respectively 47 (m) Using the SUMIF function, write a formula in cell E54 to calculate the total number of Small servers rented. Copy the formula across to cells F54 and G54 to compute for Medium & Large servers, respectively. 48 49 50 51 52 53 Table 11 Statistics on the basis of Server Size Small Medium Tand Average Total Cost Number of Servers Total Number of hours Rented 54 55 56 (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. 57 (0) 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. Instructions 58 (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: 59 (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 165 to 169. 60 Large 01 02 03 Q3-SampleAnswer 2:20 PM
Transcribed Image Text:43 You would like to present the server usage statistics to help create a server renting strategy for the future. 44 Table 11 has the statistics based on server Size, and Table 12 has Statistics based on Server Type and Server Size. 45 (k) Using the AVERAGEIF function, write a formula in cell E52 to compute Small servers' average total cost. Copy the formula across to cells F52 and G52 to compute for Medium & Large servers, respectively. 46 (1) Using the COUNTIF function, write a formula in cell E53 to calculate the total number of Small servers rented. Copy the formula across to cells F53 and G53 to compute for Medium & Large servers, respectively 47 (m) Using the SUMIF function, write a formula in cell E54 to calculate the total number of Small servers rented. Copy the formula across to cells F54 and G54 to compute for Medium & Large servers, respectively. 48 49 50 51 52 53 Table 11 Statistics on the basis of Server Size Small Medium Tand Average Total Cost Number of Servers Total Number of hours Rented 54 55 56 (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. 57 (0) 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. Instructions 58 (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: 59 (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 165 to 169. 60 Large 01 02 03 Q3-SampleAnswer 2:20 PM
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Payback period
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS