Welcome to your Libre Office Calc Set 3 1. What will be the value of ‘= ROUND (1762.667, -2)’? 1762.67 1800 1700 error None 2. What is the number of by default rows and columns in LibreOffice Calc? 65536, 256 525235, 42 1048576, 1024 1048576, 16384 None 3. In which menu is the option of Donnet found in LibreOffice Writer or Kalk? Edit Help View None None 4. How many types of ‘cell references’ are there in LibreOffice Calc? 5 4 2 0 None 5. What is the shortcut key to clear direct format in Libra Office Calc? Ctrl + V Ctrl + N Ctrl + M Ctrl + Shift + M None 6. M.S. What is the maximum number of Zoom you can do in Excel? 300 399 400 490 None 7. What is the shortcut key for inserting date in Libreoffice Calc? Ctrl +; Alt+: Shift +; None None 8. Which of the following is not a financial function? SUM () NPV () PMT () FV () None 9. What is the maximum zoom in LibreOffice Calc? 400% 500% 600% 700% None 10. What does SUMIF Function do? Adds up cell values based on a condition Returns a subtotal in a list or database Adds all numbers in a range of cells All of above None 11. Maximum value in A1 to A4? Max (A1: A4) Max (A1; A4) Max (A1, A4) None None 12. What will be the value of ‘ QUOITENT (5,2)’? 2 6 4 1 None 13. In the LibreOffice Calc spreadsheet, what is the font size found in the font size dropdown-menu? 24 34 28 18 None 14. What is the alignment of numbers in Libre Office Calc? Right Center Left None None 15. Which menu will be required to comment in LibreOffice Calc? View Format Data Insert None 16. Is the correct formula for extracting average in Microsoft Excel? Average () Averg () Averagee () None None 17. Which of the following options is used to show the current date? Today Date Now None None 18. What cannot be done with the formula in Libreoffice Calc? Circulr Refrence Numeric Add Both A and B Only Text None 19. Will this option be used to divide any table into different parts? Split cell Split table Split row Split column None 20. Which shortcut key is used to go to the back row in LibreOffice Calc? Ctrl + Tab Alt + Tab Shift + Tab Shift + Enter None 21. What will be the value of ‘= 256 / min (5,0,8)’? # div / 0! 0 8 5 None 22. Which side of the legend appears by default in Bar Chart? right in the middle left below None 23. If the cell address changes after copying the formula, then the address is known as ………. Absolute address Dynamic address Mixed Address Relative Address None 24. Ctrl + F2 shortcut key is used for? format cell print preview Function Wizard none of these None 25. Which bar is at the top of LibreOffice Calc? format bar Manu bar status bar title bar None Share this:TweetEmailTelegramPrintWhatsAppLike this:Like Loading... Related Posts (You May Also Read):