Spreadsheet ( LibreOffice Calc ) - Set 2

1. What does the "#DIV/0!" error in a formula cell in LibreOffice Calc represent ?
   1. The formula contains a syntax error.
   2. The formula attempts to divide a number by zero.
   3. The formula references a range in a different sheet.
   4. The formula is missing a closing parenthesis.
   Show Answer

   Answer : B
   Explain: "#DIV/0!" means the number or value is divided by 0 which is not possible.
2. What does the "#VALUE!"or 'Err:519' error in a formula cell in LibreOffice Calc indicate ?
   1. The formula contains a reference to a missing cell.
   2. The formula references cells from multiple sheets.
   3. The formula contains a circular reference.
   4. The formula includes inappropriate text in a numerical calculation.
   Show Answer

   Answer : D
   Explain: The formula yields a value that does not correspond to the definition; or a cell that is referenced in the formula contains text instead of a number.
3. What is the matching point of row and Column ?
   1. Cell
   2. Row
   3. Column
   4. Worksheet
   Show Answer

   Answer : A
   Explain: The meeting point of row and column is known as cell.
4. What is the shortcut key using for Paste special ?
   1. Ctrl+Shit+V
   2. Ctrl+V
   3. Ctrl+A+V
   4. Ctrl+Shift+C
   Show Answer

   Answer : A
   Explain: For paste we use Ctrl+V and for paste special we use Ctrl+Shift+V.
5. To insert chart we go to which menu ?
   1. Insert>Chart
   2. File>Chart
   3. Format>Chart
   4. Styles>Chart
   Show Answer

   Answer : A
   Explain: To insert chart we go to Insert menu and then chart option.
6. In which menu, Data Validity option are found ?
   1. File
   2. Insert
   3. Format
   4. Data
   Show Answer

   Answer : D
   Explain: When a worksheet is used to receive input data from users, data validation can be used to restrict users from invalid data input.
7. In which menu,Pivot Table option are found ?
   1. File
   2. Insert
   3. Format
   4. Data
   Show Answer

   Answer : D
   Explain: A PivotTable is an interactive way to quickly summarize large amounts of data.
8. In LibreOffice Calc, what does the "Sort Ascending" option do when applied to a range of cells ?
   1. It arranges the data in descending order.
   2. It organizes the data from smallest to largest.
   3. It reverses the order of the data in the range.
   4. It alphabetically arranges the data.
   Show Answer

   Answer : B
   Explain: Sort Option, found in Data Menu.
9. What is the Shortcut key used for Auto filter ?
   1. Ctrl+l
   2. Ctrl+Shift +L
   3. Ctrl+Shift +F
   4. Ctrl+Shift +V
   Show Answer

   Answer : B
   Explain: In Data menu, Auto filter option available. It is use to temporarily displays a subset of data based on specified criteria.
10. Shortcut key to insert date in calc ?
    1. Ctrl+ ;
    2. Ctrl+:
    3. Ctrl+Shift+;
    4. Ctrl+T
    Show Answer

    Answer : A
    Explain: For date use Ctrl + ; and Ctrl+Shft; use for time. Date and Time are available in Insert Option.
11. Which of the following chart is not available in libre office calc ?
    1. Line
    2. Pie
    3. Bar
    4. Circle
    Show Answer

    Answer : D
    Explain: Chart in LibreOffice Calc are: Column, Bar, Line, Area, Pie, XY (Scattered), Bubble, Net, Column and line, and Stock. There are total 10 charts.
12. Libreoffice calc does not give a wizard for ?
    1. Letter
    2. Fax
    3. Agenda
    4. E-Mail
    Show Answer

    Answer : D
    
13. LibreOffice Calc shortcut key for automatic spell check :
    1. Shift+F7
    2. Shift+F9
    3. Ctrl+F7
    4. Ctrl+F9
    Show Answer

    Answer : A
    
14. Spreadsheet file can be digitally signed using a certificate of standard ______
    1. X.502
    2. X.503
    3. X.510
    4. X.509
    Show Answer

    Answer : D
    Explain: An X.509 certificate is a digital certificate that uses the widely accepted international X.509 public key infrastructure (PKI) standard to verify that a public key belongs to the user, computer or service identity contained within the certificate.
15. Which is not a valid formatting mark in libreoffice calc ?
    1. Non-breaking space
    2. Non-breaking hypen
    3. Word joiner
    4. Sentence joiner
    Show Answer

    Answer : D