2001XLProficiencyWSolutions

# 2001XLProficiencyWSolutions - Excel Proficiency Exercises...

This preview shows pages 1–6. Sign up to view the full content.

Excel Proficiency Exercises With suggested solutions E XCEL R EVIEW 2001-2002

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
The best way to learn Excel is to use it. The best way to use Excel is on the job to solve a problem you need solving or by devising your own problems and finding solutions to them. This document includes practice exercises that illustrate features of the Excel software that are useful for modeling problems. Thanks to Decision Science Professor Laura Kornish for suggesting the exercises in this document. Try solving each problem on your own. If you need help, notes and suggested solutions are included. You may come up with solutions that use different techniques and that look a bit different from the ones here; your solutions may be completely valid! Excel offers many ways to accomplish the same thing. Paula Ecklund Spring 2001
Contents Page 1. Multiplication Table Problem. ....................................................................... 1 Relative, Absolute, & Mixed Addressing 2. Olive Oil Pricing Problem. ............................................................................ 6 IF Statements, SUMPRODUCT Function, MIN Function 3. Web Service Problem. ................................................................................. 13 Forecasting & Charting 4. Pro Forma Problem. .................................................................................... 19 Forecasting, Data Table, Goal Seek 5. Data Relationship Problem . ......................................................................... 28 Scatter or XY Plot

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

### Page1 / 38

2001XLProficiencyWSolutions - Excel Proficiency Exercises...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online