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

MABS Institution

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

Time : 1.30 Hours

Part - A

Multiple Choice Question - Answer All Question

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

True
False
Blasse
Error

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

COMBINA
CEILING
Floor
ABS

Which can be powerful way to convey information to the reader through a pictorial representation?

Charts and images
graphs and images
Charts and graphs
Images and Pictures

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

To protect cell in Open Office Calc Format → Cells and click which tab?

Protect Cell
Protection Cell
Cell Protection
Cell Protect

To select multiple continuous sheet which key is used?

Ctrl
Shift
Alt
tab

What will be value returned by = DECIMAL (“16;”1101)

To make which cell address absolute we use sign?

Absolute
Relative
Comparative
Reference

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

Part - B

Generic 3 - Answer All Question

How to hide/show rows and columns in sheet?

Differentiate relative Cell addressing from absolute cell addressing

What is range? Give example.

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

Write briefly about ASIN function in Open Office Calc.

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 - 4 ( Data Tools and Printing )

MABS Institution

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

Part - A

Multiple Choice Question - Answer All Question

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

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

Which can be powerful way to convey information to the reader through a pictorial representation?

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?

To protect cell in Open Office Calc Format → Cells and click which tab?

To select multiple continuous sheet which key is used?

What will be value returned by = DECIMAL (“16;”1101)

To make which cell address absolute we use sign?

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?

Part - B

Generic 3 - Answer All Question

How to hide/show rows and columns in sheet?

Differentiate relative Cell addressing from absolute cell addressing

What is range? Give example.

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

Write briefly about ASIN function in Open Office Calc.

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