Kips Class 7 IT Beans Chapter 4 Using Excel as Database

Chapter 4 Using Excel as Database

Brain Developers
A. Fill in the blanks:
1. A database helps the users to
organise, retrieve, sort and edit data as needed.
2. A
form provides an easy way to enter or display a record.
3.
Field Name is a column label for the field in a database.
4. To restrict cell entries within a specific range, use
data validation option.
5. To search a record with specific value, click on the
criteria button in a form.
6.
Pivot table provides an easy way to present the data in a summarized way.

B. State True or False:
1. Records refer to rows in the database. (
True)
2. Field names can be duplicated in the database. (
False)
Correct Answer: Field names cannot be duplicated in the database.
3. You can sort the data only in one field. (
False)
Correct Answer: You can sort the data in more than 1 field.
4. Field represents a column in the database. (
True)
5. Subtotal values in the database are calculated with Count function. (
False)
Correct Answer: Subtotal values in the database are calculated with Sum function.
6. In a database, one cannot rearrange the data as per the need. (
False)
Correct Answer: In a database, one can rearrange the data as per the need.
7. Form provides the option to delete a particular record. (
True)

C. Application Based Questions:
1. Kanika is a Chartered Accountant. She looks after account of various companies and keeps their records in Microsoft Excel. She does not have any idea how to view only those records that she wants to see. Suggest her the feature of Microsoft Excel using which she can perform this task.
Answer:
Kanika can use Filter option to view only those records that she wants to see.

2. Varun is maintaining the marksheet of his class in Microsoft Excel. The teacher has asked Varun to find the maximum and minimum marks obtained in the class. Which feature of Microsoft Excel should Varun use in order to accomplish the task?
Answer:
Varun can use Data Validation.

D. Multiple Choice Questions:
1. Which option is used to restrict the cell entries within a specific range?
a) Advanced Filter
b) Data Validation
c)  Pivot Table

Answer: b) Data Validation

2. Which button under data tab is used to remove a duplicate value from one or more columns?
a) Remove
b) Remove Data
c) Remove Duplicates

Answer: c) Remove Duplicates

3. Which feature in a database provides an easy way to enter display a complete row of information?
a) Form
b) Adding Subtotal
c) Filter

Answer: a) Form

4. What do we call a row in a database?
a) Form
b) Field
c) Record

Answer: c) Record

5. Which feature allows us to arrange the given data according to a particular field either in an ascending or descending order?
a) Data Form
b) Sort
c) Filter

Answer: b) Sort

E. Answer the following:
1. Describe the term Database.
Answer:
A database is a collection of information related to a particular subject. It helps the user to organise, retrieve, sort and edit data as per requirement.

2. What is the use of Sorting feature in Excel?
Answer:
Sorting is used to arrange the data either in an ascending or descending order in a worksheet. Data can be sorted in row on the basis of text, numbers and combination of text number & numbers or dates.

3. Briefly explain the utility of Filter feature.
Answer:
Filter feature allows us to view only those records that we want to display while it hides the rest of the data temporarily from the view.

4. What is Pivot Table? Describe its utility.
Answer:
Pivot Table is a powerful tool for consolidating, summarising and presenting data.

5. How is Advanced Filter different from Filter?
Answer:

• Advanced Filter option is used to filter the data in multiple fields using specified criteria, or to copy the filtered record to a different location, or to find unique records.
• Filter feature allows us to view only those records that we want to display while it hides the rest of the data temporarily from the view.

40 comments:

  1. Anonymous05 June, 2021

    Ideas:
    1) Please make Python posts tooo! They are becoming so popular....
    2) Make more handmade coverpage
    3) Make more extra knowledge posts
    4) Make posts on Artificial Intelligence
    5) Make posts on Robots
    6) Make more Diary Entry posts
    7) Make more posts on Book Review!!!


    And that's all from my side.... Thank you
    ������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������




    From my side!!! Keep going bros...

    ReplyDelete
    Replies
    1. Hi, thanks for your positive feedback!!! We shall consider your topics for our posts... Keep visiting our blog!

      Delete
    2. We have started to make some Python basics' posts... You can visit these posts at:

      https://vs.eyeandcontacts.com/search/label/Python

      Delete
    3. thank you for helping in my tomorrows exam

      Delete
    4. Welcome! Our website's main motto is to help students get good marks...

      Delete
  2. Anonymous06 June, 2021

    Thanks for making this post! I couldn't find posts regarding the solutions of Kips (Computers) Class 7, even after searching multiple times! Thanks once again:)

    ReplyDelete
    Replies
    1. Thank you for helping me

      Delete
    2. Welcome! If you found this website informative, do share it with your friends.

      Delete
  3. Thanks it helps in doing my assignment

    ReplyDelete
  4. Replies
    1. Welcome! Keep visiting our website for more solutions...๐Ÿ˜Š

      Delete
  5. Replies
    1. Welcome! We're also providing NCERT correct solutions of Maths, Social, Science. So if you feel that our answers are correct and reliable according to your needs, then do refer our NCERT Solutions as in many big websites they have mistakes...

      Delete
  6. Replies
    1. Welcome! We're also providing NCERT correct solutions of Maths, Social, Science. So if you feel that our answers are correct and reliable according to your needs, then do refer our NCERT Solutions as in many big websites they have mistakes...

      Delete
  7. Replies
    1. Welcome Nysa Karim! Do recommend our website to your friends if you found our website helpful...

      Delete
  8. I was having my exams and it helped me a lot. Thanks.๐Ÿ˜Š

    ReplyDelete
    Replies
    1. Welcome Pragya Joshi! Do recommend our site to your friends!

      Delete
  9. This website have really help me to prepare for final exam

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

      Delete
  10. Dude please send pdf's I need to download this study material

    ReplyDelete
  11. Thanks ๐Ÿ™ for your q and answer. Pls give tips to me to remeber the long answers. Your all time ๐Ÿ˜‰ vister and sharer.

    ReplyDelete
    Replies
    1. Welcome! Sure there are a few tips to remember the long answers:
      • First, you should read the answer and understand it.
      • Then, you should learn it thrice (or more times if you are unable to).
      • After learning that answer, once write that answer on paper and check if you have written it correctly (if not, learn and rewrite it).
      • Then you can read the chapter.
      • After one hour or so, you should be able to summarize it.

      Delete
  12. 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