A Lesson Approach:Excel 2010 Unit 2 Working with Formulas and Functions 1 | P a g e 2/28/12Be sure to select Download Start File before beginning. Unit Application 2-1 Create named ranges. Use a constant. Insert functions. Each office location has a 2-month period during which it displays a large jar with gumballs. The patient who guesses closest to the actual number of gumballs in the jar wins free eye exams for 1 year. The worksheet calculates the winner. Because guesses can be greater than or less than the actual value, you’ll use the ABS function to display each result as a positive value. 1.Open Excel_LAu2-1 start file. Save the workbook as your initialsu2-12.Apply Center Across Selection to cells B2:C3. Copy the format from cell D6 to the
Remember to click the Submit My Project button to submit your work for grading. .