Available Answers

1. 1.

   Choose the Correct Option.

   1. The Filter button is present in the __________ Tab.
      1. Home
      2. Data
      3. Insert
      4. Chart Tools
   2. The Custom Filter dialog allows you set a __________ for filtering.
      1. Condition
      2. Colour
      3. Both a and b
      4. None of these
   3. Filter by Font Colour allows you to filter by ______________.
      1. Colour of the cell
      2. Size of the font
      3. Colour of the font
      4. Width of the cell
   4. The ___________ chart creates horizontal bars to represent variations of value with respect to time.
      1. Column
      2. Bar
      3. Pie
      4. Line
   5. ____________ is used for actual charted values which are usually rows or columns of the source data in a chart.
      1. Value Axis
      2. Chart Title
      3. Data Series
      4. Category Axis
2. 2.

   State True (T) or False (F):

   1. The Sort button is present in the Home tab.
   2. You cannot arrange text in alphabetical order in Excel.
   3. The default sorting within a cell range is always performed according to the first column.
   4. It is possible to filter data according to Font or Cell colour.
   5. The Styles group of the Home Tab houses the Conditional Formatting button.
3. 3.

   Fill in the blanks with the correct word:

   Legend, Source, Design, Pie, Line

   1. A ___________ chart shows trends and variations in data over time using a line.
   2. A __________ chart displays information when you want to represent different parts of the whole, or the percentages of a total.
   3. ___________ in a chart is used to identify colours on a chart representation.
   4. The range of cells containing data that makes a chart is termed as __________ data.
   5. The ___________ tab of the Chart Tools is responsible for changing the Chart Type, Data source, Layouts, Chart Styles, etc.
4. 4.

   What is sorting?

5. 5.

   What do you understand by the term Filtering?

6. 6.

   What is an axis in relation to a chart?