SCMA 350 UNL Exam 1 Key Terms- Questions and Correct Answers

Model inputs The given numeric values in any problem statement Decision variables The variables a decision maker has control over to obtain the best solutions Model outputs The numeric values that result from combinations of inputs and decision variables through the use of logical formulas Relative, absolute cell addresses Useful for copying formulas; absolute row or column stays fixed, relative row or column "moves" A1 (relative), $A1 or A$1 (mixed), $A$1 (absolute); press F4 to cycle through possibilities Range names Useful for making formulas more readable Type the name in the Name box, or use the Create from Selection shortcut on the Formulas ribbon Pasting range names Provides a list of all range names in the current workbook Use Paste List from Use in Formula dropdown list on Formulas ribbon Cell comments Useful for documenting contents of cells Right-click cell, select Insert Comment menu item One-way data table Shows how one or more outputs vary as a single input varies Use Data Table from What-If Analysis dropdown list on Data ribbon Goal Seek Solves one equation in one unknown Use Goal Seek from What-If Analysis dropdown list on Data ribbon Formula Auditing toolbar Useful for checking which cells are related to other cells through formulas Use Formula Auditing buttons on Formulas ribbon button Useful for getting help on Excel functions On Formulas ribbon VLOOKUP function Useful for finding a particular value based on a comparison =VLOOKUP(valueToCompare, lookupTable,columnToReturn,True/False) Two-way data table Shows how a single output varies as two inputs vary Use Data Table from What-If Analysis dropdown list on Data ribbon