Top Experts from August 2014 Awarded

ICT Trends is growing as the most reliable one stop portal to prepare Computer Operator Exam conducted by Public Service Commission and many other organizations. This success would never be possible without the help of our loyal users.

The usefulness of ICT Trends is greatly contributed by our experts by offering their valuable replies in the forum. I’d like to express my sincere gratitude for all the awesome answers they provided for user questions in ICT Trends Discussion Board.

Recognizing their contribution and with a hope that this will bring more positive impact towards the usability and reliability of this community, I am glad to announce the cash award to the top Experts. [Continue reading]

Solved Excel Practical Question from Set 8 Question 3 – Data Validation, Conditional Formatting & Nested IF

Solved Excel Practical Question Set 8 question 3 - Data Validation, Conditional Formatting, Nested IF

Here I present another video solution to Computer Operator Practical Question paper Set 8 Question No 3. The question asked to create a table in Excel and asks us to perform various tasks: Apply Data validation so that users can type exactly 7 … [Continue reading]

Video Solution to Computer Operator Practical Examination Model Set 3 Question B

Solution to excel Practical Question Set 3B

Some time back, I'd created Computer Operator Practical Model Question Papers to help candidates of Computer Operators of Public Service Commission (Lok Sewa Ayog) so that they can realize what kind of question will be asked in their practical … [Continue reading]

Computer Operator Practical Question Paper Set 16

Format Cells Dialog Box

MS Word Create a new document as 'Aug14' and save it with following content:                                                Enter following text and number the lines starting from 10 and with difference 3. On the Insert tab, the … [Continue reading]

Excel Data Validation: How to accept exactly 4 characters (Not Numbers)

Excel Data Validation button menu

This post briefly explains how Excel Data Validation can be used to ensure correct data for worksheet and goes on to show how you can make required cells accept exactly 4 characters (not numbers). What is Data Validation Data validation is the … [Continue reading]

Access: Change Form Control Size, Name, Caption and Alignment

Sizing and Naming MS Access Form Controls

These are basic skills to design Access Forms. You should be able to size the form controls such as text boxes, combo boxes, labels and so on. It will give your form look attractive and professional. But, more importantly, if you know the sizing … [Continue reading]