Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Analysis of this worksheet in 250 words! What insights do you have about the data presented in the spreadsheet? Are there any anomalies or interesting

image text in transcribedAnalysis of this worksheet in 250 words!

  • What insights do you have about the data presented in the spreadsheet? Are there any anomalies or interesting facts you see?
  • What kinds of decisions can you make from the data, or what recommendations can you make to improve the business, process, etc. that is presented in the spreadsheet?
  • What can be changed to improve the worksheet? Why would your recommendation be an improvement?

image text in transcribed

AutoSave OFF A A G Cuv... RSRHelpDesk Home Insert Draw Page Layout Formulas Data Review View Tell me Details 09 Updates Not Installed Some updates could not be installed automatically fx Define Name fox Update ? A AutoSum Recently Financial Logical Text Used ev Date & Lookup & Math & Time Reference Trig Es, Trace Precedents Trace Dependents 16 Show Error Watch FRemove Arrows Formulas Checking Window Insert Function More Functions Create from Selection Calculation calculate Sheet Options Check for Updates > Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A4 x fc Operators A B D E G H 1 K L M N o O R s T U V w Operator Summary 1 RSR Computer Services Help Desk Status Report 2 Calls Total Time Avg Time ID 1 2 . 3 Santini Hector 2 Rubin Jane 3 Listowel Terri 4 Number of Active calls: Number of Closed calls: Last Name First Name #NAME Time Spent 2.25 0.25 0.5 1.25 3 4 Operators 5 Last Name 6 First Name 7 Date 8 3/1/21 9 3/2/21 10 3/3/21 11 3/3/21 12 3/5/21 13 3/5/21 14 3/5/21 15 3/8/21 16 3/9/21 17 3/10/21 18 3/12/21 19 3/12/21 20 3/15/21 21 3/15/21 22 3/16/21 23 3/17/21 24 3/18/21 25 3/22/21 26 3/23/21 27 3/26/21 28 3/26/21 29 3/29/21 30 3/30/21 31 32 33 34 35 36 37 38 39 40 Ticket No. 14401 14402 14403 14404 14405 14406 14407 14408 14409 14410 14411 14412 14413 14414 14415 14416 14417 14418 14419 14420 14421 14422 14423 Priority Type of Call 1 Hardware 1 Password 1 OS 2 Email 1 Password 2 Hardware 2 Email 3 Internet 3 Internet 1 Hardware 3 Email 3 Email 2 Internet 2 Internet 3 Password 2 Email 1 Email 1 Hardware 3 OS 2 Hardware 1 OS 3 Internet 1 Hardware 4 Benton Jamie Operator ID File No. 1 14401-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 2 14410-1-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 1 14418-1-1 4 14419-3-4 3 14420-2-3 1 14421-1-1 2 14422-3-2 4 14423-1-4 0.25 1.75 1 0.5 0.5 3.25 1 0.5 0.75 1.25 0.5 0.75 1.25 Status Closed Closed Closed Closed Closed Active Closed Closed Closed Closed Closed Closed Closed Closed Closed Active Active Active Active Closed Closed Active Active 2.25 1.75 1.25 2.25 0.75 1 11 Status Report + Edit Average: 2.5 Count: 15 Sum: 10 + 100% AB27 x fx A D E G H 1 L M N o P Q R 1 Operator Summary RSR Computer Services Help Desk Status Report 2 ID Calls Total Time Avg Time 1 2 1 Santini Hector 3 4 Number of Active calls: Number of Closed calls: Last Name First Name #NAME? 3 4 Operators 5 Last Name 6 First Name 7 Date 8 3/1/21 9 3/2/21 10 3/3/21 11 3/3/21 12 3/5/21 13 3/5/21 14 3/5/21 15 3/8/21 16 3/9/21 17 3/10/21 18 3/12/21 19 3/12/21 20 3/15/21 21 3/15/21 22 3/16/21 23 3/17/21 24 3/18/21 25 3/22/21 26 3/23/21 27 3/26/21 28 3/26/21 29 3/29/21 30 3/30/21 31 32 33 34 35 36 37 2 3 Rubin Listowel Jane Terri Priority Type of Call 1 Hardware 1 Password 1 OS 2 Email 1 Password 2 Hardware 2 Email 3 Internet 3 Internet 1 Hardware 3 Email 3 Email 2 Internet 2 Internet 3 Password 2 Email 1 Email 1 Hardware 3 OS 2 Hardware 1 OS 3 Internet 1 Hardware Ticket No. 14401 14402 14403 14404 14405 14406 14407 14408 14409 14410 14411 14412 14413 14414 14415 14416 14417 14418 14419 14420 14421 14422 14423 Status Closed Closed Closed Closed Closed Active Closed Closed Closed Closed Closed Benton Jamie Operator ID File No. 1 14401-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 2 14410-1-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 1 14418-1-1 4 14419-3-4 3 14420-2-3 1 14421-1-1 2 14422-3-2 4 14423-1-4 Closed Time Spent 2.25 0.25 0.5 1.25 0.25 1.75 1 0.5 0.5 3.25 1 0.5 0.75 1.25 0.5 0.75 1.25 2.25 1.75 1.25 2.25 0.75 1 Closed Closed Closed Active Active Active Active Closed Closed Active Active 38 39 40 11 Status Report + Ready AutoSave OFF A A G Cuv... RSRHelpDesk Home Insert Draw Page Layout Formulas Data Review View Tell me Details 09 Updates Not Installed Some updates could not be installed automatically fx Define Name fox Update ? A AutoSum Recently Financial Logical Text Used ev Date & Lookup & Math & Time Reference Trig Es, Trace Precedents Trace Dependents 16 Show Error Watch FRemove Arrows Formulas Checking Window Insert Function More Functions Create from Selection Calculation calculate Sheet Options Check for Updates > Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A4 x fc Operators A B D E G H 1 K L M N o O R s T U V w Operator Summary 1 RSR Computer Services Help Desk Status Report 2 Calls Total Time Avg Time ID 1 2 . 3 Santini Hector 2 Rubin Jane 3 Listowel Terri 4 Number of Active calls: Number of Closed calls: Last Name First Name #NAME Time Spent 2.25 0.25 0.5 1.25 3 4 Operators 5 Last Name 6 First Name 7 Date 8 3/1/21 9 3/2/21 10 3/3/21 11 3/3/21 12 3/5/21 13 3/5/21 14 3/5/21 15 3/8/21 16 3/9/21 17 3/10/21 18 3/12/21 19 3/12/21 20 3/15/21 21 3/15/21 22 3/16/21 23 3/17/21 24 3/18/21 25 3/22/21 26 3/23/21 27 3/26/21 28 3/26/21 29 3/29/21 30 3/30/21 31 32 33 34 35 36 37 38 39 40 Ticket No. 14401 14402 14403 14404 14405 14406 14407 14408 14409 14410 14411 14412 14413 14414 14415 14416 14417 14418 14419 14420 14421 14422 14423 Priority Type of Call 1 Hardware 1 Password 1 OS 2 Email 1 Password 2 Hardware 2 Email 3 Internet 3 Internet 1 Hardware 3 Email 3 Email 2 Internet 2 Internet 3 Password 2 Email 1 Email 1 Hardware 3 OS 2 Hardware 1 OS 3 Internet 1 Hardware 4 Benton Jamie Operator ID File No. 1 14401-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 2 14410-1-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 1 14418-1-1 4 14419-3-4 3 14420-2-3 1 14421-1-1 2 14422-3-2 4 14423-1-4 0.25 1.75 1 0.5 0.5 3.25 1 0.5 0.75 1.25 0.5 0.75 1.25 Status Closed Closed Closed Closed Closed Active Closed Closed Closed Closed Closed Closed Closed Closed Closed Active Active Active Active Closed Closed Active Active 2.25 1.75 1.25 2.25 0.75 1 11 Status Report + Edit Average: 2.5 Count: 15 Sum: 10 + 100% AB27 x fx A D E G H 1 L M N o P Q R 1 Operator Summary RSR Computer Services Help Desk Status Report 2 ID Calls Total Time Avg Time 1 2 1 Santini Hector 3 4 Number of Active calls: Number of Closed calls: Last Name First Name #NAME? 3 4 Operators 5 Last Name 6 First Name 7 Date 8 3/1/21 9 3/2/21 10 3/3/21 11 3/3/21 12 3/5/21 13 3/5/21 14 3/5/21 15 3/8/21 16 3/9/21 17 3/10/21 18 3/12/21 19 3/12/21 20 3/15/21 21 3/15/21 22 3/16/21 23 3/17/21 24 3/18/21 25 3/22/21 26 3/23/21 27 3/26/21 28 3/26/21 29 3/29/21 30 3/30/21 31 32 33 34 35 36 37 2 3 Rubin Listowel Jane Terri Priority Type of Call 1 Hardware 1 Password 1 OS 2 Email 1 Password 2 Hardware 2 Email 3 Internet 3 Internet 1 Hardware 3 Email 3 Email 2 Internet 2 Internet 3 Password 2 Email 1 Email 1 Hardware 3 OS 2 Hardware 1 OS 3 Internet 1 Hardware Ticket No. 14401 14402 14403 14404 14405 14406 14407 14408 14409 14410 14411 14412 14413 14414 14415 14416 14417 14418 14419 14420 14421 14422 14423 Status Closed Closed Closed Closed Closed Active Closed Closed Closed Closed Closed Benton Jamie Operator ID File No. 1 14401-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 2 14410-1-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 1 14418-1-1 4 14419-3-4 3 14420-2-3 1 14421-1-1 2 14422-3-2 4 14423-1-4 Closed Time Spent 2.25 0.25 0.5 1.25 0.25 1.75 1 0.5 0.5 3.25 1 0.5 0.75 1.25 0.5 0.75 1.25 2.25 1.75 1.25 2.25 0.75 1 Closed Closed Closed Active Active Active Active Closed Closed Active Active 38 39 40 11 Status Report + Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

324300980, 978-0324300987

Students also viewed these Accounting questions