Skip to main content

Spreadsheets: Charts in Excel 2013 Class 8 Computer

Charts in Excel 2013
A Fill in the blanks with the correct words.
1. The y-axis is also known as the value axis.
2. The legend identifies the data series.
3. The data label provides additional information about a data point on a chart.
4. The radar chart plots data in concentric circles.
5. The pie chart is used to plot data for a single data series.

B State whether True or False. Correct the False statements.
1. A bar chart is a column chart drawn sideways. (True)
2. A doughnut chart represents only one data series. (False)
(A pie chart represents only one data series)
3. A 3-D chart contains two walls and a floor. (True)
4. You cannot move a chart on the worksheet. (False)
(We can move a chart on the worksheet)
5. If you are not sure which type of chart to create, click the Recommended Charts command. (True)

C Choose the correct option.
1. Which of these options means the dataset used for creating a chart?
a. Legend
b. Data table
c. Chart area
d. Chart tools
2. Which of these is the rectangular area bounded by two axes?
a. Legend
b. Data label
c. Plot area
d. Gridlines
3. Which of these charts plots data for a single data series?
a. Column chart
b. Pie chart
c. Scatter chart
d. Bar chart
4. Which of these shortcut buttons appear at the top-right corner of a chart?
a. Chart Elements
b. Chart Styles
c. Chart Filters
d. All of these
5. Which of these gives a y-axis title to your chart?
a. Chart Title
b. Axis Title
c. Primary Vertical
d. Primary Horizontal

D Answer the following.
1. Describe all the components of a chart.
a. Data Table: Set of data values from which the chart is derived.
b. X-Axis: Horizontal axis of the chart.
c. Y-Axis: Vertical axis of the chart.
d. Chart Table: Helps to understand what information the chart shows.
e. Axis Title: Title given to an axis.
f. Chart Area: Area within which all chart components are placed.
g. Plot Area: Rectangular area bounded by two axes.
h. Legend: It identifies the data series.
i. Gridlines: Makes it easier to identify the value of data points.
j. Data Label: Gives additional information about a data point.

2. Write the steps to change the chart type.
DESIGN tab → Type group → Change Chart Type button

3. Explain the stock chart using an example.

A stock chart helps stock companies to analyze the fluctuation in stock prices.

4. List the steps to give light-pink background to a chart.
FORMAT tab → Shape Styles group → Shape Fill → Select light pink color.

5. What is a combo chart? How will you create a combo chart?
A combo chart is a single chart that plots the series using different chart types.
INSERT tab → Charts group → Recommended Charts
Insert dialog box appears.
All Charts tab → Combo.
Labels:

Comments

Post a Comment

This site is all about helping you kids study smart because for Gen Z, studying "hard" is not enough. If you feel there is any way I could improve my posts or if you have any random suggestion that might help make this more kid friendly, please don't hesitate to drop in a comment!

Be sure to check back for my response if you've asked me a question or requested a clarification through the comment section because I do make every effort to reply to your comments here.

Popular posts from this blog

Tenses: Correct Form of the Verb Exercises: ICSE English Language

Tenses: Correct Form of the Verb Exercises: ICSE English Language ** [For other Important Links related to English Language, click here 👇 https://english-language-important-links ( It is advisable to first try and solve the answers on your own, write it down in your copies and once you're done with all the questions, check from the solutions and rectify your mistakes. This practice enables you to learn from your mistakes and helps your brain retain a vivid memory and enhances your ability of language acquisition)  In the following passage, fill in each of the numbered blanks with the correct form of the word given in brackets. Do not copy the passage, but write in correct serial order the word or phrase appropriate to the blank space. (answers below). Exercise I (0) disappeared The sun (0)_______ (disappear) behind the clouds and the sky turned grey. The wind (1)____(pick) up and a few drops of rain fell on the old tin roof. Jose (2)_____(run) inside and (3)_____(cl
1 comment
Read more

ICSE Mathematics Specimen Paper 2023 with Solutions(/ Answer Key)

ICSE Mathematics Specimen Paper 2023 with Solutions(/ Answer Key) Part A: Question Paper Part B: Answer Key Part A: Question Paper:- For detailed video explanation of these sums and sums from other chapters in your syllabus, click here 👉  Chapter wise Video Explanations of most important sums from each chapter Part B: Answer Key:-  (Scroll Below the next section on other important links for rest of the pages) [ **If you found this useful, do check the 2023 specimen papers of other subjects along with their Solutions by clicking here:  https://novakidhs.blogspot.com/p/icse-specimen-papers-2023-with.html ** For Questions and Answers, Solved Test Papers , Previous Years paper scanner and much more curated study materials on all the subjects of the ICSE syllabus, click here 👇 https://novakidhs.blogspot.com/p/icse-class-10a
Post a Comment
Read more

Do as Directed: ICSE English Language

ICSE English Language: Do as Directed: Exercises with Answers for Practice  ** [If you're unable to solve some of these questions or feel the need to revise the basics and rules, click here for an easy-to-follow guideline👇 https://transformation-of-sentences-complete-guide ( It is advisable to first try and solve the answers on your own, write it down in your copies and once you're done with all the questions, check from the solutions and rectify your mistakes. This practice enables you to learn from your mistakes and helps your brain retain a vivid memory and enhances your ability of language acquisition)  1. It is probable that he will never come back. (Begin: In …) 2. He said to me, ‘Where are you going?’ (Begin: He asked me …) 3. As soon as the chief guest had arrived, the play began. (Begin: No sooner ….) 4. I was surprised at his behaviour. (Begin: His …) 5. He will certainly succeed. (Begin: He is …) 6. He is the best student in the class. (Use better instea
Post a Comment
Read more