Asked Question Set 10 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 10 Asked Question Set 10 1) ……..enables you to view data from a table based on a specific criterion? Query Form Report Macro 2) Filter option is used to…..? Arrange data in Alphabetical order Extract the records that meet given criteria Arrange data in numericorder Arrange data in chronological order 3) ……Enables serval people to work to create and update a document? Document sharing Document protection Document collaboration Document locking 4) The formula =if(A1>B1,A1-B1,B1-A1) gives? Positive difference of A1&B1 Contents of A1 Contents of B1 Larger one from cell A1 & B1 5) Unicode standard is…..? Character encoding system Font Software Keyboard layout 6) To set the background color we use? All of these <body text="color"> <body bgcolor="color"> <body="color"> 7) Function to get some of the contents of the cells A1,A2,B1,B2 is…….? =sum(A1+A2+B1+B2) =total(A1..B2) =sum(A2,B2) =sum(A2:B2) 8) In Microsoft PowerPoint in order to see all the slides on one screen you use? Master view Slide view View,slide sorter view Slide show 9) Cache memory……? Store data permanently Placed between main memory and microprocessor Helps to store more data in hard disk Holds last time visited data only 10) Thesaurua tool in MS Word is used for? Grammar options Synonymous and antonyms word All of these Spelling suggestions 11) What are the different views to display a table? Design view Datasheet view All of these Pivot table and pivot chart view 12) An area of a computer that temporarily holds data waiting to be processed is? Storage CPU Memory File 13) A word processor would most likely be used to do? Type a biography Keep an account of money spent Do a computer search in media center Maintain an inventory 14) Shortcut key to bring format cells dialog box is? Ctrl + 1 Ctrl + D Ctrl + F Ctrl + E 15) …….switch the page between portrait and landscape layout? Margin Columns Size Orientation 16) Transistor is related to……generation computers? Fifth Third Second Fourth 17) Program developed according to the requirement specific to an office is……..? Packaged software All of these Utility software Tailored software 18) In HTML……tag is used for linking an external document? <anchor> <src> <include> <a> 19) …….runs on computer hardware and sarve as platform for other software to run on? System software Application software Operating system All of these 20) A database language concerned with the definition of the whole database structure and schema is? DDL DCL All of these DML 21) Which tab in font dialog box contains options to apply font effects? Character spacing Text effects Font tab Standard toolbar 22) In a database table, the category of information is called? Record Field Tuple All of these 23) ……are set of rules and procedures to control the data transmission over the internet? Gateway Protocol IP address Domains 24) The primary function of an operating system is? To keep system programs employed To make the most efficient use of the computer hardware To allow people to use the computer To make computers easier to use 25) The operating system creates…….from the physical computer? None of these Virtual space Virtual device Virtual computers 26) When a hyperlink is created, Word formats the web address as……? Italicized and colored red Italicized and colored blue Underlined and colored blue Underlined and colored red 27) To edit the contents of cell? Click on formula bar Double click on cell Press F2 All of these 28) The difference between people with access to computers and the internet and those without these access is known as the? Internet divide E-illiteracy Web divide Digital divide 29) Which of the following is not of the merge process? Format the main document Sort the data source records Edit the data source Merge the two files to print or create a new document 30) Which of the following font effect is not available in PowerPoint font dialog box? Underline Strikethrough Shadow Embos 31) IBM 1401 was brought to prepare the census report of….? 2018BS 2028BS 2038BS 2048BS 32) ……..is a tool in word which apply same format to different character/paragraph? Format painter Format generator Format repeater Format applier 33) Which of the following is a file attribute? All of these Hidden Read only Achieve 34) How do you display updatable current date in MS Excel? Ctrl + ; NOW() DATE() TODAY() 35) Windows 7 supports which of the following file system? UNIX FAT EXIT NTFS 36) A screen element of MS Word that is usually located below the title bar that provides categorized options is? Tool bar Status bar Menu bar All of these 37) Which among the following are the best tools for fixing errors in disk? Scandisk Chkdsk Fixdisk Fdisk 38) If you need to change the typeface of a document, which menu will you choose? View Edit Tools Format 39) Graphical representation of worksheet data? Scenario Pivote table Goal seek Graph 40) Workbook is collection of? Workspaces Worksheets Cells Projects 41) A fault in a computer program which prevents it from working correctly is known as? Biff Strap Boot Bug 42) The cell reference $A$5 is a……..? Mixed cell reference None of these Relative cell reference Absolute cell reference 43) For reproducing sound, a CD(compact disk) audio player uses a….? Laser beam Titanium needle Quartz crystal Barium titanium 44) A function inside another function is called? Sum function Round function Nedted function Text function 45) Full from of HTML is? All of these Hotmail Hypertext Markup Language Hypertext mail language 46) Which one of the following printers is suitable for printing sprocket fed carbon copies? Dot matrix Drum Ink jet Laser 47) …….are used to identify a user who returns to a website? Session Scripts Cookies Plug-ins 48) The ability to recover and read deleted or damaged files from a criminal’s computer is an example of an enforcement specially called? Animation Simulation Robotics Computer forensics 49) This key uniquely identify each record? Unique key Key record Primary key Field name 50) What are the three options available in Insert>>Picture menu? Clipar,Pictures,Shapes Clipar,Pictures,Autoshapes Clipar,From file,Shapes Clipar,From file,Autoshapes Your score isThe average score is 0%Share this quiz with your friends. LinkedIn Facebook Follow Us @ 0% Restart quiz Exit Please drop your valuable review. Send feedback