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