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

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-1
2. 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.
.