11th Standard Syllabus & Materials
11th Standard
TN 11th Tamil இயற்கை வேளாண்மை,சுற்றுச்சூழல் -செய்யுள் - மனோன்மணீயம் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil என்னுயிர் என்பேன் -துணைப்பாடம் - இசைத்தமிழர் இருவர் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil மொழி கலை -செய்யுள் - ஒவ்வொரு புல்லையும் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil பீடு பெற நில் - இலக்கணம் - பகுபத உறுப்புகள் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil பீடு பெற நில் - துணைப்பாடம் - வாடிவாசல் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil பீடு பெற நில் - செய்யுள் - குறுந்தொகை Important Questions And Answers Study Material - QB365 Set A

Published on: 06/09/2019
Introduction to Spreadsheet
Download Tamil Nadu 11th Standard Computer Technology question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.
Questions + Answers key
Take MCQ Computer Technology Test

1.
What are the keyboard shortcuts to cut, copy and paste?
2.
Write the general syntax of constructing a formula in Calc.
3.
Write about the text operator in OpenOffice Calc.
4.
Write any three formatting options.
5.
Differentiate Deleting data using Backspace and Delete.
6.
Write about inserting columns and rows in Calc.
7.
Write the steps to generate the following series. 5, 10, 20 ….. 2560.
8.
Explain about changing the column width in Calc.
9.
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
10.
What will be the result of the following expression (Assume H1 = 12, H2 = 12)? = H1 <> H2
True
False
24
1212
11.
What will be the result of the following formula (Assume A1 = 5, B2 = 2)? + A1 ^ B2
7
25
10
52
12.
Grid of cells with a programmable calculator:
Spreadsheet
Database
Word processor
Linux
13.
Which of the following applications is the parent to OpenOffice Calc?
Visicalc
LibreCalc
Lotus 123
Star Office Calc
1.
The Keyboard Shortcuts to
(i) Cut → Ctrl + x
(ii) Copy → Ctrl + c
(iii) Paste → Ctrl + v
2.
General Syntax of constructing a formula is : = cell reference 1 <operator> cell reference 2 <operator> ......................
3.
In Calc, "&" is a text operator which is used t combine two or more text. Joining two different texts is also known as "Text Concatenation". An expression using the text operator has the following syntax: text reference 1 & text reference 2.
4.
(i) Bold
(ii) Italic
(iii) Underline
5.
| Deleting Data | Backspace |
| Delete key deletes data towards right of the insertion point. | Backspace key deletes data towards left of the insertion point |
6.
Insert a new column anywhere in the worksheet.
Step 1 : Select the column where a new column to be inserted.
Step 2 : Right–click on the selected column name that you selected. A pop-up menu appears.
Step 3 : click the "Insert Columns" option from the menu.
a new column will be inserted to the left of the current column. Insert a new row in the worksheet.
Step 1 : Select the row where a new row to be inserted.
Step 2 : Right–click on the row number, a pop-up menu appears.
Step 3 : click "Insert Rows" option from the menu a new row will be inserted to above the current row.
7.
The steps to generate the series 5,10,20.......2560.
Step 1 : Select Edit → fill → Series Command. The fill series dialog log opens. In the dialog box.
Step 2 : Select Direction (Down / Right / Up / Left) in which the series to be displayed.
Step 3 : Select Growth to generate the series
Step 4 : Initial value of the series 5 should be typed in start value box.
Step 5 : End value of the series 2560 should be typed in End value text box.
Step 6 : Growth value of the series 2 should be typed in Increment text box.
Step 7 : Click OK to generate the series.
8.
Changing Column Width and Row Height :
(i) Often while entering data into a worksheet you will realize that the width of the column is not enough.
(ii) StarOffice Calc. allows you to change the width of a column and the height of a row. To change the column width, select the column whose width you want to change.
(iii) Click on Format → Column → Width and type the new column width in the dialog box, which appears as shown in figure Click on OK.
(iv) You can also change the column width in another way. Point to the line separating the column whose width you want to change from the next column.
(v) The mouse pointer becomes a double – headed arrow. Click and drag this pointer to the left to decrease the width and to the right to increase the width.
9.
(a)
Alt + Right arrow
10.
(b)
False
11.
(b)
25
12.
(a)
Spreadsheet
13.
(d)
Star Office Calc
11th Standard Syllabus & Materials
11th Standard
TN 11th Tamil பீடு பெற நில் - செய்யுள் - காவடிச்சிந்து Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil பீடு பெற நில் - உரைநடை - மலை இடப்பெயர்கள் : ஓர் ஆய்வு Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil மாமழை போற்றுதும் - துணைப்பாடம் - யானை டாக்டர் Important Questions And Answers Study Material - QB365 Set A
NEW11th Standard
TN 11th Tamil மாமழை போற்றுதும் - செய்யுள் - ஐங்குறுநூறு Important Questions And Answers Study Material - QB365 Set A
Tamilnadu Stateboard 11th Standard Subjects

Maths

Commerce

Economics

Biology

Business Maths and Statistics

Accountancy

Computer Science

Physics

Chemistry

Maths

Biology

Economics

Physics

Chemistry

History

Business Maths and Statistics

Computer Science

Accountancy

Computer Applications

History

Computer Technology

Commerce

Computer Applications

Computer Technology

Tamil

English

French
Tamilnadu Stateboard Standards