Available Answers

1. 1.

   Fill in the blanks with the correct words.

   Auto Fill, Flash Fill, DATA, Delete, Ascending

   1. To delete a list in Custom lists, select it and click the ___________ button.
   2. Sorting and filtering options are available on the HOME and ___________ tabs.
   3. The ____________ feature allows you to fill a range of cells with a series of data without actually typing it.
   4. Click ↓ button to sort the data in _____________ order.
   5. The ______________ feature recognizes the data fill pattern in a worksheet and fills the remaining series accordingly.
2. 2.

   Write T for the true statement and F for the false one. Correct the false statements (s).

   1. You can sort data on only one column or field.
   2. You can add your own list in Custom Lists.
   3. Once you filter the data, you cannot get it back.
   4. You can filter the data based on certain specific conditions.
   5. You can copy the conditional formatting to other cells using the Format Painter tool.
3. 3.

   Choose the correct option.

   1. button is used for
      1. Conditional formatting
      2. Cell style
      3. Format as Table
      4. Filter
   2. The filter button  means
      1. Filter is applied
      2. Filter is enabled but not applied
      3. Filter is disabled
      4. None of these
   3. button sorts the data in
      1. ascending order
      2. descending order
      3. have to specify the order
      4. none of these
   4. To know about which filtering criteria is applied
      1. Bring the mouse pointer over the filter button, it displays the filter criteria as screen tip.
      2. Apply the filter criteria again.
      3. Click the Filter button on the DATA tab.
      4. none of these
   5. To search all the records of students whose name starts with 'A' type
      1. *A
      2. A*
      3. *A*
      4. A
4. 4.

   Which feature of Excel would you use to create the list of numbers 1700, 1701, 1702 ... 1749 in cells A1:A50?

5. 5.

   How will you add a list  of your five friends in Custom Lists? Explain any one method.

6. 6.

   What is Flash Fill? Explain with an example.