In cells B$4$:B$15,$ type a yearly salary for each staff member. Format these values as Currency with no decimal places.

Calculate the new salary with a $10\%$ increase in column C$.$

Calculate the new salary with a $15\%$ increase in column D$.$ The increase should be over the original or Current Salary $($Column B$).$

Calculate total salaries for each level in cells B$16$:D$16.$

In cell A$16,$ type: Totals.

In cell A$18,$ type: Average.

In cell A$19,$ type: Median.

Calculate the average and median salary for each column in cells B$18$:D$19.$

In cell B$21,$ and type this sentence: "Type ID in cell B$22."$ including the period. Type one of the staff IDs from column A in cell B$22.$

Select cell C$22.$ Build an XLOOKUP $($or VLOOKUP$)$ function to display the salary with a $10\%$ increase for the staff ID shown in cell B$22.$ Format the results as Currency with no decimals.

Test your function by typing a different staff ID in cell B$22.$

Type a name for the company in cell A$1.$ Select A$1$:D$1$ and apply Merge & Center.

Type a description of the data in cell A$2.$ Select A$2$:D$2$ and apply Merge & Center.

Increase the Row Height of Row $3$ to $30.$

Insert the TODAY function in cell D$25.$

Name the sheet Salaries and set a tab color.

Complete formatting on the sheet to relate and highlight sections of the data. Change the theme, set alignment, apply cell styles, build borders, and fill. Continue to professionally format your worksheet by applying different formatting techniques.

Add a footer that shows the file name in the right section.

Set document properties to show your name as the author and the company name as the title.