BA In class Wk 6

xlsx

School

Alexander College *

*We aren’t endorsed by this school

Course

102

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

13

Uploaded by LieutenantCrownLeopard27

Report
City Sum - Order Amount Calgary $3,364 Hamilton $5,489 Montreal $4,534 Oshawa $5,917 Saskatoon $5,479 Torento $8,814 Vancouver $2,279 Total Result $35,876 Calgary Hamil ton Montr eal Oshaw a Sask 0 5000 10000 15000 20000 25000 30000 35000 40000
askato on Tor ento Vancouver Tota l R esult Total Sum - Order Amount
Sum - Order Amount Month Salesperson January February March April June Total Result Colins, Chris $2,276 $1,403 $1,182 ### $5,917 Davis, Tia $1,064 $890 $325 $2,279 Flores, Richard $2,074 $2,460 $4,534 Georgia, Sara $1,366 $1,184 ### ### $5,489 Jordan, Melissa $1,509 $1,509 $346 $3,364 Sipmson, William $2,822 $1,390 $2,085 ### ### $8,814 Walters, Shannon $2,071 $2,044 ### $5,479 Total Result $9,745 $11,089 $6,495 ### ### $35,876 Colins, Chris Da 0 2000 4000 6000 8000 10000 12000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Davis, T ia Flores , Richard Geor gi a, Sara Jor dan, Melis sa Sipmson, Wi lliam Walt ers, Shannon Tot al R esult Month January February March April June
Sum - Order Amount Month City January February March April June Total Result Calgary $1,509 $1,509 $346 $3,364 Hamilton $1,366 $1,184 ### ### $5,489 Montreal $2,074 $2,460 $4,534 Oshawa $2,276 $1,403 $1,182 ### $5,917 Saskatoon $2,071 $2,044 ### $5,479 Torento $2,822 $1,390 $2,085 ### ### $8,814 Vancouver $1,064 $890 $325 $2,279 Total Result $9,745 $11,089 $6,495 ### ### $35,876 Calgary Ha 0 2000 4000 6000 8000 10000 12000
Hamil ton Mon tr eal Oshaw a Saskato on Tor ento Vancouv er Tot al R esult Month January February March April June
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Month Sum - Order Amount March $6,495 April $5,713 June $2,834 Total Result $15,042 March April 0 2000 4000 6000 8000 10000 12000 14000 16000
June Total Result Total Sum - Order Amount T S 2 I a i E s This shape represents a slicer. Slicers are supported in Excel 2010 or later. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.
This shape represents a slicer. Slicers are supported in Excel 2010 or later. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Salesperson City Account Order Amount Month Colins, Chris Oshawa 76763 $256 March Colins, Chris Oshawa 70686 $264 January Colins, Chris Oshawa 16440 $605 January Colins, Chris Oshawa 24908 $926 March Colins, Chris Oshawa 13787 $1,056 April Colins, Chris Oshawa 12996 $1,403 February Colins, Chris Oshawa 24859 $1,407 January Davis, Tia Vancouver 65609 $325 April Davis, Tia Vancouver 77084 $389 January Davis, Tia Vancouver 41954 $675 January Davis, Tia Vancouver 48881 $890 February Flores, Richard Montreal 48112 $686 January Flores, Richard Montreal 30661 $1,006 February Flores, Richard Montreal 83817 $1,388 January Flores, Richard Montreal 48838 $1,454 February Georgia, Sara Hamilton 64852 $700 April Georgia, Sara Hamilton 74466 $1,101 April Georgia, Sara Hamilton 31255 $1,138 June Georgia, Sara Hamilton 54309 $1,184 March Georgia, Sara Hamilton 42162 $1,366 February Jordan, Melissa Calgary 34550 $346 June Jordan, Melissa Calgary 64256 $437 January Jordan, Melissa Calgary 70739 $698 February Jordan, Melissa Calgary 70060 $811 February Jordan, Melissa Calgary 35882 $1,072 January Sipmson, William Torento 57516 $259 January Sipmson, William Torento 84076 $370 January A retailer sells items in different cities. The sales manager aims to analyze the number of sales in each city by e sales. You are required to: 1- In the following table, find the location of 13787 in the Account column (use the MATCH function); (10%) 2- In the following table, start from Account 70686, move 3 rows below and 1 column forward and return the 3-Name the Table area as "Customer data"; (5%) 4- Create a new column that gives customer ID in the format: name/account. Example Colins, Chris/76763. Us 5. Sort data by Order Amount in descending order (5%) Use Pivot tables and charts for the following tasks. Please create a new sheet for q6, q7, q8 and q9-11 (total 4 6- Calculate the Summation of Order Amount in each City; (10%) 7- Calculate the Summation of Order Amount by each Salesperson in different Months; (15%) 8- Calculate the Summation of Order Amount in each City in different Months; (10%) 9- Insert a chart to show the Summation of Order Amount in each month; (10%) 10- Insert Data Lable and Chart Title for the chart; (5%) 11- Insert a Filter for the Chart to show the Order Amount for each Month based on different Cities; (10%) **Please insert a New Sheet to respond to each question and Rename the sheets as the number of the questi
Sipmson, William Torento 41103 $813 March Sipmson, William Torento 70829 $946 January Sipmson, William Torento 15872 $1,167 April Sipmson, William Torento 19084 $1,247 January Sipmson, William Torento 15819 $1,272 March Sipmson, William Torento 73776 $1,350 June Sipmson, William Torento 57747 $1,390 February Walters, Shannon Saskatoon 10875 $827 February Walters, Shannon Saskatoon 71599 $976 March Walters, Shannon Saskatoon 21843 $1,068 March Walters, Shannon Saskatoon 65306 $1,244 February Walters, Shannon Saskatoon 36025 $1,364 April
Month Order Customer Id 3 Colins, Chris, 76763 1 Colins, Chris, 70686 Q1 ---> 5 1 Colins, Chris, 16440 Q2---> 926 3 Colins, Chris, 24908 4 Colins, Chris, 13787 2 Colins, Chris, 12996 1 Colins, Chris, 24859 4 Davis, Tia, 65609 1 Davis, Tia, 77084 1 Davis, Tia, 41954 2 Davis, Tia, 48881 1 Flores, Richard, 48112 2 Flores, Richard, 30661 1 Flores, Richard, 83817 2 Flores, Richard, 48838 4 Georgia, Sara, 64852 4 Georgia, Sara, 74466 6 Georgia, Sara, 31255 3 Georgia, Sara, 54309 2 Georgia, Sara, 42162 6 Jordan, Melissa, 34550 1 Jordan, Melissa, 64256 2 Jordan, Melissa, 70739 2 Jordan, Melissa, 70060 1 Jordan, Melissa, 35882 1 Sipmson, William, 57516 1 Sipmson, William, 84076 each sales person to get a general understanding of the performance in output (use OFFSET function); (10%) se Concatnate function (10%) 4 additional sheets). Please rename the sheets properly tions**
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3 Sipmson, William, 41103 1 Sipmson, William, 70829 4 Sipmson, William, 15872 1 Sipmson, William, 19084 3 Sipmson, William, 15819 6 Sipmson, William, 73776 2 Sipmson, William, 57747 2 Walters, Shannon, 10875 3 Walters, Shannon, 71599 3 Walters, Shannon, 21843 2 Walters, Shannon, 65306 4 Walters, Shannon, 36025