i need anwers of follwing quetions just excel formulas

1.

Zarika Enterprises is a consultative firm that specializes in retail construction using sustainable products. The firm began a new construction on Monday of the current week. This project comprises of five major activities. An activity begins on the next working day after the previous activity finishes. For example, Activity 2 begins the next working day after Activity 1. Assuming that working days are Monday to Friday and there are no holidays, design a spreadsheet that accepts as inputs the duration (in days) of the five activities. The spreadsheet should then display the date at which each activity completes.

2.

Using the world population estimates in the 2019 estimates worksheet, write a formula (in a separate worksheet) using the INDEX and MATCH functions to determine (based on a country and an estimate which the user of your worksheet chooses) the estimated data for that country. For example, if the user chooses the country, Canada and estimate, Net Migrants, the formula result should display 220,000. Set data validation restricting the selection of countries and estimates to the countries and estimates displayed in the 2019 estimates worksheet. If no country or estimate is selected, the result should not display #N/A.

3.

Watson Law Office would like to automate its billing system. The companys billing policy is net 21 EOM (the payment must be made in full within 21 days following the end of the month of the statement date). Create a model in which a user can enter a statement date, and the spreadsheet returns the appropriate due date. The formula should not display data if no statement date is entered.

4.

Look up the conversion of a Canadian dollar to Mexican peso, Japanese yen and Indian rupee. Suppose you want to create a spreadsheet model that will calculate the equivalent amount when a user enters an amount in Canadian dollars and chooses one of the three currencies. Set up the model in Excel.

5.

Springs Mill brews two types of beer, Barley Wine and Oatmeal Stouts. The brewery sells the beer in litre bottles. Barley Wine sells for $12 per litre and Oatmeal Stouts for $9.50 per litre. The per unit variable costs for Barley Wine include $2.75 in raw materials, $0.55 in packaging, $1.50 in manufacturing overhead and $0.65 in shipping. The per unit variable costs for Oatmeal Stouts include $1.50 in raw materials, no packaging costs, $1.00 in manufacturing overhead and $0.30 in shipping. Springs Mills fixed costs include office rent of $225, office supplies of $20 and marketing expenses of $30.

Create a spreadsheet that projects the income position of the brewing business should Springs Mill sell 100 litres of Barley Wine and 120 litres of Oatmeal Stouts. Assuming a unit to unit sale, what is a more profitable brew for Springs Mill? Determine the break-even for each beer, assuming that fixed expenses are divided equally between the two beers. Provide a chart showing the break-even point for each brew.

6.

Barkley employees take Sundays off, and the following holidays: Christmas Eve, Christmas Day, New Years Eve, New Years Day, February 14, May 5, July 15, and October 20. Design a spreadsheet model in which the user can enter start and end dates, and the worksheet returns the total number of working days? Your model should work for end dates entered up to and including December 31, 2026. The result should be blank if no dates are entered.

7.

Soho Dealership expects to sell 5,000 electric cars in 2019. Within the next few years, the company anticipates a competitor to enter the market. Soho expects to lose 25% of its market share the year in which the competitor enters. Assuming an annual sales growth of 8% for electric cars, create a model that computes the annual sales from 2019-2028.

8.

The tournament director for the World Trek Open would like to record the finishing time of each participants hike up Alexis Grind. Create a spreadsheet model that accepts as inputs the start time and end time of a participants hike. The spreadsheet should then return the hike duration in minutes.