Task 1: Go to cells A5:A9. Change the horizontal format from General to Right Indent and indent 5 spaces.
Task 2: Show all formulas in the document.
Task 3: Set the width of columns B through E to 40. Set the height of row 2 to 30.
Task 4: Insert (line) Sparklines in column G which shows the cookies per hour data from columns C D E F
Task 5: Name the range B4:B8 JUNKFOOD.
Task 6: Set conditional formatting to highlight cells with YELLOW FILL WITH DARK YELLOW TEXT for any number below 40.
Task 7: Use a function to show the highest value in the range G3-G25
Task 8: Title the chart Fastest Animal and swap the data over the axis
Task 9: Do a multi level sort. Sort by Last Name and then School and then Class Of
Task 10: Filter the data to show only "single" people.
Task 11: In column G figure out how much tax is paid by each person. You will have to multiply each persons earnings by the tax rate in I7.
Task 12: Delete cell E16 to align the template properly
Task 13: Move chart to a new sheet and name it COLLEGE CLASS
Task 14: Apply the Colorful Palette 3 style to the chart.
Task 15: Convert the range A1:F20 to a table. Insert a total row. Calculate the average earnings for column F.
Task 16: Remove row 10 and Column G from the spreadsheet.
Task 17: Wrap the text in cells A2:K2
Task 18: If a cell is empty, that means that the employee had no sales that month. Use a formula to count the months that each employee had no sales.
Task 19: For task 19 you have to do two things.
1.) Set conditional formatting in the range B3:L9 to highlight the text with Green Fill With Dark Green Text for any number over 10.
2.) In Column O, use a formula to count how many months each employee had more than 10 sales.
1.) Set conditional formatting in the range B3:L9 to highlight the text with Green Fill With Dark Green Text for any number over 10.
2.) In Column O, use a formula to count how many months each employee had more than 10 sales.
Task 20: In the space provided from C3:C13, use a formula to make all letters in D3:D13 Upper Case
Task 21: There are 3 steps to this worksheet.
1.) In cell D2, use a formula to take the first 5 characters from each cell in column E2 (pull this formula down until D21).
2.) In cell G2 , use a formula to take the last 3 characters from each cell in column H2 (pull this formula down until H21).
3.) In cell J2, CONCAT B2, D2 and G2 (pull this formula down until J21).
1.) In cell D2, use a formula to take the first 5 characters from each cell in column E2 (pull this formula down until D21).
2.) In cell G2 , use a formula to take the last 3 characters from each cell in column H2 (pull this formula down until H21).
3.) In cell J2, CONCAT B2, D2 and G2 (pull this formula down until J21).
Task 22: Use a function to create email addresses for the new students above. Emails should have first name graduation year and (at)gmail.com
Task 23: Create a function to display "WE RICH" if units sold is over 50 and "KEEP HUSTLIN" if units sold is under 50.