Function: IF; Formula: Multiply; Cell Referencing BE24.5 - Using Excel to Determine Reportable Segments PROBLEM Foley Corporation has seven industry segments with total revenues as follows. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the SUM function with cell references to the Problem area to determine total revenue. Use Excel's IF function with mathematical formulas and cell references to the Problem area and the work area for each segment. Do not use all uppercase letters. $ Penley Konami KSC Red Moon Cheng Takuhi Molina 600 650 250 275 225 200 700 Use Excel's IF function to identify which industry segments are reportable, based only on the revenues test. Total revenue $ 2,900 Penley Konami KSC Red Moon Cheng Takuhi Molina