On the Calc sheet, in cell C$11,$ use the SUMIF function to deterOn 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 $H8,$ 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\%.$

On 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 determine 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,$ 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).$

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 $G4,$ return $H4.$ Otherwise, return Below $130\%.$

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.

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$).$

On the Compensation sheet, in cell H$8,$ use the IFS function to determine the bonus level. Use

absolute references for the Bonus table. If thev did not reach $100\%.$ return E$8-100\%.$mine the total expenses for North America $($NA$).$ Use the value of C$6$ instead of "North America $($NA$)"$