Microsoft Office Tutorials and References
In Depth Information
In the Lab 3: Expand Your World: Cloud and Web Technologies Online
Lab 3: Expand Your World: Cloud and Web Technologies
Problem: You are tasked with creating a travel expense report for two trips you made to
conferences during the past six months. You decide to download and use one of Excel’s templates
to create your worksheet.
Instructions Part 1: Tap or click the New tab in the Backstage view and then search for and
tap or click the Travel expense report template to download it. Enter data for two trips, one to
Las Vegas and one for San Diego, using the web to search for data. Save the le as Lab 1-3 Part 1
Travel Expenses. Print the worksheet. Submit the assignment as specied by your instructor.
Instructions Part 2: Which template would you use if you wanted to create a workout plan or
a training plan for employees?
Consider This: Your Turn
Apply your creative thinking and problem solving skills to design and implement a solution.
1: Create a Personal Budget
Part 1: To estimate your budget, you decide to create a worksheet listing your income and expenses.
Create a worksheet that lists your incomes and your expenses using estimates for the next six months.
Total your income and expenses. Calculate your net value using a simple formula. Use the concepts
and techniques presented in this chapter to format your worksheet and create a 3-D pie chart for your
net result for the six months. Submit your assignment in the format specied by your instructor.
Part 2: Now that you have looked over your results, did you neglect to include any income?
How did you determine the values you used in your estimates? Did you anticipate possible changes
in the near future?
2: Create a Sales Worksheet
Part 1: You are working for a popular sports restaurant that has ve branches. Your boss has
asked you to create a worksheet to show results for drinks, meals, games, and souvenir sales. Using
estimates, create the worksheet for Sports & You. Include totals and averages. Use the concepts
and techniques presented in this chapter to format the workbook. Include a chart to compare your
revenues. Submit your assignment in the format specied by your instructor.
Part 2: What steps did you use to create your estimates? Based upon your knowledge of
restaurants, do you think seasonal sales would be different, and if so, why?
3: Compare Car Prices
Research and Collaboration
Part 1: Working in a group, research current cars for sale. Create a worksheet that compares the
type of cars and the base price for each model, as well as the costs to add various additional options.
Calculate the average price for the cars and averages of the additional options. Use the concepts
and techniques presented in this chapter to format the worksheet. Include a chart to compare the
different car costs. Submit your assignment in the format specied by your instructor.
Part 2: Based upon the data you found, how could you chart the information to show the
comparisons? Which chart would be the best to use?