Question

Please provide a step by step solution

create a Vacation Budget worksheet Add at least 6 other expenses related to your planned vacation (car rental etc.) enter an estimate of the cost of for each item Use a function to calculate the total estimated costs. g) Enter a function to calculate the average cost per day. h) Create a chart (you choose the type) in this same worksheet based on this trip to display the estimated costs. Add a title and a legend and format the chart in a professional, easy read manner

Estimated Vacation Expenses:
Item	Cost	Notes
Airfare
Hotel
Food

Answer 1

Creating a vacation Worksheet for Assam Trip in India For 2 Days

A)

My expenses Includes

• Flight
• Hotel(per night)
• taxi & Bus
• Breakfast
• Lunch
• Dinner
• snacks & Drinks
• Museum Tickets
• Shooping
• Tour guide

B)

Estimated Calculation Of my Vacation EXpenses On a worksheet

Formula/Function used For calculating Average Total Expenses in a Day =SUM(G5:G14)

Formula/Function used For calculating Total Expenses =SUM(F5:F14)

Formula used for calculating the Amount based on units is =IF(ISBLANK(E6),0,IF(ISBLANK(C6),E6,C6*E6))

C)

Bar Chart on the Estimated Calculation

D)

Estimated Calculation Based on Percentage Of my Expenses

Calculation Of Amount= SUMIF($D$5:$D$14,"="&J4,$F$5:$F$14)

calculation of Percentage =(L4/$I$7)

Calculation of amount of Other Expenses =I7-SUM(L4:L5)

E)

Total View Of My Worksheet Based On Aboved Instruction/Data