mon Project Alacs, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco The Cooler has asked you to help evaluate this offer to determine if the company should make or buy the component Use the information included in the Excel Simulation and the Excel functions described below to complete the task Cell Reference Allows you to refer to data from another cell in the worke Besis Meth unclets Allows you use the basic mam symbos to perform mathematical functions. You can use the folowing keys plus sign to add sign to subtract sign to multiply, and forward slash to divide if using the other math symbols the result out an appropriate answer for function hnston Alows you to test condition and return a specific value is the rest true and different value if the result is fise The of the function is Fest.condones and specific consideration needs be made when using this function The test condition argument i evaluation of the status of a cell such as the value of a ces is greater man less than or equal to another rand value,e arguments will retum any specific ut for each option, such as another cell reference a value, or text Throughout the equation, if text is being used in the rest.condition, valenue or we can the text should be entered in quotations so that Excel will recognize the text "ang of stead of another function Abe Reference; Allows you to maintain the original cel reference when a formule is cooled toner cell. The cell reference is ocked by putting a oper sign (s) before the column and row references. By default a cell reference is relative, s when you capy formula to another cel the values update based on a relative reference for exemple you copy o C.the formule cet C2 will relatively update b9-010 since the copied formula moved down one cel the formula cell references sas moved down one cel Conversely, by adding the absolute cet reference "locks" to the equation, the formule will not change when sped so any other cel. For example 50-5059" written in ces Clis copied to cell C2, the form in C2 wil 5058-5050 You - ano use a mued cell reference by only "locking the column or row only $6 or 05 which looks that spec morrow and the other reference becomes a relative reference and moves with the formule as copied to another ces For copy the formuese- nom ces C1 to cell C2, the formula in cell C2 will update to be 0-10 since the copied Sus moved down one cell the formule cell relative references also moved down one cel but the absoune ocked reference remained this pet, when ing About Ceferencing, you can also use the auto-fil option, however for proper grading you PLE DA M3