APPSC CPT MODEL PAPER 3 PART 1 WITH MS ACCESS SYLUBUSCPTGroup 2

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Fqu2C7Uw7ao

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

#############################

New on site