Kips Class 7 IT Beans Chapter 5 Advanced Features of Excel

Chapter 5 Advanced Features of Excel

Brain Developers
A. Fill in the blanks:
1.
Chart is an effective way to display data in pictorial form.
2.
Data Series are the bars or slices that show data values.
3.
Legend is a key that is used to identify the colours, patterns or symbol assigned to data series.
4.
Bar chart display data in the form of long rectangular rods.
5.
Value axis is the vertical axis that is used to plot the values.
6. The purpose of grouping worksheets it is to enter common
data, formulas and formatting effects.

B. State True or False:
1. A chart is updated automatically with the change in data. (
True)
2. We cannot modify the chart by changing its colours and patterns. (
False)
Correct Answer: We can modify the chart by changing its colours and patterns.
3. X-Axis is the horizontal axis. (
True)
4. The Chart Area contains the actual chart itself and includes data series, category and value axis as well. (
True)
5. You can change the pattern of data series using Fill option. (
True)
6. All the worksheets cannot be deleted in a workbook. (
True)

C. Application Based Question:
1. Ritu is a student of Class VII. Her geography teacher has asked her to prepare a chart on the population of four Metro cities of India. Suggest her the best suited chart type for her project.
Answer:
She can use Bar Chart.

2. Tripti has created a chart. She wants to improve the appearance of her chart by changing the background colour of its Plot area. Which option will you suggest her to perform this task?
Answer:
Tripti can use the Format Plot Area option that comes on right-clicking the plot area.

D. Multiple Choice Questions:
1. Which feature is used to set a specific result for one cell by adjusting a value in another cell?
a) Grouping Worksheets
b) Legends
c)  Goal Seek

Answer: c) Goal Seek

2. Name the bars or slices that represent the data values on the chart.
a) Data Series
b) Plot Area
c) Legend

Answer: a) Data Series

3. Which chart displays data in the form of a circle?
a) Line
b) Pie
c) Bar

Answer: b) Pie

4. Which function key is used to insert a chart, instantly in a worksheet?
a) F6
b) F8
c) F11

Answer: c) F11

5. Which key is used to group multiple worksheets?
a) Shift
b) Ctrl
c) Enter

Answer: a) Shift

6. Name the special window that displays data, when you insert a chart.
a) Datasheet
b) Database
c) Sheet
Answer:
a) Datasheet

E. Answer the following:
1. What is a Chart?
Answer:
Chart is an effective way to display data in a pictorial form. Charts make it easier to draw comparisions and analyse the growth, relationship and trends among the values in a range.

2. How is a Column chart diferent from a Bar chart?
Answer:

Column Chart - It is used to display data in form of vertical bars. It is used to show changes in data over a period of time.
Bar Chart - It displays data in the form of long rectangular rods called bars. A Bar Chart is used to illustrate comparision among the individual items.

3. What is the difference between Chart Area and Plot Area?
Answer:

Chart Area - The Chart Area includes all the objects and elements in a chart.
Plot Area - Plot Area is a window within the Chart Area. It contains actual chart and includes the plotted data, data series, category axis and value axis.

4. How will you group worksheets?
Answer:
To group worksheets, hold down CTRL and click the sheet tabs of the sheets you want to group. Release CTRL.

5. What do you understand by the term Data Consolidation?
Answer:
Data Consolidation refers to combining of data either in the same worksheet or in the other worksheet.

E. Briefly explain the following terms:
1.
Data Series:
Data series are the bars, slices or other elements that represent the data values.
2. Category Name: Category names are the labels, which are displayed on the X and Y-axis.
3. Value Axis: Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.
4. Goal Seek: Goal Seek is a wonderful feature for fixing a specific result for one cell by adjusting a value in another cell.

28 comments:

  1. You're helping me a lot.... Please keep posting when school reopens... I'll be very benefited if you continue to post these...

    ReplyDelete
  2. Thanks for the correct answers

    ReplyDelete
  3. Thanks for helping and giving the same and correct Questions and answers

    ReplyDelete
    Replies
    1. Anytime😊! We always try our level best to provide quality answers to the students... Do follow us to receive our daily updates!

      Delete
  4. Quality Answers!
    They surely helped me alot in exams! Thanks alot eyeandcontacts.

    ReplyDelete
    Replies
    1. Welcome! It is our pleasure to share our knowledge with you... Thanks to you too!

      Delete
  5. What allows us to read chart in an accurate manner
    Please answer for this question

    ReplyDelete
    Replies
    1. Hello user,

      The answer to your question is: Gridlines. Gridlines make it easier to read and understand the values.

      Delete
  6. Replies
    1. Anytime... We help students by providing correct and accurate solutions. Keep visiting our website for more solutions!

      Delete
  7. Replies
    1. Hi user,

      You can download the PDF by:
      Step 1: Open the PDF that you want to download in a new tab.
      Step 2: On the top right you'll see a down arrow that is underlined.
      Step 3: Click on that arrow. The PDF will be downloaded in your respective download folder...

      Delete
  8. can you please send the Q/A of all chapter, because i cant find the answers of the chapter python and cyber crimes and security, btw the website is very helpful

    ReplyDelete
  9. Thank You for your help.

    ReplyDelete
    Replies
    1. Thanks! Do recommend our website to your friends if you found our website helpful...

      Delete
    2. u helped me in my exam thanks and can u also make question answers on different chappters aswell and thanks again

      Delete
    3. Welcome! To help you in question and answers of different chapters, we need resources. You can help increase our resources by opening ads displayed on our site and sharing our website with your friends on social media!

      Delete
  10. thanks you its is very wonderful full...

    ReplyDelete
    Replies
    1. Welcome! Do share our website with your friends!

      Delete
  11. please put class 7 chapter 7 review python and chapter 6

    ReplyDelete
    Replies
    1. Hey there,
      Thanks for showing your confidence in vs.eyeandcontacts.com and becoming our valued user!
      Actually we've only IT Beans and Artificial Intelligence books' solutions. If you want the answer of particular question or chapter, mail us the question along with textbook pdf at vshelpcare@gmail.com! In future we might plan to post those questions also!

      Thank you.

      Delete
  12. Replies
    1. If you like our website, then you can spread this website to your friends!

      Delete
  13. I get so much help from this

    ReplyDelete
    Replies
    1. 😃 If you like vs.eyeandcontacts.com and enjoy visiting the solutions, please tell your friends on Facebook, Twitter, Instagram etc! Thank you.

      Delete

Also read!

Class 6 Solutions

• Class 7

Class 7 Computer Kips Solutions
Class 7 Gul Mohar English Solutions
English Grammar Class 7
English Writing Skills Class 7
Class 7 Map Pointing Solutions
Class 7 NCERT Civics Solutions
Class 7 NCERT Civics Notes
Class 7 NCERT Civics Extra Questions
Class 7 NCERT Geography Solutions
Class 7 NCERT Geography Notes
Class 7 NCERT Geography Extra Questions
Class 7 NCERT History Solutions
Class 7 NCERT History Notes
Class 7 NCERT History Extra Questions
Class 7 NCERT Maths Solutions
Class 7 NCERT Science Solutions
Class 7 NCERT Science Notes
Class 7 NCERT Science Extra Questions

• Class 8

Class 8 Kips Artificial Intelligence Solutions
Class 8 Gul Mohar English Solutions
English Grammar Class 8
English Writing Skills Class 8
Class 8 Map Pointing Solutions
Class 8 NCERT Civics Solutions
Class 8 NCERT Civics Notes
Class 8 NCERT Civics Extra Questions
Class 8 NCERT Geography Solutions
Class 8 NCERT Geography Notes
Class 8 NCERT Geography Extra Questions
Class 8 NCERT History Solutions
Class 8 NCERT History Notes
Class 8 NCERT History Extra Questions
Class 8 NCERT Maths Solutions
Class 8 NCERT Science Solutions
Class 8 NCERT Science Notes
Class 8 NCERT Science Extra Questions
Class 8 NCERT Science Exemplar
Class 8 NCERT Science MCQs

Class 9 Solutions

• Class 10

Class 10 Kips Artificial Intelligence Solutions
Class 10 NCERT English Solutions
→ Class 10 Map Pointing Solutions
Class 10 NCERT Civics Solutions
Class 10 NCERT Civics Notes
Class 10 NCERT Civics Extra Questions
Class 10 NCERT Geography Solutions
Class 10 NCERT Geography Notes
Class 10 NCERT Geography Extra Questions
Class 10 NCERT History Solutions
→ Class 10 NCERT History Notes
Class 10 NCERT History Extra Questions
Class 10 NCERT Maths Solutions
Class 10 NCERT Science Solutions
Class 10 NCERT Science Notes
Class 10 NCERT Science Extra Questions

• Computer languages
Python Basics

• Extra Activities
Extra Activities

• Extra Knowledge
Extra Information
General Knowledge
Historical Places in India
Latest technology
Physical Sciences
Facts

• Mathematics quick links
Mathematical Terms
Maths Tricks

CONTACT US