3rd paper - 1.doc

7/27/2019 3rd paper - 1.doc

http://slidepdf.com/reader/full/3rd-paper-1doc 1/10

EVERONN SYSTEMS INDIA LIMITED

Computer faculty appraisal written examination

QUESTION PAPER CODE : ESA04-3A

1. Which of the following is not an image type?

a) .gif b) .jpgc) .zip d) .tiff

2. Queries are used toa) Display all records b) Display specific recordc) Display fields d) Display required data

3. Which of the following is not a view of MS-access

a) Template view b) Design viewc) Data Sheet view d) SQL view

4. The _________ toolbar helps you to change font style and font sizeA. Font B. StandardC. Auto text D. Formatting

5. Column in a data base is referred to asa) Column b) Tablec) Record d) Field

6. Default view for MS-Word isa) Online lay out view b) Normal viewc) Page lay out view d) Out line view

7. The total number of columns in an Excel spreadsheet is

a) 254 b) 256c) 255 d) 257

8. Which of the following is a Graphics Application?a) MS -Word b) Adobe Photoshopc) MS-Access d) Accessories

9. Which of the following is of different category than others, with respectto Excel

a) Now() b) Date()

c) Today() d) Floor()

10. The action of pushing text apart from the Margin either left or right iscalled as

a) Outlining b) Word Wrappingc) Indenting d) Justifying

7/27/2019 3rd paper - 1.doc


11. Which of the following user object(s) are provided by Data Basewizard?

a) Work Sheets b) Tablesc) Templates d) None

12 The application that helps to create pivot tablesa) MS-Powerpoint b) Star Writerc) MS-Access d) MS-Excel

13 In Access database data is stored in the object called

a) Forms b) Tablesc) Queries d) Data Structure

14 The default number of worksheets in a work book isa) 2 b) 4c) 3 d) 5

15 The control used to enter or display text in Access

a) Text bar b) Labelc) List box d) None

16 The __________ function key is known as Goto key in Excela) Ctrl + F5 b) F1c) F5 d) F12

17 In Excel the option available to find subtotals is availableunder________menu

a) View b) Datac) Tools d) Format

18 The blinking character on page is called

a) Cursor b) Insertion pointc) Space mover d) Tab

19 You can create pivot table in aa) Word document b) Work sheetc) Access Table d) None

20 Goal Seek command performs the following function

a) Add & Subtract b) Subtract & Multiplyc) Multiply & Add d) All of the above

21 In Word, which of the following option helps us to apply an existingstyle quickly?a) Copy & Paste b) Macrosc) Format Painter d) Apply Style

7/27/2019 3rd paper - 1.doc


22 The key board shortcut used to move horizontally, a screen at a timein excel

a) Ctrl + Down arrow b) Alt + Page downc) Ctrl + End key d) Alt + End key

23 The default extension of an EXCEL work sheet is

a) .wks b) .xls

c) .123 d) .doc

24 Drop cap is the command of ________ applicationa) MS-Power Point b) MS-Wordc) Excel d) Access

25 The option used to name a specific location for further navigation inWord

a) Book Mark b) Commentc) Header d) Footer

26 Half Bit is calleda) Scribble b) Nibblec) Ton d) Ruffel

27 Second generation computers are manufactured using ________ technologies

a) Vacuum Tube b) Integrated Circuitsc) Transistors d) VLSI

28 The shortcut Key used to edit the content of a cell is

a) F5 b) F3

c) F2 d) Ctrl+F1

29 Fx Stands in excel is used toa) Insert formula b) Insert fieldc) Insert symbol d) Insert function

30 MS-word window can be break with the help of following command

a) New windows b) Freezec) Split d) Break

31 The key combination to warm boot a system is

a) Ctrl+Alt+Shift b) Ctrl+Alt+Delc) Ctrl+Shift+F1 d) Alt+Ctrl+F1

32 Which of the following option is used to trace a particular file inWindows

7/27/2019 3rd paper - 1.doc


a) Windows Explorer b) Findc) New Search d) My computers

33 Which of the following is an impact printer

a) Inkjet printer b) Laser printerc) Bubble jet d) dot matrix

34 How many types of page orientations available in MS-word

a) 2 b) 3c) 1 d) 4

35 Star topology is concerned with_________ network

a) Lan b) Wan

c) Man d) Intranet

36 ________ card will be used for interfacing computers on network

a)Intranet b) NICc) Internet d) Extranet

37 Internal signals of the personnel computer is____________ a) Analog b) Micro wavec) Pulse d) Digital

38. _________represents data in visual form

a) Picture b) Auto shapec) Chart d) None

39. In conditional formatting a maximum of how many conditions Excelallows

A. 2 B. 3C. 5 D. 4

40. Which of the following is a scripting language?

A. Java B. HTMLC. JavaScript D. XML

41. When a formula is cut from a worksheet it can be pasted _______

A. Twice B. ThriceC. Once D. Any times

42. The primary factor that determines the speed of a computerA. Processor B. ROM

7/27/2019 3rd paper - 1.doc


C. RAM D. Cache Memory

43. What is the last cell address in ExcelA. IV65535 B. IV65536

C. IV65534 D. IV65532

44. The protocol used to download files through Internet is

A. TCP/IP B. HTTPC. FTP D. None

45 UPS stands fora) Un-supply power system b) Uniform Power Supplier

b) Un-interrupted power supplier d) Urgent power supplier

46 Which of the following is not an RDBMS package

a) MS-Access b) Oracle

c) Sybase d) Dbase

47. A ________ is a database object that creates a data sheet of recordsextracted from one or more tables

A. Form B. TableC. Query D. Report

48 Engineering drawings can be printed with the help of ________ device

a) Plotter b) Digitizerc) Sensor d) Printer

49. The Latest version of Internet explorer isa) 5.0 b) 6.0c) 4.2 d) 6.4

50. The first page that appears after opening a web site is known as ______

a) Default page b) Home pagec) Favorite Page d) First Page

51. Selected records of a table can be viewed by applying _____ A. Sort B. Filter

C. Arrange D. None

52. In windows a _________ displays a horizontal list of iconised options thathelps us to perform the works quickly.

A. Title Bar B. Tool BarC. Menu Bar D. Status Bar

7/27/2019 3rd paper - 1.doc


53. To print the entire document, click the ________ radio button in the printdialog boxA. Current Page B. AllC. Pages D. Selection

54. In ________ networks computers acts as both client and server

a) Client Server b) Peer to Peer

c) Internet d) Intranet Server

55. _________ view is used to enter notes for slides within a presentationA. Normal B. Slide SorterC. Master D. None

56. The ‘Change Case’ option available on ______ menuA. Edit B. FormatC. Insert D. Tools

57. ___________ option is used to add decorative text to the document

A. Auto shapes B. Text boxC. Picture D. Word art

58. In Word, Columns option is present under ____________ menuA. Edit B. ToolsC. Insert D. Format

59. The insert WordArt button in MS-Word is available on the __________ toolbar

A. Standard B. DrawingC. Mail Merge D. Formatting

60. In Ms-Access the Security option is available under ___________ menuA. File B. ToolsC. Records D. Edit

61. _________ is a utility that provides a guided sequence to perform complextasks easily and quickly

A. Application B. WizardC. Program D. None

62. The Movies and Sound option in MS-Power point is selected from the ___________ menuA. Edit B. File

C. Insert D. Tools

63. _____ is an internet serviceA. E-mail B. DocumentC. Web page D. None

64. ____ switch is used with DEL command to delete a file with confirmmessage.

7/27/2019 3rd paper - 1.doc


A. /w B. /pC. /b D. /h

65. The ________ dialog box is used to rename the fields in a query in Ms-Access

A. Properties B. Design windowC. Field Properties D. None

66. Protection of work book prevents users from ________ work sheetsA. Deleting B. CopyingC. Adding D. All the above

67. In Excel, Custom Views option is available on _______ menuA. File B. ViewC. Edit D. Tools

68. Toolbars can be hidden or displayed using _________ menuA. Edit B. ViewC. File D. Tools

69. Shift + F7 is used as a short cut key which of the following option in MS-Word

A. Find B. Spelling & GrammarC. Thesaurus D. Auto text

70. Which key is used to complete the suggestion of Auto Complete in MS-Word?

A. Back space B. TabC. Insert D. Enter

71. What is the maximum number of worksheets within a workbook?A. 255 B. 65536

C. 256 D. None of the above

72. ________ bar shows the position of the ongoing taskA. Menu bar B. Address barC. Status bar D. Toolbar

73. In MS-Word, the ‘Theme’ option is available on ________ menuA. File B. InsertC. Format D. Tools

74. To print active page in a document click ______ radio button in the printdialog box

A. Pages B. SelectionC. Current Page D. All

75. Which of the following is NOT a data type in Access?A. Hyperlink B. NumberC. Boolean D. Currency

76. The _______ query wizard is used to locate duplicate records in a table

7/27/2019 3rd paper - 1.doc


A. Duplicates Query Wizard B. Matched Query WizardC. Find Duplicates Query Wizard D. Simple Query Wizard

77. _____ is the short cut key for opening control menuA. Alt + F4 B. Alt + EscC. Alt + Tab D. Alt + Spacebar

78. Word count option in MS-Word is available on _______ menu

A. Tools B. TableC. View D. Format

79. Show Auto Complete Suggestions option available on ___ tab sheet of auto correct dialog boxA. Auto text B. Auto FormatC. Auto Correct D. Smart Tags

80. Which of the following is not a Tab alignment in Word.A. decimal B. LeftC. Side D. Bar

81. Which of the following is can be used both as an input and outputdevice?

A. Hard Disk B. JoystickC. Mouse D. Scanner

82. _________ option on the start menu is used to open a file or programdirectly

A. Help B. FindC. Run D. Programs

83. ROM stands forA. Random Access Memory B. Read on Memory

C. Random Only Memory D. Read Only Memory

84. ‘MS Paint’ is anA. Application to create and edit text filesB. Application to perform mathematical operationsC. Application to draw and paint picturesD. Application to scan system

85. The storage capacity of a 3 ½ inch floppy disk may vary fromA. 360 KB to 1.44 MB B. 740 KB to 1.44 MBC. 750 KB to 1.44 MB D. 730 KB to 1.44 MB

86. The _________ command is used to view the contents of a file in DOS.A. COPY CON B. EDITC. REN D. TYPE

87. _________ represents the individual computers in the network uniquelyA. Network Interface card B. TCP/IPC. Operating System D. IP Number

7/27/2019 3rd paper - 1.doc


88. _________ software converts high-level language file into machine levellanguage file.

A. Application software B. CompilerC. Interpreter D. Customized software

89. _________ is an example of harmful programA. Computer games B. Virus scanC. Virus D. Operating system

90. You can enlarge a window using _______________ buttonA. Minimize B. MaximizeC. Close D. Restore

91. The process of loading the Operating System into the memory of thecomputer is called as

A. Start up B. BootingC. Post D. Self test

92. The DOS command used to prepare a disk for usageA. Scandisk B. Undisk

C. Format D. ChkDisk

93. If a form is opened in design window which menu is added into menu barin MS-AccessA. Format B. FormC. Query D. Report

94. A word template document has an extension __________ A. tmp B. pptC. dot D. doc

95. Ctrl + K is short cut for ________ option in MS-WordA. Book mark B. PictureC. Auto text D. Hyperlink

96. To symbol used to refer an absolute address in an excel formula is

a) # b) $c) @ d) =

97. In which of the following situations ‘Records Menu’ is added to menu barA. If a Query is opened B. If a table is openedC. If a Form is opened D. All the above

98. The default tab stop in MS-Word isa) 1" b) 2"c) 1.5" d) 0.5"

99. Extension for a Slide Show presentation file is ______ by defaultA. ppt B. ppsC. ppw D. None

7/27/2019 3rd paper - 1.doc


100. Loop Continuously unit ‘Esc’ option in available on ________ dialog boxA. Slide transition B. Set up showC. Custom animation D. Options

3rd paper - 1.doc

Documents