On the Calc sheet, in cell C$11,$ use the AVERAGEIF function to calculate the average Gross Revenue for the security product. Use the cell reference D$6$ for Security.

D On the Compensation sheet, in cell H$10,$ use the IF function to compare cell E$10$ with cell G$4.$ If E$10$ is greater than or equal to G$4,$ return $H4.$ Otherwise, return Below $130\%.$

On the Compensation sheet in cell $H8$ use the IFS function to determine the bonus level. Use absolute references for the Bonus table. If they did not reach $100\%,$ return E$8-100\%.$

On the Calc sheet, in cell C$11,$ enter this formula to determine the total expenses for sales of security products in EMEA using the following named ranges and cell references: $=$SUMIFS$($Expenses$,$Area,C$5,$Product,D$6).$

D On the Calc sheet, in cell C$11,$ use the AVERAGEIFS function to determine the average gross revenue for security products in Central America $($CA$).$ Use the following names and cell references in this order: Gross$\_$Revenue, Area, C$4($Central America$),$ Product, D$6($Security$).$

Dn the Calc sheet, in cell C$11,$ use the SUMIFS function to calculate the total units of analytics sold in the SOHO segement.

On the Calc sheet, in cell C$11,$ use the SUMIF function to detemine the total units sold $($Use Units$\_$Sold$)$ for the Enterprise segment $($use cell reference B$3).$ Also, use the name Segment for segment.

On the Calc sheet, in cell C$11,$ use the SUMIF function to determine the total expenses for North America $($NA$).$ Use the value of C$6$ instead of "North America $($NA$)".$

On the Compensation sheet, in cell H$8,$ use nested If functions to determine the bonus level. Use absolute references for the Bonus table and if they did not reach $100\%$ return E$8-100\%.$