Question: Please help me create these formulas. 9 A B C D E F G H J K L M RSR Computer Services Operator Summary Help

Please help me create these formulas.

9 A B C D E F G H J K L M RSR Computer Services Operator Summary Help Desk Status Report D Calls Total TimeAvg Time 1 4 Operators 1 2 3 4 5 Last Name Santini Rubin Listowel Benton Number of Active calls: 3 6 First Name Hector Jane Terri Jamie Number of Closed calls: 7 Date No. Priorityype of CaJperator IC File No. Last Name First Name Time Spent Status 3/1/2021 14401 1 Hardware 1 14401-1-1 2.25 hrs Closed 3/2/2021144021 Password 2 14402-1-2 0.25 hrs Closed 313/2021 14403 1 0S 2 14403-1-2 0.50 hrs Closed 3/3/2021 14404 > 2 Email 1 14404-2-1 1.25 hrs Closed 3/5/2021 14405 1 Password 3 14405-1-3 0.25 hrs Closed 3/5/2021 14406 > 2 Hardware 4 14406-2-4 1.75 hrs Active 3/5/2021 14407 > 2 Email 4 14407-2-4 1.00 hrs Closed 318/2021 14408 T 3 Internet 4 14408-3-4 0.50 hrs Closed 319/2021 14409 3 Internet 2 14409-3-2 0.50 hrs Closed 3/10/2021 14410 1 Hardware 2 14410-1-2 3.25 hrs Closed 3/12/2021 14411 T 3 Email 1 14411-3-1 1.00 hrs Closed 3/12/2021 14412 3 Email 1 14412-3-1 0.50 hrs Closed 3/15/2021 14413 2 Internet 3 14413-2-3 0.75 hrs Closed 3/15/2021 1 4414 > 2 Internet 314414-2-3 1.25 hrs Closed 3/16/2021 14415 T 3 Password 2 14415-3-2 0.50 hrs Closed 23 3/17/2021 144162 Email 2 14416-2-2 0.75 hrs Active 24 3/18/2021144171 Email 1 14417-1-1 125 hrs Active 3122/2021 14418 1 Hardware 1 14418-1-1 2 25 hrs Active 312312021 14419 T 3 OS 4 14419-3-4 1.75 hrs Active 3/26/2021 14420 2 Hardware 3 14420-2-3 1.25 hrs Closed 28 3/26/2021 144211 OS 1 14421-1-1 2.25 hrs Closed 3/29/2021 14422 T 3 Internet 2 14422-3-2 0.75 hrs Active 3/30/2021 14423 1 Hardware 4 14423-1-4 1.00 hrs Active 29 30 4. In cells 15 and 16, create COUNTIF formulas to count the number of active calls (15) and the number of closed calls (16). Use range names in the formulas. 5. Create COUNTIF formulas in cells K3 through K6 to count the calls assigned to operator IDs 1, 2, 3, and 4, respectively. Use range names in the formulas 6. Create SUMIF formulas in cells L3 through L6 to calculate the total time spent on calls assigned to operator IDs 1, 2, 3, and 4, respectively. Use range names in the formulas. Format the results to display two digits after the decimal point

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need help with the formulas for this. It keeps saying to use absolutes to copy and paste but I dont understand how that will work I am also having trouble with the vlookup and hlookup. I just need...

please how can find Fraction of year? AutoSave O Off ACC2202 W21 Excel Assignment 2 Student File Final - Excel Search A Maya M X File Home Insert Page Layout Formulas Data Review View Help Share...

please comment so I can share you the link to excel file EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap...

Need to prepare budget report in excel workbook whose images i have provided if you need workbook please share your email id. Where i can share workbook. MGMT 8500: BUDGET ASSlGNMENT- W21...

For this project you will account for a factorys costs for one month in a job costing system There are four tabs on the file: Overhead Budget Job Cost Sheets Actual Overhead Costs Questions to Answer...

EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your...

All these are in proper sequence. please solve it. I Cannot increase the Font Size more, So can you please manage to answer. Please see below for your group project variables. A B C D E F G H 1 K L M...

Please give interpretation of ROA and ROE for the above data urgently. 5.. finalbrm 1 v1 - Excel Kavya Gupta KG Ga File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what...

This is an accounting project. Could you please verify and tell me if I'm missing any data entry for the Journal entry and the ledgers? Everything else looks acceptable to me. _._, ______________...

ABC Company makes steel tool cabinets for offices. They are in the process of preparing a Master Budget including the Operating budget, Cash Statement, Income Statement and Balance Sheet for 2020....

How does the inverse operation interact with scalar multiplication and addition of matrices? (a) What is the inverse of rH? (b) Is (H + G)-1 = H-1 + G-1?

How might cultural, political, or geo-economics challenges affect a global companys use of the Internet? Give several examples.

An employee can indicate whether they want an additional amount withheld for payroll taxes on the Form W - 4 . Question 2 Select one: True False

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...