Suggessation - Computer Operation_3.pdf

Computer Operation- Level 3 1. Which one is an example of spreadsheet software? a. MS Excel c. MS Access b. MS Word d. MS PowerPoint 2. Internet Explorer is used f...

Computer Operation- Level 3 1. Which one is an example of spreadsheet software? a. MS Excel c. MS Access b. MS Word d. MS PowerPoint 2. Internet Explorer is used for: a. Viewing Movie c. Viewing Web Pages b. Listing Music d. Drawing 3. The extension of a text file (i.e Notepad) is: a..text c..txt b..tet d..tft 4. Formulas in Excel start with a. / c. – b. F d. = 5. In Microsoft Excel spreadsheets, rows are labelled as a. 1, 2, 3, ….. c. A1, B1, C1…. b. A, B, C, …. d. I, II, III, ….. 6. In Microsoft Excel spreadsheets, Column are labelled as a. 1, 2, 3, ….. c. A1, B1, C1…. b. A, B, C,…. d. I, II, III, ….. 7. Which shortcut key is used to apply outline borders? a. Ctrl + Shift + 7 c. Ctrl +Right Arrow key b. Shift + F1 d. Shift + 7 8. Which shortcut key is used to add new worksheet? a. Shift + F1 c. Shift + F11 b. Ctrl + Shift d. Ctrl +Right Arrow key 9. Which key is used to create chart in MS Excel? a. Shift+F4 c. Shift+End b. F11 d. F12 10. Which key is used to insert the current time? a. Shift+F7 c. Ctrl+Shift+; b. Shift+Alt+D d. Shift+F12 11. Which key is used to insert the current date? a. Shift+F7 c. Shift+F12 b. Shift+Alt+T d. Ctrl+; 12. Ctrl + -------- is used to undo the last action? a. X c. Q b. Y d. Z 13. Which key is used to edit the highlighted cell? a. F6 c. F2 b. F3 d. F9 14. Which key is used with CTRL to insert a hyperlink? a. K c. D b. H d. F 15. In Excel which shortcut key is used to hide the selected rows? a. Alt+9 c. Ctrl+A b. Ctrl+9 d. Ctrl+J 16. Which shortcut key is used to remove all borders? a. Shift + _ (Underline) c. Ctrl +Right Arrow key b. Shift + F1 d. Ctrl + Shift + _ (Underline) Prepared By: Jakir Hossain  Computer Operation- Level 3 17. Which software can be used for giving presentations (e.g. product demo)? a. MS Word c. MS PowerPoint b. MS Excel d. MS Access 18. The Process of erasing a disk is called: a. Wiping c. Cleaning b. Formatting d. Defragmenting 19. The shortcuts that appear on the Desktop is called: a. Image c. Icon b. My Document d. My computer 20. Which one is an example of database designing software? a. MS Excel c. MS Access b. MS Word d. MS PowerPoint 21. Notepad is used for: a. Text c. Both Text and Image b. Image d. None of these 22. Which one can be used for creating a document (e.g. Annual Report) ? a. MS Excel c. MS PowerPoint b. MS Word d. MS Windows 23. Which one is an example of Word Processing software? a. MS Excel c. MS Acces b. MS Word d. MS PowerPoint 24. Which of the following MS-Word feature crosses texts out by drawing a line through it? a. Subscript c. Underine b. Pagination d. Strikethrough 25. MS Word is a a) Computer Hardware Program c) Computer Application Program b) Computer Non-Application d) None of the above Program 26. Which of the following is not present in MS Word? a) Word Count c) Brush b) Font Size d) Page Margin 27. Which is not in MS Word? a) Italic c) Bold b) Font d) Magic Tool 28. In which view Headers and Footers are visible a. Normal View c. Print Layout View b. Page Layout View d. Draft View 29. The process of removing unwanted parts of an image is called a. Hiding c. Cropping b. Bordering d. Cutting 30. To apply center alignment to a paragraph we can press a. Ctrl+S c. Ctrl+C+A b. Ctrl+C d. Ctrl+E 31. The space left between the margin and the start of a paragraph is called a. Spacing c. Indentation b. Gutter d. Alignment Prepared By: Jakir Hossain  Computer Operation- Level 3 32. Text-styling feature of MS word is a. WordColor c. WordArt b. WordFont d. WordFill 33. Which items are placed at the end of a document a. Footer c. End Note b. Foot Note d. Header 34. To change line height to 1.5 we use shortcut key: a. Ctrl+1 c. Ctrl+3 b. Ctrl+2 d. Ctrl+5 35. A number of letters that appears little above the normal text is called: a. Superscript c. Supertext b. Subscript d. Toptext 36. We can insert a page number at a. Header c. Both A and B b. Footer d. None 37. Which one can be used as watermark in a word document Text b. Both A and B a. Image c. None 38. Which item appears dimly behid the main body text a. Water Color c. Watermark b. Background d. Back Color 39. Which feature starts a new line whenever a word or sentence reached a border a. Text line c. Text Wrapping b. New Line d. Text Align 40. The direction of a rectangular page for viewing and printing is called a. Orientation c. Print Layout b. Direction d. Preview 41. We can remove/hide border of a shape by selecting a €â a. No Line c. Whit Line b. No Outline d. No Border 42. Which Functionin Excel tells how many numeric entries are there? a. NUM c. SUM b. COUNT d. CHKNUM 43. A features that displays only the data in column (s) according to specified criteria a. Formula c. Filtering b. Sorting d. Pivot 44. Statistical calculations and preparation of tables and graphs can be done using a. Adobe Photoshop c. Notepad b. Excel d. Power Point 45. What type of chart will you use to compare performance of two employees in the year 2016? a. Column Chart c. Pie Chart b. Line Chart d. Dot Chart 46. Which one is not a Function in MS Excel? a. SUM c. MAX b. AVG d. MIN Prepared By: Jakir Hossain  Computer Operation- Level 3 47. Functions in MS Excel must begin with a. An () sign c. A Plus Sign b. An Equal Sign d. A>Sign 48. Which function in Excel checks whether a condition is true on not? a. SUM c. IF b. COUNT d. AVERAGE 49. IN Excel, Columns are labelled as a. A, B, C, etc c. A1, A2, etc. b. 1,2,3 etc d. $A$1, $A$2, etc 50. The Greater Than sign (>) is an example of operator. a. Arithmetic c. Conditional b. Logical d. Greater 51. What type of chart is useful for showing trends or changes over time? a. Pie chart c. Line Chart b. Column Chart d. Dot Graph 52. The process of arranging the items of a column in some sequence of order is known as: a. Arrengin c. Sorting b. Autofill d. Filtering 53. What is Landscape? a) Page Orientation c) A Font Size b) Paper Size d) Page Layout 54. Which function key is used to spell check? a) F6 c) F1 b) F7 d) F5 55. Which one is not a way of communication? a) Verbal c) Online Communication b) Written d) Zoom 56. Which one is not a Channel of communication? a) Zoom c) Verbal b) Google Meet d) Microsoft Team 57. Which one is not an Ergonomic requirement? a) Chair height, seat and back c) Document holder adjustment d) Enough lighting b) Workstation height and layout 58. Which one is a common application software? a) Note Pad c) Android b) MAC d) Microsoft 59. Which effect do we see as the slides of a PowerPoint change over a. Animation c. Effect b. Timing d. Transition 60. Which one is not Image Editing software? a. Photo Shop c. Corel Draw b. MS PowerPoint d. MS Paint 61. A window can have states a. 1 b. 2 Prepared By: Jakir Hossain  Computer Operation- Level 3 c. 3 d. 4 62. Which one is not an Image file? a..bmp c..wmv b..png d..jpg 63. How many scrollbars does a window have in general? a. 1 c. 3 b. 2 d. 4 64. Which one is not a file attribute? a) Date c) Time b) Size d) Font Format 65. Which one is not a type of document in MS-Excel? a) Calendar c) Salary Sheet b) Monthly budget d) Business Latter 66. To write the formula in Excel, which symbol is needed firstly? a) $ c) = b) * d) ; 67. The Slide that is used to introduce a topic and set the tone for the presentation is called the a) Title Slide c) Table Slide b) Bullet Slide d) Graph Slide 68. The feature of MS Excel quickly completes a series of data a. Auto Complete c. Fill Handle b. Auto Fill d. Sorting 69. What type of chart is useful for comparing parts of a whole? a. Pie Chart c. Line Chart b. Column Chart d. Dot Graph 70. In Excel, Rows are labelled as a. A, B, C, etc c. A1, A2, etc b. 1,2,3 etc d. $A$1, $A$2, etc. 71. What do you use to create a chart? a. Pie Wizard c. Data Wizard b. Excel Wizard d. Chart Wizard 72. How will you graphically represent expenditure in different departments? a. Column Chart c. Pie Chart b. Line Chart d. Dot Chart 73. What type of chart is good for single series of data? a. Column Chart c. Pie Chart b. Line Chart d. Cone Chart 74. The basic unit of a worksheet into which you enter data in Excel is called a a. Cell c. Box b. Table d. Column 75. How many sheets are there, by default, when we create a new Excel file? a. 1 c. 5 b. 3 d. 10 76. In Excel, which one denoted a range from B1 through E5 a. B1-E5 b. B1:E5 Prepared By: Jakir Hossain  Computer Operation- Level 3 c. B1 to E5 d. B1 $E5 77. An Excel file is generally called a/an: a. E-Spreadsheet c. Workbook b. Woorksheet d. Sheet 78. It is a collection of data that is stored electronically as a series of records in a table. a. Spreadsheet c. Database b. Presentation d. MS Word 79. Free of cost repair of software bug available at Internet is called a. Version c. Tutorial b. Ad-on d. Patch 80. Which one is a presentation software? a. Google docs c. Excel b. Numbers d. Google slide 81. The process of transferring files from you computer to a computer on the Internet is called a. Uploading c. FTP b. Forwarding d. Downloading 82. Verification of a login name and password is known as: a. configuration c. authentication b. accessibility d. logging in 83. What’s a web browser? a. A kind of spider b. A computer that stores www files c. A person who likes to look at websites d. A software program that allows you to access sites on the world wide web 84. The Internet was originally a project of which agency? a. ARPA c. NSA b. NSF d. None of these 85. Which of the following is a correct format of email address? a. name@website@info c. www.nameofebsite.com b. [email protected] d. Name.website.com 86. HTML is used to create a. Machine language program c. Web page b. High level program d. Web server 87. The computer jargon- WWW stands for: a. World Wide Web Worm c. World Wide Women’s Web b. World Wide Wildlife Web d. World Wide Women’s Week 88. The process of transferring files from a computer on the Internet to your computer is called a. Uploading c. FTP b. Forwarding d. Downloading 89. In internet terminology IP means a. Internet Provider c. Internet Procedure b. Internet Protocol d. Internet Processor 90. A Web site’s front page /main page is called a. Browser Page c. Home Page b. Search Page d. Bookmark 91. Which one of the following is not a search engine? Prepared By: Jakir Hossain  Computer Operation- Level 3 a. Bing c. Yahoo b. Google d. Windows 92. Verification of a login name and password is known as: a. Configuration c. Authentication b. Accessibility d. Logging in 93. Internet explorer falls under: a. Operating System c. Browser b. Compiler d. IP address 94. What is the full form of WWW in web address? a. World Wide Web c. World Wide Wood b. World Wide Word d. None of these 95. Full Form of HTML is: a. Hyper Text Markup Language b. Hyper Text Manipulation Language c. Hyper Text Managing Links d. Hyper Text Manipulating Links 96. Moving from one website to another is called: a. Downloading c. Uploading b. Browsing d. Attachment 97. A computer on internet is identified by: a. E-mail address c. IP address b. Street address d. None of the above 98. What is the meaning of “Booting” in the system a. Restarting Computer c. To scan b. Install the program d. To turn of 99. The Shortcuts that appears on the Desktop is called: a. Image c. Icon b. My Document d. My computer 100. Which one of the following is an input device? a. Monitor c. Printer b. Speaker d. Scanner 101. What one is not computer peripherals? a. Scanner c. Microphone b. HDD d. Webcam 102. A spreadsheet is the best application for a. Writhing a information d. Keeping an inventory of b. Handling simple accounts equipment used c. Producing a grid-referenced map 103. Which one is not a Unicode font? a. Sutonny MJ c. TonnyBanglaOMJ b. Nikosh d. None of above 104. Which one of the following is a search engine? a. Bing c. Firefox b. Gmail d. Windows Prepared By: Jakir Hossain  Computer Operation- Level 3 105. The central processing unit is located in the a. Hard disk c. Memory unit b. System unit d. Monitor 106. Deleted data remains on a disk until a. The data is overwritten c. A file compression utility is b. The recycle bin is emptied used d. The disk is scanned 107. While on the desktop in Windows, what happens pressing F5 do? a. Refreshes the screen c. Does Nothing b. Opens help menu d. Opens Search 108. What is the main advantage of using a text box? a. It automatically makes the text large b. It allows you to change the page orientation c. It gives you more freedom to move the text around d. It automatically appears on every page of your document 109. In which view Headers and Footers are visible? a. Normal View c. Print Layout View b. Page Layout View d. Draft View 110. Which items are placed at the end of a document? a. Footer c. End Note b. Footnote d. Header 111. A number of letters that appears little below the normal text is called: a. Superscript c. Supertext b. Subscirpt d. Toptext 112. We can change the thickness of a line from a. Line width c. Line Thick b. Line Height d. Line Style 113. To go to a specific location in a document we use: a. Table c. Bookmark b. Hyper Text d. Macro 114. Superscript, subscript and strikethrough are known as? a. Font Face c. Font Effects b. Font Style d. Font Format 115. In MS-Excel Graphics objects on a chart are used to: a. Add emphasis to chat data c. Help explain the chart data b. Add interest to a chart d. All the above 116. What is the shortcut key to highlight the entire column in excel? a. Ctrl + C c. Ctrl + Page Up b. Ctrl + Enter d. Ctrl + Space Bar 117. In the formula, which symbol specifies the fixed columns of rows? a. $ c. % b. * d. ; 118. The effect applied to Display when slides change in slide show view is: a. Slide Animation c. Custom Transition b. Custom Animation d. Slide transition Prepared By: Jakir Hossain  Computer Operation- Level 3 119. We can change the thickness of a line from a. Line width c. Line Thick b. Line Height d. Line Style 120. What item contains detailed information about something in the text? a. Footer c. Header b. Foot Note d. Head Note 121. Which item is printed at the bottom of each page? a. Header c. Title b. Foot Note d. Footer 122. Color and pattern used to fill a closed shape is called. a. Shape c. Fill Style b. Word Art d. Fill Back 123. Where footnotes appear in a document a. End of document c. End of Heading b. Bottom of a Page d. None 124. What is the intersection of a column and a row on a worksheet called? a. Column c. Address b. Value d. Cell 125. What type of chat is useful for comparing values over categories? a. Pie Chat c. Line Chart b. Column Chart d. Dot Graph 126. Which software is not a file compression utility? a. 7-zip c. Win RAR b. Win Zip d. Compres 127. From where we can change the name of a Use Account? a. Settings c. Computer Name b. Code Panel d. Control Panel 128. In which situation do running applications of a user account remain active? a. When we Log off c. When we Shut Down b. When we Switch User d. When We Reboot 129. How can we bring ‘My Computer icon on the desktop if it is not there? a. From Wallpaper c. From Display Properties b. From Settings d. From Explorer 130. In a PowerPoint Presentation Animation can be repeated how many times a. 2 to 5 c. 2 to 10 b. 1 to 5 d. 1 to 20 131. Which shortcut key is used to format numbers in time format? a. Shift + @ c. Shift + F1 b. Ctrl + Shift + @ d. Ctrl +Right Arrow key e. 132. Which key is used to create chart in MS Excel? a. Shift+F4 c. Shift+End b. F11 d. F12 Prepared By: Jakir Hossain  Computer Operation- Level 3 133. In MS-Excel which command do you use to enter the current date in a cell? a. Ctrl + Shift + : c. Ctrl+ F10 b. Ctrl + ; d. None of these e. 134. In Microsoft Excel spreadsheets, rows are designated as. a. 1, 2, 3,... c. A1, B1, C1,.... b. A, B, C,... d. I, II, III,... 135. The Greater Than sign (>) exemplifies a/an operator. a. Arithmetic c. Logical b. Conditional d. Greater e. 136. Excel function returns TRUE or FALSE based on two or more conditions. a. =AVERAGEIFS c. =COUNTA b. =CONCAT d. =AND 137. Microsoft word is software. a. Application c. System b. Compiler d. Programming e. 138. Which is not in MS Word? a. Italic c. Font b. Magic tool d. Bold e. 139. cannot be used to work in MS Office. a. Joystick c. Light Pen b. Scanner d. (D) Mouse 140. In addition to password protection, what other security feature can be used in Microsoft Word to restrict editing? A. Read-only mode C. Document Encryption B. Track Changes D. Watermark 141. What action should take if you want to remove password protection from a Word document? A. File tab > Remove Password B. Review tab > Unlock Document C. Save the document in a different file format D. Review tab > Product Document > Remove Protection 142. The space between the margin and the start of a paragraph is called A. Blank space C. Negative space B. Positive space D. Indentation Prepared By: Jakir Hossain