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