CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet

Read CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet below. Find free printable Class 7 Computer Science worksheets in PDF format built specially for Formulas and Functions in Ms Excel. These practice tasks follow the 2026-27 curriculum patterns suggested by CBSE, NCERT, and KVS to help you learn faster.

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-27 session.

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

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-

Free study material for Computer Science

Formulas and Functions in Ms Excel Practice Sheet & Solutions for Class 7 Computer Science

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

Access the Formulas and Functions in Ms Excel practice worksheet above to gear up for forthcoming school assessments. Following the active CBSE curriculum for Class 7 Computer Science, these solved questions are simple to download in PDF format for daily practice. Built by expert educators around high-yield exam themes, these exercises help raise your overall test scores.

Master Formulas and Functions in Ms Excel with Official NCERT Resources

Compiled using the standard NCERT book for Class 7 Computer Science, these practice exercises ensure accurate guidance. Completing the questions should be followed by checking our comprehensive NCERT solutions, designed to teach clear techniques for Computer Science questions. Every resource is available free of cost.

More Practice Materials for CBSE Examinations

Enhance your Class 7 achievements by completing the online Computer Science MCQ test available here. We also host numerous printable assignments for Class 7 Computer Science online. Regular exercises cultivate exam readiness and elevate your final standing in CBSE evaluations.

FAQs

Where can I download the latest PDF for CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet?

You can download the teacher-verified PDF for CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet from StudiesToday.com. These practice sheets for Class 7 Computer Science are designed as per the latest CBSE academic session.

Are these Computer Science Class 7 worksheets based on the 2026-27 competency-based pattern?

Yes, our CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet includes a variety of questions like Case-based studies, Assertion-Reasoning, and MCQs as per the 50% competency-based weightage in the latest curriculum for Class 7.

Do you provide solved answers for CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet?

Yes, we have provided detailed solutions for CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet to help Class 7 and follow the official CBSE marking scheme.

How does solving CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet help in exam preparation?

Daily practice with these Computer Science worksheets helps in identifying understanding gaps. It also improves question solving speed and ensures that Class 7 students get more marks in CBSE exams.

Is there any charge for the Class 7 Computer Science practice test papers?

All our Class 7 Computer Science practice test papers and worksheets are available for free download in mobile-friendly PDF format. You can access CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet without any registration.