All answers must be entered as a formula

Question 1 fot 1 Save&Ext Subme value 20.00 points Adams Corporation evaluates divisional managers based on Return on investment (ROI) and has provided the operating results of the Northern Division from last year The Controller has asked you to compute the ROl and Residual Income based on data from last year and if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions described below to complete the task the formula would output the . Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions You can use the following keys (pus sign to adl (minus sign to subtract) From the Excel Simulation below, if are expressed as a range in the formula and the result would be 12 00 in this an evaluation of the status of a . Cell Reference Alows you to refer to data from another cell in the worksheet From the Excel Simulation below if in a blank cel, -65' was result from cell G5, or 4.00 in this example (asterisk sign to multiply), and (forward slash to divide). From the Excel Simulation below d in a blank cell -G5+G6' 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: Alows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utiize this function in a bank cel SUMG506 G7?w as entered the formula old output he result of ading those three separate cels o 12 00 n this ea pe Snoy in a blak cel SUMIG5 GT) was entered the formula would output the same resuit of adding those cels, except they example IF funstion: to test a condition and return a specific value is the result is true and different value if the result is false The syntax of the IF function is naltu e if false and specific considerations need to be made when using this function Tstcondosut forach IF(test condition, value if true value if false) and speci cell, such as if the value of a cell is greater than, less than, or equal to another number or cell The value f true and option, such as another cell reference, a value or text. Throughout the entire equation if test is being u value t faise arguments well return any specific resut for each sed in the test condition, value it true, or value d faise argumer s then the text xcel will recognize the text as a string of sext instead of another function From the Excel Simulation below it in a biank cel itself should be entered in quotations so that E ?FtG10-20. Total cost is High' Total cost is low) was entered the formula would output the result true since the test condition would be result as true or in this case First Excel processes the IF function by separating it out into separate parts the text Total cost is greater than 20 Once Excel determines if the resut of that test resut of that test Conditon i TRUE o Fst the rest conition Excel thinks, find cel 610 and determne it the vale s TRUE or FALSE t will return the aerue or value i alse DOLL F10 F11 F12 P