Computer Lab

Open up the following file and create a first spreadsheet: Lab 4 Example.pdf
Lab 4 ExampleB.docx
download
1. type all the data as it is shown in the example and then format it afterwards.
a. first cell – Budget
b. second cell – Three-Week Trip to Europe
c. third cell – Expense Unit Unit Cost Number Total
d. fourth cell – Airfare from Los Angeles, Ticket, $ 850.00, 1
e. fifth cell – Accommodations: Youth Hostels, Night, $ 30.00, 10
f. sixth cell – Accommodations: Pensions, Night, $ 80.00, 8
g. seventh cell – Accommodations: Hotels, Night, $ 100.00, 3
h. eight cell – Food, Day, $ 75.00, 11
i. ninth cell – Food: Hostels, Day, $ 20.00, 10
j. tenth cell – Car Lease, Week, $ 400.00, 2
k. eleventh cell – Gas, Kilometer, $ 1.50, 40
l. twelfth cell – Sightseeing, Day, $ 20.00, 21
m. thirteenth cell – Shopping, Day, $ 10.00, 21
2. adjust columns from A to B so that the labels on the left that starts with “Airfare from Los Angeles” so that it does not overlap to the next column.
3. highlight “Budget” from left to right until you are just over the totals below and select merge and center.
4. highlight the “Three-Week Trip to Europe” and merge and center it like you did “Budget”.
5. For Budget – make the font size 18 and change the background to dark red by choosing the paint bucket icon and selecting dark red. Change the font to white.
6. highlight “Three-Week Trip to Europe” and change the font to size 16, dark blue.
7. highlight “Unit Unit Cost Number Total” do a right-click and choose format cells, alignment, on the “Degrees” box, type the number 90.
8. in the first totals box, enter an equal sign, select the first unit cost, put in a * and select the first number under the label Number. Hit enter
9. On the bottom right hand corner, select the dark black cross – autofill handle and copy it all the way down.
10. Total this totals column by selecting the empty cell below the las total and select auto sum and enter. To the left of that total type Expense Subtotal. Adjust column as necessary.
11. Select the cell under that total and type the formula: =.10*4605 and enter. To the left of that total type – Contingency: 10%
12. Add the two totals ( contingency and expense subtotal) select the empty cell below and select auto sum. Adjust the circular cell reference so that it highlights the two totals and then enter.

Last Completed Projects