Class VII- MS Excel

Which Excel feature is used to arrange data in ascending or descending order?

• Filter

• Advance Filter

• Sorting

• Goal Seek

Which button under Data tab is used to remove duplicate values from one or more columns?

• Remove

• Remove Duplicates

• Remove Value

• Remove Data

Which Excel feature is used to view only those records we are interested in and hide rest of the data?

• Sort

• Subtotal

• Consolidate

• Filter

Which feature in a database provides an easy way to enter, modify and view one record at a time?

• Table

• Form

• Filter

• Field

Identify this ? Component of the chart.

• Data Series

• X-Axis

• Chart Title

• Legends

Which component of a chart is used to plot the values?

• Legends

• Chart Title

• X - Axis

• Y-Axis

Which type of chart is a circular chart divided into sectors?

• Column Chart

• Pie Chart

• Line Chart

• Bar Graph

These are mini charts to provide visual representation of the data.

• Goal Seek

• Consolidate

• Spark Lines

• Charts

Which feature is used to determine the input values needed to achieve a specific goal?

• Consolidate

• Grouping

• Goal Seek

• Advance Filter

A ____________ chart displays data in the form of rectangular rods.

• Doughnut

• Pie

• Line Chart

• Column Chart