LIBRE OFFICE CALC 50 QUESTIONS LIBRE OFFICE CALC TEST Basics of LibreOffice CalcLibreOffice Calc is a spreadsheet application similar to Microsoft Excel 1 / 50 Which function is used to find the average of a range of numbers? SUM() AVERAGE() COUNT() MAX() 2 / 50 What is the default file extension for LibreOffice Calc spreadsheets? .xls .ods .csv .xlsx 3 / 50 What Is The Minimum Font Size In Libreoffice Calc? 4 5 6 None 4 / 50 What Is A Shortcut To Full Screen Libreoffice Calc? Ctrl+Shift+J Ctrl+Shift+G Ctrl+Alt+G None 5 / 50 Which Shortcut Key Is Used To Go To The Front Sheet In Libreoffice Calc? Ctrl+S Ctrl+T Ctrl+Tab Ctrl+A 6 / 50 Where Is The Goal Seek Option In Libreoffice Calc? Window Tool Data Format 7 / 50 What Will Be The Value Of Ceiling(120,22)? 231 120 132 111 8 / 50 One Or More Worksheet Found In Libre Office Calc? Template Workbook Worksheet Cell 9 / 50 The Formula In Libreoffice Calc Is Started With? ? @ = None 10 / 50 Which Is The Function Used In The ‘ Sum(A1,A2) ‘ Formula ? Logical Text Numerical Mathematical 11 / 50 What Will Be The Value Os ‘ Sum (A1:B2) ‘? If A1= 1 A2= 2 B1=3 B4=5? 3 5 6 10 12 / 50 What Does Sumif Function Do? Adds Up Cell Value Based Upon A Condition Adds All Number In A Range Of Cells Returns A Subtotal In A List Or Database None 13 / 50 Which Of The Following Option Is Used To Show The Current Date? Today Now Date None 14 / 50 Q14. What Will Be The Value Of ‘256/Min (5,0,8)’? #Div/0! 0 8 5 15 / 50 What Is The Shortcut Key To Clear Direct Formatting In Libreoffice Calc? Ctrl+V Ctrl+Shift+M Ctrl+M Ctrl+N 16 / 50 Which Of The Following Is The Correct Function? Average (5,8,9) Average (G2,G5,R4) Average (2+4+5) A&B 17 / 50 What Will Be The Value Of ‘Average (3,4,5)’? 3 4 6 8 18 / 50 In Libreoffice Calc, Is The Extension Name Of The Template File? .Ods .Xlsx .Xlt .Odt 19 / 50 How Many Types Of Charts Are Available In Libreoffice Calc? 9 10 11 12 20 / 50 Which Of The Following Chart Is Used To Display A Data Series? Column Bubble Pie None 21 / 50 Which Of The Following Charts Is Not In The Chart Menu? Pie Chart Bar Chart Line Chart Square Chart 22 / 50 Which Shortcut Key To Used To Close Libreoffice Calc? Ctrl+Shift+E Ctrl+T Ctrl+Q Ctrl+H 23 / 50 Which Shortcut Key Is Used To Edit Cell In Libreoffice Calc? F1 F2 F12 None 24 / 50 In LIBREOFFICE CALC There Is Some Number In Cell A1, A2, A3, A4 . What Will Be the Cell Address When Transpose Them? A1, B1, C1, D1 B1, C1, D1, E1 B1 ,B2 ,B3 ,B4 A1:B4 25 / 50 Which Of The Following Is Used To Convert Row Into Column? Row To Column Transpose Reverse Convert 26 / 50 What Is The Shortcut Key To Move One Cell To Another Cell In LIBREOFFICE CALC? TABS CTRL+Q CTRL+N NONE 27 / 50 How Is The Cell Selected In Libreoffice Calc Defined? Deep Wide Border Dotted Border Blinking Border Italic Text 28 / 50 What Is Made At The Place Where The Colum & Row Cut Each Other? Cell Formula Column None 29 / 50 The Shortcut Key To Access A1 Cell Is? Ctrl+Home Shift+Home Home Ctrl+Page Up 30 / 50 What Will Be The Value Of Round (1762.667,-2)? Error 1700 1762.67 1800 31 / 50 How Many Sheets Are There By Default In Libreoffice Calc? 1 2 3 4 32 / 50 What Will Be The Value Of Floor (15257,-5)? 16000 15000 Error 16257 33 / 50 What is the shortcut key to select the entire row in Calc? Shift+Spacebar Ctrl+Spacebar Shift+Alt Ctrl+Shift 34 / 50 Find the value of =SUM(2,6,8)*5 in Calc? None 16 40 80 35 / 50 What will be the value of =LEN ("CCCWIFISTUDY") in Calc? 6 13 12 11 36 / 50 What will the value of =FLOOR(1209,11)? None 1188 1199 1210 37 / 50 In an Libre office Calc the active cell in indicated by? By italic text A dark wide border A blinking border A dotted border 38 / 50 Which of the following is not a valid data type in calc ? Number Date/ Time Text Character 39 / 50 ........ is the set of values that you want to plot in the chart ? Gridlines Data label Data series Chart area 40 / 50 Under which Menu , the Print Preview option is available for printing? View Data Formula File 41 / 50 Libre Office Calc stores dates internally as ............... ? Date and Time Number Text Date 42 / 50 If cell range A1:A5 contain the Numbers 20,6,-16,22,9 then =AVERAGE(A1:A5) will display ? 8.2 14.25 13.65 9.5 43 / 50 Which one of the following is a spreadsheet software ? Lotus 1-2-3 Multiplan Visi Calc All of these 44 / 50 Absolute cell referencing occurs when ? Formula is dragged and the cell reference adjusts automatically $ symbol is a automatically added which each cell value Formula is dragged but the cell references do not adjust spreadsheet is saved with "absolute" as file name 45 / 50 In Calc , the contents of the active cell are displayed in the ? formula bar footer bar tool bar task bar 46 / 50 To select a single entire column , the easiest method is to ? double click any cell in the column click the column heading click the row heading drag from the top cell in the column to the last cell in the column 47 / 50 Cell address $A4 in a formula means it is a ? relative cell reference absolute cell reference All of the above mixed cell reference 48 / 50 If you type =2*(6-4) in cell A1 , what value will be displayed ? 8 2 4 5 49 / 50 Which of the following software used to create Pie chart ? Database software Desktop publishing software Spreadsheet software Browser software 50 / 50 The Autofill Feature ? Applies a border around selected cells Automatically adds range of cell values Extends a sequential series of data All of the above Your score isThe average score is 0% 0% Restart quiz CCC ONLINE TEST Libre OfficeCalc Set-1 Nielit O Level
