Borough of Manhattan Community College Raybridge Recruiting Sales Report Worksheet

1.Lindsey Sawyer is the director of recruiting and business development for Raybridge Recruiting in Washington, D.C. She has been analyzing sales and commissions for recruiters in an Excel workbook and has asked you to help her complete the analysis.

Go to the Sales worksheet. Rename the Sales worksheet as Sales and Commissions, which is a more accurate name.

2.Unfreeze column A so it is not displayed when you scroll horizontally.

3.Middle-align the contents of the merged cell A1 to improve the appearance of the worksheet title.

4.In cell B3, insert a formula that uses the NOW function to display today’s date.

5.Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistent number format for the sales data.

• Lindsey wants to show the sales trend for each position and month from January to June. Provide this information as follows:
  • In cell H6, insert a Line sparkline based on the data in the range B6:G6.
  • Use the Fill Handle to fill the range H7:H10 without formatting based on the contents of cell H6.
  • Change the color of the sparklines in the range H6:H10 to Dark Purple, Text 2 (4th column, 1st row of the Theme Colors palette) to emphasize them.

d.Show a High Point and a Low Point in the sparklines to make those values easy to identify.