50+ LibreOffice Calc MCQ (Multiple Choice Questions)

इस पोस्ट में आपको LibreOffice Calc के Objective Type Question और Fill in the Blanks मिलेंगे जिससे आपको अपने एग्जाम के लिए काफी helpful होगा 

Multiple choice Questions

• Which of the following technique can be used to allow only date value in cell ?
  1. Data formatting    
  2. Data sorting
  3. Data filtering
  4. Data validation
• Which of the following options when selected deletes all data validation?
  1. Delete formatting
  2. Delete all
  3. Delete formula
  4. Delete me
• We can replace multiple occurrences of a word using which of the following facilities of Calc?
  1. Find and replace
  2. By copy only
  3. By copy command
  4. By preview command
• What is the name of a mechanism to arrange the data in a particular order?
  1. Sorting
  2. Searching
  3. Filtering
  4. Validating
• What is the name of mechanism to filter out unnecessary data?
  1. Sorting
  2. Searching
  3. Filtering
  4. Validating
• Which of the following type of package does Calc refer to ?
  1. Spreadsheet
  2. Double sheet
  3. Multi-sheet
  4. Cannot determine
• Which of the following is an extension of a worksheet created in Calc?
  1. .ods
  2. .odd
  3. .xls
  4. .obj
• How can one calculate the total of values entered a worksheet column of?
  1. By manual entry
  2. By auto-sum
  3. By formula
  4. By sum functions
• What is the correct way to enter a function in Calc?
  1. Directly typing function name in a cell
  2. Using function wizard to selecting from toolbar
  3. Both (a) and (b)
  4. Depends on the function
• A function should start with                              
  1. ̔= ̓ sign
  2. alphabets
  3. numbers
  4. All of the these
• Which of the following option is used to print a chart?
  1. Insert → Chart
  2. File → View
  3. File→ Print
  4. View → Chart
• How many axes does chart in Calc have?
  1. Two
  2. Three
  3. Two or Three
  4. Four

LibreOffice Calc MCQ

• The chart preview can be seen in .
  1. Page preview
  2. Chart preview
  3. Export chart
  4. All of these

• What is theshortcut key of print preview in LibreOffice Calc?

1. Ctrl + Shift + P
2. Ctrl + P
3. Ctrl + Shift + O
4. None

• Which key will be used to select the entire seat in LibreOffice calc?

1. Ctrl + A
2. Ctrl + Shift + A
3. Ctrl + shift + Space
4. a & b both

• Which key do you use to edit the cell in edit mode?

1. Ctrl + Shift + M
2. Ctrl + M
3. F3
4. F2

• Cannot do maximum Zoom in LibreOffice Calc

1. 200%
2. 500%
3. 300%
4. 400%

• Which shortcut key do you use for cell  formatting in LibreOffice Calc

1. Ctrl + M
2. Ctrl + F2
3. Ctrl + 2
4. Ctrl + 1

• How many columns are there in LibreOffice Calc

1. 1048576
2. 16384
3. 1024
4. None

• Which shortcut key do you use to insert time in libreOfficecalc

1. Ctrl + Shift +
2. Ctrl + T
3. Ctrl +;
4. None

• In which menu is the Merge Cells command found in LibreOffice Calc ?

1. Edit
2. Style
3. Sheet
4. Format

• LibreOffice Calc has number left alignment and alphabet right alignment.

1. True
2. False

• In LibreOffice Calc , what is the value if there is a larger value than the cell

1. ####
2. ###
3. The    cell becomes large and the value is correct
4. #Name?

• What is the shortcut to delete a cell?

1. Ctrl + D
2. Ctrl + –
3. Ctrl + +
4. Delete

• Which shortcut key do you use to select the entire row

1. Shift + Space
2. Ctrl + Shift + Page down
3. Ctrl + Space
4. None

• Which key do LibreOffice use to insert a function in calc

1. Ctrl + F4
2. Ctrl + F3
3. Ctrl + F2
4. None

• Round and Truncate  functions are the same

1. True
2. False

• What is the default file extension in LibreOffice Calc  ?

1. .ods
2. .odp
3. .odt
4. .xlsx

• By what name is the LibreOffice Calc file saved by default ?

1. Spreadsheet1
2. Calc1
3. Untitled1
4. None

• Which key do you use to comment in LibreOffice

1. Ctrl + Alt + C
2. Ctrl + Shift + T
3. Ctrl + Shift + C
4. Ctrl + C

• What is a Cycle Case

1. Sentence Case
2. Lower case
3. Upper case
4. All of above

• What will be the value of Product (7, 8) ?

1. 15
2. 56
3. 1
4. -1

• Which key do you use to move to the next seat

1. Ctrl + Tab
2. Ctrl + Shift + Tab
3. Tab
4. Shift + Tab

• LibreOffice can convert entire cell into a cell in calc 

1. False
2. True

• Which shortcut key do you use to full screen in LibreOffice

1. Ctrl + Shift + J
2. Ctrl + Shift + F
3. Ctrl + Shift + F
4. None

• Which shortcut key do you use to highlight a value in LibreOffice Calc 

1. Ctrl + F8
2. Ctrl + F6
3. Ctrl 
4. Ctrl + F1

• Where a cell’s address appears in LibreOffice Calc 

1. Address Book
2. Name box
3. Formula Bar
4. None

• In LibreOffice Writer, mail merge option is in which menu?

1. Insert
2. Tools
3. Format
4. Form

• Which key is used with the control to create a new line or paragraph inside the cell of LibreOffice Calc?

1. Tab
2. Shift
3. Enter
4. Alt

• LibreOffice Calc Formula always start with a Symbol?
• &
• %
• =
• $
• How Many types of Cell Reference are there in LibreOffice Calc?
  1. 3
  2. 1
  3. 4
  4. 2
• What is the maximum number of worksheets LibreOffice Calc Can have?

1. 10000
2. 256
3. 1028
4. None

• What is the shortcut key to open the Cell Format dialog box in Libreoffice Calc?
  1. Ctrl + Alt + 1
  2. Alt + 1
  3. Ctrl + 1
  4. Shift + 1

• LibreOffice is the shortcut to insert a function in Calc?
  • Ctrl + F2
  • Shift + F3
  • Alt + F3
  • Ctrl + F3
• Which categories of functions are COS, EVEN, FACT, EXP in LibreOffice Calc?
  • Math / string
  • Mathematical
  • String
  • Data
• What is the shortcut key of print preview in LibreOffice Calc?
  • Ctrl + Shift + O
  • Ctrl + Shift + P
  • Ctrl + P
  • None
• What key do LibreOffice use to insert a function in calc?
  • Ctrl + F3
  • Ctrl + F2
  • Ctrl + F4
  • None
• LibreOffice Calc What is the default file extension?
  • .Xlsx
  • .odp
  • .ods
  • .odt
• Which shortcut key do you use to insert time in LibreOffice Calc?
  • Ctrl + Shift + ;
  • Ctrl + ;
  • Ctrl + T
  • None
• Which shortcut key do you use for cell formatting in LibreOffice Calc?
  • Ctrl + M
  • Ctrl + 1
  • Ctrl + F2
  • Ctrl + 2
• In which menu is the Merge Cells command found in LibreOffice Calc?
  • Style
  • Sheet
  • Format
  • Edit
• Which key do you use to convert a number into currency format in LibreOffice Calc?
  • Ctrl + Shift + 1
  • Ctrl + Shift + 3
  • Ctrl + Shift + 4
  • Ctrl + Shift + 5
• LibreOffice is the shortcut to clear the direct format in Calc?
  • Ctrl + M
  • Ctrl + V
  • Ctrl + 1
  • Ctrl + Shift + F
• Which shortcut key do you use to highlight a value in LibreOffice Calc?
  • Ctrl + F8
  • Ctrl + F1
  • Ctrl + F6
  • Ctrl
• Where does the address of a cell appear in LibreOffice Calc?
  • Name box
  • Formula bar
  • Address book
  • None
• Which key will be used to select the entire seat in LibreOffice Calc?
  • Ctrl + Shift + Space
  • Ctrl + Shift + A
  • Ctrl + A
  • a & b both
• LibreofficeCalc Select a cell to break a merged cell …… ..button click?
  • Splide
  • Center
  • Merge and center
  • Split and merge
• What do you do to write in LibreOffice Calc from Monday to Sunday?
  • =Week () use the function
  • Press inter on Monday
  • Holding down Monday, holding down the right corner and pulling it down
  • All of the above
• Which key do Libreoffice Calc use to move to the left (one step back) of a cell?
  • Shift + Tab
  • Alt
  • Tab
  • Alt + Tab
• What is the address of the last column in LibreOffice Calc?
  • EMJ
  • AMJ
  • AMG
  • XFD
• What is formed by adding libreoffice Calc rows and columns?
  • DATA
  • CELL
  • TABLE
  • POSITION
• Which sign is visible when there is a formula error in Libreoffice Calc?
  •  
  • #
  • $
  • *
• What will be the value of = 10 * 20/4 * 8 in LibreOffice Calc?
  • 7
  • 400
  • 500
  • 25
• LibreOffice Calc has number left alignment and alphabet right alignment?
  • True
  • False
• Libreoffice Calc has alphabet right and numbers left align?
  • Ture
  • False
• LibreOffice Calc by default provides an auto calculator feature that displays as if in a selected range range?
  • True
  • False
• Can LibreOffice convert entire cell into a cell in calc?
  • True
  • False
• In LibreOffice Calc and Writer do Ctrl + D have the same function?
  • True
  • False

  Fill in the blanks

1. The column  immediately  next  to  column    “Z”  is AA
2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is .ods .
3. The spreadsheet feature used to continue the series is called as fill handle.
4. The formula ‘’=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to  =min(d1:d5)
5. The formula in cell A2 is = B2+C3. On copying this formula to cell C2, C2 will change to =d2+e3
6. The cell address of the cell formed by the intersection of the ninth column and the eight row will be 18.
7.  $A1$B2 is an example of mixed referencing in spreadsheet software .
8.  Number entered into a cell are automatically  right aligned.
9.  If A1:A5 contain the number 16 , 10, 3, 25 and 6 then = Average(A1:A5;60) will display 20.
10. In Relative referencing, the reference changes rows and columns automatically when it is copied to a new cell.

यदि आप Multipe Choice Questions के इलावा Short Answer Type Question भी देखना चाहते है तो आप लिंक पर क्लिक कर देख सकते है –

• Libre Office Calc – Short Answer Type Question

LibreOffice Calc – Videos