In R15: 4 points Save Answer Use the appropriate function that will return TRUE if the Region is RG4 or the Year of Hire is 1991 or the Salary is 95,000 or more or the Rating is 5. Copy the function down to the other cells in the column. In cell R10 use the appropriate function to calculate how many are TRUE. M N O P Q R T U Department Supervisor Bonus Region Bonus Rate Bo 1202 Laing 1,200 RG1 2.00% 1211 Zheng 900 RG2 2.25% 1225 Ahmed 1,000 RG3 2.35% 1237 Enkomo 1,100 RG4 1.95% 1249 Da Silva 950 1255 Borrows 1,050 R15 fx F G H Annual Units Bonus Bonus Bonus Award? 1234 Sold Rate 100 0 200 16,500 270 950 No Award 0.75% $ 3,950 $ 18.00 Certificate 1.50% $ 4,650 500 18,000 1,400 Bronze 3.25% $ 5,100 5 750 6 1,000 19,500 1,800 22,000 2,500 Gold 4.50% $ 3,500 Platinum 6.00% 7 8 9 10 11 + 12 13 Job Title Answers Units Sold Units Sold Units Sold Units Sold Annual Units Rating Year of Hire Age Salary Gender 14 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Sold 15 Junior Sales Rep 2 1998 61 $ 32,118 M 3,229 3,499 3,884 4,973 15,585 16 Manager 4 1989 59 $ 136,465 M 5,683 5,693 5,113 4,506 20,995 17 Advisor 4 1990 65 $ 86,624 F 4,011 4,109 4,491 5,641 18,252 18 Sales Rep 5 1997 52 $ 50,657 F 5,460 5,495 4,854 3,965 19,774 19 Junior Sales Rep 1 1991 53 $ 34,572 M 3,601 3,643 3,450 5,397 16,091. 20 Manager 5 1988 58 $ 97,983 M 5,140 5,194 4,469 4,888 19,691 21 Junior Sales Rep 1 1992 50 $ 34,706 M 3,940 4,213 4,557 5,781 18,491 22 Manager 3 1987 66 $ 126,164 M 3,852 3,864 6,052 6,534 20,302 23 Junior Sales Rep 3 1990 46 $ 37,294 M 5,786 5,984 5,865 5,315 22,950 24 Junior Sales Rep 1 1999 62 $ 35,401 M 5,851 6,059 4,261 6,554 22,725 25 Junior Sales Rep 1 1986 55 $ 36,323 M 5,370 5,535 4,785 4,180 19,870 26 Junior Sales Rep 3 1993 66 $ 33,816 M 4,124 4,145 5,855 6,564 20,688 27 Sales Rep 5 1985 53 $ 44,760 M 3,668 3,682 5,551 5,641 18,542 28 Sales Rep 3 1984 63 $ 74,578 M 4,546 4,582 5,704 5,897 20,729 " Famil nnnin STARTUP TEST DATA PIVOT Owner + Enter Functions below acc