AMP
Home › Tamil Nadu State Board › CLASS 11th › COMPUTER APPLICATIONS › Chapter 7: Working with OpenOffice Calc

Chapter 7: Working with OpenOffice Calc — Online MCQ Test

COMPUTER APPLICATIONS · CLASS 11th · Tamil Nadu State Board
Practice Chapter 7: Working with OpenOffice Calc with a free chapter-wise online MCQ test. This chapter covers: Focusing on electronic spreadsheets this chapter details grid layouts cell formatting data entry and mathematical formulas. Students master built-in functions chart generation and.... AI-generated questions from basic to board-exam level, with instant results and explanations.

Start Exam on Full Site →

Chapter 7: Working with OpenOffice Calc — Important Questions & Answers

Which component of the OpenOffice suite is used for electronic spreadsheet processing?
  • A. OpenOffice Writer
  • B. OpenOffice Calc
  • C. OpenOffice Impress
  • D. OpenOffice Base
Answer: B. OpenOffice Calc
OpenOffice Calc is the designated application for spreadsheet tasks within the OpenOffice suite.
The intersection of a row and a column in a worksheet is called a:
  • A. Field
  • B. Range
  • C. Cell
  • D. Block
Answer: C. Cell
In a spreadsheet, a cell is the fundamental unit formed by the intersection of a row and a column.
If cell A1 contains 10 and B1 contains 20, what is the result of =A1*B1?
  • A. 30
  • B. 200
  • C. 1020
  • D. 20
Answer: B. 200
The formula multiplies the values of cell A1 and B1 (10 * 20 = 200).
A student wants to calculate the average of numbers in cells B1 through B10. Which formula is correct?
  • A. =AVERAGE(B1;B10)
  • B. =AVG(B1:B10)
  • C. =AVERAGE(B1:B10)
  • D. =MEAN(B1:B10)
Answer: C. =AVERAGE(B1:B10)
The correct syntax for calculating an average in OpenOffice Calc is =AVERAGE(range).
If a cell contains '=5+10*2', what is the value displayed in the cell?
  • A. 30
  • B. 25
  • C. 20
  • D. 15
Answer: B. 25
Calc follows the BODMAS rule; multiplication is performed before addition (10*2=20, 20+5=25).