Adams Corporation evaluates divisional managers based on feturn on investment (POi) and has peovided the operating results of the Northem Division from last year. The Controllor has askod you to compute the ROI and Reslodual income bosed on data from tort yeara and if the divifion ndets in mow product line. Use the information included in the Fxcel Simulation and the Excel functions described below to complete the task. - Cell References Allows you to refer to data from anotber cell in the worksheot. From the Excel Simulation below, if in a biank cel, "i G5" was entered, the formula would output the resuit from cell 65, or 4.00 in this example. - Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions You can use the folowing keys (plus sign to add), - (minus slgn to subtract, " (osterisk sign to multiply, and / (fonward slash to divide). From the Excel Simulation below, if in a blank cell " GS+G5" was entered, the formula would add the values from those cells and output the result, or 10.00 in this example. If using the other math symbols the result would output an appropriate answer for its function. - SUM function. Allows you to refer to multiple cels and adds all the values. You can add individual cett references or ranges to utifie this same result of adding those celis, except they are expressed as a range in the formula, and the result would the t2 o0 in this exartiple The tost. condition argument is an evaluation of the status of o cell, such as if the volue of a cell is greater than, less than, of equal to arpether number or cell. The valie, if true and wahie, it fabe arpuments wal feturn any specific fesult for each option, such as another cell reference, the text itseif should be entered in quotations so thet Excel wil recognire the text as a "string of text" instead of another furction Fiont the Excel Simulation below, if in a biank cell "uifiGsos20, Total cost is High", Total cost is lown was entered, the formula inould output the result. of the value. IC true since the fest conditon would be result as true, or in this case the text "Total cost is high: Fxcel processes the if Sovind Help Sar