1) In an Excel Workbook: (30%) a

Subject:Computer SciencePrice: Bought3

Share With

1) In an Excel Workbook: (30%) a. b. Create a project budget template for your trip The project budget template should contain the following: i. Trip details (name, start date, end date, max available budget) ii. The list offlights to be taken with costs iii. The list of visits and activities to be performed iv. The details list of activities (with detailed costs) v. The expected expenses for each task or subtask (including hotels, restaurants and shopping) vi. Group the tasks by categories vii. Calculate the total amount of expenditure viii. Write a function that compares the total amount of expenditure with the available budget and that displays whether this trip is feasible or not ix. Write a function that takes a task/activity name as input and returns the cost

2) The Excel workbook will be evaluated based: a. b. c. d On the good presentation and formatting of your data On the organization of the data and whether they are logical or not The functions and formulas used Use of conditional formatting (here you have to choose your own designs and conditions) Add a chart with formatting