Scribd
Upload
89 views4 pages

Excel Database Fundamentals for Class 7

Uploaded by

mitmak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
89 views4 pages

Excel Database Fundamentals for Class 7

Uploaded by

mitmak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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.

Common questions

Powered by AI

Field names cannot be duplicated in a database because each field must be uniquely identifiable to ensure accurate data retrieval and manipulation. Unique field names prevent confusion and errors in data management processes, such as sorting or filtering, and maintain the integrity of data organization within the database .

A database serves as a collection of information related to a specific subject, which helps users to organize, retrieve, sort, and edit data according to their needs. It allows users to handle large volumes of data efficiently, making data management tasks like sorting and filtering more manageable .

For a user like Kanika, who wants to view only specific records, I recommend using the Filter option in Excel. By applying filters, she can view and analyze only the data that meets her specified criteria, such as filtering by company name or date range, while temporarily hiding irrelevant records .

A Form in a database provides an easy way to enter and display a complete row of information, thereby simplifying data entry and reducing errors. It is an important feature because it streamlines the process of updating records and allows users to focus on a single record's details without being distracted by other data in the database .

The Remove Duplicates feature improves the reliability of a database by ensuring that each record is unique, thus preventing errors in data analysis or reporting. By eliminating duplicate entries, it enhances the accuracy of data summaries and reports and ensures that decision-making is based on accurate and non-redundant data .

Rearranging data in a database is possible due to the flexibility of the database structure, which allows sorting and filtering based on various criteria. This capability is essential for effective data retrieval and analysis, as it enables users to customize views and focus on specific data subsets, improving the efficiency of data-driven decision-making .

A Pivot Table in Excel is a powerful tool for consolidating, summarizing, and presenting data. It allows users to quickly reorganize large sets of data into a more manageable and interpretable format, facilitating easier data analysis through summarization and categorization of data fields .

The Sort feature is important for managing data records in Excel as it allows users to arrange data logically, either in ascending or descending order, based on text, numbers, or dates. This enhances data readability and allows for more efficient data analysis, such as sorting a list of employees by their last names or organizing sales records by date .

The Filter feature in Excel allows users to view specific records by temporarily hiding the rest of the data, making it useful for simple data sorting. In contrast, the Advanced Filter offers more complex data handling capabilities, such as filtering data across multiple fields using specified criteria, copying the filtered records to a different location, or identifying unique records .

The Data Validation feature in Excel is beneficial when there is a need to restrict cell entries to a specific range or type of data. This ensures data accuracy and consistency, such as when recording numerical values within a set budget or limiting input options for categorical data .

You might also like