# West Los Angeles College Tab

part 5

• Open excel file:
• Click the Challenge tab in the bottom-left of the workbook.
• For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
• Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.
• part 6
• Open excel file:
• Click the Challenge tab in the bottom-left of the workbook.
• Apply a filter to show only Electronics and Instruments.
• Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
• Clear the Item Description filter.
• Using a number filter, show loan amounts greater than or equal to \$100.
• Filter to show only items that have deadlines in 2016.
• part 7
• Open excel file:
• Click on the Challenge tab in the bottom-left of the workbook.
• Sort the workbook by Grade from smallest to largest.
• Use the Subtotal command to group at each change in Grade. Use the SUMfunction and add subtotals to Amount Raised.
• Select Level 2 so that you only see the subtotals and grand total
• part 8
• Open excel file:
• Click the Challenge tab in the bottom-left of the workbook.
• Select cells A2:D9 and format as table. Choose one of the light styles.
• Insert a row between rows 4 and 5. In the row you just created, type Empanadas: Banana and Nutella, with a unit price of \$3.25, and a quantity of 12.
• Change the table style to Table Style Medium 10.
• In Table Style Options, uncheck banded rows and check banded columns.
• part 9
• Open excel file:
• Click the Challenge tab in the bottom-left of the workbook.
• Select cells A1:E6 and insert a 2D Clustered Column chart.
• Change the chart title to September to December Sales.
• Use the Switch Row/Column command. The columns should now be grouped by month, with a different color for each salesperson.
• Move the chart to a new sheet.
• Change the chart type to line with markers.
• Use the Quick Layout command to change the layout of the chart to Layout 4.
• ### Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount

Posted in Uncategorized