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