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 -2 ( Working with OpenOffice Calc )

MABS Institution

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

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

Which will limit the visible rows in a spreadsheet?

Filters
Sort
Function
Chart

(258) is treated as

Positive number
negative number
text
label

Which of the following command used to check the worksheet required format to be printed?

File Pageview
File Page preview
Format Page
File Print preview

What will be the result from the following formula (Assume A1=5, B2=2)? +A1^B2

7
25
10
52

The default zoon scale in

25 %
75 %
50 %
100%

Which menu consists cut, copy and paste option?

file
Edit
Tools
Format

if \(\times\)2 = 98, \(\times\)3 = 100 what is result if (=\(\times\)2 >= \(\times\)3)?

False
True
198
98100

How many categories of functions in Openoffice Calc?

10
11
12
13

An alternate way to copy and paste is

Autocopy
Autocut
Autofill
Autopaste

Openoffice keeps a list of recently opened files under the menu?

Tools
Format
View
file

Part - B

Generic 2 - Answer All Question

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

Write a note on visicalc.

What are functions? How can be a function inserted in a worksheet?

How calc calculates the results in a worksheet?

What is Active cell?

Define cell

What is sorting.

Part - C

Generic 3 - Answer All Question

Write a note on conditional formatting.

Write the steps to insert a new row in a worksheet?

How will you insert cells, row and columns using "Insert cells" Toolbar.

Write the steps to do selection sort.

Write the elements of formula bar and their uses.

Write the classification of data types in Openoffice calc.

Write the three types of reference Operators?

Part - D

Generic 5 - Answer All Question

Explain the parts of OpenOffice Calc Status bar.

Explain how will you insert a function wizard.

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

Explain about changing the column width in Calc.
Explain Reference operator with an example.

Write the steps to do multiple sorting data.

Explain how will you generate whole number series.

Comment

Add Comment

Tamilnadu Stateboardszs - Class