Advertisements
Chapters
2: Number Systems
3: Computer Organisation
4: Theoretical Concepts of Operating System
5: Working with Windows Operating System
6: Introduction to Word Processor
▶ 7: Working with OpenOffice Calc
8: Presentation Basics
9: Introduction to Internet and Email
10: HTML - Structural Tags
11: HTML - Formatting text, Creating Tables, List and Links
12: HTML - Adding multimedia elements and Forms
13: CSS - Cascading Style Sheets
14: Introduction to Javascript
15: Control Structure in Javascript
16: JavaScript Functions
17: Computer Ethics and Cyber Security
18: Tamil Computing
![Samacheer Kalvi solutions for Computer Applications [English] Class 11 TN Board chapter 7 - Working with OpenOffice Calc - Shaalaa.com](/images/computer-applications-english-class-11-tn-board_6:5f2b1b2038084cf381bfa42c826a928c.jpg "Samacheer Kalvi solutions for Computer Applications [English] Class 11 TN Board chapter 7 - Working with OpenOffice Calc")
Advertisements
Solutions for Chapter 7: Working with OpenOffice Calc
Below listed, you can find solutions for Chapter 7 of Tamil Nadu Board of Secondary Education Samacheer Kalvi for Computer Applications [English] Class 11 TN Board.
Samacheer Kalvi solutions for Computer Applications [English] Class 11 TN Board 7 Working with OpenOffice Calc Evaluation [Pages 164 - 166]
Part A - Choose the correct answer
Which is the first electronic spreadsheet?
Excel
Lotus 1-2-3
Visicalc
OpenOffice Calc
Which of the following applications was the parent to OpenOffice Calc?
Visicalc
LibreCalc
Lotus 123
StarOffice Calc
Grid of cells with a programmable calculator:
Spreadsheet
Database
Word processor
Linux
A column heading in Calc is represented using ______.
Number
Symbol
Date
Alphabet
Which key is used to move the cell pointer in the forward direction within the worksheet?
Enter
Tab
Shift + Tab
Delete
A formula in calc may begin with ______.
=
+
-
All the above
What will be the result from the following formula (Assume A1=5, B2=2)? + A1^B2?
7
25
10
52
What will be the result from the following expression (Assume H1=12, H2=12)? = H1<>H2?
True
False
24
1212
Which of the following symbol is used to make a cell address as an absolute reference?
+
%
&
$
Which of the following key combinations is used to increase the width of the current column?
Alt + Right arrow
Ctrl + Right arrow
Alt + Left arrow
Ctrl + Left arrow
Part B - Very Short Answers
What are the types of toolbars available in OpenOffice calc?
What is a Cell pointer?
Write about the text operator in OpenOffice Calc.
Write the general syntax of constructing a formula in Calc.
What are the keyboard shortcuts to cut, copy and paste?
Can you edit the contents of a cell? If yes, explain any one of the method of editing the cell content.
What are the options available in “Insert Cells” dialog box?
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) $A5$ | (4) Active cell |
Define Text Operator.
Define Rows and Columns of spreadsheet.
Differentiate between Copy -Paste and Cut-Paste.
Part C - Short Answers
Write a short note on OpenOffice Calc.
Write about inserting columns and rows in Calc.
Differentiate Deleting data using Backspace and Delete.
Write any three formatting options.
In cell A1=34 A2=65 A3=89 write the formula to find the average.
Part D - Explain in Detail
Explain about changing the column width in Calc.
Write the steps to generate the following series. 5, 10, 20 ….. 2560.
Read the following table.
| A | B | C | D | E | |
| 1 | Year | Chennai | Madurai | Tiruchi | Coimbatore |
| 2 | 2012 | 1500 | 1250 | 1000 | 500 |
| 3 | 2013 | 1600 | 1000 | 950 | 350 |
| 4 | 2014 | 1900 | 1320 | 750 | 300 |
| 5 | 2015 | 1850 | 1415 | 820 | 200 |
| 6 | 2016 | 1950 | 1240 | 920 | 250 |
Above table shows the sales figures for “Air Cooler” sold in four major cities of Tamilnadu from the year 2012 to 2016. Based on this data, write the formula to calculate the following.
- Total sales in the year 2015.
- Total sales in Coimbatore from 2012 to 2016.
- Total sales in Madurai and Tiruchi during 2015 and 2016.
- Average sales in Chennai from 2012 to 2016
- In 2016, how many “Air Coolers” are sold in Chennai compared to Coimbatore?
Solutions for 7: Working with OpenOffice Calc
Samacheer Kalvi solutions for Computer Applications [English] Class 11 TN Board chapter 7 - Working with OpenOffice Calc
Shaalaa.com has the Tamil Nadu Board of Secondary Education Mathematics Computer Applications [English] Class 11 TN Board Tamil Nadu Board of Secondary Education solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. Samacheer Kalvi solutions for Mathematics Computer Applications [English] Class 11 TN Board Tamil Nadu Board of Secondary Education 7 (Working with OpenOffice Calc) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. Samacheer Kalvi textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in Computer Applications [English] Class 11 TN Board chapter 7 Working with OpenOffice Calc are Deleting Columns and Rows, Formatting Worksheet, Functions, Working with Chart, Advanced Data Analysis Tools, Setting the Page Size, Orientation and Margins, Introduction to Spreadsheet, Working with Openoffice Calc, Creating a New Worksheet, Working with Data, Creating Formulae, Save, Close and Open the Worksheet, Copy, Cut and Paste, Auto Fill Feature, Inserting Columns, Rows and Cells.
Using Samacheer Kalvi Computer Applications [English] Class 11 TN Board solutions Working with OpenOffice Calc exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in Samacheer Kalvi Solutions are essential questions that can be asked in the final exam. Maximum Tamil Nadu Board of Secondary Education Computer Applications [English] Class 11 TN Board students prefer Samacheer Kalvi Textbook Solutions to score more in exams.
Get the free view of Chapter 7, Working with OpenOffice Calc Computer Applications [English] Class 11 TN Board additional questions for Mathematics Computer Applications [English] Class 11 TN Board Tamil Nadu Board of Secondary Education, and you can use Shaalaa.com to keep it handy for your exam preparation.
