Welcome to your Libre Office Calc Set 1 1. Shortcut key to insert cell in Libreoffice Calc? shift + + Ctrl + – Ctrl + + Ctrl + shift + + None 2. What is the maximum cell height in Libreoffice calc? 3.37 Inches 39 Inches 39.37 Inches 37.39 Inches None 3. How many seats are there by default in the work book of LibreOffice Calc? 1 2 3 4 None 4. How to edit cell in LibreOffice Calc spreadsheet, or what shortcut key will be used to edit the cell? F1 F2 F12 None None 5. What is the shortcut key to move from one cell to another in LibreOffice Calc? Ctrl + Q Tabs Ctrl + M None None 6. Currently you are on a G7 cell in a Libreoffice Calc spreadsheet, which of the following will you be in after pressing the Home key of the keyboard? A1 A7 F7 B7 None 7. Which shortcut key will be used to open the dialog box that formats the cell in LibreOffice Calc? Alt + Shift + 1 Ctrl + 1 Alt + 1 None None 8. The maximum width of a column can be? 400 300 200 100 None 9. Shortcut key ‘Ctrl + -‘ used for? Delete column Delete cell Delete sheet Delete row None 10. The formula in LibreOffice Kalka starts with? = @ ? # None 11. Which of the following can represent a column in LibreOffice Calc? 1,2,3,4 A1, B1, C1 A, B, C, D 1A, 1B, 1C None 12. Which of the following is used to convert a row into a column? Reverse Row to column Convert Transpose None 13. What is the default width of the column in the libre office column? 1.28 inch .18 inch .89 inch 1.05 inch None 14. The formula that will be multiplied by the value of B2 years after adding the value of cell C2 with the value of D4? D4 + C2 * B2 (D4 + C2) * B2 [(B2 * (D4 + C2)] (D4 + C2) * B2 None 15. Which shortcut key will be used to edit the current cell? Ctrl + F4 F2 Ctrl + F2 F4 None 16. Which shortcut key will be used to go to the bottom ROW in the spreadsheet? Ctrl + Shift + Down Arrow Alt + Shift + Down Arrow Alt + Ctrl + Down Arrow Ctrl + Down Arrow None 17. Which of the following can represent Row in LibreOffice Calc? A, B, C, D 1,2,3,4 1A, 1B, 1C A1, B1, C1 None 18. Which is the function used in the ‘= SUM (A1: A2)’ formula? numerical logical Mathematical text None 19. What is the number of seats by default in LibreOffice 6.0 Calc? 1 2 3 4 None 20. In LibreOffice Call, there are some numbers in cell A1, A2, A3, A4. What will be the cell address when transpose them? A1, B1, C1, D1 A1: B4 B1, B2, B3, B4 B1, C1, D1, E1 None 21. What is the shortcut key to full screen Libreoffice Calc? Ctrl + Alt + G Ctrl + Shift + J Ctrl + Shift + G Ctrl + Alt + R None 22. What is the shortcut key to close LibreOffice spreadsheet? Ctrl + T Ctrl + H Ctrl + Q Ctrl + Shift + E None 23. 1 or more worksheets are found in LibreOffice Calc ………. Workbook Worksheet cell Template None 24. How is the cell selected in LibreOffice Calc defined? A Blinking Border A Deep Wide Border A Dotted Border By Italic text None 25. Calculates the sum of cells from B10 to B14 and adds the value of B8, then what will be the formula? SUM (B10: B14) + B8 SUM (B11: B14) + B8 SUM (B12: B14) + B8 None None Share this:TweetEmailTelegramPrintWhatsAppLike this:Like Loading... Related Posts (You May Also Read):