Skip to Main Content |
New version is in progress. You may experience some difficulties. We are working to re-launch by new year!
Your Friend, Philosopher and Guide to Achieve Your Dream Government Job
Menu 
APPSC / TSPSC Computer Proficiency Test
“Proficiency in Office Automation with Usage of Computers and Associated Software” is a test to verify the candidate’s computer skills. It is known as Computer Proficiency Test. The candidates shall be given the text /matter in the Question Paper and they must type/reproduce it in the Answer Sheet. The formatting of the text should also be of the same type as given in the Question Paper.
| Name of the part | Name of the Question to be answered | Marks |
| Part A | Example: Typing a letter/passage/paragraph ( about 100-150 words ) in MS-Word | 15 |
| Part B | Example: Preparation of a Table/Graph in MS-Excel | 10 |
| Part C | Example: Preparation of Power Point Presentations/Slides (Two) on MS-Power Point. | 10 |
| Part D | Example: Creation and manipulation of data bases. | 10 |
| Part E | Example: Displaying the content of E-mail (Inbox) | 5 |
| Total | 50 |
CONTENTS OF PART-A: WORD: 15 Marks
- Create and save a document using MS WORD
a. Deletion of Character, Word, line and block of text
b. Undo and redo process
c. Moving, Copying and renaming - Format the Text document
a. Character formatting
b. Paragraph formatting
c. Page formatting - Spell check the document
a. Finding and Replacing of text
b. Bookmarks and Searching for a Bookmarks
c. Checking Spelling and Grammar automatically
d. Checking Spelling and Grammar using Dictionary - Print the document
a. Print Preview
b. Print Dialog box - Mail Merge in Ms-word
a. Create main document and data file for mail merging
b. Merging the files
c. From letters using mail merging
d. Mailing labels using mail merging - Table creation in Ms-word
a. Create a table in the document
b. Add row, column to a table
c. Changing column width and row height.
d. Merge, split cells of table.
e. Use formulae in tables.
f. sorting data in a table.
g. formatting a table. - Ability to type on Qwerty key board of Computer at a speed of at least equivalent to 30 Words per 1 minute (Lower type writing test).
CONTENTS OF PART-B: EXCEL: 10 Marks
- Create and save a new work book in Excel
- Entering Data into Worksheet
- Editing data of Worksheet
- Formatting the text in the cells
- Formatting the numbers in the cells.
- Formatting cells.
- Copying format of cell along with data format.
- Changing the height and width of cells.
- Freezing Titles, splitting screen
- Enter formulae for calculation in the cells.
- Copying the formula over a range of cells.
- Inserting built-in functions in to the cells.
- Create graphs for the data using Chart Wizard.
- Format graphs in Excel.
- Printing of worksheet.
CONTENTS OF PART-C: POWER POINT: 10 Marks
- Create and save a new presentation using MS Power Point
- a. layout of opening screen in Power Point
- b. the tool bars in MS Power Point
- Choose Auto Layout for a new slide.
- Insert text and pictures into a blank slide.
- Insert new slides into the presentation.
- Apply slide transition effects.
- Slide show.
- Set animation to text and pictures in a slide
- Set the sounds, order and timing for animation.
CONTENTS OF PART-D: ACCESS : 10 Marks
Creation and manipulation of data bases
CONTENTS OF PART-E: INTERNET : 05 Marks
- Browse the Net using Browser software (Internet Explorer, Mozilla Firefox, Google Chrome etc.,).
- Search the Web using Search Engines.
- Create an E-mail account.
- Send and receive E-mail.
- E-commerce transactions.
- Web content uploading.
- Ability to operate Mac OS / pages / key note / Numbers.
