Documentation New Perspectives Excel 2019 | Module 7: End of Module Project 1 Pierce Software SUMMARIZE DATA WITH PIVOTTABLES Author:paula barajas Note: Do not edit this sheet. If your name does not...

1 answer below »
I uploaded the files, it contains the instructions and the assignment. please help!


Documentation New Perspectives Excel 2019 | Module 7: End of Module Project 1 Pierce Software SUMMARIZE DATA WITH PIVOTTABLES Author:paula barajas Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Customer Call Log Customer Call Log: January-March Customer Survey Scores Call IDDateService RepCall CodeCall TypeQuestion 1Question 2Question 3Question 4AverageRepTotal CallsAverage Score 201911/4/21Wagner74524Barry 201541/4/21Thanh12131Bruno 211701/4/21Darego175555Calder 211451/5/21Calder164535Darego 221031/5/21Shanahan214444Shanahan 222461/6/21Bruno184534Thanh 221371/7/21Thanh73333Volmann 222341/7/21Shanahan12111Wagner 232281/7/21Wagner23221Zimmerman 232151/8/21Calder84332 241171/9/21Darego255535 241401/9/21Bruno93332 252241/11/21Thanh34544 231261/12/21Volmann25545 252101/12/21Barry123221 201891/14/21Wagner211111 201261/14/21Shanahan203442 261571/15/21Bruno222322 252011/16/21Thanh164334 261491/16/21Calder195455 232231/16/21Calder35555 242411/16/21Bruno174332 241521/17/21Thanh185445 241961/17/21Volmann164335 262421/17/21Darego44224 271431/17/21Volmann44333 201551/18/21Barry155535 211711/18/21Thanh52332 222271/18/21Shanahan221221 201771/20/21Bruno183333 271961/20/21Zimmerman154434 222131/20/21Volmann235544 252001/21/21Barry164455 281441/22/21Calder65324 281471/22/21Zimmerman34455 292151/23/21Thanh173444 261281/23/21Bruno54555 291361/24/21Darego164444 291821/25/21Zimmerman173223 241261/26/21Bruno202132 271471/27/21Barry105455 281171/28/21Volmann114455 211781/28/21Thanh164333 262421/29/21Calder53223 301191/29/21Thanh251111 301941/29/21Barry215345 212231/30/21Zimmerman135535 241321/30/21Shanahan83555 301711/31/21Barry144444 231611/31/21Thanh204334 231622/4/21Barry71244 231632/4/21Calder13433 231702/4/21Zimmerman24511 241652/5/21Thanh85355 241662/5/21Bruno254455 241672/6/21Darego95343 241682/7/21Zimmerman34244 241692/7/21Bruno23344 241702/7/21Barry124531 241712/8/21Calder214323 241722/9/21Darego203234 241732/9/21Bruno222344 241742/12/21Thanh165454 251752/12/21Volmann194534 251762/12/21Barry34433 251772/14/21Wagner173323 251782/14/21Shanahan181412 251792/15/21Bruno165444 251802/15/21Thanh45535 261812/16/21Thanh54453 261822/16/21Darego164242 261832/17/21Calder174533 261842/17/21Shanahan203444 261852/17/21Bruno102335 261862/17/21Thanh113414 261872/17/21Darego164453 261882/18/21Zimmerman55554 261892/18/21Bruno253444 271902/18/21Barry214245 271912/20/21Volmann135144 271922/20/21Thanh83442 271932/20/21Calder141445 271942/21/21Thanh203344 281952/21/21Barry215234 281962/22/21Zimmerman204122 281972/23/21Shanahan225324 281982/23/21Barry164545 281992/24/21Thanh193333 282002/25/21Barry34242 292012/26/21Calder174343 292022/26/21Zimmerman183434 292032/28/21Shanahan162525 292042/28/21Barry43434 292053/4/21Thanh42323 292063/4/21Barry153434 292073/4/21Calder54444 292083/5/21Zimmerman185545 292093/5/21Thanh163444 292103/6/21Bruno44232 292113/6/21Darego55525 302123/7/21Zimmerman163533 302133/7/21Bruno172442 302143/8/21Barry205255 302153/9/21Thanh104134 302163/9/21Shanahan114444 302173/10/21Bruno163453 312183/12/21Zimmerman51331 312193/12/21Volmann255215 312203/13/21Barry35132 312213/14/21Calder174352 312223/15/21Zimmerman184241 312313/16/21Wagner164354 312243/16/21Bruno43543 322253/16/21Darego42335 322263/16/21Zimmerman153254 322273/17/21Bruno54333 322283/17/21Wagner225444 323213/18/21Volmann183533 323223/18/21Thanh154431 323233/18/21Calder235315 333343/20/21Wagner163425 333353/20/21Barry61434 333363/20/21Zimmerman33534 333373/23/21Shanahan175434 333383/22/21Barry54244 333393/22/21Thanh165544 332403/23/21Bruno81253 332413/23/21Darego145332 332423/24/21Zimmerman205443 332433/25/21Thanh214554 332443/26/21Darego204335 342453/27/21Calder224413 342463/28/21Shanahan163534 342473/28/21Bruno192354 342483/29/21Thanh33143 342493/29/21Darego44352 342503/29/21Thanh105513 342513/30/21Barry123455 342523/30/21Zimmerman202233 Call Type by Rep Call Types by Service Rep Scores by Date Average Monthly Scores Survey Questions Call Type Lookup Table Call Code06111621 Call TypeBug reportFeature requestHow toTech problemCancellation Customer Survey Scores 5Very satisfied 4Satisfied 3Neutral 2Dissatisfied 1Very dissatisfied Customer Survey Questions How satisfied are you with: Question 1The service rep's product knowledge Question 2How much time it took to reach a service rep Question 3The overall process of contacting Pierce Software Question 4How the service rep handled your call
instructionsnpex19eom7-1-ed3ulled.docx npex19eom7-1paulabarajas1-jjed515x.xlsx
Answered Same DayApr 13, 2021

Answer To: Documentation New Perspectives Excel 2019 | Module 7: End of Module Project 1 Pierce Software...

Ali Asgar answered on Apr 14 2021
130 Votes
Documentation
        New Perspectives Excel 2019 | Module 7: End of Module Project 1
        Pierce Software
        SUMMARIZE DATA WITH PIVOTTABLES
    Author:    paula barajas
    Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Customer Call Log
    Customer Call Log: January-March
                        Customer Survey Scores
    Call ID    Date    Service Rep    Call Code    Call Type    Question 1    Question 2    Question 3    Question 4    Average        Rep    Total Calls    Average Score
    20191    1/4/21    Wagner    7    Feature request    4    5    2    4    3.75        Barry    20    3.80
    20154    1/4/21    Thanh    1    Bug report    2    1    3    1    1.75        Bruno    20    3.00
    21170    1/4/21    Darego    17    Tech problem    5    5    5    5    5.00        Calder    15    3.93
    21145    1/5/21    Calder    16    Tech problem    4    5    3    5    4.25        Darego    13    4.15
    22103    1/5/21    Shanahan    21    Cancellation    4    4    4    4    4.00        Shanahan    12    3.00
    22246    1/6/21    Bruno    12    How to    4    5    3    4    4.00        Thanh    26    3.58
    22137    1/7/21    Thanh    7    Feature request    3    3    3    3    3.00        Volmann    9    4.33
    22234    1/7/21    Shanahan    1    Bug report    2    1    1    1    1.25        Wagner    7    3.29
    23228    1/7/21    Wagner    2    Bug report    3    2    2    1    2.00        Zimmerman    17    3.65
    23215    1/8/21    Calder    8    Feature request    4    3    3    2    3.00
    24117    1/9/21    Darego    25    Cancellation    5    5    3    5    4.50
    24140    1/9/21    Bruno    9    Feature request    3    3    3    2    2.75
    25224    1/11/21    Thanh    3    Bug report    4    5    4    4    4.25
    23126    1/12/21    Volmann    2    Bug report    5    5    4    5    4.75
    25210    1/12/21    Barry    12    How to    3    2    2    1    2.00
    20189    1/14/21    Wagner    21    Cancellation    1    1    1    1    1.00
    20126    1/14/21    Shanahan    20    Tech problem    3    4    4    2    3.25
    26157    1/15/21    Bruno    22    Cancellation    2    3    2    2    2.25
    25201    1/16/21    Thanh    16    Tech problem    4    3    3    4    3.50
    26149    1/16/21    Calder    19    Tech problem    5    4    5    5    4.75
    23223    1/16/21    Calder    3    Bug report    5    5    5    5    5.00
    24241    1/16/21    Bruno    17    Tech problem    4    3    3    2    3.00
    24152    1/17/21    Thanh    18    Tech problem    5    4    4    5    4.50
    24196    1/17/21    Volmann    16    Tech problem    4    3    3    5    3.75
    26242    1/17/21    Darego    4    Bug report    4    2    2    4    3.00
    27143    1/17/21    Volmann    4    Bug report    4    3    3    3    3.25
    20155    1/18/21    Barry    15    How to    5    5    3    5    4.50
    21171    1/18/21    Thanh    5    Bug report    2    3    3    2    2.50
    22227    1/18/21    Shanahan    22    Cancellation    1    2    2    1    1.50
    20177    1/20/21    Bruno    18    Tech problem    3    3    3    3    3.00
    27196    1/20/21    Zimmerman    15    How to    4    4    3    4    3.75
    22213    1/20/21    Volmann    23    Cancellation    5    5    4    4    4.50
    25200    1/21/21    Barry    16    Tech problem    4    4    5    5    4.50
    28144    1/22/21    Calder    6    Feature request    5    3    2    4    3.50
    28147    1/22/21    Zimmerman    3    Bug report    4    4    5    5    4.50
    29215    1/23/21    Thanh    17    Tech problem    3    4    4    4    3.75
    26128    1/23/21    Bruno    5    Bug report    4    5    5    5    4.75
    29136    1/24/21    Darego    16    Tech problem    4    4    4    4    4.00
    29182    1/25/21    Zimmerman    17    Tech problem    3    2    2    3    2.50
    24126    1/26/21    Bruno    20    Tech...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?