WorksheetsClass VII- MS Excel
Total questions: 15
Worksheet time: 8mins
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
A __________ is a collection of information on a particular topic.
Data
Field
Record
Database
On which tab Sort option is available?
Data
Insert
Home
Format
On which tab Charts option is available?
Home
Insert
Data
View
A chart which is a combination of two or more chart types is known as _____________
Combine Chart
Combination Chart
Combo Chart
Combi Chart
Which is not one of the option in Spark Lines?
Win/Loss
Column
Line
Pie
