Succeeding in Business with Microsoft Office Excel 2003: A Problem-Solving Approach

by Gross,Debra

• ISBN13: 9780619267407
• ISBN10: 0619267402
• Edition: CD
• Format: Paperback
• Copyright: 2005-03-15
• Publisher: Cengage Learning

Summary

Succeeding in Business with Microsoft Excel 2003: A Problem-Solving Approach prepares students to analyze data and solve real-life business problems using Microsoft Excel as a tool. Moving beyond the basic ?point and click? focus of most computer applications texts, it challenges students to use critical thinking and analysis to find efficient and effective solutions to real-life situations.

Table of Contents

Preface	xiv
Getting the Most Out of Succeeding in Business With Microsoft Office Excel 2003	xv
The Succeeding in Business Instructor Resources	xvi
Succeeding in Business Series Walk-Through	xviii
About the Authors	xxii
Author Acknowledgements	xxiii
Introduction: Introduction to Problem Solving and Decision Making with Microsoft Office Excel 2003	2	(16)
About This Book and Microsoft Office Excel 2003	3	(1)
The Relationship Between Problem Solving and Decision Making	4	(1)
Information Overload	4	(1)
Which Comes First: The Problem or the Decision?	5	(1)
A Problem-Solving Process	6	(1)
Problem Recognition	7	(1)
Problem Statement	8	(1)
Solution	8	(4)
Problem Solving in This Book	12	(1)
Skills Training	13	(1)
Case Scenario	14	(1)
The Company	14	(1)
The Brand	14	(1)
Key Players	14	(1)
Company Goal: Expand the Product Line	15	(1)
How Is Excel Used at TheZone?	15	(1)
Chapter Summary	16	(1)
Conceptual Review	16	(2)
Applying Fundamental Excel Skills and Tools in Problem Solving	18	(54)
Level 1: Identifying and Correcting Common Errors in Formatting and Formulas	20	(16)
Excel 2003 Skills Training (powered by SAM)	20	(1)
Examining a Basic Worksheet for Errors	20	(2)
Correcting Formatting Problems	22	(1)
Modifying Column Width	22	(1)
Checking Error Messages	22	(1)
Formatting Numbers	23	(2)
Inserting a Title	25	(2)
Correcting Errors in Formulas	27	(2)
Checking Simple Formulas for Accuracy	29	(1)
Using Formulas and Cell References Instead of Values	29	(1)
Determining Order of Precedence	30	(1)
Understanding Precision Versus Display	30	(3)
Checking Accuracy in Formula Updates	33	(2)
Steps To Success: Level 1	35	(1)
Level 2: Calculating and Comparing Data Using Simple Functions	36	(12)
Excel 2003 Skills Training (powered by SAM)	36	(1)
Working with Multiple Worksheets	37	(1)
Calculating Totals using the Sum Function	38	(2)
Calculating Quickly with AutoSum	40	(1)
Calculating Average, Minimum, and Maximum Values	41	(3)
Calculating the Number of Values using the Count and Counta Functions	44	(1)
Steps To Success: Level 2	45	(3)
Level 3: Analyzing Cell References When Writing and Copying Formulas	48	(15)
Excel 2003 Skills Training (powered by SAM)	48	(1)
Creating a Budget Workbook	48	(1)
Organizing the Workbook	49	(3)
Understanding Relative Cell Referencing	52	(2)
Understanding Absolute and Mixed Cell Referencing	54	(4)
Naming a Cell or Cell Range	58	(1)
Writing a Formula to Subtotal the Cost of Goods Sold	58	(1)
Writing a Formula to Calculate Selling Expense	59	(1)
Writing a Formula to Calculate Projected Earnings	59	(1)
Completing the Budget Workbook	60	(1)
Steps To Success: Level 3	61	(2)
Chapter Summary	63	(9)
Conceptual Review	64	(2)
Case Problems	66	(1)
Level 1 -- Purchasing a Computer for Grusee & Associates	66	(2)
Level 2 -- Compiling Relocation Information for Devcon Finn, Inc.	68	(1)
Level 3 -- Analyzing Regional Sales Information for CKG Auto	69	(3)
Solving Problems with Statistical Analysis Tools	72	(74)
Level 1: Using Statistical Functions to Compare Data Values	74	(22)
Excel 2003 Skills Training (powered by SAM)	74	(1)
Understanding Fundamentals of Statistics	74	(5)
Controlling the Precision of Data Using the Round Function	79	(3)
Rounding Values to the Nearest Hundredth	82	(1)
Using Paste Special to Copy and Paste Data	83	(3)
Calculating the Mean, Median, Mode, and Standard Deviation	86	(2)
Managing Large Worksheets by Freezing Panes and Splitting the Window	88	(3)
Comparing Current Values to Historical Values	91	(1)
Calculating the Difference Between Two Sets of Data	92	(1)
Calculating the Percent Difference Between Two Sets of Data	92	(2)
Steps To Success: Level 1	94	(2)
Level 2: Organizing and Evaluating Different Data Groupings	96	(19)
Excel 2003 Skills Training (powered by SAM)	96	(1)
Determining a Rank for Each Value in a Data Set	96	(2)
Determining the Highest and Lowest Values in a Data Set	98	(1)
Determining the Highest Value with the Large Function	99	(2)
Determining the Lowest Value with the Small Function	101	(1)
Determining the Number of Items That Meet Specified Criteria	102	(5)
Determining a Total Value for Items That Meet Specified Criteria	107	(6)
Steps To Success: Level 2	113	(2)
Level 3: Extending the Analysis with What-If, Goal Seek, and Simulation	115	(22)
Excel 2003 Skills Training (powered by SAM)	115	(1)
Evaluating a Larger Data Set	115	(2)
Specifying a Custom Number Format	117	(1)
Understanding Custom Formatting Codes	118	(3)
Considering Alternatives: What-If Analysis and Goal Seek	121	(1)
Performing What-If Analysis	122	(1)
Using the Goal Seek Tool to Work Backward	123	(3)
Combining Countif and Sumif to Analyze Data in Specific Categories	126	(3)
Analyzing Data Through Simulation	129	(1)
Randomly Assigning a Number Between Two Values Using the Randbetween Function	130	(2)
Assigning a Random Value Using the Rand Function	132	(1)
Calculating Probable Costs Using a Round Function	132	(2)
Completing the Cost Benefit Analysis	134	(1)
Steps To Success: Level 3	135	(2)
Chapter Summary	137	(9)
Conceptual Review	137	(2)
Case Problems	139	(1)
Level 1 -- Analyzing Sales for Cremes Ice Cream	139	(2)
Level 2 -- Analyzing Demographic Data for La Rosa Restaurant	141	(1)
Level 3 -- Determining Inventory levels for CKG Auto	142	(4)
Determining Effective Data Display with Charts	146	(58)
Level 1: Analyzing Basic Chart Types	148	(20)
Excel 2003 Skills Training (powered by SAM)	148	(1)
Visualizing Data	148	(4)
Effective Charting in Excel	152	(1)
Determining the Appropriate Chart Type and Chart Options	153	(13)
Steps To Success: Level 1	166	(2)
Level 2: Evaluating Chart Sub-types	168	(18)
Excel 2003 Skills Training (powered by SAM)	168	(1)
Examining Sub-Types for Various Chart Types	168	(1)
Adding Things Up: Stacked Chart Options	168	(2)
Summing to 100%: Alternatives to Pie Charts	170	(1)
Slicing the Pie Too Thin: Summarizing Too Much Detail in Pie Charts	171	(5)
Monitoring a Business with Stock Charts	176	(8)
Steps To Success: Level 2	184	(2)
Level 3: Exploring More Advanced Chart Types	186	(12)
Excel 2003 Skills Training (powered by SAM)	186	(1)
Evaluating the Effectiveness of Radar, Bubble, and Dashboard Charts	186	(1)
Understanding Radar Charts	186	(3)
Understanding Bubble Charts	189	(4)
Creating a Management Dashboard	193	(4)
Steps To Success: Level 3	197	(1)
Chapter Summary	198	(6)
Conceptual Review	200	(1)
Case Problems	201	(1)
Level 1 -- Illustrating Travel Data for the Indiana Department of Tourism	201	(1)
Level 2 -- Analyzing Stock Performance for Universal Investments	201	(1)
Level 3 -- Illustrating Patterns in Gas Prices for CKG Auto	202	(2)
Applying Logic in Decision Making	204	(68)
Level 1: Analyzing Data Using Relational Operators and Boolean Logical Functions	206	(25)
Excel 2003 Skills Training (powered by SAM)	206	(1)
Reviewing Financial Criteria Related to Credit	206	(4)
Using Relational Operators to Compare Two Values	210	(3)
Using Boolean Logical Functions to Evaluate a List of Values and Determine a Single True or False Value	213	(2)
Using the OR Function to Evaluate Criteria	215	(4)
Using the AND Function to Evaluate Criteria	219	(3)
Using the NOT Function to Evaluate Criteria	222	(1)
Applying Conditional Formatting to a Worksheet	223	(1)
Applying Conditional Formatting Based on Cell Value	223	(3)
Applying Conditional Formatting Based on the Results of a Formula	226	(3)
Steps To Success: Level 1	229	(2)
Level 2: Analyzing Data Using IF Functions and Nested Functions	231	(15)
Excel 2003 Skills Training (powered by SAM)	231	(1)
Introduction to IF Functions and Nested Functions	231	(1)
Writing Simple IF Functions	231	(3)
Writing an IF Function with a Logical Test That Evaluates True/False Values	234	(1)
Writing and IF Function with a Logical Test That Performs a Simple Calculation	234	(3)
Writing IF Functions with Nested Functions	237	(2)
Constructing a Simple Nested IF Function	239	(3)
The Order of Logical Tests for Non-Mutually Exclusive Criteria	242	(1)
The Order of Logical Tests for Mutually Exclusive Criteria	243	(1)
The Order of Logical Tests for Criteria Between a Range of Values	243	(1)
Steps To Success: Level 2	244	(2)
Level 3: Creating Complex Logical Constructs for Solving Problems	246	(15)
Excel 2003 Skills Training (powered by SAM)	246	(1)
Evaluating More Complex Criteria	246	(2)
Using an IF Function to Combine Sets of Criteria	248	(2)
Using the None of Construct	250	(3)
Using the Only Construct	253	(3)
Nesting Boolean Logical Operators to Analyze Criteria	256	(1)
Completing the Complex Nested IF Formula	257	(3)
Steps To Success: Level 3	260	(1)
Chapter Summary	261	(11)
Conceptual Review	262	(2)
Case Problems	264	(1)
Level 1 -- Evaluating Job Applicants for Winston, Winston & Coombs	264	(3)
Level 2 -- Estimating Painting Job Costs for RJ Construction	267	(2)
Level 3 -- Analyzing Dealership Promotions for CKG Auto	269	(3)
Retrieving Data for Computation, Analysis, and Reference	272	(74)
Level 1: Performing Basic Lookups to Calculate and Evaluate Data	274	(17)
Excel 2003 Skills Training (powered by SAM)	274	(1)
Working with Lookup Tables	274	(2)
Retrieving Data From a Vertical Lookup Table	276	(3)
Examining the Vlookup Algorithm	279	(3)
Retrieving an Exact Match	282	(3)
Retrieving Data From a Horizontal Lookup Table	285	(4)
Steps To Success: Level 1	289	(2)
Level 2: Performing More Complex Lookups Involving Multiple Worksheets and Multidimensional Tables	291	(18)
Excel 2003 Skills Training (powered by SAM)	291	(1)
Retrieving Data From Multiple Worksheets	291	(2)
Using Vlookup with Multiple Worksheets	293	(2)
Looking Up Data in a One-Row or One-Column Range	295	(4)
Retrieving Data From Multidimensional Tables	299	(1)
Using the Index Function with a Two-Dimensional Table	300	(3)
Using the Index Function with a Three-Dimensional Table	303	(3)
Steps To Success: Level 2	306	(3)
Level 3: Nesting Lookup and Reference Functions to Retrieve and Calculate Data	309	(27)
Excel 2003 Skills Training (powered by SAM)	309	(1)
Refining the Order Form	309	(4)
Preventing Errors in Data Retrieval	313	(2)
Using the ISBLANK Function	315	(2)
Nesting Lookup Functions to Calculate the Price Per Unit	317	(1)
Nesting VLOOKUP in an If Function to Determine the lookup_value	318	(1)
Using the Choose Function to Determine the table_array	319	(2)
Determining the col_index_num	321	(1)
Determining the range_lookup	322	(1)
Creating the Nested VLOOKUP Formula	323	(1)
Calculating Totals	324	(1)
Calculating the Discount Amount	325	(1)
Calculating the Shipping Costs Using Match and Index Functions	326	(3)
Determining the reference Argument of the Index Function	329	(1)
Determining the row_num of the Index Function	329	(1)
Determining the col_num of the Index Function by Using the Match Function	329	(2)
Determining the area_num of the Index Function	331	(1)
Creating the Complex Index Formula and Completing the Worksheet	332	(2)
Steps To Success: Level 3	334	(2)
Chapter Summary	336	(10)
Conceptual Review	337	(2)
Case Problems	339	(1)
Level 1 -- Evaluating Tax Rates for the Arlington Group	339	(2)
Level 2 -- Calculating Travel Costs at America Travels	341	(2)
Level 3 -- Creating a Cost Estimate Form for CKG Auto	343	(3)
Evaluating the Financial Impact of Loans and Investments	346	(66)
Level 1: Calculating Values For Simple Financial Transactions	348	(18)
Excel 2003 Skills Training (powered by SAM)	348	(1)
Understanding How Interest is Calculated	348	(1)
Calculating Simple Interest	348	(1)
Calculating Compound Interest	349	(1)
Reviewing Alternative Financing Options	350	(1)
Using the PMT Function to Determine a Loan Payment	351	(1)
The Arguments of the PMT Function	352	(1)
Understanding Cash Flow (Inputs and Outputs)	353	(1)
Specifying Consistent Units of Time	354	(1)
Determining the Value of the Loan Payment	354	(1)
Using a Financial Function with Cell Referencing	355	(1)
Using the Rate, NPER, PV, and FV Functions	356	(1)
Determining the Future Value of a Financial Transaction	357	(2)
Determining the Present Value of a Financial Transaction	359	(1)
Determining the Interest Rate of a Financial Transaction	360	(1)
Determining the Number of Periods of a Financial Transaction	361	(2)
Selecting a Financing Option	363	(2)
Steps To Success: Level 1	365	(1)
Level 2: Creating a Projected Cash Flow Estimate and Amortization Table	366	(20)
Excel 2003 Skills Training (powered by SAM)	366	(1)
Designing The Cash Flow Estimate Worksheet	366	(2)
Identifying the Missing Data Elements	368	(2)
Setting Up An Amortization Table	370	(1)
Calculating Principal and Interest Payments	371	(2)
Calculating Principal and Interest Payments Between Two Periods	373	(3)
Calculating Depreciation Using the SLN Function	376	(3)
Alternative Depreciation Options Provided in Excel	379	(1)
Calculating Taxes	380	(2)
Completing the Analysis	382	(2)
Steps To Success: Level 2	384	(2)
Level 3: Evaluating the Financial Viability of Alternative Project Options	386	(16)
Excel 2003 Skills Training (powered by SAM)	386	(1)
Setting Up a Worksheet to Analyze Profitability	386	(3)
Calculating Net Present Value	389	(1)
Entering the NPV Function	389	(1)
Setting Up a Table of Hurdle Rates	390	(2)
Calculating the Internal Rate of Return	392	(2)
Creating a Chart Showing the Hurdle Rate Versus NPV	394	(1)
Calculating the Return on Investment	394	(1)
Determining the Payback Period	395	(3)
Setting Up the Worksheet For the Low Capital Option	398	(2)
Evaluating the Results of the Analysis	400	(1)
Steps To Success: Level 3	400	(2)
Chapter Summary	402	(10)
Conceptual Review	402	(2)
Case Problems	404	(1)
Level 1 -- Evaluating Loan Options for Flowers By Diana	404	(2)
Level 2 -- Creating a Mortgage Calculator for TriState Savings & Loan	406	(2)
Level 3 -- Analyzing Purchasing Versus Leasing Options for CKG Auto	408	(4)
Organizing Data for Effective Analysis	412	(66)
Level 1: Importing and Structuring Text Data in Excel Worksheets	414	(23)
Excel 2003 Skills Training (powered by SAM)	414	(1)
Working With Text Data	414	(2)
Combining Text Using the Concatenate Function	416	(2)
Extracting Characters from a Text String	418	(1)
Removing Spaces from a Text String	419	(1)
Determining the Position of a Character Within a Text String	420	(1)
Sorting and Removing Invalid Data	421	(3)
Working With Nonnumeric Data	424	(2)
Labeling and Sorting Data	426	(1)
Analyzing Data by Creating Subtotals	427	(2)
Creating And Working With An Excel List	429	(2)
Sorting an Excel List	431	(1)
Filtering an Excel List	431	(3)
Adding Data to an Excel List	434	(2)
Steps To Success: Level 1	436	(1)
Level 2: Analyzing Data Imported from a Database and Organizing Data with a Pivottable Report	437	(24)
Excel 2003 Skills Training (powered by SAM)	437	(1)
Importing Data From a Database into Excel	437	(2)
Importing an Access Table into Excel	439	(2)
Using the Query Wizard to Select Data from a Database	441	(2)
Making Calculations With Date and Time Data	443	(4)
Analyzing Data Using a Pivottable Report	447	(1)
Creating a PivotTable Report	447	(3)
Analyzing Data Using the Row, Column, and Data Areas	450	(3)
Adding Fields to the Page Area	453	(2)
Evaluating Data Using a Pivotchart Report	455	(2)
Importing Information From the Web into Excel	457	(2)
Steps To Success: Level 2	459	(2)
Level 3: Importing and Exporting XML Data	461	(12)
Excel 2003 Skills Training (powered by SAM)	461	(1)
Understanding Markup languages and XML	461	(1)
XML Documents	462	(1)
Analyzing XML Data With Excel	463	(1)
Importing XML Data as an XML List	464	(2)
Adding an XML Map to a Workbook	466	(2)
Exporting XML Data	468	(3)
Steps To Success: Level 3	471	(2)
Chapter Summary	473	(5)
Conceptual Review	473	(2)
Case Problems	475	(1)
Level 1 -- Importing and Analyzing Data for Johnson Equipment	475	(1)
Level 2 -- Analyzing Manager Performance at Home Station	476	(1)
Level 3 -- Creating a Loan Application and Amortization for CKG Auto	477	(1)
Using Data Tables and Excel Scenarios for What-If Analysis	478	(64)
Level 1: Using Data Tables to Perform Break-Even and Sensitivity Analysis	480	(22)
Excel 2003 Skills Training (powered by SAM)	480	(1)
Conducting Break-Even and Sensitivity Analyses	480	(2)
Analyzing What-If Results With Data Tables	482	(1)
Preparing a Worksheet for Data Tables	483	(3)
Varying One Value in a What-If Analysis	486	(2)
Setting Up a One-Variable Data Table's Structure	488	(1)
Completing a One-Variable Data Table	489	(2)
Interpreting One-Variable Data Tables	491	(3)
Varying Two Values in a What-If Analysis	494	(1)
Setting Up a Two-Variable Data Table's Structure	495	(1)
Completing a Two-Variable Data Table	496	(2)
Interpreting Two-Variable Data Tables	498	(3)
Steps To Success: Level 1	501	(1)
Level 2: Using Scenarios to Perform What-If Analysis	502	(23)
Excel 2003 Skills Training (powered by SAM)	502	(1)
Comparing The Results Of Complex Analyses	502	(1)
Planning Scenarios	503	(1)
Preparing the Inputs	503	(2)
Preparing the Outputs	505	(1)
Setting Up a Scenario	506	(1)
Preparing a Worksheet for Scenarios	507	(2)
Adding Scenarios to a Worksheet	509	(4)
Viewing and Analyzing Scenarios	513	(3)
Editing and Deleting Scenarios	516	(2)
Generating Scenario Reports	518	(1)
Creating Scenario Summaries	518	(2)
Creating Scenario PivotTable Reports	520	(2)
Creating Scenario PivotChart Reports	522	(1)
Steps To Success: Level 2	523	(2)
Level 3: Using Excel's Data Tables to Create a Simulation	525	(11)
Excel 2003 Skills Training (powered by SAM)	525	(1)
Understanding Simulation in Business	525	(1)
Preparing a Worksheet for a Simulation Using a Data Table	526	(3)
Developing a Simulation With a Two-Variable Data Table	529	(1)
Structuring a Two-Variable Data Table for a Simulation	529	(1)
Completing a Two-Variable Data Table for a Simulation	530	(3)
Calculating Simulation Statistics	533	(1)
Interpreting Simulation Results	534	(1)
Steps To Success: Level 3	535	(1)
Chapter Summary	536	(6)
Conceptual Review	537	(1)
Case Problems	538	(1)
Level 1 -- Estimating Travel Expenses for Executive Transport, Inc.'s Customers	538	(1)
Level 2 -- Evaluating Expansion Financing Options for Granite City Books	539	(1)
Level 3 -- Analyzing Health Insurance Plan Options for CKG Auto	540	(2)
Enhancing Decision Making with Slover	542	(50)
Level 1: Solving Product Mix Questions Using Goal Seek and Solver	544	(16)
Excel 2003 Skills Training (powered by SAM)	544	(1)
The Other Side of What-If Analysis	544	(1)
Performing What-If Analysis Using Goal Seek	545	(1)
Creating a Solver Model	546	(8)
Adding or Changing a Constraint in a Solver Model	554	(2)
Saving a Solver Solution as a Scenario	556	(1)
Analyzing Data Using a Solver Report	557	(2)
Steps To Success: Level 1	559	(1)
Level 2: Enhancing the Production Plan with Solver	560	(12)
Excel 2003 Skills Training (powered by SAM)	560	(1)
Adding Time Variables to the Production Plan	560	(1)
Adding Formulas and Constraints to the Solver Model	561	(2)
Troubleshooting an Infeasible Solution	563	(1)
Troubleshooting an Unbounded Solution	564	(1)
Identifying a Feasible Solution	564	(2)
Visualizing the Constraints in a Solver Model	566	(3)
Finding an Optimal Solution	569	(1)
Steps To Success: Level 2	570	(2)
Level 3: Managing Transportation Problems with Solver	572	(15)
Excel 2003 Skills Training (powered by SAM)	572	(1)
Developing a Distribution Plan Using Solver	572	(1)
Setting Up a Worksheet for the Distribution Plan	573	(4)
Saving a Solver Model	577	(3)
Using Solver when Demand Exceeds Supply	580	(2)
Assigning Contracts by Using Binary Constraints	582	(2)
Evaluating Assignment Problems with Too Many Resources	584	(2)
Steps To Success: Level 3	586	(1)
Chapter Summary	587	(5)
Conceptual Review	587	(1)
Case Problems	588	(1)
Level 1 -- Creating a Production Plan for ATC Inc.	588	(1)
Level 2 -- Managing Purchases for Brightstar Toy Company	589	(2)
Level 3 -- Assigning Specialists to Teams at CKG Auto	591	(1)
Troubleshooting Workbooks and Creating Excel Applications	592	(57)
Level 1: Preparing Error-Free Workbooks	594	(22)
Excel 2003 Skills Training (powered by SAM)	594	(1)
Planning an Excel Application	594	(1)
Controlling Data Entry Errors	595	(2)
Validating Data Using the Data Validation Tool	597	(6)
Circling Invalid Data	603	(1)
Protecting Workbooks	604	(2)
Locking and Unlocking Cells	606	(1)
Protecting a Worksheet	607	(1)
Hiding and Displaying Rows and Columns	608	(1)
Protecting a Workbook	609	(2)
Documenting Workbooks	611	(1)
Providing a Thorough Documentation Worksheet	612	(1)
Including Comments in a Worksheet	613	(2)
Steps To Success: Level 1	615	(1)
Level 2: Preventing Errors in Formulas	616	(14)
Excel 2003 Skills Training (powered by SAM)	616	(1)
Auditing Formulas	616	(1)
Using the Formula Auditing Tools	617	(2)
Tracing and Solving Formula Errors	619	(1)
Tracing Errors	620	(2)
Identifying and Correcting Errors	622	(2)
Tracing Precedent Cells	624	(1)
Tracing Dependent Cells	625	(3)
Setting Error-Checking Options	628	(1)
Steps To Success: Level 2	629	(1)
Level 3: Automating Excel Tasks	630	(13)
Excel 2003 Skills Training (powered by SAM)	630	(1)
Understanding Macros	630	(1)
Recording a Macro	631	(2)
Running a Macro	633	(1)
Creating a Macro Button	634	(2)
Editing a Macro in the Visual Basic Editor	636	(6)
Steps To Success: Level 3	642	(1)
Chapter Summary	643	(6)
Conceptual Review	643	(1)
Case Problems	644	(1)
Level 1 -- Troubleshooting Formulas and Data Entry for a Payroll Data Workbook for Irene's Scrapbooking World	644	(1)
Level 2 -- Troubleshooting Formulas for a Job Invoicing Workbook for David's Computer Repair	645	(1)
Level 3 -- Projected Sales and Commissions for CKG Auto	646	(3)
Glossary	649	(11)
Index	660