Tamil Nadu Board of Secondary EducationHSC Science Class 11th

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide chapter 7 - Working with OpenOffice Calc [Latest edition]

Chapter 7: Working with OpenOffice Calc

Evaluation - PART – IEvaluation - PART – IIEvaluation - PART – IIIEvaluation - PART – IV
Evaluation - PART – I [Pages 164 - 165]

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide Chapter 7 Working with OpenOffice CalcEvaluation - PART – I [Pages 164 - 165]

Evaluation - PART – I | Q 1. | Page 164

Which is the first electronic spreadsheet?

• Excel

• Lotus 1-2-3

• Visicalc

• OpenOffice Calc

Evaluation - PART – I | Q 2. | Page 164

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

• Visicalc

• LibreCalc

• Lotus 123

• StarOffice Calc

Evaluation - PART – I | Q 3. | Page 164

Grid of cells with a programmable calculator:

• Database

• Word processor

• Linux

Evaluation - PART – I | Q 4. | Page 164

A column heading in Calc is represented using ______.

• Number

• Symbol

• Date

• Alphabet

Evaluation - PART – I | Q 5. | Page 164

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

• Enter

• Tab

• Shift + Tab

• Delete

Evaluation - PART – I | Q 6. | Page 164

A formula in calc may begin with ______.

• =

• +

• -

• All the above

Evaluation - PART – I | Q 7. | Page 164

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

• 7

• 25

• 10

• 52

Evaluation - PART – I | Q 8. | Page 165

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

• True

• False

• 24

• 1212

Evaluation - PART – I | Q 9. | Page 165

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

• +

• %

• &

• $Evaluation - PART – I | Q 10. | Page 165 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 Evaluation - PART – II [Pages 165 - 166] Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide Chapter 7 Working with OpenOffice CalcEvaluation - PART – II [Pages 165 - 166] Very Short Answers Evaluation - PART – II | Q 1. | Page 165 What are the types of toolbars available in OpenOffice calc? Evaluation - PART – II | Q 2. | Page 165 What is a Cell pointer? Evaluation - PART – II | Q 3. | Page 165 Write about the text operator in OpenOffice Calc. Evaluation - PART – II | Q 4. | Page 165 Write the general syntax of constructing a formula in Calc. Evaluation - PART – II | Q 5. | Page 165 What are the keyboard shortcuts to cut, copy and paste? Evaluation - PART – II | Q 6. | Page 165 Can you edit the contents of a cell? If yes, explain any one of the method of editing the cell content. Evaluation - PART – II | Q 7. | Page 165 What are the options available in “Insert Cells” dialog box? Evaluation - PART – II | Q 8. | Page 165 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
Evaluation - PART – II | Q 9. (i) | Page 165

Define Text Operator.

Evaluation - PART – II | Q 9. (ii) | Page 165

Define Rows and Columns of spreadsheet.

Evaluation - PART – II | Q 10. | Page 166

Differentiate between Copy -Paste and Cut-Paste.

Evaluation - PART – III [Page 166]

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide Chapter 7 Working with OpenOffice CalcEvaluation - PART – III [Page 166]

Evaluation - PART – III | Q 1. | Page 166

Write a short note on OpenOffice Calc.

Evaluation - PART – III | Q 2. | Page 166

Write about inserting columns and rows in Calc.

Evaluation - PART – III | Q 3. | Page 166

Differentiate Deleting data using Backspace and Delete.

Evaluation - PART – III | Q 4. | Page 166

Write any three formatting options.

Evaluation - PART – III | Q 5. | Page 166

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

Evaluation - PART – IV [Page 166]

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide Chapter 7 Working with OpenOffice CalcEvaluation - PART – IV [Page 166]

Explain in Detail

Evaluation - PART – IV | Q 1. | Page 166

Explain about changing the column width in Calc.

Evaluation - PART – IV | Q 2. | Page 166

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

Evaluation - PART – IV | Q 3. | Page 166

 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.

1. Total sales in the year 2015.
2. Total sales in Coimbatore from 2012 to 2016.
3. Total sales in Madurai and Tiruchi during 2015 and 2016.
4. Average sales in Chennai from 2012 to 2016
5. In 2016, how many “Air Coolers” are sold in Chennai compared to Coimbatore?

Chapter 7: Working with OpenOffice Calc

Evaluation - PART – IEvaluation - PART – IIEvaluation - PART – IIIEvaluation - PART – IV

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide chapter 7 - Working with OpenOffice Calc

Tamil Nadu Board Samacheer Kalvi solutions for Class 11th Computer Applications Answers Guide chapter 7 (Working with OpenOffice Calc) include all questions with solution and detail explanation. This will clear students doubts about any question and improve application skills while preparing for board exams. The detailed, step-by-step solutions will help you understand the concepts better and clear your confusions, if any. Shaalaa.com has the Tamil Nadu Board of Secondary Education Class 11th Computer Applications Answers Guide solutions in a manner that help students grasp basic concepts better and faster.

Further, we at Shaalaa.com provide such solutions so that students can prepare for written exams. Tamil Nadu Board Samacheer Kalvi textbook solutions can be a core help for self-study and acts as a perfect self-help guidance for students.

Concepts covered in Class 11th Computer Applications Answers Guide 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 Tamil Nadu Board Samacheer Kalvi Class 11th solutions Working with OpenOffice Calc exercise by students are an easy way to prepare for the exams, as they involve solutions arranged chapter-wise also page wise. The questions involved in Tamil Nadu Board Samacheer Kalvi Solutions are important questions that can be asked in the final exam. Maximum students of Tamil Nadu Board of Secondary Education Class 11th prefer Tamil Nadu Board Samacheer Kalvi Textbook Solutions to score more in exam.

Get the free view of chapter 7 Working with OpenOffice Calc Class 11th extra questions for Class 11th Computer Applications Answers Guide and can use Shaalaa.com to keep it handy for your exam preparation