The following sheet has had conditional formatting applied to the Grand Total, Limit, and Overdue columns. What types of conditional formatting have been applied to each column? What are the rules underlying each of the conditional formatting rules? Account Current 31-60 61-90 91-120 Over 120 Grand Total Limit OverDue A00106 35 $ 797 V $ 832 $ 500 332 A00108 S 1 $ 1 $3,000 $ A00115 $ 50 $ 4,950 5,000 $ 5,000 $ A00138 $ 36 36 $ 2,000 A00183 S 149 $ 149 $ 3,000 A00228 $ 214 S 1 $ 36 $ 2,500 2,751 $ 2,000 S 751 A00229 3 6 S 6 $1,000 A00245 6 $ 4 S 10 $5,000 BOO102 S 0 $ 0 $1,000 $ BOO103 $ 1,000 $ 22 $ 43 $ 1,064 $ 3,000 $ BOO113 $ 19 $ 19 $4,000 $ BOO151. $ 6 $ 1,000 1,006 $ 1,000 6 800197 $ 5 VS 5 $3,000 BOO204 $ 24 $ 1,230 1,254 $2,000 BOO207 $ 35 $ 1,500 1,535 $ 1,000 5 BOO248 223 $ 140 $ 0 S 887 VS 1,250 $ 2,000 BO0267 $ 205 VS 205 $ 3,000 BOO284 $ 12 $ 1,000 VS 1,012 $ 1,000 12 BOO296 $ 13 $ 2,000 O $ 2,013 $4,000 $ BOO319 S 10 $ 175 VS 185 $5,000Short Answer Question What are five different ways to merge Table 1 and Table 2 in Power Query using the CustomerID column? Which values would be returned for each join type? Table 1 Table 2 CustomerID ~ Amount- CustomerID * Product 1 $ 42.01 1 A 2 $ 10.85 2 B 3 5 22.00 5 C 4 S 90.33 6 D Zoom image Answer Paragraph AQuestion 23/24 (10 p.) Short Answer Question You have three tables in an Excel Workbook containing information on customers, sales, and sales associates. You load the three tables into Power BI. How would you relate the tables to create the data model? Associates Name il Sales Associate Amount AssociatelDIE Name Position By Lumino Assoc _ Joe Gomez 1 5 162.00 Associate S Trent AA 5 198 00 le Mans Andy Robertson Europe 2 5 102.00 Bobby Firming 5 Allsson Becker | South America 35 162.00 Audio Mane Vice Pres Customers Sales Associates CustomerD AStoCataD Name Name Regic sales Associate Position Amount