Open up the following file and create a first spreadsheet: Lab 4 Example.pdfLab 4 ExampleB.docxdownload1. 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, 21m. thirteenth cell – Shopping, Day, $ 10.00, 212. 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 enter9. 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.
This question has been answered exceptionally by https://essayblazers.com/
Place a similar order with a custom made answer.
Your privacy is our assurance as well as great grades.
Try us today, you will not regret!
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more