Скачать или смотреть APPSC CPT MODEL PAPER 6 /APPSC/ANGRUA (WITH MS ACCESS SYLUBUS/CPT)/Group 2

CPT, #COMPUTER PROFICIENCY TEST
For Model papers ping me on 9949362258
Acharya N. G. Ranga Agricultural University
ఆచార్య ఎన్ జి రంగా వ్యవసాయ విశ్వవిద్యాలయం
Pursuant to the Notification No.01/Ser.III/2019, dt.11.02.2019 issued by A.N.G.R. Agricultural
University for filling up of vacant posts of Junior Assistant-cum-Typist, the following candidates whose

PLAY LIST: https://www.youtube.com/playlist?list...

register numbers have been provisionally selected for Computer Proficiency Test (C.P.T.) are informed
that APPSC notified the Schedule for CPT to be held on 30.03.2020, 31.03.2020 and 01.04.2020 at
APPSC, Government Offices Building Ist & IInd Floors, Opp.Indira Gandhi Municipal Stadium
Complex, M.G. Road (Bandar Road), Vijayawada-520010
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
2. Format the Text document
a. Character formatting
b. Paragraph formatting
c. Page formatting
3. 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
4. Print the document
a. Print Preview
Print Dialog box
5. 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
6. 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.Create and save a new work book in Excel
2. Entering Data into Worksheet
3. Editing data of Worksheet
4. Formatting the text in the cells
5. Formatting the numbers in the cells
6. Formatting cells
7. Copying format of cell along with data format.
8. Changing the height and width of cells
9. Freezing Titles, splitting screen
10. Enter formulae for calculation in the cells.
11. Copying the formula over a range of cells.
12. Inserting built-in functions in to the cells.
13. Create graphs for the data using Chart Wizard
14. Format graphs in Excel.
15. Printing of worksheet.
f. sorting data in a table.
g. formatting a table.
7. 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).
15
NAME CONTENTS OF PART-B MARKS
EXCEL
1. Create and save a new work book in Excel
2. Entering Data into Worksheet
3. Editing data of Worksheet
4. Formatting the text in the cells
5. Formatting the numbers in the cells
6. Formatting cells
7. Copying format of cell along with data format.
8. Changing the height and width of cells
9. Freezing Titles, splitting screen
10. Enter formulae for calculation in the cells.
11. Copying the formula over a range of cells.
12. Inserting built-in functions in to the cells.
13. Create graphs for the data using Chart Wizard
14. Format graphs in Excel.
15. Printing of worksheet.
10

NAME CONTENTS OF PART-C MARKS
POWER
POINT
1. Create and save a new presentation using MS Power
Point layout of opening screen in Power Point the
tool bars in MS Power Point
2. Choose Auto Layout for a new slide.
3. Insert text and pictures into a blank slide
4. Insert new slides into the presentation
5. Apply slide transition effects.
6. Slide show.
7. Set animation to text and pictures in a slide
8. Set the sounds, order and timing for animation
10
NAME CONTENTS OF PART-D MARKS
ACCESS Creation and manipulation of data bases 10
NAME CONTENTS OF PART-E MARKS
INTERNET
1. Browse the Net using Browser software (Internet
Explorer, Mozilla Firefox, Google Chrome etc.).
2. Search the Web using Search Engines.
3. Create an E-mail account
4. Send and receive E-mail.
5. E-commerce transactions.
6. Web content uploading.
7. Ability to operate Mac OS / pages / key note / Numbers.
0
Create and save a new presentation using MS Power
Point layout of opening screen in Power Point the
tool bars in MS Power Point
2. Choose Auto Layout for a new slide.
3. Insert text and pictures into a blank slide
4. Insert new slides into the presentation
5. Apply slide transition effects.
6. Slide show.
7. Set animation to text and pictures in a slide
8. Set the sounds, order and timing for animation
Creation and manipulation of data bases
Browse the Net using Browser software (Internet
Explorer, Mozilla Firefox, Google Chrome etc.).
2. Search the Web using Search Engines.
3. Create an E-mail account
4. Send and receive E-mail.
5. E-commerce transactions.
6. Web content uploading.
7. Ability to operate Mac OS / pages / key note / Numbers