Welcome to your Libre Office Calc Set 4 1. What is the shortcut key to close LibreOffice spreadsheet? Ctrl + Q Ctrl + H Ctrl + T Ctrl + Shift + E None 2. What will be the value of Product (7, 8) ? 15 1 56 -1 None 3. ………………………. option is found in Edit Menu in LibreOffice Calc. Replac Find Both A and B Share None 4. What is the last row and column name in Libreoffice Calc? 1048576, AMJ 1048776, AMH 1048556, AME 1047576, AMJ None 5. What is made at the place where the column and row cut each other? Cell Column Formula None None 6. Which is the easy way to select a column? Ctrl + A shortcut key Double clicking on any cell in the column Clicking on the column heading and selecting Selecting by dragging from the topmost cell of the column to the bottom None 7. Which shortcut key do you use to highlight a value in LibreOffice Calc Ctrl + F4 Ctrl + F1 Ctrl + F6 Ctrl + F8 None 8. In the LibreOffice call, is there a shortcut key to select the entire column? Ctrl + Shift + Space Shift + Space Ctrl + Space Ctrl + Shift + Enter None 9. What will be the value of ‘= SUM (2 (PRODUCT (3,7))’? 42 24 22 44 None 10. Which shortcut key is used to increase the width of columns in LibreOffice Calc? Alt + Right Arrow Alt + Dwon Arrow Ctrl + Right Arrow Alt + Left Arrow None 11. In LibreOffice, give the value of ‘= Average (1, 2, 4, 9)’? 2 3 4 5 None 12. To insert columns in LibreOffice call it has to be used? format seat Insert Style None 13. Select the correct formula from the following- Sum (D1? D2) SUM (D1: D2) Sum (D1: D2) All of the above None 14. What is the shortening type in LibreOffice Calc? three four two five None 15. What is the shortcut key to save as in LibreOffice spreadsheet? Shift + Alt + S Ctrl + Shift + S Ctrl + S Ctrl + Alt + S None 16. What is the default font name of LibreOffice Calc? Times New Roman Liberation Serif Calibri Liberation Sans None 17. From which menu is the text color changed in LibreOffice Calc? Style formatting edit view None 18. Which of the following charts is not in the chart menu? Bar Chart Pie Chart Line Chart Square Chart None 19. In LibreOffice Calc, which key is used along with the control key to create a new line or paragraph inside the cell? Ctrl Enter Alt Shift None 20. What is the address of last cell in LibreOffice Calc? AMJ1024 XFD1048576 AMJ1048576 XFD1024 None 21. What is the page orientation of LibreOffice Calc? Portrait landscape Horizontal none of the above None 22. What is the shortcut key to select cells in Libreoffice Calc? Ctrl + Shift + 1 Shift + D Ctrl + 1 Ctrl + A None 23. How is the cell selected in LibreOffice Calc defined? A Dotted Border A Blinking Border A Deep Wide Border By Italic tex None 24. The correct formula is to add cells B6, B8, B10? SUM (B6: B8: B10) SUM (B6-B8-B10) SUM (B6, B8, B10) D.SUM (B6, B8.B10) None 25. What will be the value of ‘= SUM (A1: B2)’? If A11, A22, B13, B45. 2 6 4 0 None Share this:TweetEmailTelegramPrintWhatsAppLike this:Like Loading...Related Posts (You May Also Read):