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