Spreadsheet ( LibreOffice Calc )

1. What is the default file format used by LibreOffice Calc to save spreadsheets ?
   1. xlsx
   2. ods
   3. docx
   4. csv
   Show Answer

   Answer : B
   Explain: Default extension of Calc is .ods ( open document spreadsheet ).
2. What is the short cut key use to reach last edit cell in libreoffice calc
   1. Ctrl + Home
   2. Ctrl + End
   3. Home
   4. End
   Show Answer

   Answer : B
   Explain: Ctrl + End - Move cursor to last cell with data inside, Ctrl+ Home - move cursor to A1.
3. What is the short cut key is used to open function wizard libreoffice calc ?
   1. Alt+F1
   2. Ctrl + F3
   3. Ctrl+F2
   4. None of above
   Show Answer

   Answer : C
   
4. What is the short cut key is used to moves the cursor to the Input line where you can enter a formula for the current cell ?
   1. Shift + Ctrl + F2
   2. Ctrl + Home
   3. Ctrl + End
   4. F2
   Show Answer

   Answer : A
   Explain: Shift+Ctrl+F2 - Moves the cursor to the Input line where you can enter a formula for the current cell.
5. In LibreOffice calc formula always starts with ?
   1. #
   2. %
   3. ^
   4. =
   Show Answer

   Answer : D
   Explain: Formaula always start with = sign. Example : =max(A1:B3).
6. Shortcut key use to open the Define Names dialog ?
   1. F4
   2. F5
   3. Ctrl+F3
   4. F7
   Show Answer

   Answer : C
   Explain: Ctrl+F3 - define names dialog or by Manually, Choose Sheet - Named Ranges and Expressions - Define.
7. What is the maximum character lenght in one cell of LibreOffice calc ?
   1. 32767
   2. 1,048,576
   3. 1024
   4. 68
   Show Answer

   Answer : A
   Explain: The maximum number of characters in one cell is 32767, each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns.
8. How many types of cell refernce in LibreOffice calc ?
   1. 1
   2. 0
   3. unlimited
   4. 3
   Show Answer

   Answer : D
   Explain: There are three types of cell references in Excel: relative, absolute and mixed.
9. If the cell address not changes after copy the formula, this cell refence is known as ?
   1. Relative
   2. Absolute
   3. Dynamic
   4. Mixed
   Show Answer

   Answer : B
   Explain: Absolute refernce means when formula put in anohter cell its cell value not change.
10. What is the shortcut key for Format cells dialog box ?
    1. F1
    2. Ctrl+F3
    3. Ctrl+F1
    4. Ctrl+Shift +F2
    Show Answer

    Answer : C
    
11. What is the shortcut key is used to insert comment in LibreOffice Calc ?
    1. Ctrl+Alt+C
    2. Ctrl+Shift+J
    3. Ctrl+Alt+S
    4. Ctrl+Alt+T
    Show Answer

    Answer : A
    Explain: Press Ctrl+Alt+C, you can see a box along right side in which comment is write.
12. What shortcut keys is used to add cell in LibreOffice Calc ?
    1. Ctrl+=
    2. Ctrl++
    3. Ctrl+-
    4. Ctrl+*
    Show Answer

    Answer : B
    Explain: To insert or add cell or column use Ctrl+ + and to remove, we use Ctrl+ -.
13. In Which menu Freeze Rows and Columns Found ?
    1. File
    2. Insert
    3. View
    4. Format
    Show Answer

    Answer : C
    Explain: In view menu we see Freeze Rows and Columns are found.
14. In which menu Insert cell, Insert rows and insert column found. ?
    1. Insert
    2. Data
    3. Format
    4. Sheet
    Show Answer

    Answer : D
    Explain: In Calc, these option are found in Sheet Menu.
15. In, which menu merge and unmerge cell option is available ?
    1. Insert
    2. Sheet
    3. Style
    4. Format
    Show Answer

    Answer : D