Microsoft Office Tutorials and References
In Depth Information
In the Lab 3: Expand Your World: Cloud and Web Technologies
column by $20,000.00 until the lowest ending balance in cell F18 is greater than zero. Decrement
all 12 values in column D the same number of times. Your worksheet is correct when the lowest
ending balance in cell F18 is $39,361.00. Update the worksheet header and save the workbook.
Print the worksheet. Submit the assignment as specied by your instructor.
Lab 3: Expand Your World: Cloud and Web Technologies
Online
Problem: You want to create an estimate of the cost for attending your college for four years. You
decide to create the worksheet using the Excel web app so that you can share it with your friends
online.
Instructions: Perform the following tasks:
1. Sign in to your Microsoft account on the web and run the Excel web app. Create a blank
workbook. In the rst worksheet, use row headings for each year of college (Freshman,
Sophomore, Junior, and Senior). For the column headings, use your current expenses (such as
car payment, rent, tuition, and so forth). Enter estimates for each year based upon estimates
you nd by searching the web. Include totals for each column. Also include highest, lowest, and
average values for the columns. Using the techniques taught in this chapter, create appropriate
titles and format the worksheet accordingly. Submit the assignment as specied by your
instructor.
Consider This: Your Turn
Apply your creative thinking and problem solving skills to design and implement
a solution.
1: Analyze Energy Consumption
Personal
Part 1: Your parents believe that your late-night studying sessions and household appliance usage
contribute to excessive electricity bills. You have decided to try to prove them wrong by
analyzing your monthly electricity consumption. You research the energy consumption of your personal
items and appliance usage to obtain consumption costs per hour for each item. Table 2 – 8 contains
the data and format for the report you will create. Use the concepts and techniques presented in
this project to create and format the worksheet.
Table 2– 8 Appliance Electricity Usage Costs
Cost per Hour
Hours Used
Monthly
Total Cost per
Month (30 Days)
Appliance
Clothes dryer
$0.447
20
Computer
$0.08
150
Blu-ray player
$0.061
100
Light bulbs
$0.056
160
Sound system
$0.05
180
Television
$0.08
90
Washing machine
$0.06
30
Continued >
Search JabSto ::




Custom Search