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 Weekly Test - 2 ( Introduction to Spreadsheet )

MABS Institution

11th Computer Technology Weekly Test - 2 ( Introduction to Spreadsheet )-Aug 2020

Time : 1.30 Hours

Part - A

Multiple Choice Question - Answer All Question

Grid of cells with a programmable calculator:

Spreadsheet
Database
Word processor
Linux

Which of the following symbol is used to make a cell address as an absolute reference?

+
%
&
$

Which of the following applications was the parent to OpenOffice Calc?

Visicalc
LibreCalc
Lotus 123
Star Office Calc

What will be the result from the following expression (Assume H1=12, H2=12)? = H1<>H2

True
False
24
1212

Which of the following key combination is used to increase the width of the current column?

Alt + Right arrow
Ctrl + Right arrow
Alt + Left arrow
Ctrl + Left arrow

Which is the first electronic spreadsheet?

Excel
Lotus 1-2-3
Visicalc
Open Office Calc

A column heading in Calc is a

Number
Symbol
Date
Alphabet

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

7
25
10
52

A formula in calc may begin with

=
+
-
All the above

Which key is used to move the cell pointer in the forward direction within the worksheet?

Enter
Tab
Shift + Tab
Delete

Part - B

Generic 2 - Answer All Question

Write the general syntax of constructing a formula in Calc.

Differentiate between Copy -Paste and Cut-Paste.

What are the types of toolbars available in OpenOffice calc?

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 is a Cell pointer?

Write about the text operator in OpenOffice Calc.

What are the keyboard shortcuts to cut, copy and paste?

What are the options available in “Insert Cells” dialog box?

Can you edit the contents of a cell? If yes, explain any one of the method of editing the cell content.

Define the following (i) Text Operator (ii) Rows and Columns of spreadsheet.

Part - C

Generic 3 - Answer All Question

Write a short note on OpenOffice Calc.

In cell A1=34 A2=65 A3=89 write the forumla to find the average.

Write about inserting columns and rows in Calc.
Differentiate Deleting data using Backspace and Delete.

Write any three formatting options.

Comment

Add Comment

Tamilnadu Stateboardszs - Class