Data Files

Please note that all of the files below should be used in conjunction with the textbook chapter narratives and contexts. All data files have corresponding information, steps, screenshots, tips, and more in the chapters they are embedded in. Each data file has its sources noted in either the textbook narrative or the file itself.

Chapter

Data Files

1. Fundamental Skills

Chapter 1 Practice

2. Formulas, Functions, Cell References

Chapter 2 Data file: Personal Budget

3. More on Formulas, Logical and Lookup Functions

Chapter 3 Data file

Chapter 3 Practice

4. Presenting Data with Charts

Chapter 4 Data file

Chapter 4 Practice: Crude Oil Imports

5. Excel Tables

Chapter 5 Data file: Weather Data

Chapter 5 Practice 1: Tourism Data

Chapter 5 Practice 2: Audible Data

6. PivotTables & PivotCharts

Chapter 6 Data file: U.S. Dept. of Education

Chapter 6 Practice 1: U.S. Energy Information Administration

Chapter 6 Practice 2: FDA Food Recall Data

Chapter 6 Practice 3: CFBP Complaint Data

7. Multiple Sheet Files

Chapter 7 Data file: Budgeting

Chapter 7 Practice: Sports Data

8. Advanced Logic & Conditional Functions

Chapter 8 Data file: U.S. Dept. of Education, Revisited

Chapter 8 Practice: U.S. Dept. of Transportation

9. Functions for Personal Finance

Chapter 2 Data file: Personal Budget, Revisited

Chapter 9 Practice: Lawn Care Business Data

10. Integrating Microsoft Office Suite Applications

Chapter 10 Data file: Miscellaneous Data