West Los Angeles College Tab

part 5

  • Open excel file: download
  • 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: download
  • 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: download
  • 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: download
  • 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: download
  • 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