A Lesson Approach:Excel 2010Unit 2Working with Formulas and Functions1 |P a g e2/28/12Be sure toselectDownloadStart Filebeforebeginning.Unit Application 2-1Create named ranges. Use a constant. Insert functions.Each office location has a 2-month period during which it displays a large jar withgumballs. The patient who guesses closest to the actual number of gumballs in the jarwins free eye exams for 1 year. The worksheet calculates the winner. Because guessescan be greater than or less than the actual value, you’ll use the ABS function to displayeach result as a positive value.1.OpenExcel_LAu2-1start file. Save the workbook asyour initialsu2-12.Apply Center Across Selection to cells B2:C3. Copy the format from cell D6 to theRemember toclick theSubmitMy Projectbuttonto submit yourwork for grading..