Asked Question Set 19 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 19 Asked Question Set 19 1) Which of the following line spacing is invalid? Multiple Single Triple Double 2) Red triangle at the to right corner of a cell indicates? The cell can't accept formula The font color the text in cell is red There is an error in the cell There is a comment associated with the cell 3) The short cut for print preview in Ms-Word is? Ctrl + J Alt+ctrl+i Ctrl + A Ctrl + Shift + K 4) Which of the paper size is the largest? A3 Legal Letter A4 5) To auto fit the width of column? Double click the column header Double click left border of column All of these Double click right border of column 6) In which mode windows starts with only core drivers and services ? Safe mode Normal mode Quick mode Repair mode 7) Which of the below IP address would be used for a private network ? 209.131.36.100 69,72,169,241 74,125,127,100 192.168.1.100 8) To insert new comment in excel sheep press……? Shift+F3 F2 F3 Shift+F2 9) Data Definition language (DDL) includes? Selecting table Data insert All of these Creating table 10) In Ms Excel, getting data from a cell located in a different sheet is called ……? Referencing Accessing Functioning Updating 11) A character that is raised and smaller above the baseline is known as? Raised Outlined Superscript Subscript 12) The shortcut to collapse and expand the ribon in Ms-Word is? Alt+ctrl+F1 Alt+F1 Ctrl + F1 Shift+F1 13) Invalid formula category in Excel is? Date and time Cube Graphical Financial 14) Which of the following is the property of primary key? Duplicate Limited Pictorials Unique 15) Distortion in a signal is called? IP switch Amplitude Phase Noise 16) A computer program that converts an entire program into machine language at a time is called a/an? Compiler Commander Interpreter Simulator 17) The BIOS is the abbreviation of……..? Base input output system Best input output system Basic input output symbol Basic input output system 18) ASCII stands for? American standard code for interchange information American stable code for international interchange American standard code for information interchange American standard case for institutional interchange 19) Tool in Ms Excel to combine values from multiple ranges into a new range is? Consolidate Ranging Combination What-IF analysis 20) In Ms Access, technique to speed up data retrieval? Speeding Indexing Referencing Listing 21) The two basic types of record access methods are? Direct and immediate sequential and random Online and real time sequential and indexed 22) Central processing Unit is combination of? Arithmetic logic and control unit Arithmetic logic and input unit Control and output unit Control and storage 23) The language that the computer can understand and execute is called ? Machine language System program Compiler Application software 24) The key F12 opens a? Open dialog box Save dialog box Close dialog box Save as dialog box 25) Background color or effects applied on a document is not visible in? Print preview Reading view Web layout view Print layout view 26) How do you delete the selected a column or cells Ctrl++ Alt+- Ctrl+- Alt++ 27) Conditional count can be performed using? Incount() Iffcount() Countiff() Countif() 28) In Ms Excel to select multiple non-adjacent cells in a worksheet you will click them holding ? CTRL key Shift key ALT key Ctrl + Shiftkey 29) What is legend? Explains the axes of the chart Explains the purpose of entire chart Explains the title of the chart Provides text to explain what each visual part of a chart means 30) Which of the following is praphicssolution for word processors? All of these Word art Drop cap Clipart 31) The keystrokes Ctrl+I is used? Inserts a line break Increase font size Applies italic format to selected text Indicate the text should be bold 32) What is the short cut key to open font dialog box? Alt+ctrl+F Ctrl + D Ctrl + Shift + D Ctrl + F 33) Where can you change the vertical alignment? Page setup dialog box Paragraph dialog box Formatting toolbar Standard toolbar 34) In word, the mailing list is known as the……? Data sheet Source Data source Sheet 35) As compared to the secondary memory, the primary memory of a computer is? Cheap Slow Large Fast 36) Which of the following is the default page setup orientation of slides in power point? Landscape Vertical Portrait None of these 37) Which of the following presentation elements can you modify using the slide master? Slide comments Slide transitions All of these Speaker note 38) To insert function in excel sheet press……? Shift+F3 Shift+F2 F2 F3 39) What is the shortcut to copy the format from a text? Ctrl + Alt + C Shift+Alt+C Ctrl + Shift + C Alt+Ctrl+F 40) Which of the following memories has the fastest access times? Magnetic core memory RAM Cache memory Magnetic bubble memory 41) How was the generation of computer classified? By the device used in memory and processor By the speed of computer By the accuracy of computer By the model of the computer 42) The term gigabyte refers to? 1024 kilobytes 1024 bytes 1024 gigabytes 1024 megabytes 43) How do you delete any content directly without consuming the space of recycle bin? None of these Ctrl + Shift + Delete Shift+Delete Ctrl + Delete 44) Which of the following is the part of the operating system ? Kernal Cell Disk FAT 45) When a formatted number does not fit within a cell,it displays? #DIV/@ ##### None of these #DIV/0 46) NTFS is……? External command Internal command Storage format Disk tool 47) The first computer introduced in Nepal was? IBM1402 IBM1401 IBM1400 ICL/2950 48) Which of the following operating system does not implement multitasking truly? MS Dos Windows 98 Windows XP Windows NT 49) The istructions for starting the computer are housed on? All of these CD-ROM Read only memory chip Random access memory 50) Which of the following is an absolute cell reference? $A1$ #A$1 $A$1 #A1# 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