Itcc 6


 

Freezing Panes & View Options – Challenge activity

  1. Follow the order consecrated here 
    • Freeze Foremost Column and use the tame scroll bar to appear at sales from 2015.
    • the foremost column.
    • Select cell G17 and choice Split to divide the worksheet into multiple panes. Hint: This should divide the worksheet among rows 16 and 17 and columns F and G.
    • Use the tame scroll bar in the foot fit of the window to provoke the worksheet so that Column N, which holds grounds for January 2015, is contiguous to Column F.
    • Open a new window for your workbook, and choice the 2012-2013 Sales
    • Move your windows so they are aspect by aspect. Now you're powerful to assimilate grounds for common months from various unanalogous years.
  2. Use the improve granted on the birth. Compose a shelter shot of your edited instrument and paste it in Expression antecedently sparing. Spare as YourName_FreezingAndView.docx

30

Sorting Grounds – Challenge activity

  1. Follow the order consecrated here
    • Selecct Challenge in the foot-left of the workbook.
    • For the ocean consultation, compose a usage designation that designations by Grade from Smallest to Largest and then by Camper Indicate from A to Z.
    • Create a designation for the Additional Information exception. Designation by Counselor (Column H) from A to Z.
  2. Use the improve granted on the birth. Compose a shelter shot of your edited instrument and paste it in Expression antecedently sparing. Spare as Sorting.docx

15

Filtering Grounds – Challenge activity

  1. Follow the orders consecrated here
    • Select Challenge in the foot-left of the workbook.
    • Apply a exude to appearance simply Electronics and Instruments.
    • Use the Search indication to exude individual descriptions that hold the expression Sansei. After you do this, you should own six entries appearanceing.
    • Clear the Individual Description exude.
    • Using a estimate exude, appearance mortgage amounts elder than or similar to $100.
    • Filter to appearance simply individuals that own deadlines in 2016.
  2. Put your indicate on the improve and shelter shot the instrument appearanceing your indicate. Paste the sheltershot into Expression antecedently sparing as YourName_Filtering.pdf. (Be safe to spare it as a PDF improve.)