Misy 5325 Ms Excel Midterm Exam Study Guide - Bio171 Microbio Full Exam

Landscape {Ans: ________________ orientation is a good choice for large worksheets, because when printed the worksheets width is greater than its height.}False {Ans: You use the ALT key when trying to select more than one range.}False {Ans: A number can contain only the following characters: 1,2,3,4,5,6,7,8,9,0.}Function {Ans: A _______________ is a prewritten formula that is built into excel. Ex. Sum, Max, Min}If {Ans: The _____ function is useful when you want to assign a value to a cell based on logical test.}1.Add-in 2.Binding constraint 3.Constraint 4.Changing variable cell 5.Solver {Ans: 1.A program that can be added to Excel to provide enhanced function 2.A constraint that Solver enforces to reach the target value 3.A limitation that imposes restrictions on Solver 4.A cell containing a variable whose value changes until Solver optimizes the value in the objective cell 5. An add-in application that manipulates variables based on constraints to find the optimal solution to a problem.}