Do you need to learn CCC Online Test Chapter 4 Answers : LibreOffice Calc? Here Is the Important Questions and Answers of CCC Online Test Chapter 4 Answers – Libreoffice Calc, which will be very helpful in your CCC Exam to pass the exam easily.
CCC Online Test Chapter 4 Answers – Libreoffice Calc MCQs
So let’s start, today we will read for you important CCC Online Test Chapter 4 Answers of CCC Book Chapter number one, the name of this chapter is “Libreoffice Calc”.
Apply Here : for Nielit CCC Exam
What to Do if You Don’t Pass the CCC Online Test Chapter 4?
If you don’t pass the CCC online test Chapter 4 Answers, there are three things you can do. The first is to take a break and come back to it later. You could also go through the questions that you missed and see if you can understand why the answers are wrong. Finally, you can get some help from a tutor or friend who has taken the test before.
1) Take a break and come back to it later:
2) Go through questions that were missed and see if an answer is wrong:
3) Get help from a tutor or friend who has taken the test before:
CCC Online Test Chapter 4 Questions with Answers
Question No. 1. What is the shortcut key to open ‘File Open Window’ in LibreOffice Calc?
a) Ctrl + Shift + O
b) Ctrl + O
c) Shift + O
d) None
Correct Answer Is: [ B ]
Question No. 2. How many rows and columns does LibreOffice Calc have?
a) 1048576 and 1024
b) 1024 and 1048576
c) 1048576 and 16384
d) 16384 and 1048576
Correct Answer Is: [ A ]
Question No. 3. What is the maximum column name in Libra Office Calc?
a) AMJ
b) XFD
c) AJS
d) none of the above
Correct Answer Is: [ A ]
Question No. 4. What happens to the Libreoffice Calc and Excel date and time shortcuts?
a) Ctrl +;
b) Ctrl + Shift +:
c) a and b both
d) None
Correct Answer Is: [ C ]
Question No. 5. What is the maximum number of worksheets in LibreOffice Calc?
a) 10000
b) 1000
b) 5000
d) 255
Correct Answer Is: [ A ]
Question No. 6. What will be the value of ‘= product (5,2)’?
a) 10
b) 3
c) 7
d) 1
Correct Answer Is: [ A ]
Question No. 7. Which of the following is not the maximum zoom size of Libreoffice Calc?
a) 200
b) 300
c) 400
d) 500
Correct Answer Is: [ D ]
Question No. 8. What is the shortcut key to save as LibreOffice Calc sheet?
a) Ctrl + Shift + F
b) Ctrl + Shift + S
c) Ctrl + F2
d) None
Correct Answer Is: [ B ]
Question No. 9. What is the shortcut key to select All in Libreoffice Calc?
a) Ctrl + A
b) Ctrl + Shift + A
c) Ctrl + Shift + Space
d) None
Correct Answer Is: [ B ]
Question No. 10. What is the maximum height of LibreOffice Calc I Cell?
a) 0.45 each
b) 0.45 cm
c) 1.25 inch
d) 1.25cm
Correct Answer Is: [ C ]
Question No. 11. What Will Be The Value Of The Formula ‘=floor(123,11)’?
a) 121
b) 120
c) 132
d) 125
Correct Answer Is: [ A ]
Question No. 12. What Is The F2 Key Used For In Libreoffice Calc?
a) Formula Edit
b) Help
c) Tool Bar
d) Save As
Correct Answer Is: [ A ]
CCC Online Test Chapter 4 Libreoffice Calc Answers
Question No. 13. What is the shortcut key to open the ‘Cell Format dialog box’ in Libreoffice Calc?
a) Ctrl + 4
b) Ctrl + 3
c) Ctrl + 2
d) Ctrl + 1
Correct Answer Is: [ D ]
Question No. 14.What is the shortcut key to superscript in Libreoffice Calc?
a) Ctrl + Shift + B
b) Ctrl + Shift + P
c) Ctrl + Shift + +
d) none of these
Correct Answer Is: [ B ]
Question No. 15. In LibreOffice Calc or Writer, specify the shortcut key of Clear Format?
a) Ctrl + C
b) Ctrl + M
c) Ctrl + Shift + M
d) None
Correct Answer Is: [ B ]
Question No. 16. How many charts are there in Libreoffice Calc?
a) 5
b) 7
c) 10
d) 13
Correct Answer Is: [ C ]
Question No. 17. What is the shortcut key to open a new page in Libra Office Calc?
a) Ctrl + N
b) Ctrl + M
c) Shift + N
d) Ctrl + Shift + N
Correct Answer Is: [ A ]
Question No. 18. What is the name of the last cell in LibreOffice Calc?
a) AJD1
b) AMJ1
c) ANM1
d) All of these
Correct Answer Is: [ B ]
Question No. 19. What is the name of Column in LibreOffice Calc?
a) A1, B1, C1
b) A, B, C
c) 1, 2, 3
d) None of these
Correct Answer Is: [ B ]
Question No. 20. In LibreOffice Calc, in which Align is the number?
a) Right
b) Left
c) Center
d) Top
Correct Answer Is: [ A ]
Question No. 21. Which shortcut key will be used to select a row of cells in LibreOffice?
a) Ctrl + Space
b) Shift + Space
c) Alt + Space
d) None
Correct Answer Is: [ B ]
Question No. 22. What Will Be The Value Of The Formula ‘=ceiling(97,7)’?
a) 97
b) 98
c) 91
d) 92
Correct Answer Is: [ B ]
Question No. 23. What is the shortcut key to go to the last edit cell in Libra Office Calc?
a) Alt + Ctrl + O
b) Ctrl + End
c) Ctrl + Home
d) None
Correct Answer Is: [ B ]
Question No. 24 What is the value of A1 + A2 in Libra Office Calc?
a) 5
b) 0
c) 1
d) ###
Correct Answer Is: [ B ]
Question No. 25. If the value of 3 + 4 + * 5 is 23 in the Libra Office Calc, then what will be the value of (3 + 4) * 5?
a) 35
b) 60
c) 23
d) 45
Correct Answer Is: [ A ]
Question No. 26. What is the shortcut key to add cell in LibreOffice Calc?
a) Ctrl + +
b) Ctrl + –
c) Ctrl +:
d) None
Correct Answer Is: [ A ]
CCC Online Test Chapter 4 Libreoffice Calc Answers
Question No. 27. What is the shortcut key to go to the last active cell in LibreOffice call?
a) Ctrl + Page Down
b) Ctrl + End
c) Alt + End
d) Ctrl + Down arrow
Correct Answer Is: [ B ]
Question No. 28. What is the value of A1 + A2 in Libra Office Calc?
a) 2
b) 1
c) #NAME?
d) 0
Correct Answer Is: [ D ]
Question No. 29. What is the maximum zoom in LibreOffice Calc?
a) 300%
b) 3000%
c) 400%
d) 600%
Correct Answer Is: [ C ]
Question No. 30. To increase the cell width of LibreOffice Calc __ shortcut key is used?
a) Alt + Left Arrow
b) Alt + Right Arrow
c) Ctrl + Right Arrow
d) None
Correct Answer Is: [ B ]
Question No. 31. Which shortcut key will be used to select a row of cells in LibreOffice?
a) Ctrl + Space
b) Shift + Space
c) Alt + Space
d) None
Correct Answer Is: [ B ]
Question No. 32. What is the height of the cell in Libreoffice Calc?
a) 0.89
b) 0.18
c) 5
d) 6.62
Correct Answer Is: [ B ]
Question No. 33. What is the Readymade Sheet in LibreOffice Calc called?
a) Spread sheet
b) Template
c) Bank sheet
d) None
Correct Answer Is: [ B ]
Question No. 34. What is the number of charts in LibreOffice Calc?
a) 10
b) 8
c) 15
d) None
Correct Answer Is: [ A ]
Question No. 35. What is A Chart in LibreOffice Calc?
a) Bubble
b) Balun
c) Hollow
d) Circle
Correct Answer Is: [ A ]
Question No. 36. Which shortcut key will be used to increase the width of a cell in LibreOffice Calc?
a) Alt + left arrow
b) Alt + right arrow
c) Ctrl + right arrow
d) None
Correct Answer Is: [ B ]
CCC Online Test Chapter 4 Libre office Calc Answers
Question No. 37. What is the width of a column in LibreOffice Calc?
a) 0.18
b) 0.89
c) 1.14
d) 3.0
Correct Answer Is: [ B ]
Question No. 38. The formula in LibreOffice that shows 16% of A1 Cell?
a) = A1 * 16%
b) = A1% 16
c) = a1 # 16%
d) A1% 16
Correct Answer Is: [ A ]
CCC Online Test Libreoffice Calc
Question No. 39. In LibreOffice Calc, which key is used to move to the first column?
a) Home
b) Ctrl + Home
c) Alt + Home
d) None
Correct Answer Is: [ B ]
Question No. 40. What is the shortcut key to open a new file in LibreOffice Calc?
a) Ctrl + N
b) Ctrl + M
c) Ctrl + Shift + N
d) None
Correct Answer Is: [ A ]
Question No. 41. In LibreOffice Calc, which is used for Cell Select?
a) Ctrl + +
b) Ctrl + Space
c) Shift + Space
d) Ctrl + $
Correct Answer Is: [ A ]
Question No. 42. What is another name for LibreOffice Calc?
a) Spreadsheet
b) Workbook
c) Worksheet
d) Sheet
Correct Answer Is: [ A ]
Question No. 43. What is the mail merge option in LibreOffice Calc?
a) To match the file created to someone
b) use it to mail many people
c) To merge two mails
d) none of these
Correct Answer Is: [ B ]
What Is The Value Of Formula ‘=round(2,sum(5,7))’ In Libreoffice?
a) 2
b) 30
c) 28
d) 20
Correct Answer Is: [ A ]
Question No. 45. Which keyboard shortcut key has to be pressed to go to the last column in LibreOffice Calc?
a) Ctrl + Enter
b) Ctrl + Enter
c) Ctrl + Right Arrow
d) Shift + Right Arrow
Correct Answer Is: [ C ]
CCC Online Test Chapter 4 Libreoffice Calc Answers
Question No. 46. In which menu is the option of pivot table available in LibreOffice Calc?
a) Tools
b) View
c) Data
d) Format
Correct Answer Is: [ C ]
Question No. 47. Where in the LibreOffice calc program does the option to reduce the Zoom show?
a) Task bar
b) Status bar
c) Formating bar
d) None
Correct Answer Is: [ B ]
Question No. 48. With the help of which option the column in Libreoffice Calc is fixed? So that it does not move from its place.
a) Freeze column
b) Freeze sheet
c) Freez cell
d) Cannot be fixed.
Correct Answer Is: [ A ]
Question No. 49. What Will Be The Value Of The Formula ‘=quotient(509.8, 7)’?
a) 75
b) 72
c) 76
d) 54
Correct Answer Is: [ B ]
Question No. 50. What is the shortcut key to enter the current time in a cell in LibreOffice Calc?
a) Ctrl +;
b) Ctrl + Shift +;
c) Shift +;
d) Alt + Shift +;
Correct Answer Is: [ B ]
Related Posts: