FAU ISM 3011 LAu2-1_instructions - A Lesson Approach Excel 2010 Unit 2 Working with Formulas and Functions Unit Application 2-1 Create named ranges Use

# FAU ISM 3011 LAu2-1_instructions - A Lesson Approach Excel...

• Lab Report
• AjaniG
• 1

This preview shows page 1 out of 1 page.

A Lesson Approach: Excel 2010 Unit 2 Working with Formulas and Functions 1 | P a g e 2/28/12 Be 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. .