11th Computer Technology Weekly Test - 2 ( Data Tools and Printing )

MABS Institution

11th Computer Technology Weekly Test - 2 ( Data Tools and Printing )-Aug 2020

Time : 1.30 Hours

Part - A

Generic 2 - Answer All Question

What is header and footer?

What is sorting?

Write the method to rename sheet.

What are the types of Cell addressing?

What are the type of the filters?

Part - B

Generic 5 - Answer All Question

Discuss in detail about steps to create chart in OpenOffice calc.

Explain the applications of Header and Footer with example.

Explain how to format worksheet.

How to use function in Open Office Calc? Explain with suitable example.

Create a Worksheet to contain student database with following fields.
Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.

Create a student database with register number, student name, Mark1, Mark2, and Mark3. Calculate the total and average of the students. Show the marks which are below 50 in red colour and marks above 50 is shown in green colour.

Comment

Add Comment

InstaQB

Institutions

12th Standard English Medium

12th Standard Tamil Medium

11th Standard English Medium

11th Standard Tamil Medium

10th Standard English Medium

9th Standard English Medium

8th Standard English Medium

7th Standard English Medium

Class XII

Class XI

12Th Standard

11Th Standard

10Th Standard

9Th Standard

11th Computer Technology Weekly Test - 2 ( Data Tools and Printing )

MABS Institution

11th Computer Technology Weekly Test - 2 ( Data Tools and Printing )-Aug 2020

Part - A

Generic 2 - Answer All Question

What is header and footer?

What is sorting?

Write the method to rename sheet.

What are the types of Cell addressing?

What are the type of the filters?

Part - B

Generic 5 - Answer All Question

Discuss in detail about steps to create chart in OpenOffice calc.

Explain the applications of Header and Footer with example.

Explain how to format worksheet.

How to use function in Open Office Calc? Explain with suitable example.

Create a Worksheet to contain student database with following fields. Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.

Create a student database with register number, student name, Mark1, Mark2, and Mark3. Calculate the total and average of the students. Show the marks which are below 50 in red colour and marks above 50 is shown in green colour.

Comment

Other Study material

11th Computer Technology Weekly Test - 3 ( Comput

11th Computer Technology Monthly Test - 4 ( Number

11th Computer Technology Monthly Test - 3 ( Numbe

11th Computer Technology Weekly Test - 1 ( Comput

11th Computer Technology Weekly Test - 2 ( Comput

11th Computer Technology Monthly Test - 4 ( Introd

11th Computer Technology Monthly Test - 1 ( Theore

11th Computer Technology Weekly Test - 4 ( Theoret

11th Computer Technology Weekly Test - 3 (Theoreti

11th Computer Technology Weekly Test - 2 ( Theore

11th Computer Technology Weekly Test - 1 (Theoret

11th Computer Technology Monthly Test - 4 ( Comput

11th Computer Technology Monthly Test - 3 ( Comput

11th Computer Technology Monthly Test - 2 ( Compu

11th Computer Technology Monthly Test - 1 ( Comput

Tamilnadu Stateboardszs - Class

Create a Worksheet to contain student database with following fields.
Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.