Computer Ms Excel Quiz For Crpf Radio Operator, Cipher and Radio Fitter Entrance Exam

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.

Why is MS Excel Important for CRPF Roles?

1. 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.
2. Reporting: Excel is widely used for generating reports, analyzing trends, and presenting data in a structured format.
3. Automation: Excel’s formulas and functions allow for automating repetitive tasks, saving time and reducing errors.
4. 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:

1. Basic Excel Operations: Understanding the interface, cells, rows, columns, and worksheets.
2. Formulas and Functions: Commonly used functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and TODAY().
3. Data Formatting: Formatting cells, applying borders, and using conditional formatting.
4. Charts and Graphs: Creating and interpreting charts like bar graphs, pie charts, and line graphs.
5. Data Sorting and Filtering: Organizing data for better analysis.
6. Shortcut Keys: Time-saving keyboard shortcuts for navigation and operations.
7. Cell Referencing: Understanding relative, absolute, and mixed cell references.
8. 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

1. Practice Regularly: Use Excel regularly to familiarize yourself with its features and functions.
2. Learn Shortcuts: Mastering keyboard shortcuts can save time during the exam.
3. Solve Sample Papers: Practice with previous years’ question papers and mock tests.
4. Understand Concepts: Focus on understanding the logic behind formulas and functions rather than memorizing them.
5. 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!