CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet

Access the latest CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet. We have provided free printable Class 7 Computer Science worksheets in PDF format, specifically designed for Formulas and Functions in Ms Excel. These practice sets are prepared by expert teachers following the 2025-26 syllabus and exam patterns issued by CBSE, NCERT, and KVS.

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

Students should use these Class 7 Computer Science chapter-wise worksheets for daily practice to improve their conceptual understanding. This detailed test papers include important questions and solutions for Formulas and Functions in Ms Excel, to help you prepare for school tests and final examination. Regular practice of these Class 7 Computer Science questions will help improve your problem-solving speed and exam accuracy for the 2026 session.

Download Class 7 Computer Science Formulas and Functions in Ms Excel Worksheet PDF

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.


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

Computer Applications Worksheets for Class 7 Computer Science
CBSE Class 7 Computer Applications Worksheet Set A
CBSE Class 7 Computer Applications Worksheet Set B
Computers Formulas and Functions in Ms Excel Worksheets for Class 7 Computer Science
CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet
Computers Revision Worksheets for Class 7 Computer Science
CBSE Class 7 Computers Revision Worksheet Set B

Important Practice Resources for Class 7 Computer Science

Formulas and Functions in Ms Excel CBSE Class 7 Computer Science Worksheet

Students can use the Formulas and Functions in Ms Excel practice sheet provided above to prepare for their upcoming school tests. This solved questions and answers follow the latest CBSE syllabus for Class 7 Computer Science. You can easily download the PDF format and solve these questions every day to improve your marks. Our expert teachers have made these from the most important topics that are always asked in your exams to help you get more marks in exams.

NCERT Based Questions and Solutions for Formulas and Functions in Ms Excel

Our expert team has used the official NCERT book for Class 7 Computer Science to create this practice material for students. After solving the questions our teachers have also suggested to study the NCERT solutions  which will help you to understand the best way to solve problems in Computer Science. You can get all this study material for free on studiestoday.com.

Extra Practice for Computer Science

To get the best results in Class 7, students should try the Computer Science MCQ Test for this chapter. We have also provided printable assignments for Class 7 Computer Science on our website. Regular practice will help you feel more confident and get higher marks in CBSE examinations.

Where can I download latest CBSE Practice worksheets for Class 7 Computer Science Formulas and Functions in Ms Excel

You can download the CBSE Practice worksheets for Class 7 Computer Science Formulas and Functions in Ms Excel for the latest session from StudiesToday.com

Are the Class 7 Computer Science Formulas and Functions in Ms Excel Practice worksheets available for the latest session

Yes, the Practice worksheets issued for Formulas and Functions in Ms Excel Class 7 Computer Science have been made available here for the latest academic session

Is there any charge for the Practice worksheets for Class 7 Computer Science Formulas and Functions in Ms Excel

There is no charge for the Practice worksheets for Class 7 CBSE Computer Science Formulas and Functions in Ms Excel you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in Formulas and Functions in Ms Excel Class 7 Computer Science

Regular revision of practice worksheets given on studiestoday for Class 7 subject Computer Science Formulas and Functions in Ms Excel can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 7 Computer Science Formulas and Functions in Ms Excel

Yes, studiestoday.com provides all the latest Class 7 Computer Science Formulas and Functions in Ms Excel test practice sheets with answers based on the latest books for the current academic session