InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

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

MABS Institution

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

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

To select multiple continuous sheet which key is used?

Ctrl
Shift
Alt
tab

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

True
False
Blasse
Error

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

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

COMBINA
CEILING
Floor
ABS

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

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

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 active sheet colour will be of which colour?

Grey
Green
White
Yellow

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

12
13
D
E

To make which cell address absolute we use sign?

Absolute
Relative
Comparative
Reference

Part - B

Generic 2 - Answer All Question

What is sorting?

What are the type of the filters?

Write the steps to format the margin of the paper as 1” in all sides.

What is Chart?
What is the use of freezing a sheet?

What is header and footer?

Write the method to rename sheet.

How to select continuous and non-continuous sheets in OpenOffice Calc?

What are the types of Cell addressing?

Part - C

Generic 3 - Answer All Question

What is range? Give example.

How to hide/show rows and columns in sheet?

Write briefly about ASIN function in Open Office Calc.

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

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

The user needs page number at the bottom of all pages. Which tool is used? Write the steps to design the needs.

What are functions in OpenOffice Calc?

Differentiate relative Cell addressing from absolute cell addressing

Part - D

Generic 5 - Answer All Question

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.

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

Explain the applications of Header and Footer with example.

Comment

Add Comment

Tamilnadu Stateboardszs - Class