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:-**

**Explanation:-**

**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.

**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.

**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:

**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:-**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

**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.

**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

**Rules To Enter A Function**

**Common Functions**

**Function Library:-**

**Please click on below link to download CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet-**

**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 |