i need to do a budget expense report. i am usuing san diego as my destination ans i dont understand how to input formulas on a excel sheet

View Zoom Insert Table Chart Text Shape Comment Collaborate + Grading Sheet Budget Expenses Loans Stats Data App G H J K L M N 0 P 1 Input Name Here Formula Required Each cell is color coded as indicated to the left. The cell will change to grey after it has been Number/Text completed. 2. 3 4 Budget Total: formula 5 citation 6 7 8 9 10 11 citation 12 13 You are going on a dream vacation with five of your closest friends for a week. Since you are taking a math course, your friends asked you to come up with a budget to see how much it will cost each of you. Please identify your location in the US input in Cell D2) and then determine the total costs (for everyone going). remember to be thorough so the group does not run out of money. Your expense list must include the following (this means that you cannot book an all-expenses paid trip): Travel expenses, such as plane or bus fare, local travel within the area. Lodging expenses. If you plan to camp, you will include expenses for your camping gear. 14 15 16 17 18 citation 19 Food expenses while you are on your trip. One way to do this is to research cost of living in your destination county to find out what a local family would expect to budget to pay for food. Another is to research local restaurants and groceries, 20 21 -Entertainment or activity expenses and/or miscellaneous expenses that may occur. 22 23 24 125 citation 26 27 28 29 Grading Sneel F D B A Location California Transportation Qty Price each Total price numbers Number or NA Formulas $49.00 49.5= Source Link or citation Item Description Plane ticket (Add rows as needed) Item Description Lodging Qty Price each numbers Number or NA Total price Formulas Link or citation Un 3 4 15 16 (add rows as needed) - ge Food Price each numbers Number or NA Item Description Qty Total price Formulas Link or citation F liv to (add rows as needed) .En 17 18 19 20 21 22 23 24 25 26 27 28 29 Item Numbers Entertainment and Misc. Qty Price each Total price numbers Number or NA Formulas Link or citation (add rows as needed) Formatted 2 MacRool View Zoom Insert Table Chart Text Shape Comment Collaborate + Grading Sheet Budget Expenses Loans Stats Data App G H J K L M N 0 P 1 Input Name Here Formula Required Each cell is color coded as indicated to the left. The cell will change to grey after it has been Number/Text completed. 2. 3 4 Budget Total: formula 5 citation 6 7 8 9 10 11 citation 12 13 You are going on a dream vacation with five of your closest friends for a week. Since you are taking a math course, your friends asked you to come up with a budget to see how much it will cost each of you. Please identify your location in the US input in Cell D2) and then determine the total costs (for everyone going). remember to be thorough so the group does not run out of money. Your expense list must include the following (this means that you cannot book an all-expenses paid trip): Travel expenses, such as plane or bus fare, local travel within the area. Lodging expenses. If you plan to camp, you will include expenses for your camping gear. 14 15 16 17 18 citation 19 Food expenses while you are on your trip. One way to do this is to research cost of living in your destination county to find out what a local family would expect to budget to pay for food. Another is to research local restaurants and groceries, 20 21 -Entertainment or activity expenses and/or miscellaneous expenses that may occur. 22 23 24 125 citation 26 27 28 29 Grading Sneel F D B A Location California Transportation Qty Price each Total price numbers Number or NA Formulas $49.00 49.5= Source Link or citation Item Description Plane ticket (Add rows as needed) Item Description Lodging Qty Price each numbers Number or NA Total price Formulas Link or citation Un 3 4 15 16 (add rows as needed) - ge Food Price each numbers Number or NA Item Description Qty Total price Formulas Link or citation F liv to (add rows as needed) .En 17 18 19 20 21 22 23 24 25 26 27 28 29 Item Numbers Entertainment and Misc. Qty Price each Total price numbers Number or NA Formulas Link or citation (add rows as needed) Formatted 2 MacRool