Comprehensive Computer Skill Test Guide for CPT & Interviews

Welcome to this detailed tutorial on computer skill tests, specifically designed for CPT exams and job interviews. This guide covers various practical questions and answers related to MS Word and MS Excel, helping you understand key concepts and apply them effectively.

This tutorial addresses common questions from the Junior Assistant post computer skill test. Each question is explained with practical demonstrations to ensure clarity. The video recording was done via mobile due to technical issues, but the content remains highly useful.

MS Word Practical Questions

Creating Columns and Drawing Lines Between Columns

One question asks about the second step in creating a micro (likely referring to a micro document or section) and involves working with columns in MS Word.

• When you select columns in MS Word and check the "Line Between" checkbox, a vertical line is drawn between the columns.
• However, if you select only one column, the "Line Between" option is disabled.

Practical Demonstration:

• Select a paragraph.
• Go to the Columns option.
• Choose "More Columns".
• Check the "Line Between" checkbox and click OK.
• You will see a line drawn between the columns.
• If you select only one column, the checkbox is disabled.

Answer: None of the above (since the line between option is disabled for one column).

Inserting Page Numbers in Footer and Changing Number Format

Another question involves inserting page numbers in the footer and changing the numbering format from numbers (1, 2, 3) to letters (A, B, C) or Roman numerals.

Steps:

• Go to the Insert tab.
• Click on Page Number.
• Choose the position (Top of Page, Bottom of Page).
• Click on "Format Page Numbers".
• In the dialog box, select the desired number format (e.g., Capital Letters A, B, C).
• You can also set the starting number or letter.

Practical Demonstration:

• Insert page numbers at the bottom of the page.
• Change the format to capital letters (A, B, C).
• The pages will be numbered accordingly.

Answer: All of the above options are correct.

MS Excel Practical Questions

Completing a Cell Entry in Excel

A question asks which action is NOT valid to complete a cell entry in Excel.

• Pressing Enter key: Valid, completes the entry.
• Pressing arrow keys: Valid, moves to adjacent cells.
• Pressing Spacebar: Not valid, adds spaces but does not complete entry.
• Pressing Enter in the formula bar: Valid.

Answer: Pressing Spacebar is NOT a valid way to complete a cell entry.

What-If Analysis in Excel

What-If Analysis is a powerful tool in Excel used for scenario analysis and decision making.

• It allows users to test different values and see how they affect the outcome.
• This concept is important for computer proficiency tests.

Multiple Calculations in a Single Formula

Excel allows combining multiple formulas into a single formula using functions like IF, AND, OR, etc.

• This enables complex calculations within one cell.

Freezing Rows and Columns in Excel

To keep row and column titles visible while scrolling:

• Select the row below the row(s) you want to freeze.
• Go to the View tab.
• Click on Freeze Panes.
• Choose "Freeze Panes" to lock the selected rows and columns.

Practical Demonstration:

• Freeze the top row or first column to keep headers visible during scrolling.

Rounding Errors in Excel

Rounding errors occur due to decimal precision in calculations like addition, subtraction, multiplication, and division.

• These errors can affect final results.
• Excel provides functions to manage rounding:
  • ROUND: Rounds to a specified number of digits.
  • ROUNDDOWN: Always rounds down.
  • ROUNDUP: Always rounds up.

Using ROUND Function:

• Syntax: =ROUND(number, num_digits)
• Example: =ROUND(A1, 2) rounds the value in A1 to 2 decimal places.

Using ROUNDDOWN and ROUNDUP:

• ROUNDDOWN rounds towards zero.
• ROUNDUP rounds away from zero.

Handling Negative num_digits:

• Negative values round to the left of the decimal point.

Practical Tips:

• Use these functions to reduce rounding errors in financial and scientific calculations.

Conclusion

This guide covered essential computer skill test questions with practical demonstrations in MS Word and Excel. Understanding these concepts will help you perform better in CPT exams and interviews.

If you have any doubts, feel free to comment and subscribe for more tutorials. Share this guide with your friends to help them prepare effectively.

Jai Hind! Jai Bharat!