IT Planet Class 7 Computer Chapter 3 Solution – Advance Features In MS-Excel
IT Planet Class 7 Solution: IT Planet Class 7 Computer Chapter 3 Advance Features In MS-Excel all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter Advance Features In MS-Excel Solution.
Q1) Tick ( √ ) the correct answer :-
a) The data you enter in Excel is stored in a file called
Ans: ii) Workbook
b) The columns that are used to define each part of the list in Excel are known as
Ans: iii) Fields
c) A function that returns the lowest value in a series
Ans: i) MIN
Q2) Fill in the blanks :-
a) The rows and columns collectively are called a Table
b) A database is a collection of related information.
c) Field names is also called labels
d) A table is an entire database list of information.
e) Data Form is another way to enter database records.
f) …………………………. options are used to view only a portion of the data.
g) Sorting means organizing data in ascending or descending order.
Q3) Answer the following questions :-
a) Solution:
The other name of spreadsheet program is MS Excel which is a part of the MS
Office Suite. Microsoft Excel is a electronic spreadsheet and a part of Microsoft Office
Suite. This program was designed for performing different mathematical operations on a
spreadsheet (the data is entered in tabular form (rows and columns) on a sheet. Microsoft Excel is also known as spreadsheet. Excel also has different built-in tools lie functions, formulas etc which helps to perform mathematical operation/calculations. You can even prepare various sheets on Excel like Salary sheet, Marksheet etc.
b) Solution:
You might have heard a system called ‘ Sampoorna ‘ that contains all the
information about the students in our public schools. The data regarding lakhs of students have be compiled systematically. Such collection of data in a systematic manner is called databases. In databases, the data is recorded in one or many tables. Database helps to store data securely, add new data, removes unwanted data, uses data as per need, makes suitable changes etc. For ex:- Telephone and address books are examples of paper databases.
c) Solution:
i) Fields :- Field is a single unit of information in a table. The fields (columns)
contains the actual data that describe and distinguish the items maintained in a table.
For ex :- Roll No, First __ Name, Middle _ Name, Last _ Name, Address, City, Mob _
Num etc. Fieldnames always appear at the top of the list which they are called as
labels.
ii) Records :- For making the list of data, one can make use of rows to make an entries
of database (which are called as records). In the database each row shows one record.
iii) Tables :- Table is a collection of data organized into rows and columns which
contains an entire list of information . You can create as many tables as you can in
Excel. For ex:- One table might contain list of customers and addresses and another
might list product items and prices.
iv) Form :- Form allows you to add and update data in a table, one record at a time.
With the making use of data form, it helps the user to enter the database list very fastly.
There is availability of all table fields in your data form. By filling/completing the fillation
of fields in the form, it is easier for one to enter a record.
d) Solution:
In Excel, a database is collection of records which are related to each other. once
the database table is created successfully, one can do various tasks on it like analyzing the data, sorting it and filtering it. Below are the steps for how to create a database table in Excel :-
i) Click on the cell where you want to insert the first field label.
ii) Type the field label.
iii) When you press the Tab key, your cursor will move to the next cell, where one can
type the next field label.
iv) For entering more field labels, we have to repeat the step no 3 and 4.
e) Solution:
In Excel there is a function named as Financial —– PMT —— where you can
calculate the loan amount, rate of interest, loan tenure etc.
f) Solution:
In Excel, there is a tool which will tell/help us to find a way for reaching to the goal.
For ex:- If you want to take a new loan from the bank for constructing a new house, but
our goal is to pay specific monthly amount as EMI. With the use of goal seek feature one can reach towards the goal by making an adjustment with the loan terms such as its
interest or loan amount.
h) Solution:
With the making use of data form, it helps the user to enter the database list very
fastly. There is availability of all table fields in your data form. By filling/completing the
fillation of fields in the form, it is easier for one to enter a record.
i) Solution:
Data Validation Rule helps to set up the database table and to make a control over
it like what kind of data should be entered in the cells. Once the data validation rule is
been applied, you must make sure that whatever the data you enter into the cell is
correct/right. If incase you make a mistake while entering the data in the cell like instead
of entering the numerical data you had entered the text data, then it will show the error
message in the box and will suggest what type of data should be entered into the cell.