# CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet

Download printable Computer Science Class 7 Worksheets in pdf format, CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Computer Science Class 7 Assignments and practice them daily to get better marks in tests and exams for Grade 7. Free chapter wise worksheets with answers have been designed by Standard 7 teachers as per latest examination pattern

## Formulas and Functions in Ms Excel Class 7 Computer Science Worksheet Pdf

Class 7 Computer Science students should refer to the following printable worksheet in Pdf for Formulas and Functions in Ms Excel in Grade 7. This test paper with questions and solutions for Standard 7 Computer Science will be very useful for tests and exams and help you to score better marks

### Class 7 Computer Science Worksheet for Formulas and Functions in Ms Excel

TOPIC:- FORMULAS AND FUNCTIONS IN MS EXCEL

INTRODUCTION:- Students will learn about the following sub- topics:-

• Formulas in excel

• Creating a basic Formula

• Using Formula On Text

• Cell Range and Cell Reference

• Formula Errors

• Functions

• Common Functions

• Managing Worksheets

Explanation:-

One of the imprint attributes of Excel is its ability to perform calculation either by using a Formula or a Function. In this topic we will learn the basics of Formulas and Functions in M S Excel.

Formula:- Formulas are the user defined instructions to perform calculations relating tasks involving addition, subtraction, multiplication and division etc. A formula establishes a relationship between two or more cells. It can include cell addresses, numbers, arithmetic operators and parenthesis. Using it, we can perform simple as well as complex calculations.

A Formula must begin with an equal to (=) symbol followed by cell reference and operators. It may contain below mentioned elements:

Reference: A cell or a range of cells that we want to include in calculations.

Operators: Symbols (+, -, ^, *, %, \$, # etc)

Constants: Numbers or text values that do not change.

Functions: Pre- defined formulas in Excel.

Creating A Basic Formula: Basic Formula involves only one type of operator in it. Let us use to calculate the sum of the numbers in C1, C2, C3 ...... C7 and display result in C8.

• Enter the data in cells e.g maths marks of seven students.
• Click on the cell C8 where you want to display the result) and type ‘ =’ sign.
• Now type = C2 +C3+ C4+C5+C6+C7
• Press enter Key and you will get total marks.

Using Formula on Text:- we can perform addition on character and string data type. The ampersand symbol is used to perform addition .Addition of two or more tent values is called concatenation. For example:
• Enter any string type value in cell A1 and B1,say kips in A1 and Indian in B1.
• Enter the formula =A1 and B1 in cell C1 and press the enter key.
• It will display kips India in C1.

Cell Range: A range is a group of contiguous cell, which form the shape of a rectangle. It can be group of two cell or as big as entire work sheet . For cell C1:C10 Indicates the range .

Cell Reference And its Types:- The cell address that we use in the Formula is known as the cell reference. For example A1 where a denotes column name and 1 denotes row number. There are three types of Cell References.

• Relative Reference
•Absolute Reference
•Mixed Reference

Relative Reference:- A relative reference in Excel is a cell address without \$ sign in the row And column coordinates like A1, When a Formula with relative cell is copied to another cell, the reference changes automatically based on the relative position of rows and columns. By default Excel uses relative reference. For example =A1+A2.

Absolute Reference:- An absolute cell reference is a cell address that contains dollar sign before the
column name and row number. For example =\$A\$1 +\$A\$2.

Mixed Reference:- It is a combination of Relative and Absolute reference. In this type of reference, either row or column has to remain fixed e.g. \$A1 + A\$2.

Formula Error :- In Microsoft Excel , if any formula is entered incorrectly, then Excel display an error message instead of the value and assists you in identifying and fixing the problem.

Some of the common errors are:

•#### Error:- This error occur if the column is not having enough space to accommodate the value.
•# Name? Error:- It occurs if the formula is used incorrectly.
• # Value Error:- It occurs if the formula contain invalid data.
• # Ref! Error:- This error occurs when the formula refers to a cell that does not exists.
• # Div/0 Error:- This error occurs if the number is divided by 0.

Functions:- Function are the pre designed formula in Excel to perform both simple and complex calculations. It saves time and eliminate the chances to write wrong formulas. They accept arguments and return value.

Arguments: Arguments are the input to functions on which calculations are performed to find out the final result.

Values : Values can be numbers , text, etc and are enclosed within parenthesis

A Function must begin with equals to (=) sign followed by the function name and then the list of arguments.

For example, =Function name(argument1, argument2)
= SUM(A1:A5) Where sum is function name and A1:A5 are arguments.

Rules To Enter A Function

• All Excel function must begin with =sign.
• Function name must be valid Excel name. For e.g SUM, AVERAGE.
• Function name must be followed by an opening and closing parenthesis.
• Arguments are enclosed in the parenthesis.

Common Functions

1. SUM(): The Sum Function retuns the total of the range values. For example =SUM (A1:A5)
2. AVERAGE(): it returns the average of the range values. For example =AVERAGE (A1:A5)
3. MAX(): It is used to find the largest value in given range. For example = MAX (A1:A5)
4. MIN(): It is used to find the lowest value in the given range. For example =MIN (A1:A5)
5. TODAY: It is used to display the current date. For example =TODAY ()

Function Library:-

There are many functions defined in Excel and it is beyond the capacity to remember the name and functionality of each of them. To overcome it, Excel has clubbed all the functions in the Function Library group of Formula tab.
Managing Worksheets:

1.Renaming Worksheet:- By default, excel displays three sheets in a worksheet naming SHEET1, SHEET2 and SHEET3 but we can add as many sheets we require and assign any name to them.

To Rename a Sheet follow the given steps:-

• Right Click on the Sheet 1

• A Shortcut menu will appear. Click on the Rename option.

• The name of the sheet get highlighted. Type the name ‘Kips’ and press Enter Key.

•  Note the name of the sheet1 has been changed to ‘kips’.

2. Deleting Worksheets:- We can Delete a worksheet if it is of no use. To delete a Worksheet:

•Right –click on the sheet which you want to delete.

• Click on the delete option.

## Tags:

Click for more Computer Science Study Material
 CBSE Class 7 Computer Applications Worksheet Set A CBSE Class 7 Computer Applications Worksheet Set B
 CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet
 CBSE Class 7 Computers Revision Worksheet Set B

## Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

### CBSE Science Challenge 2021 22

Science is inexplicably linked with our lives and helps us to understand the world around us better. Scientific and technological developments contribute to progress and help improve our standards of living. By engaging with this subject, students learn to think, solve...

### Online courses for classes XI and XII offered by NCERT

Ministry of Education (MoE), Government of India has launched a platform for offering Massive Open Online Courses (MOOCs) that is popularly known as SWAYAM (Study Webs of Active learning for Young Aspiring Minds) on 9 th July, 2017. NCERT now offers online courses for...

### Surya Namaskar Project on 75th Anniversary of Independence Day

Ministry of Education, Govt of India vide letter No. F.No. 12-5/2020-IS-4 dated 16.12.2021 has intimated that under the banner Azadi ka Amrit Mahotsav the National Yogasanasports Federation has decided to run a project of 750 million Surya Namaskar from 01 January 2022...

### National Youth Day and Birth Anniversary of Swami Vivekananda

Ministry of Education, Govt. of India vide D.O No. 12-4/2021-IS.4 dated 04.01.2022 intimated that 12 January 2022 will be celebrated as “National Youth Day” and “Birth Anniversary of Swami Vivekananda”.   All Schools affiliated to CBSE may celebrate 12 January 2022 as...

### All India Children Educational Audio Video Festival

The Central Institute of Educational Technology (CIET), a constituent unit of National Council of Educational Research and Training (NCERT), is inviting entries for the 26th All India Children’s Educational Audio Video Festival (AICEAVF). This festival showcases the...