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

MABS Institution

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

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

To make which cell address absolute we use sign?

Absolute
Relative
Comparative
Reference

In a form, the teacher needs “True or False” as a drop down menu. Which of the following tool is used?

Form
Data
List
Format

Which command is used to show the hidden row in OpenOffice Calc?

Format → Row → Show
Format → Show → Row
Format→Display→Row
Format → Row → Display

The customer required to design the item number between 101 to 200. If the user types above 200 or below 100, the system should give an error message. Which of the following tool is used?

Listing
Filtering
Formatting
Validating

There are 10000 rows in a spread-sheet. The user need to view a particular row of the database. Which of the following tool is used?

Sorting
Merging
Filtering
Formatting

If cell A5 contains value 18, then if (A26<5; “True”, “False”) will return

True
False
Blasse
Error

To delete a single sheet which command is to be selected?

File → Sheet → Delete
Delete →Sheet→Delete
Sheet → Delete
Edit → Sheet → Delete

Which function sounds a number upto the nearest multiple of significance?

COMBINA
CEILING
Floor
ABS

The active sheet colour will be of which colour?

Grey
Green
White
Yellow

The size of an A4 paper is 21 cm x 29 cm. If the user chooses Landscape orientation, then the size of the paper is…..?

21 x 29
29 x 21
None of the above
All of the above

Part - B

Generic 2 - Answer All Question

What is header and footer?

Write the method to rename sheet.

What are the type of the filters?

What is sorting?

What is the use of freezing a sheet?

What is Chart?
What are the types of Cell addressing?

Part - C

Generic 3 - Answer All Question

Write briefly about ASIN function in Open Office Calc.

Write the steps for sorting the database based on the customer name in ascending order.

What is range? Give example.

Write the steps to print the title row on every page of the spread-sheet.
How to hide/show rows and columns in sheet?

What are functions in OpenOffice Calc?

Differentiate relative Cell addressing from absolute cell addressing

Part - D

Generic 5 - Answer All Question

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.

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

Explain the applications of Header and Footer with example.

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

Explain how to format worksheet.

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

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 Monthly Test - 2 ( Data Tools and Printing )

MABS Institution

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

Part - A

Multiple Choice Question - Answer All Question

To make which cell address absolute we use sign?

In a form, the teacher needs “True or False” as a drop down menu. Which of the following tool is used?

Which command is used to show the hidden row in OpenOffice Calc?

The customer required to design the item number between 101 to 200. If the user types above 200 or below 100, the system should give an error message. Which of the following tool is used?

There are 10000 rows in a spread-sheet. The user need to view a particular row of the database. Which of the following tool is used?

If cell A5 contains value 18, then if (A26<5; “True”, “False”) will return

To delete a single sheet which command is to be selected?

Which function sounds a number upto the nearest multiple of significance?

The active sheet colour will be of which colour?

The size of an A4 paper is 21 cm x 29 cm. If the user chooses Landscape orientation, then the size of the paper is…..?

Part - B

Generic 2 - Answer All Question

What is header and footer?

Write the method to rename sheet.

What are the type of the filters?

What is sorting?

What is the use of freezing a sheet?

What is Chart?

What are the types of Cell addressing?

Part - C

Generic 3 - Answer All Question

Write briefly about ASIN function in Open Office Calc.

Write the steps for sorting the database based on the customer name in ascending order.

What is range? Give example.

Write the steps to print the title row on every page of the spread-sheet.

How to hide/show rows and columns in sheet?

What are functions in OpenOffice Calc?

Differentiate relative Cell addressing from absolute cell addressing

Part - D

Generic 5 - Answer All Question

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.

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

Explain the applications of Header and Footer with example.

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

Explain how to format worksheet.

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

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.