Theory Questions for LAB exam - (study Lab Manual of ITWS)

1. What is word procesing ?

2. Write about important features of MS-Word?

3. How to invoke MS word

4. What are some common word processing packages?

5. What are the advantages of word processing?

6. What is title bar, tool bar, ruler bar, status bar, scroll bar, workspace, main menu?

7. How to insert a table?

8. how do you create table of contents?

9. How do you udate table of contents?

10. How do you format the table of contents?

11. How do you create the table of contents from custom styles that you applied?

12. what is clipart?

13. How do you insert the clipart?

14. What is drawing toolbar?

15. How do you insert different shapes?

16. How to add color to the shape?

17. How to format auto shape?

18. What is mail merge?

19. How to preview your letters(mail merge)?

20. How to complete the merge(mail merge)?

21. what is power point presentation?

22. How to start microsoft power point?

23. How to create a new presentation?

24. How to create open and save the presentation?

25. How to view the presentation?

26. How to delete a slide?

27. How to apply animation?

28. What is microsoft excel?

29. How to start MS-Excel?

30. What are the major operations of MS-Excel?

31. How do you save excel files?

32. What are grid lines in excel?

33. How do you format cells in excel?

34. How to format text in excel?

35. How do you create a chart?

36. How do you apply a chart layout?

37. How do you add labels?

38. How to change the style of a chart?

39. how to switch data in a chart?

40. How to change the position and size of a chart?

41. how to move a chart to a chart sheet?

42. What is hyperlinking?

43. What is conditional formatiing? Write about Highlight cell rules?

44. Expand HTML.

45. What is the purpose of HTML and where do we use it?

46. What are the features of HTML?

Excel

1. Explain about count, countif, and countifs functions in detail with an example.

2. Explain about sum, sumif, sumifs functions in detail with an example.

3. Explain about logical functions – if, and, or. Give an example.

4. What are the three types of references in excel? Give examples.

5. How to get current time, Explain date functions – date, month, year,day?

6. How to change date month and year by 10 days, 10 months, 10 years?

7. How to change time?

8. How do you find the last day of the month?

9. How do you join strings in excel?

10. Explain the functions used to extract left and right most characters.

11. Explain about substitute function.

12. How to find the length of the string?

13. How to find the position of the substring?

14. Explain about Vlookup function with an example.

15. Explain about Hlookup function with an example.

16. How Pie charts can be created, give an example.

17. How Bar charts can be created, give an example.

18. How line charts can be created, give an example.

 

 

Word

1. Bullets and numbering.
   
   
2. Page Numbers
   
   
3. Shading.
   
   
4. Clipart
   
   
5. Pictures
   
   
6. Hyperlink
   
   
7. Bold 
    
8. Italic 
    
9. Underline
   
   
10. Small caps
    
    
11. Emboss
    
    
12. Super script
    
    
13. shadow
    
    
14. Line spacing
    
    
15. Check box
    
    
16. Drop down box
    
    
17. Radio button
    
    
18. Table – keep name, dept.
    
    
19. Use mail merge to send it to your four friends
    
    
20. From Developer tab
    
    

-          Insert checkbox

-          Radio button

-          List / Drop down form field

21. Date time
    
    
22. Page numbers 
     
23. Bold 
     
24. Italic
    
    
25. Underline
    
    
26. Strike Through
    
    
27. Uppercaps
    
    
28. Lower caps
    
    
29. Table.
    
    
30. Paragraphs aligned to left right and centre
    
    
31. Hyperlink
    
    
32. Footer
    
    
33. Double strike through
    
    
34. Borders
    
    
35. Font size 12, Headings 18, subheadings – 14
    
    
36. Text Shading
    
    
37. Divide the columns into 3 sections.
    
    
38. Callout
    
    
39. Image over text
    
    
40. Insert Clipart
    
    
41. Insert image
    
    
42. Insert Hyperlink
    
    
43. Insert word art
    
    
44. Insert Dropcap
    
    
45. Paragraphs aligned to left right and centre
    
    
46. Landscape view page
    
    
47. Borders for page
    
    
48. Line spacing – 2.0, before and after 1.0
    
    
49. Increase the indents
    
    
50. Decrease the indents
    
    
51. Insert some shapes
    
    
52. Insert line
    
    

HTML tags

1. table
   
   
2. td 
    
3. tr
   
   
4. th
   
   
5. caption
   
   
6. body
   
   
7. html
   
   
8. title
   
   
9. comments
   
   
10. headings (h1,h2,h3,h4,h5,h6)
    
    
11. anchor tag - <a>
    
    
12. head
    
    
13. strong<s>
    
    
14. underline<u>
    
    
15. bold<b>
    
    
16. italic <i>
    
    
17. paragraph <p>
    
    

Power point

1. view the presentation
   
   
2. slide show
   
   
3. animation
   
   
4. inserting new slide
   
   
5. inserting picture
   
   
6. inserting video
   
   

 
Test - Lab - Exam - I

1.       Create a resume for your campus interview

-          Bold

-          Underline

-          Italic

-          Emboss

-          Double strike through

-          Checkbox

-          Radio Button

-          Borders

-          Font size 12, Headings 18, subheadings – 14

-          Text Shading

2.       Create a Feedback form for self evaluation.

From Developer section insert

-          Checkbox

-          Dropdown list

-          Radio Button

-          Text box

From word section insert

-          Borders

-          Insert Time & Date

-          Bold, Underline, Italic

-          Table

-          Insert Header and footer.

-           

3.       Create a Poster for your college festival Saregamapa.

-          Divide the columns into 3 sections.

-          Callout

-          Image over text

-          Insert Clipart

-          Insert image

-          Insert Hyperlink

-          Insert word art

-          Insert Dropcap

4.       Write a letter to your principal about college environment.

-          Insert Date and Time

-          Bold, Italic, underline

-          Borders

-          Bullets

-          Hyperlink

-          Font color to red.

-          Align text to centre and right

-          Heading with font size -18

-          Upper caps

-          Subscript, superscript

-          Character spacing

-          Text highlighting

5.       Write a short notes about Sreenidhi Institute of science and Technology

-          Drop cap.

-          Line spacing

-          Bullets and numbering

-          Word art

-          Font type – Times new roman

-          Font size 14

-          Insert table

-          Header and footer

-          Hyper link

-          Insert foot note

-          Picture

-          Clipart

6.       Explain with suitable figures about Robotics and arts club of sreenidhi.

-          Pictures

-          Font size 12, linespacing – double

-          Table, text alignment-180 degrees, 90 degreees, 45 degrees inside columns.

-          Header footer

-          Shapes – line

-          Page numbers

-          Borders

-          Font colors – blue, red, green, yellow, orange

-          Font type – Ariel black

-          Font styles

-          Word art.

7.       Write about the Features of Microsoft word.

-          Bullets and numbering.

-          Page Numbers

-          Shading.

-          Clipart

-          Pictures

-          Hyperlink

-          Bold

-          Italic

-          Underline

-          Small caps

-          Emboss

-          Super script

-          shadow

8.       Create a quiz about Microsoft word.

-          Line spacing

-          Check box

-          Drop down box

-          Radio button

-          Table – keep name, dept.

-          Use mail merge to send it to your four friends

9.       Create a fill in form about your data to the Eamcet Convenor.

-          Line spacing

-          Check box

-          Drop down box

-          Radio button

10.   Create a simple document which explains about your favourite city in the world

-          Pictures aligned to left, right, middle.

-          Bold

-          Italic

-          Drop Cap

-          Bullets and numbering.

From Developer tab

-          Text box.

-          Check box.

11.   Create a simple document, what you will become after 4 years of engineering. Your Goals ideas role models, inventions.

-          Headings- font size 18, Sub headings- font size 16, normal text font size -12

-          Pictures

-          Paragraphs, left a right aligned, centre aligned

-          Font colors – use black, red, green, yellow

-          Image on text

-          Call outs

-          Drop cap.

-          Borders.

12.   Create a simple document which explains about meditation or your favorite sport.

-          Pictures.

-          Bullets and numbering.

-          Borders

-          Table

-          Paragraphs justified on left right and centre

From Developer tab

-          Insert checkbox

-          Radio button

-          List / Drop down form field

13.   Write a letter to your parents about your confessions(minimum 2 pages).

-          Date time

-          Page numbers

-          Bold

-          Italic

-          Underline

-          Strike Through

-          Uppercaps

-          Lower caps

-          Table.

-          Paragraphs aligned to left right and centre

-          Hyperlink

-          Footer

14.   Write a letter to your friends explaining about how happy you are.

-          Date time

-          Page numbers

-          Text Highlighting

-          Paragraph shading with colors – blue, green and red

-          Double Strike Through

-          Paragraphs aligned to left right and centre

-          Hyperlink

-          Header

15.   Write a Simple document for your project or invention which you would like to submit for college festival.

-          No of columns in a page : 2

-          Title, Name of the student, department and college name should be there.

-          Hyperlink

-          Superscript

-          Font size for Headings-18, Sub headings-14

-          Font size for normal text 10

-          Pictures

-          Table

-          Text alignment -180 degrees inside table for some text.

-          Bullets and numbering.

16.   Create a document in which you will explain your favorite sports star.

-          Pictures

-          Heading

-          In footer Time and date, update automatically

-          Bullets and numbering

-          Line spacing in paragraphs before 1 after 1

-          Paragraph shading – Red, black blue, green

-          Table.

From Developer tab

-          Check box.

-          Radio button.

-          Text box

17.   Create a document in which you will narrate a small story or poem.

-          Borders for page, cell, paragraph

-          Bullets and numbering.

-          Drop cap

-          Bold

-          Italic

-          Underline

-          Colors of font – blue black green red yellow

-          Pictures

18.   Create a document in which you will narrate about your parents care taking.

-          Borders for page

-          Character spacing

-          Font size – 14

-          Heading -18

-          Pictures

-          Table

-          Paragraph – aligned to left and centre

-          Date and time

-          Bullets and numbering

-          Emboss

19.   Create a document in which  you will create a poster for a dance competition Naach.

-          Page – divided in to 3 columns

-          Insert line

-          Font size -14

-          Heading -18

-          Call out

-          Hyper link

-          Paragraph – aligned to left and right

-          Font colors – blue and green

-          Insert some shapes

-          Insert pictures

-          Borders for page

-          Landscape view page

20.   Create a document with pictures on your favorite sports car or bike with specifications.

-          Pictures

-          Font size -14

-          Heading -18

-          Borders for page

-          Table – insert text as well as pictures

-          Line spacing – 2.0, before and after 1.0

-          Bullets and numbering

-          Increase the indents

-          Decrease the indents

21.   Create a document with pictures on your favorite mobile or tablet with specifications.

22.   Create a document with pictures about Android OS and its apps.

23.   Create a document with pictures about iOS and its apps.

24.   Create a document which narrates your story from childhood, about your school, friends, and college life.

25.   Create a document which tells about your good habits with pictures.

26.   Write a letter to your HOD complaining about problems you are facing in Sreendhi

27.   Write a letter to your professor to provide Letter of recommendation for the MS Program to the office in charge admissions, University of California, USA

28.   Create a document with pictures which explains about how safe india is for womens.

29.   Create a document on “Respect women”

30.   Create a document on success.