CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B

Read and download free pdf of CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B. Download printable Informatics Practices Class 11 Worksheets in pdf format, CBSE Class 11 Informatics Practices Office Automation Tools Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Informatics Practices Class 11 Assignments and practice them daily to get better marks in tests and exams for Class 11. Free chapter wise worksheets with answers have been designed by Class 11 teachers as per latest examination pattern

Office Automation Tools Informatics Practices Worksheet for Class 11

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

Class 11 Informatics Practices Office Automation Tools Worksheet Pdf

Topic : OFFICE AUTOMATION TOOLS

OPEN OFFICE CALC

LAB- WORKSHEET

Write the steps to do the following:

1. Open a new spreadsheet in Open Office Calc and save it as InternetHours

The following table records the number of hours each student uses Internet in a week:

CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B

a) Type data into your spreadsheet.

b) Add another column titled “SlNo:”to the left of name column. Fill the number in SlNo column using auto fill feature.

c) Add another column titled “Total hours per user”. Using an appropriate formula, calculate the total hours each student used in the week.

d) Add another column titled “ Average hours used in a week”. Using an appropriate formula,calculate the average hours each student used in a week. The hours should be rounded to 1 decimal place.

e) Below the last student, add a row titled “Total hours per day”. Using an appropriate formula, calculate the total hours used each day of the week.

f) Add another row titled “Minimum hours used”. Using an appropriate formula, find the minimum number of hours used for each of the days.

g) Add another row titled “Maximum hours used”. Using an appropriate formula, find the maximum number of hours used for each of the days.

h) Select the cell wherever 0 is typed and put red colour for that cell

i) Count the number of students using the count() function.

j) Add a title “INTERNET USAGE” to your spreadsheet.

k) Save the spreadsheet with appropriate name.


Please click on below link to download CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B

Practice Worksheets for Class 11 Information Practices
CBSE Class 11 Informatics Practices Hardware Concepts Worksheet
CBSE Class 11 Informatics Practices Java Programming Decision Structures Worksheet
CBSE Class 11 Informatics Practices Java Programming List Box Worksheet
CBSE Class 11 Informatics Practices Java Programming Looping Structures Worksheet
CBSE Class 11 Informatics Practices Java Programming Variables Worksheet
CBSE Class 11 Informatics Practices Java Programming Worksheet
CBSE Class 11 Informatics Practices My Sql Worksheet Set A
CBSE Class 11 Informatics Practices My Sql Worksheet Set B
CBSE Class 11 Informatics Practices My Sql Worksheet Set C
CBSE Class 11 Informatics Practices My Sql Worksheet Set D
CBSE Class 11 Informatics Practices My Sql Worksheet Set E
CBSE Class 11 Informatics Practices My Sql Worksheet Set F
CBSE Class 11 Informatics Practices Python Conditional And Iterative Worksheet
CBSE Class 11 Informatics Practices Simple Queries Worksheet
CBSE Class 11 Informatics Practices Simple Queries Worksheet Set A
CBSE Class 11 Informatics Practices Sql Worksheet
CBSE Class 11 Informatics Practices Worksheet Set A Solved
CBSE Class 11 Informatics Practices Worksheet Set B Solved
CBSE Class 11 Informatics Practices Worksheet Set C Solved
CBSE Class 11 Informatics Practices Worksheet Set D Solved
CBSE Class 11 Informatics Practices Worksheet Set E Solved
CBSE Class 11 Informatics Practices Worksheet Set F Solved
CBSE Class 11 Informatics Practices Worksheet Set G Solved
CBSE Class 11 Informatics Practices Worksheet Set H Solved
CBSE Class 11 Informatics Practices Worksheet Set I Solved
CBSE Class 11 Informatics Practices Worksheet Set J Solved
CBSE Class 11 Informatics Practices Worksheet Set K Solved
CBSE Class 11 Informatics Practices Worksheet Set L Solved
CBSE Class 11 Informatics Practices Worksheet Set M Solved
CBSE Class 11 Informatics Technology Computer Fundamentals Worksheet
CBSE Class 11 Informatics Technology Computer Organization And Network Worksheet
CBSE Class 11 Informatics Technology Computer Organization And User Perspective Worksheet
CBSE Class 11 Informatics Technology IT Applications Worksheet
CBSE Class 11 Informatics Technology Networking And Internet Worksheet
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set A
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set C
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set D
CBSE Class 11 Informatics Technology Open Office Calc Worksheet
CBSE Class 11 Informatics Technology Open Office Impress Worksheet
CBSE Class 11 Informatics Technology Open Office Writer Worksheet Set A
CBSE Class 11 Informatics Technology Open Office Writer Worksheet Set B
CBSE Class 11 Informatics Technology Presentation Worksheet Set F
CBSE Class 11 Informatics Technology Troubleshooting Hardware Software And Networking Worksheet Set A
CBSE Class 11 Informatics Technology Troubleshooting Hardware Software And Networking Worksheet Set B
CBSE Class 11 Informatics Technology Word Processing Worksheet

Office Automation Tools CBSE Class 11 Informatics Practices Worksheet

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

Where can I download latest CBSE Practice worksheets for Class 11 Informatics Practices Office Automation Tools

You can download the CBSE Practice worksheets for Class 11 Informatics Practices Office Automation Tools for the latest session from StudiesToday.com

Are the Class 11 Informatics Practices Office Automation Tools Practice worksheets available for the latest session

Yes, the Practice worksheets issued for Office Automation Tools Class 11 Informatics Practices have been made available here for the latest academic session

Is there any charge for the Practice worksheets for Class 11 Informatics Practices Office Automation Tools

There is no charge for the Practice worksheets for Class 11 CBSE Informatics Practices Office Automation Tools you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in Office Automation Tools Class 11 Informatics Practices

Regular revision of practice worksheets given on studiestoday for Class 11 subject Informatics Practices Office Automation Tools can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 11 Informatics Practices Office Automation Tools

Yes, studiestoday.com provides all the latest Class 11 Informatics Practices Office Automation Tools test practice sheets with answers based on the latest books for the current academic session