Do exercise as it aouod appear in excel & please provide formulas.

*would

VidAl The following table shows the historical prices of a gallon of gasoline in several countries at four year intervals. These are average prices, including taxes, of a U.S. gallon in U.S. dollars 4-5 Gasoline Retail Prices in Selected Countries of the Most Widely Sold Type of Gasoline (Average pump price in U.S. dollars per gallon, including taxes) Source: World Bank. http://data.worldbank. org/indicator/EP. PMP.SGAS. CD/ 2010 2014 2006 2002 1998 Australia Brazil $1.74 1.89 3.52 4.8 4,66 3.03 2.08 4.77 5.98 4.81 6.78 France Korea, Republic of Saudi Arabia United States 4.20 3.97 5.60 6.25 7.50 3.52 4.13 5.75 5.87 0.61 0,91 0.61 0.61 0.61 2.88 1.21 1.51 2.38 2.88 (a) Add rows at the bottom for average price, maximum price, and minimum price. Use functions and the Fill operation. (b) Use Auto Fill to show the predicted prices for 2018, 2022, 2026 for each country, assuming a linear trend. Fill the calculation rows out three columns to the right. Format all cells with two places to the right of the decimal point 77 SIMPLE FUNCTIONS AND THE FILL OPERATION Create a worksheet to calculate the wages for hourly employees. 4-6 (a) Start off with a heading, the names of the emplovees, and the hours worked each day. Try using Auto Fill for the days of the weeks. Type in the numbers of hours worked each day. Use a variety of numbers. Payroll Week of Sat Sun Name Mon Fri Tue Wed Thu Abel, Ann Gonzalez, Maria Shu, Ryan Wall, John (b) Add a column at the end to calculate total hours worked for each employee. Use the SUM function. (e) Add a column with the hourly wage for each employee. Use a different wage for each employee. Be generous. (d) Add a column to automatically calculate the gross wages earned for the week. (e) Add a column for federal tax withholdings of 20 % of gross wages. (f) Add a column for state tax withholdings of 5 % of gross wages. (g) Add a column for medical deduction of $17 per week. (h) Add a column for take-home pay (gross wages minus withholdings and deductions). (i) Add rows at the bottom for the total and the average of each of the columns. Use the SUM and AVERAGE functions and Fill. () Format appropriate cells with $ signs and to two decimal places to the right of the decimal point. (k) Format the worksheet so it is as attractive and readable as possible