10th Information Technology practical examination(code:402) Practicing question with answer(viva)

VIVA QUESTIONS

Types of networks

There are two major types of network Local Area Network (LAN) and Wide Area Network

(WAN).

Local Area Network

A local area network (LAN) is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, offi ce building, or closely positioned group of

buildings

Wide Area Network

A wide area network (WAN) is one which covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries).

Internet

The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite to serve billions of users worldwide.

World Wide Web

World Wide Web (abbreviated as WWW or W3, commonly known as the Web), is a system of

interlinked hypertext documents accessed via the Internet.

Internet Service Provider

An Internet service provider (ISP) is an organization which provides you with access to the Internet

via a dial-up (using modem) or direct (hard wired) or wireless connection.

Modem

Á modem is a device that converts digital computer signals into a form (analog signals) that can

travel over phone lines. It also re-converts the analog signals back into digital signals.

WI-Fi: Wi-Fi is a popular technology that allows an electronic device such as computers or mobile phones to exchange data wirelessly over a network, including high-speed Internet connections. Wi-Fi devices such as personal computer, smartphones, video game console, etc.

Blog : A blog is a discussion style site used by non-technical (or technical users) users for creating personal web pages. Blogs are similar to an online personal diary and simple to use.

Online shopping could be useful in situations when:

• A customer does not have sufficient time to visit stores.

• Visiting a store is more expensive than purchasing a product online.

• A product or service that is not available in the local market is available online.

Some of the popular online transaction websites are:

• IRCTC, an online portal for booking fl ight and train tickets.

• Flipkart, an online shopping portal for buying consumer products.

• EBay, an online portal for buying and selling goods.

• Redbus, an online portal for booking bus tickets.

1. Paragraph group is available under Page layout tab

2. Default tab stop position is 0.5”

3.  Header can be used for inserting information at the top of each page

    automatically.

4.  Header option is available under Header and Footer group in Insert Tab.

5. Footer can be used for inserting information at the bottom of each page

   automatically.

6. You can change styles by using the styles group under the Home tab.

7. Templates or document templates refer to a sample fi ll-in-the-blank document.

8. Page and Section breaks can be used to separate a document into sections.

9.  A section break controls the formatting of the document content that precedes it, until it reaches another section break.

10. To see a section/page break, click the Show/Hide button.

11. After selecting the text you need to click the Grow Font in the Font group to make the font Size larger than the current font size.

12. To remove the character formatting, select the text and click on Clear Formatting in the Font group.

13. On selecting Sentence Case the first character in the first word of the    

      Selected sentence will be converted to Capital Letter.

14. On selecting Capitalize Each Word, the first character in all the words of the

      Selected sentence will be converted to Capital Letter.

15. Clip Art can help in making a document look colourful and presentable

16. Clip Art is available under Illustrations group in Insert Tab

17. After you have inserted the picture, you can wrap the text by using the   

      wraptext option.

18. Embedded objects cannot be printed.

19. Symbol option is available under symbols group in the Insert tab.

20. You can insert lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, Stars, banners, and callouts using the shape option.

21.  Autosum is used for adding the values given in cells automatically without  

    writing  the formula.

22. AutoSum option is available in editing group under the Home tab.

23. Autosum automatically selects the values around the cells either horizontally

      or vertically

24. Conditional formatting allows you to change the formatting (font color,

       border, shading) of the cells based on the values in it.

25. Conditional formatting is available under Styles group in Home tab.

26. When you freeze a row, headers remains constant.

27. Freeze Panes option is available under Window group in View tab

28. The panes are formed where your cursor  is placed.

29. The Breaks option is available under_Page Setup group in the Page Layout

       tab.

30. To return to Normal view after you finish working with the page breaks, you need to click Normal in the Workbook Views group under the View tab.

31. Spread sheet software provides various page layout options for organizing pages using the  Page Layout option

32. Margins option is available under Page Setup  group in the Page Layout tab.

33. Two types of page orientation are portrait and landscape.

34. Different types of views are available under Workbook Views in the View tab.

35. The five types of views available are normal, page layout, page break, custom view and  full screen.

36. The custom view helps you to view a selected area of a workbook.

37. Assigning names to cells in a worksheet help you to quickly locating specific

      cells.

38. The Define Name option is available under Define Names  group in the

     Formulas tab.

39. Sort helps you arrange the selected data either in an ascending or descending

      order.

40. Sort option is available in _ Sort & Filter group under the Data tab.

41. Filter option is available in Sort & Filter group under the Data tab.

42. Presentation allows the user to add movie clips to the presentation in order to  

      make the presentation colourful and meaningful.

43. Movie option is available in  Media clips group under the Insert tab.

44. You can include audio clips to a presentation similar to that of videos.

45. Tables are used to represent the statistical data meaningfully in a

      Presentation.

46. Table option is available in tables group under the Insert tab.

47. Presentation enables the user to insert charts in slides to present statistical

     table data  in a pictorial representation.

48. Transition effects can help in increasing audience’s interest during a presentation.

49. A slide transition is the visual motion when one slide changes to the next

    during a  presentation.

50. Animation enables you to put slide elements, such as text and graphics, in

      motion within a slide.

51. Animations are helpful way to make your slides look more dynamic.

52. Grouping helps to move, rotate or resize multiple objects in a presentation.

53. The Group option is available in Arrange  group under the Format tab.

54. Speaker notes are guided text used by the presenter during a presentation.

55. A Calendaring software provides the user an electronic version of a calendar.

56. Print option is available under file menu.

57. A meeting is an appointment to which you invite people or reserve resources.

58. A database is an organized collection of data.

59. A relational database management system is a database management system  

     that is based on the relational model.

60. A primary key is a unique value that identifies a row in a table.