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 Applications Monthly Test -1 ( Working with OpenOffice Calc )

MABS Institution

11th Computer Applications Monthly Test -1 ( Working with OpenOffice Calc )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

Ms-Excel introduced in the year

1982
1985
1979
1987

Which of the following applications was the parent to Open Office Calc?

Visicalc
LibreCalc
Lotus 123
StarOffice Calc

How many selection available to select the cells of a worksheet?

3
4
2
1

How many direction keys are used to move the cell pointer in worksheet?

3
4
6
none

Which of the following is, not style of column chart?

Normal
Stacked
Donut
Percent stacked

Which operator in Open office calc gives exponent value?

^
%
!
< >

How many columns are there in Openoffice calc version 4.1.4?

256
16387
512
1024

Which of the following menu have the option 'Delete cells'?

View
Edit
Format
Insert

Active sheet tab will appear in ------------ clear.

Green
Red
Purple
White

How many options are there in Insert cells dialog box?

3
4
5
6

Part - B

Generic 2 - Answer All Question

Differentiate spreadsheet and worksheet.

How discard button differ from cancel button in alert message box while saving the document?

Write the steps that appears in a chart wizard in Calc?

Differentiate operators and Expression.

How will you select multiple sheets in a worksheet?

Match the following.

A B

(a) Cut, Copy and Paste (1) Absolute Cell

(b) Cell pointer (2) Status bar

(c) Selection Mode (3) Standard Toolbar

(d) $A$5 (4) Active cell

What are the options available in "Insert Cells" dialog box?

Name any four text formatting Icons

How relative cell reference become Absolute reference?

Differentiate between Copy -Paste and Cut-Paste

Part - C

Generic 3 - Answer All Question

In cell A1 =34, A2=65, A3=89; write the formula to find the average.

Write the steps to do selection sort.

Write the steps for using Auto filter

Define Table, Record and Filed.

Write the three types of reference Operators?

How will you insert cells, row and columns using "Insert cells" Toolbar.
Name the file type for the extension (i) .odt (ii) .ods (iii) . odp

Write the steps to construct a formula in a worksheet?

Write the steps to insert a new column in a worksheet.

What is the use of tab key, Shift tab key and Enter key in a worksheet?

Part - D

Generic 5 - Answer All Question

Explain how will you generate whole number series.

Explain about changing the column width in Calc.

Explain Reference operator with an example.

Explain how will you cut, copy and Paste data in a worksheet.

Write down the parts of the OpenOffice Calc window.

Explain the features of OpenOffice Calc.

Explain how will you insert a function wizard.

Write the steps to apply standard filter?
Explain how will you insert a function using Direct Insert method.

Write the steps to generate the following series. 5,10, 20 ..... 2560.

Comment

Add Comment

Tamilnadu Stateboardszs - Class