Office 2010 On Demand - Textbook Example Files
Frank's Word Examples - Supplemental Files
Word Examples: Excel_Examples_Frank.zip
Image File Zip: Images.zip
Office 2010 Study Guide - Textbook Example Files
How to Download & Unzip Files from the Internet
To Download from Internet Explorer:
- right-click on the link
- select "save target as"
- navigate to the folder where you want to save the file
To unzip after downloading:
- right-click on the zip file within Windows Explorer (My Computer)
- from "folder view" select "extract" or "extract all"
- follow the prompts
Project 1 - Consumer Sports Workbook
Project Specifications:
Download and save the Consumer_Sports.xls Workbook
(Note: do not open it from within the browser)
- Insert formulas to calculate the total revenue for each year, total revenue for each sport, and the average revenue for each sport.
- Add appropriate titles for the last two columns -Total and Average.
- Adjust the columns so you can see the entire contents.
- Format the data to look similar to the final handout.
- Save the Workbook.
Project 2 - State Codes
Project Specifications:
- Using this State Code link: State Code Table Link, copy the table of State and Abbreviations into a new Excel Workbook
- Separate the State and Abbreviations into 2 columns
- Format all columns to left justify, Calibri 12 font
- Change the Case of the State names column to Capitalize the first letter of each word (For Example, "NEW JERSEY" becomes "New Jersey") Hint: use a function
Project 3 - Full Time Programs Charts
Project Specifications:
- Download, save this Excel workbook, and open it from Excel: Fulltime_Programs.xls
- Save it as a 2007 Excel Workbook
- Select range A3 to D11
- Chart 1- Create a column chart that looks similar to: Fulltime_Programs_Chart1.pdf
- Chart 2 - Use the same range to create a pie chart that looks similar to: Fulltime_Programs_Chart2.pdf
Additional Examples
Printing Excel Workbooks (Activity 6-1, 6-2, 6-3): Sales_Ledger_Final.xls
Managing Range Names in Workbooks (Activity 1-1): Last_Fiscal_Sales.xls
Creating Formulas Across Multiple Worksheets (Activity 1-2): Department_Wise_Revenue.xls
Use Test Functions to Generate Reports (Activity 1-3): Employee_List.xls
Entering Functions that Apply Logical Analysis (Activity 1-4): Employee_Bonus.xls
Locating Part Numbers (Activity 1-5): Product_IDs.xls
Creating and Manipulating Tables (Activity 2-1): Inventory.xls
Formatting a Table (Activity 2-2): New_Employees_List.xls
Creating a Custom table Style (Activity 2-3): New_Employees_List.xls
Sorting and Filtering Tables (Activity 2-4): Inventory.xls
Applying Calculations to a Table or Worksheet (Activity 2-5): Quarter_1_Sales.xls
Creating Charts (Activity 3-1): Annual_Report.xls
Changing a Chart Type (Activity 3-2): Annual_Report.xls
Modifying a Chart (Activity 3-3): Annual_Report.xls
Formatting a Chart (Activity 3-4): Annual_Report.xls
