14. Save the workbook, and then close it. Develop an Excel Table In daily life, you solve all sorts.

14. Save the workbook, and then close it.

Develop an Excel Table

In daily life, you solve all sorts of problems, such as
which car purchase makes the most economic

sense when comparing purchase price, mileage, and
maintenance, or which software package will

help your biking club manage its funds, plan road trips, and
keep memberships up to date. To solve

these and other problems, you need to collect data that
tracks the current situation, determine your

ultimate goal, and then follow a logical progression to the
best solution. Developing an Excel table

can help you track the data

14. Save the workbook, and then close it.

Develop an Excel Table

In daily life, you solve all sorts of problems, such as
which car purchase makes the most economic

sense when comparing purchase price, mileage, and
maintenance, or which software package will

help your biking club manage its funds, plan road trips, and
keep memberships up to date. To solve

these and other problems, you need to collect data that
tracks the current situation, determine your

ultimate goal, and then follow a logical progression to the
best solution. Developing an Excel table

can help you track the data you need to solve such problems.

In this exercise, you need to select an activity in which
you participate or an organization to which

you belong, and identify a one-time or process-oriented
problem that needs to be solved. Then,

create

a worksheet and develop an Excel table to track relevant
data and create a solution to the

problem, using the Excel skills and features presented in
Tutorials 5 through 8.

Note: Please be sure not to include any personal information
of a sensitive nature in any worksheets

you create to submit to your instructor. Later, you can
update the worksheets with such information

for your own personal use.

1. Identify a problem to solve. This can be a one-time
problem, such as a car purchase, or a

process-oriented problem, such as tracking membership data
for a club to which you belong.

Determine feasible alternatives to solve the problem, and
then collect the data you need to

evaluate these alternatives.