To answer this question, complete the lab using the information below. You will only be allowed one attempt to complete this lab.

Complete the following tasks in order:

1. From the Data sheet, create a PivotChart using the default settings. Set Solution for Rows, Month for Columns, and Revenue for Values.
2. On the new Sheet1 sheet, add a Solution slicer and set it to Endpoint Security.
3. On the Sales Calls sheet, make the following changes:
   • Change the histogram settings to have an overflow bin of 25 and an underflow bin of 15.
   • Change the formatting of the horizontal axis labels to be numbers with no decimal places.
4. On the Loan sheet, in cell D5, determine how many months it would take to repay the loan.
5. On the Project Planning sheet, in cell C5, calculate the completion date for Project A if you do not work weekends or holidays. Use the defined name range Holidays.
6. On the Project Planning sheet, do the following tasks:
   • In cell F3, determine the day of the week for the Project start date.
   • In cell F4, determine the day of the week for the Project end date.