CCC Topic Wise Practice Set-9 (CCC Spreadsheet LibreOffice Calc)

01. How many sheets are opened by default in LibreOffice Calc?

A) 1
B) 2
C) 3
D) None

--- Answer is----> A) 1

02. What is the shortcut key of print preview in LibreOffice Calc?

A) Shift+P
B) Ctrl+Shift+O
C) Ctrl+P
D) Ctrl+Shift+P

--- Answer is-----> B) Ctrl+Shift+O

03. In LibreOffice Calc, the function and formula is always starts with which symbol?

A) =
B) #
C) ==
D) +

--- Answer is-----> A) =

04. What is the shortcut key to insert function in LibreOffice Calc?

A) Shift + F3
B) Ctrl + F3
C) Ctrl + F2
D) Alt + F2

--- Answer is-----> C) Ctrl + F2

05. Which categories functions are COS, EVEN, FACT, EXP in LibreOffice Calc?

A) Database
B) Mathematical
C) Logical
D) Financial

--- Answer is-----> B) Mathematical

06. Which shortcut key do you used for edit mode in cell?

A) Ctrl+Shift+M
B) Ctrl+M
C) F3
D) F2

--- Answer is-----> D) F2

07. Which shortcut key do you use to insert time in LibreOffice Calc?

A) Ctrl + :
B) Shift + ;
C) Ctrl + T
D) Ctrl + Shift+ ;

--- Answer is-----> D) Ctrl + Shift+ ;

08. Which shortcut key do you use for cell formatting in LibreOffice Calc?

A) Ctrl + 4
B) Ctrl + 3
C) Ctrl + 2
D) Ctrl + 1

--- Answer is----->D) Ctrl + 1

09. In LibreOffice Calc, which menu merge Cells command is found?

A) File
B) Insert
C) Format
D) View

--- Answer is-----> C) Format

10. In LibreOffice Calc, what value come if there is a larger value than the cell?

A) @@@@@
B) ###
C) @@@
D) #####

--- Answer is-----> B) ###

11. Which Symbol is used to intercept numbers in a cell as text?

A) * (Asterik)
B) ; (semi colon)
C) : (Colon)
D) ' (Single Inverted Comma)

--- Answer is-----> D) ' (Single Inverted Comma)

12. What type of cell reference is $A$5 in LibreOffice Calc?

A) Relative
B) Absolute
C) Mixed
D) None

--- Answer is-----> B) Absolute

13. The number of column available in LibreOffice Calc is?

A) 16384
B) 1048576
C) 1024
D) 256

--- Answer is-----> C) 1024

14. Which shortcut key is used to select the entire row?

A) Shift+Spacebar
B) Ctrl+Spacebar
C) Ctrl+Shift+Spacebar
D) Spacebar

--- Answer is----->A) Shift+Spacebar

15. Which shortcut key is used to select the entire column?

A) Shift+Spacebar
B) Ctrl+Shift+Spacebar
C) Ctrl+Spacebar
D) None

--- Answer is-----> C) Ctrl+Spacebar

16. Which shortcut key is used to comment in LibreOffice?

A) Ctrl+Shift+C
B) Ctrl+Shift+T
C) Ctrl+Alt+C
D) None

--- Answer is-----> C) Ctrl+Alt+C

17. Function are pre-define formulas which perform the automatic calculation.

A) True
B) False

--- Answer is-----> A) True

18. In LibreOffice Calc, which key do you use to convert a number to the currency format?

A) Ctrl + Shift + 1
B) Ctrl + Shift + 2
C) Ctrl + Shift + 3
D) Ctrl + Shift + 4

--- Answer is-----> D) Ctrl + Shift + 4

19. In LibreOffice Calc, what is the shortcut for clear direct formatting?

A) Ctrl+T
B) Ctrl+M
C) Ctrl+Shift+M
D) None

--- Answer is-----> B) Ctrl+M

20. Where is the name box in LibreOffice Calc?

A) Top left of the menu bar
B) Bottom left of the menu bar
C) On the status bar
D) Bottom right side of the menu bar

--- Answer is-----> B) Bottom left of the menubar

21. Which key do you use to move to the next sheet in Calc?

A) Shift + Tab
B) Ctrl+Tab
C) Ctrl+Shift+Tab
D) Tab

--- Answer is-----> B) Ctrl+Tab

22. Where does the cell address appear in LibreOffice Calc?

A) Formula Bar
B) Cell
C) Name box
D) Address book

--- Answer is-----> C) Name box

23. What is the last cell address in Calc.

A) A1
B) XFD1048576
C) AMJ1024
D) AMJ1048576

--- Answer is-----> D) AMJ1048576

24. In LibreOffice Calc, which key will be used to select the entire sheet?

A) Shift + Space
B) Ctrl+shift+Space
C) Ctrl + Space
D) Ctrl + 5

--- Answer is-----> B) Ctrl+shift+Space

25. Which shortcut key do we use to go to the previous work sheet?

A) Alt+PageUp
B) Shift+Tab
C) Ctrl+PageUp
D) Ctrl+ PageDown

--- Answer is-----> C) Ctrl+PageUp

26. In LibreOffice Calc, which key do we use to move to the previous cell?

A) Shift+Tab
B) Alt+Tab
C) Tab
D) None

--- Answer is-----> A) Shift+Tab

27. What will be the result of the formula = if (C2>=10, "Good", "Bad"), where C2 = 9

A) Good
B) Bad
C) Good, Bad
D) None

--- Answer is-----> B) Bad

28. What is the name of the last column in LibreOffice Calc?

A) AMJ
B) XFD
C) IMJ
D) AMF

--- Answer is-----> A) AMJ

29. Which Symbol is used to separate the cell range in Formulas?

A) ;
B) :
C) =
D) '

--- Answer is-----> B) :

30. Which Symbol appears when there is a formula error in LibreOffice Calc?

A) #
B) @
C) $
D) %

--- Answer is-----> A) #

31. What will be the value of = round(25.75, -1)?

A) 25
B) 75
C) 30
D) -1

--- Answer is-----> C) 30

32. What will be the value of = a1 / b1 in LibreOffice Calc? If a1=(10*20) and b1=(4*5), Ex- =(10*20)/(4*5)

A) 250
B) 5
C) 4
D) 10

--- Answer is-----> D) 10

33. What happens when the dollar sign ($) comes to the cell address?

A) Cell address will change when it is copied to another cell
B) An absolute cell address is created
C) The sheet tab is changed
D) The status bar does not display the cell address

--- Answer is-----> B) An absolute cell address is created

34. What will be the value of = Product (7, 8)?

A) 7
B) 8
C) 15
D) 56

--- Answer is-----> D) 56

35. What will be the value of =mod(20,-3)?

A) -1
B) 1
C) -2
D) 0

--- Answer is-----> A) -1

36. How we can edit a cell?

A) F2
B) Double clicking in the cell
C) Clicking on the formula bar
D) All of Above

--- Answer is-----> D) All of Above

37. Which is the first Spreadsheet Software?

A) Lotus 1-2-3
B) VisiCalc
C) MS Excel
D) LibreOffice Calc

--- Answer is-----> B) VisiCalc

38. How many characters can be in a cell?

A) 255
B) 256
C) 365
D) 1024

--- Answer is----->A) 255

39. The box on the chart that bears the name of each record is called ————?

A) Title
B) Axis
C) Legend
D) Data Label

--- Answer is-----> C) Legend

40. Which one is an example of a cell address?

A) 256
B) 256A
C) A1
D) 1A

--- Answer is-----> C) A1

41. Which one is an example of a Formula?

A) A1+A2
B) =A1+A2
C) =add(A1:A1)
D) =sum(A1;A2)

--- Answer is-----> B) =A1+A2

42. What will be the cell reference from G2 to M12?

A) G2.M12
B) G2;M12
C) G2:M12
D) G2-M12

--- Answer is-----> C) G2:M12

43. What is the shortcut to group cells in Calc?

A) Ctrl + F12
B) F12
C) Alt + F12
D) None

--- Answer is-----> B) F12

44. What is the shortcut key to ungroup cells in Calc?

A) Shift + F12
B) F12
C) Alt + F12
D) Ctrl + F12

--- Answer is-----> D) Ctrl + F12

45. What is the shortcut key of Fill cells down in Calc?

A) Ctrl + F2
B) Ctrl + D (ccc online test)
C) Ctrl + F1
D) Ctrl + F12

--- Answer is-----> B) Ctrl + D

46. ​​In Calc 'Shift+F3' is the shortcut key for Cycle Case.

A) False
B) True

--- Answer is-----> B) True

47. =ROUND (285.75, -2) will have a value of 200.

A) True
B) False

--- Answer is-----> B) False

47. LibreOffice Calc spreadsheet can have only one sheet.

A) True
B) False

--- Answer is-----> B) False

49. In LibreOffice Calc, Number in a cell is left align and alphabet right align.

A) True
B) False

--- Answer is-----> B) False

50. In LibreOffice Calc, by default the file is saved as sheet-1?

A) True
B) False

--- Answer is-----> B) False