9th Class LibreOffice Calc – Multiple Choice Questions

इस पोस्ट में आपको LibreOffice Calc के Objective Type Question और Fill in the Blanks मिलेंगे जिससे आपको अपने एग्जाम के लिए काफी helpful होगा 

Multiple choice Questions

  • Which of the following technique can be used to allow only date value in cell ?
    1. Data formatting    
    2. Data sorting
    3. Data filtering
    4. Data validation
  • Which of the following options when selected deletes all data validation?
    1. Delete formatting
    2. Delete all
    3. Delete formula
    4. Delete me
  • We can replace multiple occurrences of a word using which of the following facilities of Calc?
    1. Find and replace
    2. By copy only
    3. By copy command
    4. By preview command
  • What is the name of a mechanism to arrange the data in a particular order?
    1. Sorting
    2. Searching
    3. Filtering
    4. Validating
  • What is the name of mechanism to filter out unnecessary data?
    1. Sorting
    2. Searching
    3. Filtering
    4. Validating
  • Which of the following type of package does Calc refer to ?
    1. Spreadsheet
    2. Double sheet
    3. Multi-sheet
    4. Cannot determine
  • Which of the following is an extension of a worksheet created in Calc?
    1. .ods
    2. .odd
    3. .xls
    4. .obj
  • How can one calculate the total of values entered a worksheet column of?
    1. By manual entry
    2. By auto-sum
    3. By formula
    4. By sum functions
  • What is the correct way to enter a function in Calc?
    1. Directly typing function name in a cell
    2. Using function wizard to selecting from toolbar
    3. Both (a) and (b)
    4. Depends on the function
  • A function should start with                              
    1. ̔= ̓ sign
    2. alphabets
    3. numbers
    4. All of the these
  • Which of the following option is used to print a chart?
    1. Insert → Chart
    2. File → View
    3. File→ Print
    4. View → Chart
  • How many axes does chart in Calc have?
    1. Two
    2. Three
    3. Two or Three
    4. Four
  • The chart preview can be seen in .
    1. Page preview
    2. Chart preview
    3. Export chart
    4. All of these

  Fill in the blanks

  1. The column  immediately  next  to  column    “Z”  is AA
  2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is .ods .
  3. The spreadsheet feature used to continue the series is called as fill handle.
  4. The formula ‘’=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to  =min(d1:d5)
  5. The formula in cell A2 is = B2+C3. On copying this formula to cell C2, C2 will change to =d2+e3
  6. The cell address of the cell formed by the intersection of the ninth column and the eight row will be 18.
  7.  $A1$B2 is an example of mixed referencing in spreadsheet software .
  8.  Number entered into a cell are automatically  right aligned.
  9.  If A1:A5 contain the number 16 , 10, 3, 25 and 6 then = Average(A1:A5;60) will display 20.
  10. In Relative referencing, the reference changes rows and columns automatically when it is copied to a new cell.

यदि आप Multipe Choice Questions के इलावा Short Answer Type Question भी देखना चाहते है तो आप लिंक पर क्लिक कर देख सकते है –

2 thoughts on “9th Class LibreOffice Calc – Multiple Choice Questions”

Leave a Comment

error: Content is protected !!