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