Excel Question

Assignment 2 – Excel Pivot Tables IDS 200 BBA- Spring 2024 Due on Thursday, 3/14/2024, at 11:59 pm 40 points Instructions In this assignment you will be creating three pivot tables and answer the related questions. Create each pivot table using default options so it will be saved on a new worksheet. 1. Download the file “IDS 200 BBA Tutorial 2-Excel Pivot Table Data-Spring 2024.xlsx” from Blackboard to your computer and save it as Assignment2-YourNetID, for example Assignment2-jdoe2 if your NetID is jdoe2. 2. [5 points] Create a pivot table that shows the total amount of unpaid invoices for Aligni vendor in the month of March 2017. Answer the following two questions and type your answers in cells A15 and A16 respectively: a. [2 points] What was the total amount of unpaid invoices for the above vendor during the stated month? b. [2 points] What was the total amount of paid invoices for the above vendor during the stated month? 3. [5 points] Create a pivot table that shows the maximum invoice amount that each vendor has (hint: locate the Max function the same way as you locate the Average function in Tutorial 2). Answer the following three questions and type your answers in cells A15, A16 and A17 respectively: a. [4 points] Which vendor had the highest maximum invoice amount and what was the amount? b. [4 points] Which vendor had the lowest maximum invoice amount and what was the amount? c. [4 points] Which two vendors had the same maximum invoice amount and what was the amount? 4. [5 points] Create a pivot table that shows all the invoices that are less than $75. Answer the following three questions and type your answers in cells A30, A31 and A32 respectively: a. [3 points] Which vendors had invoices less than $75? b. [3 points] How many invoices less than $75 each of the above vendor had? c. [3 points] What was the total amount (the grand total) of invoices less than $75 from all of these vendors? 5. Submit the file using the designated link in Week 2 folder on Blackboard by the due date. Page 1 of 1 Invoice 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 Vendor Partzilla Fishbowl Aligni Aligni Partzilla Fishbowl Aligni Partzilla Aligni Aligni Trilogy Partzilla Fishbowl Trilogy SPI Fishbowl Aligni Fishbowl Aligni Partzilla Aligni Aligni Trilogy Trilogy Trilogy Aligni Trilogy Aligni Fishbowl Aligni Aligni Partzilla Aligni SPI Aligni Trilogy Trilogy Aligni Trilogy Trilogy Fishbowl Trilogy Aligni Fishbowl Aligni Aligni Amount $372 $251 $67 $141 $393 $468 $274 $455 $273 $213 $412 $190 $286 $75 $530 $435 $65 $211 $415 $516 $192 $546 $396 $82 $490 $219 $166 $185 $370 $191 $61 $128 $427 $479 $497 $429 $230 $512 $113 $278 $205 $66 $420 $258 $257 $395 Date Received 1/1/2017 1/1/2017 1/2/2017 1/3/2017 1/4/2017 1/6/2017 1/7/2017 1/7/2017 1/7/2017 1/8/2017 1/10/2017 1/12/2017 1/14/2017 1/15/2017 1/16/2017 1/16/2017 1/17/2017 1/17/2017 1/17/2017 1/19/2017 1/21/2017 1/22/2017 1/22/2017 1/24/2017 1/24/2017 1/25/2017 1/25/2017 1/25/2017 1/26/2017 1/26/2017 1/27/2017 1/27/2017 1/29/2017 1/30/2017 2/1/2017 2/3/2017 2/4/2017 2/4/2017 2/4/2017 2/6/2017 2/6/2017 2/9/2017 2/9/2017 2/10/2017 2/10/2017 2/11/2017 Paid yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes no yes no yes yes yes yes Date Paid 2/17/2017 1/4/2017 1/29/2017 1/19/2017 1/30/2017 1/15/2017 2/4/2017 2/4/2017 3/5/2017 2/8/2017 2/5/2017 1/17/2017 1/24/2017 1/26/2017 1/28/2017 2/2/2017 1/26/2017 2/2/2017 1/18/2017 3/14/2017 3/9/2017 2/5/2017 3/8/2017 2/23/2017 2/13/2017 3/13/2017 3/11/2017 2/1/2017 2/2/2017 2/4/2017 3/11/2017 3/18/2017 3/26/2017 3/15/2017 2/1/2017 3/24/2017 3/11/2017 3/9/2017 2/27/2017 3/26/2017 3/7/2017 2/23/2017 3/31/2017 4/3/2017 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 Aligni Aligni Aligni Aligni Trilogy Aligni Aligni Aligni Trilogy Aligni Trilogy Fishbowl Aligni Partzilla SPI SPI Aligni Trilogy SPI Fishbowl Fishbowl Aligni Fishbowl Fishbowl Aligni Trilogy Aligni Aligni Fishbowl Fishbowl Trilogy Aligni Trilogy Fishbowl Aligni Partzilla Aligni Aligni Aligni Trilogy Aligni Aligni Trilogy Aligni Aligni Fishbowl Aligni $476 $525 $425 $333 $207 $477 $501 $60 $287 $362 $366 $67 $335 $151 $312 $77 $309 $112 $72 $155 $408 $340 $166 $490 $484 $250 $236 $62 $381 $137 $173 $308 $489 $78 $510 $529 $491 $524 $224 $99 $330 $360 $427 $203 $164 $287 $391 2/13/2017 2/14/2017 2/14/2017 2/14/2017 2/15/2017 2/15/2017 2/16/2017 2/16/2017 2/18/2017 2/18/2017 2/19/2017 2/19/2017 2/22/2017 2/22/2017 2/24/2017 2/26/2017 2/28/2017 2/28/2017 3/1/2017 3/2/2017 3/3/2017 3/4/2017 3/5/2017 3/5/2017 3/6/2017 3/7/2017 3/9/2017 3/9/2017 3/10/2017 3/11/2017 3/13/2017 3/14/2017 3/15/2017 3/15/2017 3/16/2017 3/17/2017 3/17/2017 3/18/2017 3/21/2017 3/22/2017 3/24/2017 3/24/2017 3/24/2017 3/26/2017 3/26/2017 3/27/2017 3/29/2017 yes yes yes yes no yes yes no yes yes yes yes no no no yes no yes yes no yes no yes no yes yes yes no yes no no no yes no no no no no yes no no no no no yes yes no 3/27/2017 3/16/2017 2/25/2017 3/12/2017 2/20/2017 3/9/2017 2/18/2017 2/27/2017 2/20/2017 3/10/2017 4/9/2017 3/12/2017 4/9/2017 3/11/2017 4/12/2017 3/21/2017 4/8/2017 4/15/2017 4/21/2017 4/9/2017 4/4/2017 5/4/2017 4/1/2017 10094 10095 10096 10097 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 Trilogy Trilogy Aligni Aligni Aligni Trilogy Partzilla Aligni Trilogy Trilogy Fishbowl Aligni Aligni SPI Fishbowl Aligni Partzilla Aligni Aligni Aligni Aligni Aligni Aligni Aligni Partzilla SPI Aligni Aligni Aligni Aligni Fishbowl SPI Aligni Partzilla Aligni Fishbowl Trilogy Trilogy Partzilla Partzilla Fishbowl Fishbowl Fishbowl Aligni Fishbowl Aligni Fishbowl $272 $256 $393 $522 $77 $103 $369 $353 $58 $337 $400 $122 $455 $117 $166 $175 $516 $326 $495 $248 $407 $56 $306 $59 $496 $508 $163 $309 $186 $103 $275 $544 $439 $177 $74 $541 $195 $325 $361 $171 $236 $345 $231 $89 $319 $227 $405 3/29/2017 3/30/2017 3/30/2017 3/31/2017 3/31/2017 4/1/2017 4/2/2017 4/3/2017 4/3/2017 4/4/2017 4/5/2017 4/5/2017 4/8/2017 4/8/2017 4/9/2017 4/11/2017 4/11/2017 4/11/2017 4/12/2017 4/12/2017 4/12/2017 4/13/2017 4/15/2017 4/16/2017 4/18/2017 4/21/2017 4/21/2017 4/22/2017 4/22/2017 4/22/2017 4/23/2017 4/24/2017 4/24/2017 4/28/2017 4/28/2017 4/29/2017 4/29/2017 4/29/2017 4/30/2017 5/1/2017 5/1/2017 5/1/2017 5/2/2017 5/4/2017 5/5/2017 5/6/2017 5/6/2017 no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no 10141 10142 10143 10144 10145 10146 10147 10148 10149 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 Partzilla Fishbowl Aligni Partzilla Aligni Fishbowl Trilogy Aligni Partzilla Aligni Aligni Aligni Fishbowl Partzilla Trilogy Aligni Fishbowl SPI Aligni Trilogy Aligni Trilogy Trilogy SPI Partzilla Fishbowl Fishbowl Aligni Trilogy Trilogy Aligni Trilogy Aligni SPI Fishbowl Fishbowl Aligni Trilogy Trilogy Fishbowl Trilogy Aligni SPI Trilogy Aligni Aligni SPI $136 $202 $218 $370 $198 $151 $323 $509 $340 $262 $397 $195 $468 $482 $517 $178 $544 $59 $241 $397 $329 $510 $439 $349 $97 $98 $418 $423 $304 $538 $289 $433 $95 $449 $462 $268 $268 $167 $543 $536 $67 $461 $64 $523 $92 $487 $240 5/7/2017 5/7/2017 5/10/2017 5/11/2017 5/11/2017 5/17/2017 5/17/2017 5/18/2017 5/18/2017 5/21/2017 5/22/2017 5/22/2017 5/22/2017 5/23/2017 5/25/2017 5/25/2017 5/25/2017 5/27/2017 5/29/2017 5/30/2017 5/30/2017 6/2/2017 6/5/2017 6/6/2017 6/7/2017 6/8/2017 6/8/2017 6/9/2017 6/10/2017 6/11/2017 6/12/2017 6/13/2017 6/13/2017 6/19/2017 6/20/2017 6/21/2017 6/22/2017 6/24/2017 6/24/2017 6/24/2017 6/25/2017 6/26/2017 6/27/2017 6/28/2017 6/28/2017 7/2/2017 7/3/2017 no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no no 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 Aligni Aligni Aligni Aligni Trilogy SPI Trilogy Aligni Aligni Aligni Aligni Aligni Aligni $192 $116 $434 $291 $465 $544 $65 $258 $68 $391 $518 $476 $224 7/5/2017 7/6/2017 7/6/2017 7/10/2017 7/12/2017 7/13/2017 7/14/2017 7/15/2017 7/16/2017 7/16/2017 7/16/2017 7/17/2017 7/17/2017 no no no no no no no no no no no no no

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.