CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet

Computer Science
Download PDF

Read and download free pdf of CBSE Class 7 Computers Formulas and Functions in Ms Excel Worksheet. Download printable Computer Science Class 7 Worksheets in pdf format, CBSE Class 7 Computer Science 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 Class 7. Free chapter wise worksheets with answers have been designed by Class 7 teachers as per latest examination pattern

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

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

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

More Study Material

Tags
Printable Worksheets for Class 7
Class 7 Computer Science Printable Worksheets
Class 7 Computer Science pdf test papers
Class 7 Computer Science Printable Worksheets pdf
Class 7 Computer Science
Computer Science Class 7 Printable Worksheets
Class 7 Computer Science Chapter Worksheets
Printable Worksheets for Class 7 Computer Science

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

The above practice worksheet for Formulas and Functions in Ms Excel has been designed as per the current syllabus for Class 7 Computer Science released by CBSE. Students studying in Class 7 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 7 Computer Science on a daily basis. All the latest practice worksheets with solutions have been developed for Computer Science by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their examinations. Studiestoday is the best portal for Printable Worksheets for Class 7 Computer Science students to get all the latest study material free of cost.

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

Teachers of studiestoday have referred to the NCERT book for Class 7 Computer Science to develop the Computer Science Class 7 worksheet. If you download the practice worksheet for the above chapter daily, you will get better scores in Class 7 exams this year as you will have stronger concepts. Daily questions practice of Computer Science printable worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision Worksheets for Class 7 Computer Science also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the practice sheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 7 Computer Science designed by our teachers

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

All practice paper sheet given above for Class 7 Computer Science have been made as per the latest syllabus and books issued for the current academic year. The students of Class 7 can be assured that the answers have been also provided by our teachers for all test paper of Computer Science so that you are able to solve the problems and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 7 Computer Science in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 7 Computer Science students have been given on studiestoday.

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

Regular printable worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Formulas and Functions in Ms Excel concepts. Practice worksheets play an important role in developing an understanding of Formulas and Functions in Ms Excel in CBSE Class 7. Students can download and save or print all the printable worksheets, assignments, and practice sheets of the above chapter in Class 7 Computer Science in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 7 Computer Science MCQ Test for the same chapter.

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

CBSE Class 7 Computer Science best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to Formulas and Functions in Ms Excel and then take out a print of the above practice sheet and attempt all problems. We have also provided a lot of other Worksheets for Class 7 Computer Science which you can use to further make yourself better in Computer Science

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

Can I download the Practice worksheets of Class 7 Computer Science Formulas and Functions in Ms Excel in Pdf

Yes, you can click on the links above and download chapter-wise Practice worksheets in PDFs for Class 7 for Computer Science Formulas and Functions in Ms Excel

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

How can I download the Formulas and Functions in Ms Excel Class 7 Computer Science Practice worksheets

You can easily access the links above and download the Class 7 Practice worksheets Computer Science for Formulas and Functions in Ms Excel

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

Can test sheet papers for Formulas and Functions in Ms Excel Class 7 Computer Science be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Formulas and Functions in Ms Excel Class 7 Computer Science in mobile-friendly format and can be accessed on smartphones and tablets.

Are practice worksheets for Class 7 Computer Science Formulas and Functions in Ms Excel available in multiple languages

Yes, practice worksheets for Class 7 Computer Science Formulas and Functions in Ms Excel are available in multiple languages, including English, Hindi