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