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

01. In LibreOffice Calc to select data area press Ctrl + * shortcut key.

A) True
B) False

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

02. In LibreOffice Calc press 'Ctrl+F' key to search any particular text.

A) True
B) False

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

03. In LibreOffice Calc you can replace any search text with some other by using 'Ctrl+H' shortcut key.

A) True
B) False

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

04. Which shortcut key is used to delete a cell in LibreOffice Calc?

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

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

05. In LibreOffice Calc, which option is used to see the formulas entered in the sheet?

A) Show Function
B) Open formula
C) View Formula
D) Show Formula

--- Answer is-----> D) Show Formula

06. In LibreOffice Calc which shortcut is used to highlight a cell value in a sheet?

A) Ctrl + F7
B) Ctrl + F6
C) Ctrl + F8
D) Ctrl + F5

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

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

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

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

08. LibreOffice Calc the 27th column is AA.

A) True
B) False

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

09. Which of the following program is an example of LibreOffice Suits?

A) Write
B) Excel
C) Publisher
D) Calc

--- Answer is-----> D) Calc

10. Which program is used for fast and accurate calculation as well as formatting of data in documents?

A) Calc
B) Excel
C) Both Above
D) Writer

--- Answer is-----> C) Both Above

11. What type of work can be done through Calc?

A) Financial data analysis
B) Scientific data analysis
C) Statistical data analysis
D) All of the above

--- Answer is-----> D) All of the above

12. Calc is enabled for which of the work?

A) Store data
B) Manipulate data
C) Create graphical representation of data
D) All of the above

--- Answer is-----> D) All of the above

13. In Calc, the columns are named A, B, C… which is called column heading and the last column is named AMJ.

A) True
B) False

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

14. What is the minimum and maximum zoom percentage in Calc?

A) 20 & 600
B) 10 & 600
C) 10 & 400
D) 20 & 400

--- Answer is-----> D) 20 & 400

15. What is the shortcut to do Format as Number in a Calc worksheet?

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

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

16. In LibreOffice Calc which key is use to insert a cell.

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

--- Answer is-----> A) Ctrl + +

17. When opens a new file in LibreOffice Calc , the default font is Liberation Sans.

A) True
B) False 

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

18. When opens a new file in LibreOffice Calc , the default font size is 12.

A) True
B) False

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

19. Which shortcut key to use for Paste Unformatted Text?

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

--- Answer is-----> B) Ctrl+Alt+Shift+V

20. Which key is to open Extension Manager in Calc?

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

--- Answer is-----> A) Ctrl+Alt+E

21. What is the shortcut key for center align?

A) Ctrl+E
B) Ctrl+R
C) Ctrl+L
D) None

--- Answer is-----> A) Ctrl+E

22. Which shortcut key to use for Date format in Calc?

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

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

23. In Calc, the most common commands are available on?

A) Formatting Toolbar
B) Formula Bar
C) Title bar
D) Standard Toolbar

--- Answer is-----> D) Standard Toolbar

24. When we choose the Save As option in Calc, what information is asked in the dialog box?

A) File name
B) File Location
C) Both Above
D) None

--- Answer is-----> C) Both Above

25. What is the maximum number of worksheets in Calc?

A) 3
B) 256
C) 1000
D) 10000

--- Answer is-----> D) 10000

26. Which program is used for data formatting, fast and accurate calculations?

A) Excel
B) Calc
C) Both Above
D) None

--- Answer is-----> C) Both Above

27. In which format spreadsheet allow to enter data in worksheet?

A) Horizontal
B) Vertical
C) Both A and B
D) None

--- Answer is----->C) Both A and B

28. What is included in Calc for analyzing the results and preparing the merit list?

A) Calculating result
B) Sorting
C) Filtering
D) All of these

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

29. What will be the value of =floor(1209,11)?

A) 1210
B) 1188
C) 1199
D) None

--- Answer is-----> C) 1199

30. What is the shortcut key for superscript in LibreOffice Calc?

A) Ctrl + Shift + B
B) Ctrl + Shift + S
C) Ctrl + Shift + P
D) None

--- Answer is-----> C) Ctrl + Shift + P

31. What will happen if formula written in formula bar is not preceded by the equal sign?

A) #name?
B) Whatever is written in formula will remain same
C) #name
D) ####

--- Answer is-----> B) Whatever is written in formula will remain same

32. What is the default file name of LibreOffice Calc document?

A) Untitled 1
B) Calc 1
C) Spreadsheet 1
D) None

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

33. Which option is used to insert a chart?

A) Chart wizard
B) Pie wizard
C) Object
D) Shape

--- Answer is-----> A) Chart wizard

34. You can draw Line, curve, Polygon from which option in Calc?

A) Object
B) Chart
C) Pie
D) Shape

--- Answer is-----> D) Shape

35. What will be the value of =Ceiling (97,7)?

A) 98
B) 97
C) 91
D) None

--- Answer is-----> A) 98

36. The intersection of row and column is called?

A) Column
B) Cell
C) Sheet
D) Row

--- Answer is-----> B) Cell

37. To break the Merged Cell in LibreOffice Calc, you can choose?

A) Center
B) Split cell
C) Split and merge
D) Merge and center

--- Answer is-----> B) Split cell

38. What do you do to write Monday to Sunday in LibreOffice Calc?

A) Type Monday, and drag with the help of auto fill option
B) Do inter press by writing Monday
C) = week () uses the function
D) None

--- Answer is-----> A) Type Monday, and drag with the help of auto fill option

39. What will be the value of = 10*20/4*8 in LibreOffice Calc?

A) 6.5
B) 7
C) 500
D) 400

--- Answer is-----> D) 400

40. What will be the value of =Product(7, -5)?

A) 35
B) -35
C) 12
D) 5

--- Answer is-----> B) -35

41. What is the shortcut key to exit current windows in Calc?

A) Ctrl+W
B) Ctrl+Q
C) Alt+F4
D) None

--- Answer is-----> A) Ctrl+W

42. Which shortcut key do you use to highlight the value of cell in LibreOffice Calc?

A) Ctrl + F6
B) Ctrl + F9
C) Ctrl + F8
D) Ctrl + F1

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

43. What will be the result of the formula =COUNT(B1:B3)? Where B1 = 5, B2 = 4, B3 = '6'

A) 15
B) 3
C) 4
D) 2

--- Answer is-----> D) 2

44. What will be the result of the formula =COUNTA(B1:B3)? Where B1 = 5, B2 = 4, B3 = '6'

A) 15
B) 3
C) 4
D) 5

--- Answer is-----> B) 3

45. What is the result of the formula =MAX(B1:B3)+MIN(B1:B3)? Where B1 = 5, B2 = 2, B3 = 7

A) 7
B) 5
C) 14
D) 9

--- Answer is-----> D) 9

46. ​​If the cell address changes after copying the formula, then this type of addressing is known as?

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

--- Answer is-----> B) Relative address

47. MS Excel and Calc have the same number of columns.

A) True
B) False

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

48. What is the shortcut key for inserting a hyperlink in Calc cell?

A) Ctrl+K
B) Ctrl+Shift+K
C) Ctrl+H
D) None

--- Answer is-----> A) Ctrl+K

49. How many charts type are available in Calc?

A) 7
B) 8 (ccc online test)
C) 9
D) 10

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

50. In Calc, in which menu is the Freeze Cells option are available?

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

--- Answer is-----> D) View