Computer MS Excel Quiz for CRPF Radio Operator, Cipher, and Radio Fitter Entrance Exam
The Central Reserve Police Force (CRPF) is one of India’s premier paramilitary forces, responsible for maintaining internal security and counter-insurgency operations. Aspiring candidates for roles such as Radio Operator, Cipher, and Radio Fitter are required to demonstrate proficiency in various technical and computer-related skills, including Microsoft Excel. MS Excel is a critical tool for data management, analysis, and reporting, making it an essential skill for these roles. To help candidates prepare for the entrance exam, here’s a comprehensive guide and quiz on MS Excel tailored for the CRPF exam.

Table of Contents
Why is MS Excel Important for CRPF Roles?
- Data Management: Radio Operators, Cipher Specialists, and Radio Fitters often deal with large amounts of data, including communication logs, equipment details, and operational records. Excel helps in organizing and managing this data efficiently.
- Reporting: Excel is widely used for generating reports, analyzing trends, and presenting data in a structured format.
- Automation: Excel’s formulas and functions allow for automating repetitive tasks, saving time and reducing errors.
- Problem-Solving: Proficiency in Excel demonstrates analytical and problem-solving skills, which are crucial for technical roles in the CRPF.
Key Excel Topics for the CRPF Entrance Exam
Candidates should focus on the following topics to excel in the MS Excel section of the exam:
- Basic Excel Operations: Understanding the interface, cells, rows, columns, and worksheets.
- Formulas and Functions: Commonly used functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and TODAY().
- Data Formatting: Formatting cells, applying borders, and using conditional formatting.
- Charts and Graphs: Creating and interpreting charts like bar graphs, pie charts, and line graphs.
- Data Sorting and Filtering: Organizing data for better analysis.
- Shortcut Keys: Time-saving keyboard shortcuts for navigation and operations.
- Cell Referencing: Understanding relative, absolute, and mixed cell references.
- Data Validation and Protection: Ensuring data accuracy and securing worksheets.
Ms Excel Quiz For Crpf Radio Operator Exam Preparation
Here’s a set of quiz questions to test your knowledge and prepare for the CRPF entrance exam:
1. What is the default file extension of an Excel workbook?
A) .XLS
B) .XLW
C) .XLSX
D) .DOCX
Correct Answer: C) .XLSX
2. Which function is used to add a range of cells in Excel?
A) =ADD()
B) =SUM()
C) =TOTAL()
D) =PLUS()
Correct Answer: B) =SUM()
3. What is the shortcut key to create a new chart from selected data in Excel?
A) F2
B) F11
C) Ctrl + N
D) Alt + F1
Correct Answer: B) F11
4. Which Excel feature allows you to display only specific data based on criteria?
A) Sorting
B) Filtering
C) Formatting
D) Validation
Correct Answer: B) Filtering
5. What does the function =TODAY() return?
A) Current time
B) Current date
C) Current date and time
D) Today’s day
Correct Answer: B) Current date
6. Which symbol is used to denote absolute cell referencing in Excel?
A) #
B) $
C) @
D) &
Correct Answer: B) $
7. How many rows are there in an Excel 2007 worksheet?
A) 65,536
B) 1,048,576
C) 32,000
D) 256
Correct Answer: B) 1,048,576
8. Which chart type is best for showing proportions or percentages?
A) Line Chart
B) Bar Chart
C) Pie Chart
D) Area Chart
Correct Answer: C) Pie Chart
9. What is the purpose of the IF function in Excel?
A) To count cells
B) To perform logical tests
C) To add numbers
D) To format cells
Correct Answer: B) To perform logical tests
10. Which tool is used to copy formatting from one cell to another?
A) Format Painter
B) Format Checker
C) Format Copier
D) Format Brush
Correct Answer: A) Format Painter
Ms Excel Quiz For Crpf Radio Operator, Cipher and Radio Fitter
1. The default header for a worksheet is………….
A) Username
B) Date and Time
C) Sheet tab name
D) None
Correct Answer: D) None
2. The cell reference for cell range of G2 to M12 is……………
A) G2.M12
B) G2;M12
C) G2:M12
D) G2-M12
Correct Answer: C) G2:M12
3. What is the shortcut key for creating a chart from the selected cell range?
A) F2
B) F9
C) F8
D) F11
Correct Answer: D) F11
4. The software which contains rows and columns is called…………..
A) Database
B) Drawing
C) Spreadsheet
D) Word processing
Correct Answer: C) Spreadsheet
5. Formatting a cell in Currency, you can specify………….
A) Decimal Places
B) Currency Symbol
C) Both A & B
D) None of above
Correct Answer: C) Both A & B
6. What is entered by the function =today()……………
A) The date value for the day according to system clock
B) The time value according to system clock
C) Today’s date as Text format
D) All of these
Correct Answer: A) The date value for the day according to system clock
7. Which function will you use to enter current date and time in a worksheet cell?
A) =today()
B) =now()
C) =time()
D) =month()
Correct Answer: B) =now()
8. You can autofit the width of a column by……………………
A) Double-clicking on the column name on column header
B) Double-click on the cell pointer in worksheet
C) Double-clicking on column right border on column header
D) Double-clicking on the column left border of column header
Correct Answer: C) Double-clicking on column right border on column header
9. Last column address of an Excel sheet is…………..
A) XET
B) XFD
C) YRQ
D) XYF
Correct Answer: B) XFD
10. Which of the following series type is not valid for Fill Series dialog box?
A) Linear
B) Growth
C) Autofill
D) Time
Correct Answer: D) Time
11. Which of the following can be pasted selectively using Paste Special command?
A) Validation
B) Formats
C) Formulas
D) All of these
Correct Answer: D) All of these
12. Delete command on selected cells……………………..
A) Deletes the content of a cell
B) Deletes Formats of cell
C) Deletes the comment of cell
D) Deletes selected cells
Correct Answer: A) Deletes the content of a cell
13. Which of the following is the latest among these versions of Excel?
A) Excel 2015
B) Excel 2002
C) Excel ME
D) Excel 2013
Correct Answer: D) Excel 2013
14. What is the default extension of Excel files?
A) XLS
B) XLW
C) WK1
D) 123
Correct Answer: A) XLS
15. MS-EXCEL is based on……….
A) WINDOWS
B) DOS
C) UNIX
D) OS/2
Correct Answer: A) WINDOWS
16. Excel displays the current cell address in the……….
A) Formula bar
B) Status Bar
C) Name Box
D) Title Bar
Correct Answer: C) Name Box
17. Which area in an Excel window allows entering values and formulas?
A) Title Bar
B) Menu Bar
C) Formula Bar
D) Standard ToolBar
Correct Answer: C) Formula Bar
18. Microsoft Excel is a powerful……….
A) Word processing package
B) Spreadsheet package
C) Communication S/W Package
D) DBMS package
Correct Answer: B) Spreadsheet package
19. ………………… language is used to create macros in Excel.
A) Visual Basic
B) C
C) Visual C++
D) Java
Correct Answer: A) Visual Basic
20. In Excel, you can sum a large range of data by simply selecting a tool button called…..?
A) AutoFill
B) Autocorrect
C) Autosum
D) Autoformat
Correct Answer: C) Autosum
21. To select an entire column in MS-EXCEL, press?
A) CTRL+C
B) CTRL+Arrow
C) CTRL+S
D) None of the above
Correct Answer: D) None of the above (Correct shortcut is Ctrl + Spacebar)
22. Which of the following is not a term of MS-Excel?
A) Cells
B) Rows
C) Columns
D) Document
Correct Answer: D) Document
23. How many worksheets can a workbook have?
A) 3
B) 8
C) 1024
D) None of above
Correct Answer: D) None of above (Limited by available memory)
24. An Excel Workbook is a collection of…….
A) Workbooks
B) Worksheets
C) Charts
D) Worksheets and Charts
Correct Answer: D) Worksheets and Charts
25. How do you rearrange the data in ascending or descending order?
A) Data Sort
B) Data Form
C) Data Table
D) Data Subtotals
Correct Answer: A) Data Sort
26. MS Excel 2007 worksheet has………… number of columns.
A) 16384
B) 256
C) 512
D) 1024
Correct Answer: A) 16384
27. MS Excel 2007 Worksheet can have a maximum………….. Number of rows.
A) 256
B) 1048576
C) 32000
D) 65536
Correct Answer: B) 1048576
28. Which of the cell pointer indicates that you can fill a series?
A) Doctor’s symbol (Big Plus)
B) Small thin plus icon
C) Mouse Pointer with anchor at the tip
D) None of above
Correct Answer: B) Small thin plus icon
29. What does COUNT() function do?
A) Counts cells having alphabets
B) Counts non-empty cells
C) Counts cells
D) Counts empty cells
Correct Answer: B) Counts non-empty cells
30. Which of the following syntax is correct for the SUM function in Excel?
A) =SUM(A1B1)
B) =SUM(A1:B9 )
C) =SUM(A1:A9 B1:B9 )
D) All of these
Correct Answer: B) =SUM(A1:B9 )
31. What is the syntax for the cube root of 25?
A) =25^1/3
B) =Sqrt(25)
C) =25^(1/3)
D) =25^3
Correct Answer: C) =25^(1/3)
32. You can print………
A) A range of cells by range name
B) An entire worksheet
C) A single worksheet
D) All of these
Correct Answer: D) All of these
33. The cell having a bold boundary is called……….
A) Relative
B) Active
C) Absolute
D) Mixed
Correct Answer: B) Active
34. Comments put in cells are called….
A) SmartTip
B) CellTip
C) WebTip
D) SoftTip
Correct Answer: B) CellTip
35. Getting data from a cell located in a different sheet is called….
A) Accessing
B) Referencing
C) Updating
D) Functioning
Correct Answer: B) Referencing
36. Which Chart can be created in Excel?
A) Area
B) Line
C) Pie
D) All of these
Correct Answer: D) All of these
37. A function inside another function is called a….. Function.
A) Nested
B) Round
C) Sum
D) Text
Correct Answer: A) Nested
38. All formulas in Excel start with……….
A) /
B) *
C) =
D) ?
Correct Answer: C) =
39. A value used in a formula that does not change is called a…………
A) Constant
B) Cell address
C) Variable
D) Static
Correct Answer: A) Constant
40. Which among the following is not associated with the spelling dialogue box?
A) Edit
B) Ignore
C) Change
D) Ignore All
Correct Answer: A) Edit
41. To insert three columns between columns A and B, you would……….
A) Select column A
B) Select A and B
C) Select B
D) All of these
Correct Answer: B) Select A and B
42. Divide symbol in Excel is denoted by…….
A) =
B) /
C) DIV
D) \
Correct Answer: B) /
43. The name box appears at the……..
A) Left of the formula bar
B) Right of the formula bar
C) Below the status bar
D) Below the menu bar
Correct Answer: A) Left of the formula bar
44. The intersection of a row and column is called a…………..
A) Dataset
B) Cell
C) Data
D) Set
Correct Answer: B) Cell
45. One cell format can be copied to another cell by using………………
A) Format Checking
B) Format Setting
C) Format Painter
D) Format Showing
Correct Answer: C) Format Painter
Tips for Excelling in the MS Excel Section
- Practice Regularly: Use Excel regularly to familiarize yourself with its features and functions.
- Learn Shortcuts: Mastering keyboard shortcuts can save time during the exam.
- Solve Sample Papers: Practice with previous years’ question papers and mock tests.
- Understand Concepts: Focus on understanding the logic behind formulas and functions rather than memorizing them.
- Stay Updated: Keep yourself updated with the latest version of Excel and its features.
Conclusion
MS Excel is a vital skill for CRPF aspirants, especially for technical roles like Radio Operator, Cipher, and Radio Fitter. By mastering the basics and practicing regularly, candidates can confidently tackle the Excel section of the entrance exam. Use the quiz above to test your knowledge and identify areas for improvement. With dedication and consistent effort, you can excel in the exam and take a step closer to serving the nation with the CRPF. Good luck!
1 thought on “Computer Ms Excel Quiz For Crpf Radio Operator, Cipher and Radio Fitter Entrance Exam”