1. how to do new Data Model and generate a PivotTable shows the total annual rent paid to different offices. PivotTable should have meaningful label headers and contains offices' location IDs.

1. how to Use the created PivotTable, do PivotChart with a meaningful sheet name. Format the chart as a Pie Chart with a meaningful chart title to show each office's suburb, total annual rent income and its percentage.

Home Insert Draw Page Layout Formulas Data Review View Developer Tell me fx W . . Define Name v Ly Trace Precedents Trace Dependents Insert Auto-sum Recently Financial Logical Text Date & Lookup & Maths & More Create from Selection Show Error-checking Watch Window Function Used Time Reference Trig Functions Remove Arrows v Formulas E24 X V fx 153857 K M A B C D E F G H 57 Promenade Property Pty Ltd Business Income Userid GivenName Surname Number of Properties Annual Rent Paid Received ppabisho Anna Bishop 10 121680 ppabland Alicia Bland 21 195024 ppadorri Alexandra Dorrington 29 238266 ppahens Anne Hensley 25 67147 ppalawso Abbie Lawson 17 191130 8 ppamiddl Aidan Middleton 40 318741 9 ppaplume Archer Plume 45 369836 ppbhicks Ben Hicks 41 432350 11 ppcbrydo Chelsea Brydon 37 370170 12 ppcmaher Carol Maher 20 221785 13 ppcolson Courtney Olson 27 236026 14 ppcturne Cheryl Turner 23 241060 15 ppdyates Dem Yates 25 189655 16 ppefishb Ethan Fishbourne 20 196695 17 ppefox Eva Fox 27 236045 18 ppeporte Elijah Porteus 15380 19 ppesteph Evie Stephenson 12 141777 20 ppewarlo Elizabeth Warlow-Davi 26 295425 ppewrigh Edward Wright 96454 22 ppfcolli Finn Collits 19 168650 ppfgill Francesca Gill 36 280394 ppgnicho Georgina Nicholson 13 153857 25 pphdarcy Harrison D'Arcy-Irvine 37 34567 26 pphferra Holly Ferrari 23 218600 ppinicho Isobel Nicholson 16 175407 28 ppjandre Jennifer Andrews 21 238040 29 ppjheffr Jonathan Heffron 38 356133 ppjivers Jeffrey Iverson 31 433855 ppjlarso Jacquelyn Larson 172082Home Insert Draw Page Layout Formulas Data Review View Developer Tell me fox .. . Define Name v Ev Trace Precedents 57Trace Dependents Insert Auto-sum Recently Financial Logical Text Date & Lookup & Maths & More Create from Selection Show Error-checking Watch Calcul Function Used Time Reference Trig Functions Remove Arrows v Formulas Window Optic M24 X V fx =LOOKUP(L24,job, salary) A B C D E F G H M N O P Q R S 57 Promenade Property Pty Ltd Employees User Id Title Given Name Middle Initial Surname Birthday Telephone N Address Email First Working Location Job Annual Salary Employer Super |Employee Super Commission Bonus Income Tax Annual Banked ppabisho Ms. Anna B Bishop 24691 (07) 8283 4: 135 Candleb anna.bishop 40107 PP-LOC-04 Senior Property Manager $ 60,480.00 $ 6,955.20 $2,433.60 $4,233.60 $ 13,369.84 53,777.36 ppablake Mr. Aaron Blakeney 33663 (07) 5378 2: 132 Terrace aaron.blaken 40093 PP-LOC-07 Office Manager $ 54,461.00 $ 5,990.71 $ S $3,812.27 $ 10,485.81 547,787.46 ppabland Ms. Alicia H Bland 29218 (07) 3377 6: 155 Carowel alicia.bland @ 40386 PP-LOC-03 Property Manager $ 44,070.00 $ 4,627.35 $ 1,271.84 $3,900.48 $2,313.68 $ 7,889.35 $ 41,122.96 ppacoppo Mr. Anthony M Coppola 27083 (07) 8249 8 194 Macross anthony.cop 38791 PP-LOC-07 Owne $ 88,496.00 11,504.48 2,160.69 $ $6,194.72 $ 22,667.57 $ 69,862.46 ppadorr Mrs Alexandra Dorrington 21329 (07) 8720 1: 99 Lismore S| alexandra.do 40489 PP-LOC-01 Property Manager $ 44,070.00 4,627.35 1,719.14 $4,765.32 $2,313.68 $ 8,170.42 $ 41,259.43 ppafranc Ms Alexandra Francis 33888 (07) 4031 5 20 Freeman alexandra.fra 41668 PP-LOC-03 Sales Officer 47,457.00 $ 4,982.99 $ $ $1,898.28 $ 7,587.47 $ 41,767.81 ppahensl Ms. Anne H Hensley 23535 (07) 4000 4: 69 Livingston anne.hensley 39994 PP-LOC-07 Property Manager $ 44,070.00 4,627.35 1,488.87 $3,342.94 $3,084.90 $ 7,958.80 $ 41,050.18 .0 ppalawso Mrs. Abbie Lawson 25132 (07) 5381 50 60 Eagle Tce, abbie.lawsor 1963 PP-LOC-06 Property Manager $ 44,070.00 4,627.35 ,468.96 $3,822.60 $1,762.80 $ 7,685.01 $ 40,501.43 ppamiddl Mr. Aidan E Middleton 30748 (07) 5337 7: 150 Longfor aidan.middle 10573 PP-LOC-01 Property Manager $ 44,070.00 4,627.35 881.30 $6,374.82 $2,313.68 $ 8,693.51 $ 43,183.68 12 ppapeter Mr. Alex A Peters 28867 (07) 4050 8 22 Skew St, Ji alex.peters @ 41172 PP-LOC-01 Sales Officer $ 47,457.00 4,982.99 1,265.05 $ $2,491.49 $ 7,780.26 $ 40,903.19 13 ppaplume Mr. Archer A Plume 25869 (07) 5315 8: 43 Regal PI, C archer.plume 40545 PP-LOC-01 Property Manager 44,070.00 4,627.35 1,342.64 $7,396.72 $2,313.68 $ 9,025.63 $ 43,412.12 14 ppasharp Mrs. Abigai G Sharpe 4631 (07) 6739 4: 105 Chandle ab abigail.sharp 41169 PP-LOC-06 Receptionist $ 36,255.00 3,444.23 $1,903.39 $ 3,948.48 $ 34,209.91 15 ppbcarra Mr Bryan G Carrasco 32549 (07) 6252 2 36 Mortimer bryan.carras 41584 PP-LOC-06 Sales Officer $ 47,457.00 4,982.99 35.36 $1,898.28 $ 7,587.47 $ 40,932.46 16 ppbhicks Mr. Ben M Hicks 2446 (07) 9009 5: 126 Colvin S ben.hicks @p 41679 PP-LOC-01 Property Manager S 44,070.00 4,627.35 1,582.94 $8,647.00 $1,762.80 $ 9,252.94 $ 43,643.92 17 ppbking Mr. Billy A King 29804 (07) 3245 2: 200 Chardea billy.king@pr 39822 PP-LOC-04 Sales Officer 47,457.00 4,982.99 854.58 $ $3,321.99 $ 8,050.17 $ 41,874.24 18 ppbvicin Ms. Bong Vicini 23336 (07) 8262 8: 60 Postle St, bong.vicini@ 38791 PP-LOC-01 Owner $ 88,496.00 11,504.48 2,520.81 $ $6,194.72 $ 22,667.57 $ 69,502.34 19 ppcbrydo Mrs Chelsea Brydon 31120 (07) 5384 54 40 Chubb La chelsea.bryd 1268 PP-LOC-01 Property Manager $ 44,070.00 4,627.35 895.19 $7,403.40 $2,313.68 $ 9,027.80 $ 43,864.09 20 ppcburto Ms. Charli Burton 21406 (07) 3384 56 141 Illawong charli.burton 38791 PP-LOC-01 Owner $ 88,496.00 11,504.48 $ 2,880.93 $ $6,194.72 $ 22,667.57 $ 69,142.23 ppccochr Mrs Caro R Cochran 5667 (07) 8722 1 105 Kenna S carol.cochran 42085 PP-LOC-01 Sales Officer $ 47,457.00 $ 4,982.99 $ $ $1,898.28 $ 7,587.47 $ 41,767.81 ppcmaher Mrs Carol D Maher 25195 (07) 9049 54 165 Pender & carol.maherq 39217 PP-LOC-07 Property Manager $ 44,070.00 $ 4,627.35 $ 1,514.68 $4,435.70 $3,084.90 $ 8,313.95 $ 41,761.97 ppcolson Ms. Courtney D Olson 34308 (07) 8921 4: 37 Kroshann courtney.ols 40807 PP-LOC-01 Property Manager $ 44,070.00 $ 4,627.35 $ $4,720.52 $2,313.68 $ 8,155.86 $ 42,948.33 ppcturne Ms Cheryl H Turner 24044 (07) 4972 5: 26 William St cheryl.turner 39281 PP-LOC-06 Property Manager $ 44,070.00 $ 4,627.35 $ 1,523.79 $4,821.20 $3,084.90 $ 8,439.23 $ 42,013.08