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