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