OSSSC Skill Test Question
Introduction
Hello Everyone, If you're preparing for the OSSSC Peo & JA Skill Test Exam, you'll need to take a practical test on computer skill. This test is designed to evaluate your computer knowledge and skills by assessing your ability to perform computer-related tasks such as doing simple task on MS Windows and MS Office.
Table of Contents
OSSSC Skill Test Question
Here are skill test question that you should practice.
MS Window Skill Test Question
1. Create a new folder on the desktop and name it "Test Folder."
2. Change the desktop background or wallpaper to a custom image of your choice.
3. Open the Start menu and locate the Control Panel. Adjust the screen resolution to a different setting.
4. Minimize all open windows and then restore them to their original state.
5. Open the File Explorer and navigate to the C:\ drive. Create a new text file named "Test File.txt" and save it in the root directory.
6. Copy the "Test File.txt" from the C:\ drive and paste it into a subfolder named "Documents" on the desktop.
7. Rename the "Test Folder" on the desktop to "Renamed Folder."
8. Delete the "Test File.txt" from both the C:\ drive and the "Documents" folder on the desktop, and empty the Recycle Bin.
9. Open a web browser of your choice and navigate to a specific website.
10. Take a screenshot of the entire desktop and save it to a designated folder.
11. Open the Notepad application and type a short message. Save the file with a unique name in a preferred location.
12. Open the Task Manager and end a specific process or application that is running.
13. Change the date and time settings on the computer to a specific value.
14. Connect to a Wi-Fi network and ensure that the connection is successful.
15. Log off or restart the computer.
MS Office: Word Skill Test Question
1. Open MS Word and create a new blank document.
2. Type a random paragraph of at least 5 sentences.
3. Change the font of the entire paragraph to Arial and increase the font size to 14.
4. Make the first sentence of the paragraph bold.
5. Italicize the second sentence of the paragraph.
6. Underline the third sentence of the paragraph.
7. Align the entire paragraph to the right side of the document.
8. Change the color of the fourth sentence to red.
9. Insert a numbered list at the end of the paragraph, starting with the number 1.
10. Insert a table with 3 rows and 3 columns below the numbered list.
11. Merge the cells in the first row of the table.
12. Apply a border to all the cells in the table.
13. Insert a picture of your choice from your computer into the document.
14. Create a hyperlink on the picture that opens a specific website when clicked.
15. Save the document with a unique name in a preferred location and close MS Word.
MS Office: Excel Skill Test Question
1. Create a new workbook in Microsoft Excel and save it as "SkillsTest.xlsx" in the "Desktop" folder.
| Fruits | Quantity | Price |
|---|---|---|
| Apple | 10 | 100 |
| Banana | 12 | 50 |
| Orange | 8 | 40 |
| Grapes | 20 | 50 |
| Mango | 10 | 12 |
| Cherry | 25 | 8 |
3. Calculate the total cost (quantity multiplied by price) for each item and enter the formula in column D.
4. Calculate the sum of the quantities in the "Quantity" column and enter the result in cell B7.
5. Calculate the average price in the "Price" column and enter the result in cell C7.
6. Apply a border to the table (cells A1 to D7) and format it as a table.
7. Insert a new sheet named "Sales Analysis" and copy the data from Sheet1 to this new sheet.
8. In the "Sales Analysis" sheet, create a pie chart to represent the distribution of sales quantities for each item.
9. Insert a new sheet named "Monthly Sales" and enter the following data in cells A1 to C6:
| Month | Total Sales | Average Sale |
|---|---|---|
| January | 500 | 30 |
| February | 200 | 50 |
| March | 800 | 100 |
| April | 300 | 80 |
| May | 250 | 120 |
| June | 125 | 100 |
10. Create a line chart in the "Monthly Sales" sheet to visualize the monthly sales data.
11. Calculate the sum of the "Total Sales" column and enter the result in cell B7.
12. Calculate the average of the "Average Sales" column and enter the result in cell C7.
13. Switch back to the "Sales Analysis" sheet and create a column chart to compare the sales quantities of different items.
14. Sort the data in descending order based on the "Quantity" column in the "Sales Analysis" sheet.
15. Save the workbook and close Microsoft Excel.
MS Office: PowerPoint Skill Test Question
1. Create a new slide in the presentation.
2. Change the background color of a slide.
3. Apply a slide layout to a slide.
4. Insert a picture into a slide.
5. Add a transition effect to a slide.
6. Change the font style and size of text in a slide.
7. Create a bulleted list in a slide.
8. Move a slide to a different position in the presentation.
9. Add a hyperlink to a slide.
10. Start a slideshow in PowerPoint.
11. Add a footer to a PowerPoint presentation.
12. Insert a video into a slide.
13. Change the slide orientation from portrait to landscape.
14. Insert a chart into a slide.
15. Save a PowerPoint presentation as a PDF file.
MS Office: Access Skill Test Question
1. Enter data into a cell.
2. Format cells to display numbers as currency.
3. Apply a filter to a column of data.
4. Create a simple formula to add two numbers together.
5. Change the font style and size of cell text.
6. Insert a new row or column into a worksheet.
7. Sort data in ascending or descending order.
8. Create a bar chart using data in a worksheet.
9. Apply conditional formatting to cells.
10. Merge cells together in a worksheet.
11. Freeze panes to keep column and row headers visible.
12. Use the COUNT function to count the number of cells that contain data in a range.
13. Use the SUM function to find the total of a range of numbers.
14. Rename a worksheet in a workbook.
15. Save a workbook as a different file type.
What is a Computer Skill Test?
The computer skill test is a practical examination that evaluates your ability to perform basic computer operations and applications. This test is crucial in today's world as computers are an essential part of our daily lives.
How to Score Full Marks
To score full marks on the computer skill test, you should be proficient in the fundamentals of computer hardware and software. You should also be familiar with different types of software and their uses. Practicing different computer functions can help you get more familiar with these tasks.
Conclusion
The computer skill test is a crucial component of the OSSSC Peo & JA Exam. It is essential to practice and improve your computer skills to score full marks on the exam. By being proficient in basic computer operations and applications, you can increase your chances of performing well on the test. Best of luck.
Thanks for reading. Have a great day.