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