Microsoft Excel is one of the most important sections of the CCC Online Test 2026 conducted by NIELIT. A strong understanding of Excel formulas, functions, charts, sorting, filtering, cell formatting, and keyboard shortcuts is essential to score well in the CCC examination. This CCC Online Test has been designed according to the latest exam pattern and includes important MS Excel multiple-choice questions that are frequently asked in previous exams.
This CCC Online Test 2026 MS Excel Mock Test contains 25 carefully selected MCQs with correct answers and detailed explanations. The questions cover essential topics such as SUM(), AVERAGE(), IF(), COUNT(), Data Validation, Freeze Panes, Charts, Workbook Management, and Excel Shortcuts. Practicing these questions regularly will improve your accuracy, speed, and confidence before appearing for the official CCC exam.
If you are preparing for the NIELIT CCC Online Test 2026, this free MS Excel practice test is an excellent resource to strengthen your concepts. After completing the mock test, review the answers and explanations to identify weak areas and improve your performance. Bookmark this page and explore more CCC Online Test, CCC Mock Test, CCC Practice Questions, and CCC MCQs to maximize your chances of passing the exam on your first attempt.
1. Which software is primarily used to create spreadsheets?
A) MS Word
B) MS Excel
C) MS Paint
D) PowerPoint
✅ Correct Answer: B) MS Excel
Explanation: MS Excel is a spreadsheet application used for calculations, data analysis, charts, and tables.
2. Which symbol is used to begin a formula in Excel?
A) @
B) =
C) #
D) $
✅ Correct Answer: B) =
Explanation: Every formula in Excel starts with the equal (=) sign.
3. What is the intersection of a row and a column called?
A) Table
B) Cell
C) Sheet
D) Range
✅ Correct Answer: B) Cell
Explanation: A cell is formed where a row and a column intersect.
4. Which function calculates the total of selected cells?
A) COUNT()
B) SUM()
C) MAX()
D) MIN()
✅ Correct Answer: B) SUM()
Explanation: The SUM() function adds the values in a selected range.
5. Which function calculates the average of numbers?
A) AVG()
B) MEAN()
C) AVERAGE()
D) MID()
✅ Correct Answer: C) AVERAGE()
Explanation: AVERAGE() returns the arithmetic mean of the selected values.
6. What is the default file extension of modern Excel workbooks?
A) .xls
B) .xlsx
C) .docx
D) .pptx
✅ Correct Answer: B) .xlsx
Explanation: Excel 2007 and later versions use the .xlsx file format by default.
7. Which shortcut key is used to save a workbook?
A) Ctrl + P
B) Ctrl + S
C) Ctrl + O
D) Ctrl + N
✅ Correct Answer: B) Ctrl + S
Explanation: Press Ctrl + S to save the current workbook.
8. Which feature arranges data alphabetically or numerically?
A) Filter
B) Sort
C) Freeze Panes
D) Wrap Text
✅ Correct Answer: B) Sort
Explanation: Sort organizes data in ascending or descending order.
9. Which feature displays only rows that meet specified criteria?
A) Sort
B) Filter
C) Merge
D) Zoom
✅ Correct Answer: B) Filter
Explanation: Filter hides unwanted records and displays matching data only.
10. Which chart is best for showing percentages of a whole?
A) Line Chart
B) Pie Chart
C) Bar Chart
D) Area Chart
✅ Correct Answer: B) Pie Chart
Explanation: A Pie Chart represents the contribution of each category to the whole.
11. Which key is used to edit the active cell?
A) F1
B) F2
C) F5
D) F7
✅ Correct Answer: B) F2
Explanation: Press F2 to edit the contents of the selected cell.
12. Which function returns the largest value in a range?
A) HIGH()
B) MAX()
C) LARGE()
D) TOP()
✅ Correct Answer: B) MAX()
Explanation: MAX() returns the highest numeric value.
13. Which function returns the smallest value in a range?
A) MIN()
B) LOW()
C) SMALL()
D) LESS()
✅ Correct Answer: A) MIN()
Explanation: MIN() finds the lowest value in a range.
14. Which function counts only numeric cells?
A) COUNTA()
B) COUNT()
C) COUNTIF()
D) SUM()
✅ Correct Answer: B) COUNT()
Explanation: COUNT() counts cells containing numbers only.
15. Which function counts all non-empty cells?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) IF()
✅ Correct Answer: B) COUNTA()
Explanation: COUNTA() counts every non-empty cell regardless of data type.
16. Which shortcut key copies selected cells?
A) Ctrl + X
B) Ctrl + C
C) Ctrl + V
D) Ctrl + Z
✅ Correct Answer: B) Ctrl + C
Explanation: Ctrl + C copies the selected data.
17. Which shortcut key pastes copied data?
A) Ctrl + P
B) Ctrl + V
C) Ctrl + X
D) Ctrl + O
✅ Correct Answer: B) Ctrl + V
Explanation: Ctrl + V pastes copied or cut data.
18. Which option combines multiple cells into one?
A) Wrap Text
B) Merge & Center
C) Borders
D) Fill Color
✅ Correct Answer: B) Merge & Center
Explanation: Merge & Center combines selected cells into one larger cell.
19. Which feature keeps rows or columns visible while scrolling?
A) Freeze Panes
B) Zoom
C) Split
D) Protect Sheet
✅ Correct Answer: A) Freeze Panes
Explanation: Freeze Panes locks selected rows or columns while scrolling.
20. Which function returns a value based on a condition?
A) SUM()
B) IF()
C) COUNT()
D) MAX()
✅ Correct Answer: B) IF()
Explanation: IF() checks a condition and returns different results for TRUE or FALSE.
21. Which function returns today’s current date?
A) NOW()
B) TODAY()
C) DATE()
D) YEAR()
✅ Correct Answer: B) TODAY()
Explanation: TODAY() displays the current date.
22. Which function returns the current date and time?
A) DATE()
B) TIME()
C) NOW()
D) TODAY()
✅ Correct Answer: C) NOW()
Explanation: NOW() returns both the current date and current time.
23. Which Ribbon tab is used to insert charts?
A) Home
B) Insert
C) Review
D) View
✅ Correct Answer: B) Insert
Explanation: The Insert tab contains options to create charts, tables, and illustrations.
24. Which feature prevents users from entering invalid data?
A) Conditional Formatting
B) Data Validation
C) Protect Workbook
D) Sort
✅ Correct Answer: B) Data Validation
Explanation: Data Validation restricts the type of data that can be entered into cells.
25. Which keyboard shortcut opens the Print dialog?
A) Ctrl + O
B) Ctrl + P
C) Ctrl + N
D) Ctrl + S
✅ Correct Answer: B) Ctrl + P
Explanation: Press Ctrl + P to open the Print window and print your worksheet.