CBSE Class 6 Computers More on MS Excel Worksheet

Read and download free pdf of CBSE Class 6 Computers More on MS Excel Worksheet. Download printable Computer Science Class 6 Worksheets in pdf format, CBSE Class 6 Computer Science More on 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 6 Assignments and practice them daily to get better marks in tests and exams for Class 6. Free chapter wise worksheets with answers have been designed by Class 6 teachers as per latest examination pattern

More on MS Excel Computer Science Worksheet for Class 6

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

Class 6 Computer Science More on MS Excel Worksheet Pdf

CHAPTER-5.

More on MS Excel 2007: Formulae and Operations on Rows/Columns.

Q1. How do you write text formula?
 
Ans. Text Formula is written by enclosing it in double quotes.
 
Q2. What is concatenation?
 
Ans. The process of linking text values in a sequence within a formula is called concatenation.
 
Q3. What are arguments in a function?
 
Ans. Arguments in a function are called as range of cells.
 
Q4. What are the basic types of operators available in MS Excel? Give an example of each type.
 
Ans. 1) Arithmetic Operator: + , -
2) Relational Operator : =
3) Logical Operator: NOT
 
Q5. Write the order of precedence of operators.
 
Ans. 1) ( ) : Parenthesis
2) ^ : Exponent
3) *, / : Multiplication, Division
4) +, - : Addition, Subtraction.
 
Q6. Define the term Sorting?
 
Ans. Arranging a set of data in ascending or descending order is called sorting.
 
Q7. Write the rules to write a formula in excel.
 
Ans. Rules to write a formula:
 
1) Every formulae in Excel must begin with an ‘=’ sign.
 
2) There must be some arithmetic operator to operate on numbers or data.
 
3) The data can be a cell address also.
 
Q8. What is the use of MAX( ) and MIN( ) functions?
 
Ans. MAX( ): Calculates the maximum values from a given set of values.
 
MIN( ): Calculates the minimum value from a given set of values.
 
Q9. Write the steps to sort data in MS Excel?
 
Ans. Steps to sort data: -
1) Select the cells
2) Click the Data tab on the ribbon.
3) Click Sort in Sort & Filter group.
4) Select the required options.
5) Click OK button.
 

More on MS Excel CBSE Class 6 Computer Science Worksheet

The above practice worksheet for More on MS Excel has been designed as per the current syllabus for Class 6 Computer Science released by CBSE. Students studying in Class 6 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 6 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 6 Computer Science students to get all the latest study material free of cost. Teachers of studiestoday have referred to the NCERT book for Class 6 Computer Science to develop the Computer Science Class 6 worksheet. 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 6 Computer Science designed by our teachers. After solving these you should also refer to Class 6 Computer Science MCQ Test for the same chapter. We have also provided a lot of other Worksheets for Class 6 Computer Science which you can use to further make yourself better in Computer Science.

Where can I download latest CBSE Practice worksheets for Class 6 Computer Science More on MS Excel

You can download the CBSE Practice worksheets for Class 6 Computer Science More on MS Excel for the latest session from StudiesToday.com

Are the Class 6 Computer Science More on MS Excel Practice worksheets available for the latest session

Yes, the Practice worksheets issued for More on MS Excel Class 6 Computer Science have been made available here for the latest academic session

Is there any charge for the Practice worksheets for Class 6 Computer Science More on MS Excel

There is no charge for the Practice worksheets for Class 6 CBSE Computer Science More on MS Excel you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in More on MS Excel Class 6 Computer Science

Regular revision of practice worksheets given on studiestoday for Class 6 subject Computer Science More on MS Excel can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 6 Computer Science More on MS Excel

Yes, studiestoday.com provides all the latest Class 6 Computer Science More on MS Excel test practice sheets with answers based on the latest books for the current academic session