Displaying 5 out
of 14
questions & answers.
Q1.
Fill in the blanks with the correct words.
| Category, Pie, Two, Chart, Scatter |
- A _____________ is a pictorial representation of data.
- A ____________ chart plots each data points with a marker.
- A _____________ chart is used to plot data for a single data series.
- The x-axis is also known as the ____________ axis.
- A 2-D graph has ____________ axes.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- Chart
- Scatter
- Pie
- Category
- Two
Q2.
Write T for the true statement and F for the false one. Correct the false statement(s).
- Excel supports only two types of charts.
- The two walls and the floor make up the plot area in a 3-D chart.
- The Charts group is available on the INSERT tab.
- You cannot change the size of a chart.
- The commands for formatting text and numbers in a chart are available on the FORMAT tab.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- False
- True
- True
- False
- True
Q3.
Choose the correct option.
- Which of the following chart types compares trends in data at equal intervals?
- Line chart
- Column chart
- Pie chart
- None of these
- Which of the following chart shows the relationship of parts to the whole?
- Pie
- Doughnut
- column
- None of these
- The vertical y-axis is also known as the ___________ axis.
- Category
- Data
- Value
- None of these
- A ___________ identifies the data series.
- Legend
- Axis title
- Gridlines
- None of these
- In a 3-D chart, the xy plane is known as the
- Wall
- Axis
- Floor
- None of these
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- (a) Line chart
- (a) Pie
- (c) Value
- (a) Legend
- (c) Floor
Q4.
What is the importance of charts in Excel?
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
answer not shownQ5.
Name the tabs that appear when a chart is selected.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
When a chart is selected, the Design tab and the Format tab, appear.






















































































