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
ADCA — MS Excel MCQ
25 Questions • ADCA
20:00
← Back
1
MS Excel is primarily used for?
A
Word processing
B
Spreadsheet and data calculations
C
Presentations
D
Email management
2
Default extension of MS Excel file?
A
.doc
B
.ppt
C
.xls / .xlsx
D
.csv only
3
A cell in Excel is identified by?
A
Row number only
B
Column letter only
C
Column letter + Row number (e.g., A1)
D
Cell name only
4
Formula in Excel always starts with?
A
#
B
@
C
%
D
=
5
SUM(A1:A10) adds values from?
A
Row 1 to Row 10 in column A
B
All cells in sheet
C
Only A1 and A10
D
Column A to Column J
6
AVERAGE function calculates?
A
Largest value
B
Sum of values
C
Mean (average) of values
D
Count of values
7
To sort data in Excel?
A
Format → Sort
B
Insert → Sort
C
Data → Sort
D
Home → Sort
8
A named range with $ symbol (like $A$1) is called?
A
Relative reference
B
Mixed reference
C
Absolute reference
D
Named range
9
IF function in Excel returns different values based on?
A
Color of cell
B
A condition (True/False)
C
Font size
D
Cell position
10
To create a chart/graph in Excel?
A
Edit → Chart
B
Insert → Chart
C
Format → Chart
D
View → Chart
11
MS Excel is?
A
Word processor
B
Spreadsheet application
C
Database software
D
Presentation tool
12
Cell address B5 means?
A
Row B, Column 5
B
Column B, Row 5
C
Sheet B, Cell 5
D
Page B, Line 5
13
Formula in Excel starts with?
A
#
B
+
C
=
D
@
14
=SUM(A1:A5) does?
A
Counts cells
B
Adds values from A1 to A5
C
Finds average
D
Finds maximum
15
=AVERAGE() calculates?
A
Sum
B
Mean/average of values
C
Count
D
Maximum
16
=COUNT() counts?
A
Text cells
B
Empty cells
C
Cells with numbers
D
All cells
17
=MAX() returns?
A
Minimum value
B
Maximum/largest value
C
Average
D
Sum
18
=MIN() returns?
A
Maximum
B
Minimum/smallest value
C
Average
D
Count
19
Chart in Excel is used for?
A
Text editing
B
Visual representation of data
C
Printing
D
Sorting only
20
Workbook contains?
A
Only one sheet
B
One or more worksheets
C
Only charts
D
Only macros
21
AutoFill feature?
A
Deletes data
B
Automatically fills series (numbers, dates)
C
Formats cells
D
Inserts rows
22
Conditional formatting?
A
Deletes cells
B
Formats cells based on conditions/rules
C
Creates charts
D
Prints sheets
23
=IF() function is used for?
A
Sum
B
Conditional logic (true/false)
C
Counting
D
Averaging
24
Absolute reference uses?
A
No symbol
B
$ symbol (e.g., $A$1)
C
# symbol
D
@ symbol
25
VLOOKUP searches?
A
Horizontally
B
Vertically in first column of table
C
Diagonally
D
Randomly
📋 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:
ADCA
Passing:
60%
Attempt all questions before submitting. You can review your answers using the navigator above.
Answered:
0
/ 25
Submit Quiz