BPC210 - Answer Key

Mesa Community College
Business Administration Department
BPC210 Answer Key - Office 2003


WORD Project 4 -Word Project 4 "District"- Park District Title Page.pdf Park District Proposal.pdf -Word Project 4 Apply Your Knowlege- Apply 4-1 Revised Meridian Profits Report.pdf -Word Project 4 Labs- Lab 4-1 Costume Barn Proposal.pdf Lab 4-2 Office Rentals Proposal.pdf Lab 4-3 Bus Route Proposal.pdf -Word Project 4 Cases- Case 4-1 Happy Homes Proposal.pdf Case 4-2 Greenfield Lawns Proposal.pdf Case 4-3 RSM Industries Proposal.pdf Case 4-4 Market Solutions Proposal.pdf Case 4-5 Planning Proposal.pdf Project 5 -Word Project 5 "Campground"- Camper Directory.pdf Campground Envelopes.pdf Campground Form Letter.pdf Campground Labels.pdf -Word Project 5 Apply Your Knowlege- Apply 5-1 Wellness Form Letter Revised.pdf Apply 5-1 Merged Form Letters.pdf -Word Project 5 Labs- Lab 5-1 TLC Auto Care Directory.pdf Lab 5-1 TLC Auto Care Form Letter.pdf Lab 5-1 TLC Auto Care Labels.pdf Lab 5-2 Global Coffee Envelopes.pdf Lab 5-2 Global Coffee Form Letter.pdf Lab 5-2 Global Coffee Labels.pdf Lab 5-2 Global Coffee Member Directory.pdf Lab 5-3 CADdesign Directory.pdf Lab 5-3 CADdesign Form Letter.pdf -Word Project 5 Cases- Case 5-1 Member Directory.pdf Case 5-1 Royal Oaks Form Letter.pdf Case 5-1 Royal Oaks Mailing Labels.pdf Case 5-2 Cover Letter Form Letter.pdf Case 5-2 Cover Letter Mailing Labels.pdf Case 5-2 Potential Employer List.pdf Case 5-3 Lawn Care Customer List.pdf Case 5-3 Lawn Care Form Letter.pdf Case 5-3 Lawn Care Mailing Labels.pdf Case 5-4 American Fashions Applicant List.pdf Case 5-4 American Fashions Form Letter.pdf Case 5-4 American Fashions Mailing Labels.pdf Case 5-5 Data Sources.pdf Project 6 -Word Project 6 "Samples"- Clever Clicks Online Newsletter.pdf Computer Virus Symptoms Diagram.pdf -Word Project 6 Apply Your Knowlege- Apply 6-1 Certification Information Revised.pdf -Word Project 6 Labs- Lab 6-1 Old Town Newsletter.pdf Lab 6-2 Clubs Diagram.pdf Lab 6-2 Northside Newcomers Newsletter.pdf Lab 6-3 Community Chatter Newsletter.pdf -Word Project 6 Cases- Case 6-1 Learn It Online.pdf Case 6-2 Green Thumb Gazette.pdf Case 6-3 Pennywise Press.pdf Case 6-4 Frosh World Newsletter.pdf Case 6-5 Review Newsletter.pdf Other Project Items -Word "Collaboration Feature"- Rocky Mountain Outline.pdf Rocky Mountain Outline Final.pdf Rocky Mountain Slide Show.pdf Lab CF-3 Home Renovation Article Revised.pdf Lab CF-1 Wellness Outline.pdf Lab CF-1 Wellness Slide Show.pdf Lab CF-2 Spotlight Athlete Revision 1.pdf Lab CF-2 Spotlight Athlete Revision 2.pdf Lab CF-2 Spotlight Athlete Revision 3.pdf Lab CF-2 Spotlight Athlete Revision 4.pdf -Word "Integration Feature"- Customer Base Breakdown.pdf Customer Breakdown Memo.pdf Lab IF-1 Royal Oaks Facility Usage Memo.pdf Lab IF-2 Royal Oaks Facility Usage Memo with Chart.pdf Lab IF-3 Fair Deal Realty Sales Figures.pdf Lab IF-3 Fair Deal Realty Sales Memo.pdf -Word "Web Feature"- Benjamin Okamoto.pdf Okamoto Personal Web Page.pdfL Okamoto Resume Web Page.pdf Leah Malone.pdf Lab WF-1 System Unit Paper Web Page A.pdf Lab WF-1 System Unit Paper Plain Text txt.pdf Lab WF-1 System Unit Paper Web Page B.pdf Lab WF-2 Malone Personal Web Page.pdf Lab WF-2 Malone Resume Web Page.pdf	EXCEL Project 4 -Excel Project 4 "Bank"- WeSavU National Bank.pdf e-Money Lenders Loan Payment Calculator.pdf e-Money Lenders Statement of Condition.pdf -Excel Project 4 Apply Your Knowlege- Apply 4-1 Determine Monthly Loan Payment Answer.pdf -Excel Project 4 Labs- Lab 4-1 Part 1 401(k) Planning Sheet.pdf Lab 4-1 Part 2 401(k) Planning Sheet.pdf Lab 4-2 Celine's Scooter Supply Ltd Quarterly Income.pdf Lab 4-3 Internet Bank of Chicago Loan Calculator.pdf -Excel Project 4 Cases- Case 4-1 Straight Line Depreciation.pdf Case 4-2 Break-Even Analysis.pdf Case 4-3 Future Value.pdf Case 4-4 Goal Seek.pdf Case 4-5 Present Value.pdf Project 5 -Excel Project 5 "Soccer Gear Sales"- Soccer Gear Sales Rep List.pdf Soccer Gear Sales Rep List CSV.pdf -Excel Project 5 Labs- Lab 5-1 Apothecary Sales Rep List.pdf Lab 5-1 Apothecary Sales Rep List CSV.pdf Lab 5-2 Programmer Specialist List Final.pdf Lab 5-3 Enviro Student Club List.pdf Lab 5-3 Enviro Student Club List Final.pdf -Excel Project 5 Cases- Case 5-1 Allied Sports Inventory List.pdf Case 5-2 Allied Sports Inventory List Subtotals by Priority.pdf Case 5-3 Allied Sports Inventory List Filtered.pdf Case 5-4 Working Together.pdf Project 6 -Excel Project 6 "AWI"- AWI Company Profit Potential.pdf AWI Lexington Profit Potential.pdf AWI San Diego Profit Potential.pdf Awesome Images Profit Potential Template.pdf Awesome Images Profit Potential.pdf AWI Cleveland Profit Potential.pdf -Excel Project 6 Apply Your Knowlege- Apply 6-1 Annual Payroll 1.pdf Apply 6-1 Co Emp.pdf Apply 6-1 Qtr 1 Emp.pdf Apply 6-1 Qtr 2 Emp.pdf Apply 6-1 Qtr 3 Emp.pdf Apply 6-1 Qtr 4 Emp.pdf -Excel Project 6 Labs- Lab 6-1 Jogger's Wear.pdf Lab 6-1 Jogger's Wear Template.pdf Lab 6-2 Web Salon Quarterly Sales Analysis.pdf Lab 6-3 Golden Stock Club Portfolio.pdf -Excel Project 6 Cases- Case 6-1 Special Toys Balance Sheet.pdf Case 6-1 Special Toys Balance Sheet Template.pdf Case 6-2 Tennis Summary Template.pdf Case 6-2 Tennis Summary.pdf Case 6-3 Tupelo's Budget Proposal Template.pdf Case 6-3 Tupelo's Budget Proposal.pdf Case 6-4 Specialties for Everyone.pdf Case 6-5 Tupelo's PSD Budget Proposal.pdf Case 6-5 Tupelo's PSD Fire Dept Budget Proposal.pdf Case 6-5 Tupelo's PSD Police Dept Budget Proposal.pdf Case 6-5 Tupelo's PSD S&S Dept Budget Proposal.pdf -Excel PivotTable List Features- Miles-To-Go Cabs PivotTable.pdf Lab WF2-1 Guru's Stock Club PivotTable.pdf Lab WF2-2 GPA Tutoring PivotTable.pdf -Excel "Integration Feature"- Weekly Sales Summary.pdf Weekly Sales Memorandum 12-19-2005.pdf Lab IF-1 Annual Sales Memorandum 1-9-06.pdf Lab IF-1 Quarterly Sales Summary.pdf Lab IF-1 Annual Sales Memorandum.pdf Lab IF-2 Quarterly Sales Summary with Memo 1-9-06.pdf -Excel "Web Features"- Web Feature Home Wireless Fidelity Quarterly Sales Dynamic Web Page.pdf Home Wireless Fidelity Quarterly Sales Static Web Page.pdf -Excel "Web Feature Exercises"- Lab WF-1 Awesome Intranets Annual Sales Dynamic Web Page.pdf Lab WF-2 Hard Disk Storage Plus Projections Dynamic Web Page.pdf Lab WF-1 Awesome Intranets Annual Sales Static Web Page.pdf Lab WF-2 Hard Disk Storage Plus Projections Static Web Page.pdf	ACCESS Project 4 -Access Project 4 Projects- -Excel "Ashton James College"- Ashton James College.pdf -Access Apply Your Knowlege- Begon Pest Control.pdf -Access Labs- Birds2U.pdf Babbage Bookkeeping.pdf City Guide.pdf -Access Cases- College Dog Walkers.pdf InPerson Fitness Company.pdf Regional Books.pdf Campus Housing.pdf Project 5 -Access Project 5 Projects- -Access "Ashton James College"- Ashton James College.pdf -Access Apply Your Knowlege- Begon Pest Control.pdf -Access Labs- Birds2U.pdf Babbage Bookkeeping.pdf City Guide.pdf -Access Cases- College Dog Walkers.pdf InPerson Fitness Company.pdf Regional Books.pdf Campus Housing.pdf Project 6 -Access Project 6 Projects- -Access "Ashton James College"- Ashton James College.pdf -Access Apply Your Knowlege- Begon Pest Control.pdf -Access Labs- Birds2U.pdf - apply2 Babbage Bookkeeping.pdf City Guide.pdf - apply4 -Access Cases- College Dog Walkers.pdf InPerson Fitness Company.pdf Regional Books.pdf Campus Housing.pdf -Access "SQL Feature"- Begon Pest Control.pdf Birds2U.pdf -Access "Integration Feature"- Integration Feature In the Lab 1.pdf Integration Feature In the Lab 2.pdf Integration Feature Step-by-Step.pdf -Access "Web Feature"- Ashton James College.pdf Babbage Bookkeeping.pdf Begon Pest Control.pdf

POWERPOINT Project 3 -PowerPoint Project 3 "Hidden Lake"- Hidden Lake.pdf -PowerPoint Project 3 Apply Your Knowlege- Apply 3-1 Computer Security.pdf -PowerPoint Project 3 Labs- Lab 3-1 Race.pdf Lab 3-2 Five a Day.pdf Lab 3-3 Wolf Exhibit.pdf -PowerPoint Project 3 Cases- Case 3-1 Casey.pdf Case 3-2 Menu.pdf Case 3-3 Camcorders.pdf Case 3-3 Camcorders Outline.pdf Case 3-4 Massage.pdf Case 3-5 Nutrition Counselor.pdf Project 4 -PowerPoint Project 4 "Cash for College"- College Finances ppt.pdf College Finances rtf.pdf -PowerPoint Project 4 "Europe"- Lab 4-3 Europe ppt.pdf Lab 4-3 Europe rtf.pdf -PowerPoint Project 4 "Fish"- Apply 4-1 Seattle.pdf -PowerPoint Project 4 "Northlake College"- Lab 4-2 Job Fair.pdf -PowerPoint Project 4 Labs- Lab 4-1 Credit Card.pdf -PowerPoint Project 4 Cases- Case 4-1 Bobby's Bodacious Bikes.pdf Case 4-2 Dating Services.pdf Case 4-3 Copyrights.pdf Case 4-4 Energy Bars.pdf Case 4-5 Hybrid Cars.pdf -PowerPoint "Collaboration"- Lab CF-1 New Rocky Mountain Tundra.pdf Lab CF-2 Nutrition and Fitness Revised.pdf Lab CF-3 Financial Aid.pdf Ride Smart Final.pdf -PowerPoint "Online Feature"- Completion Certificate.pdf Food Pyramid.pdf Lab OF-1 Five a Day.pdf Lab OF-2 Europe.pdf Lab OF-3 Company Background.pdf Travel Checklist.pdf -PowerPoint "Web Feature"- -PowerPoint "College Success"- Lab WF 1-1 Lakemore.pdf Lab WF 1-1 Lakemore Update.pdf -PowerPoint "Healthy Exercise"- Lab WF 1-2 Nutrition.pdf Lab WF 1-2 Nutrition Update.pdf -PowerPoint "Tutoring Web File"- Lab WF 1-3 Tutor Position.mht.pdf Lab WF 1-3 Tutor Position.ppt.pdf -PowerPoint "Web Feature"- Home Office Single File Web Page.pdf Home Office Web Page.pdf	OUTLOOK Outlook Project 2 -Outlook Project 2 "Maria's Calendar"- Maria's Calendar.pdf -Outlook Project 2 Apply Your Knowlege- Apply 2-1.pdf -Outlook Project 2 Labs- Lab 2-3 A-1 Hardware.pdf Lab 2-3 A-1 Tasks.pdf	INTEGRATION Case Studies -Case- Eastlake Letterhead.pdf Eastlake Membership Update.pdf Eastlake Swim Club - Solution.pdf Rain City Coffee doc.pdf Rain City Coffee ppt.pdf Web Investors.pdf Web Portfolio rtf.pdf Web Portfolio xls.pdf

Email corrections to Christine Held : cheld@mail.mc.maricopa.edu

Business Administration Department
1833 W. Southern Ave. (480) 461-7725
Mesa, AZ 85202-4866

Revised: 8/25/2004 - www.mc.maricopa.edu/dept/d07/bpc110/2003_bpc210_answers.html