Asked Question Set 14 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 14 Asked Question Set 14 1) Which of the following is correct syntax in Excel? =If(LogicalTest,(TrueResult,FalseResult)) =If(LogicalText, TrueResult, FalseResult) If(LogicalTest, TrueResult)(LogicalTest,FalseResult)) All of these 2) In Microsoft Word the key F12 opens a? Close dialog box Save dialog box Save as dialog box Open dialog box 3) The…….feature of MS Excel quickly completes a series of data? Autocomplete Sorting Fill handle Autofill 4) The main block of the computer system consists of? RAM ,Hard Disk, Keyboard and Monitors Input Unit,Output Unit, Control Unit Input, Output, CPU and memory Input,Output,Storage and User 5) Which HTML tag produces the biggest heading? <h4> <h7> <h9> <h1> 6) The memory which is ultraviolet light erasable and electrically programmable is? RAM ROM EPROM SRAM 7) Which of the following is not of the merge process? Format a main document Edit a data source Sort the data records Merge the two files to print or create new document 8) ……..value change the color of text into red? 0000FF FF0000 00FF00 None of these 9) What type of chart is useful for comparing parts of a whole? Line chart Column chart Pie chart Dot chart 10) The PowerPoint view that displays only text (title and bullets) is? Slide sorter view Notes page view Slide show Outline view 11) …….is the default field size of auto number ? Short integer Long interger Double Float 12) Which is an example of a function ? =sum(A1,A2) A1+A2 =A1+A Add(A1:A2) 13) The ALU of a computer normally contains a number of high speed storage element called? Semiconductor memory Registers Magnetic disk Hard disks 14) Which language is used to create macros in Excel? C Visual Basic Java VisualC++ 15) Communication between a computer and a keyboard involves……..transmission? Full-duplex Simplex Automatic Haf-duplex 16) The command allows you to create logical drive? Batch Subst Sort Path 17) …..command is used to create a file? Create Copy Create con Copy con 18) Which is the valid data type in MS Access? All of these Number Currency Text 19) How many parts are there in the constitution of nepal? 30 25 35 40 20) Pressing the combination of …….keys is called warm booting? Ctrl + Caps + Del Ctrl + Shift + Del Ctrl + Tab + Del Ctrl + Alt + Del 21) The basic operations performed by a computer are? Arithmetic operation Storage Logical operation All of these 22) Which of the following malicious program do not replicate automatically ? Virus Worm Torjan horse Zombie 23) Who was the first computer programmer? Bernouli Newton Ada Lovelace Charles Babbage 24) Objects on the slide that hold text are called ? Auto layout Object holders Placeholders Text holder 25) Which of the following memories need refreshing? All of these DRAM ROM SRAM 26) Keyboard shortcut to add new slide in MS PowerPoint is? Alt+N Ctrl + N Alt+M Ctrl + M 27) Which of the following is not a section in report design window in MS Acess? Page header Summary Report header Report footer 28) A form can be used as a? Data entry Swithboard Custom dialog box All of these 29) ……..combination of keys are used for column break? Ctrl + Alt + Del Ctrl + Shift + Home Ctrl + Shift + Enter None of these 30) Which of the following require large computers memory ? All of these Voice Imaging Graphics 31) To start data on a new line within a cell, enter a line break by pressing ? Alt+Enter Shift+Enter Ctrl + Enter None of these 32) Slides can have? Title, text, graphs All of these Drawn objects, shapes Clipart, drawn art,visual 33) The slowest transmission speeds are those of? Fiber optic cable Microwaves Coaxil cable Twisted pair cable 34) To print current page of a document only? None of these Press Ctrl+P and select current page Click MS Office button>>Print>>Print Preview>>print and select current page Click MS Office button>>Print>>Quick Print 35) The programs which are as permanent as hardware and stored in ROM are known as? Filmware Software ROM ware Hardware 36) A computer on internet is identified by? IP address E-mail address Website address Street address 37) Only filenames and extensions are to be displayed in wide format, which command you’ll use? Dir/w Dir a: Dir/s Dir/b 38) Which of the following needs refreshing? ROM DRAM All of these SRAM 39) A teleprinter is? Teletypewriter Teletype All of these TTY 40) According to the timber corporation of Nepal karmachari sewasart nimawali,2052,what is the maximum mark a candidate for promotion will get for his seniority? Twenty Sixteen Thirty Twenty four 41) The A4 default paper size of width/height is? 8.37"/11.79" None of these 8.17"/11.59" 8.27"/11.69" 42) The ASCII code of 0(Zero) is? 42H 32H 48D 0011 1000 43) In a table, the relationship among a set of values are represented by? Tuple Entity Attribute Key 44) The formula in cell B5 is=A4+C3. This is copied to the cell D8. What will be the formula in D8? E7+C5 A4+C3 C7+E7 C4+E3 45) DNS database contains? Hostname aliases Name server records All of these Hostname-to-address records 46) Which of the following is not a valid capacity of a floppy disk? 1.24 MB 360 KB 1.44 MB 720 KB 47) Function key…….is used to display the slides show? F5 F7 F4 F6 48) Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Statistical Financial Logical Math and Trigonometry 49) ……..Uniquely identifies each record? Primary key Unique key Key record Field name 50) Which of the following should be used when you want to add a slide to an exitsing presentation? Insert,New slide File open File,add a new slide File new 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