Important Notice:
|| CCC Result Nov 2025 ||
|| CCC Marksheet Aug 2025 ||
|| O Level Jul 2026 Reg. Form Last Date: 30/04/2026 ||
|| CCC Mar 2026 Exam Postponed ||
|| CCC/ O Level Exam Full Form ||
|| CCC Result Nov 2025 ||
|| CCC Marksheet Aug 2025 ||
|| O Level Jul 2026 Reg. Form Last Date: 30/04/2026 ||
|| CCC Mar 2026 Exam Postponed ||
|| CCC/ O Level Exam Full Form ||
O Level
Notes
Follow us:
OLevelNotes
Home
O Level Notes
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
CCC
CCC Chapter Wise Notes
CCC Chapter Wise MCQ
CCC Modal Paper
CCC Previous Paper
CCC Assignment
CCC Online Test/Real Portal
Chapter Wise MCQ
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
Model Paper
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
O Level Real Test Portal
Old Paper
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
Practical Paper
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
Assignment
M1-R5.1
M2-R5.1
M3-R5.1
M4-R5.1
Contact Us
ADCA Course
Introduction To Computer
Introduction To OS
MS Office
Tally Prime
Graphic Design
Web Design
Programming Language
Learn Typing
Typing Tutor
Typing Test
KCIT Student
Student Login
KCIT Student
CCC — LibreOffice Calc MCQ
25 Questions • CCC
20:00
← Back
1
Cell address A1 means?
A
Row A, Column 1
B
Column A, Row 1
C
Area 1
D
First cell of sheet A
2
MAX function returns?
A
Smallest value
B
Average value
C
Largest value
D
Count of values
3
MIN function returns?
A
Largest value
B
Smallest value
C
Average
D
Sum
4
AVERAGE(A1:A5) calculates?
A
Sum of A1 to A5
B
Mean of A1 to A5
C
Count of A1 to A5
D
Largest of A1 to A5
5
To merge cells in LibreOffice Calc?
A
Right-click → Format
B
Format → Merge Cells
C
Insert → Merge
D
Edit → Combine
6
Shortcut to insert a new row in LibreOffice Calc?
A
Ctrl+R
B
Ctrl+I
C
Right-click row number → Insert Rows Above
D
Shift+Enter
7
COUNTIF(A1:A10, ">50") counts cells?
A
Equal to 50
B
Greater than 50
C
Less than 50
D
Not equal to 50
8
To auto-fill a series in LibreOffice Calc, drag the?
A
Column header
B
Row number
C
Fill handle (small square at cell corner)
D
Scroll bar
9
Absolute cell reference in LibreOffice Calc uses?
A
# symbol
B
$ symbol
C
@ symbol
D
& symbol
10
IF(A1>10,"Yes","No") returns "Yes" when?
A
A1 is less than 10
B
A1 equals 10
C
A1 is greater than 10
D
A1 is 0
11
How many rows are in LibreOffice Calc sheet?
A
65536
B
1048576
C
256
D
16384
12
How many columns in LibreOffice Calc?
A
256
B
1024
C
16384
D
65536
13
=ROUND(3.567, 2) returns?
A
3.56
B
3.57
C
4
D
3.6
14
=LOWER("HELLO") returns?
A
HELLO
B
hello
C
Hello
D
hELLO
15
=UPPER("hello") returns?
A
hello
B
HELLO
C
Hello
D
hELLO
16
=LEFT("Computer", 3) returns?
A
Com
B
ter
C
Computer
D
Comp
17
=RIGHT("Computer", 3) returns?
A
Com
B
ter
C
put
D
uter
18
HLOOKUP searches?
A
Vertically
B
Horizontally
C
Diagonally
D
Both directions
19
Goal Seek in Calc is used for?
A
Finding a goal value by adjusting input
B
Creating charts
C
Sorting data
D
Printing
20
=NOW() returns?
A
Current date
B
Current time
C
Current date and time
D
Nothing
21
Data Validation in Calc?
A
Formats data
B
Restricts what data can be entered in cells
C
Sorts data
D
Deletes data
22
To wrap text in a cell?
A
Format → Cells → Alignment → Wrap text
B
Edit → Wrap
C
View → Wrap
D
Insert → Wrap
23
Relative reference changes when?
A
Never
B
When formula is copied to other cells
C
When file is saved
D
When printed
24
=COUNT(A1:A10) counts?
A
All cells
B
Only cells with numbers
C
Only empty cells
D
Only text cells
25
What does #VALUE! error mean?
A
Division by zero
B
Wrong type of argument in formula
C
Cell not found
D
File corrupted
📋 Question Navigator
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Answered
Not Answered
ℹ️ Quiz Info
Total Questions:
25
Time Limit:
20 min
Subject:
CCC
Passing:
60%
Attempt all questions before submitting. You can review your answers using the navigator above.
Answered:
0
/ 25
Submit Quiz