21st March 2025 QP Shift1 21st_March_2025_QP_Shift1 1 / 70Which of the following bugs occur when a software application does not function correctly across different environments, devices, or platforms? Performance Logical Security Compatibility Testing and software bugs2 / 70A Microsoft Excel 2019 file has a ________ format by default. .xls .xl .xlsx .wks Default spreadsheet extensions3 / 70With respect to computer booting, MBR stands for: Master Boot Recovery Memory Boot Recovery Memory Boot Record Master Boot Record Hard drive partitioning standards4 / 70A "clean boot" starts Windows with only one driver and startup program a maximum set of drivers and startup programs a minimal set of drivers and startup programs shutdown programs Troubleshooting startup states5 / 70What is the full form of NTFS which is developed by Microsoft? New Technology File System New Technique for File System Non-windows Technology File System Non-cluster Technique for File System File system acronyms6 / 70The term 'bit' is taken from the word Binary digit Boolean digit Bipolar digit Biased digit Binary digits origin7 / 703072 MB equals to 3KB 3GB 3000KB 1024KB Memory conversion (1024 MB = 1 GB)8 / 70Which of the following is a mid-range computer that is intermediate in size, power, speed, storage capacity, etc., between a mainframe and a microcomputer? Minicomputer Supercomputer Personal Computer Desktop Computer Classification of computers9 / 70In computing, TFT-LCD stands for Thick Film Transistor Lucent Crystal Display Thick Film Transistor Liquid Crystal Display Thin Film Transistor Liquid Crystal Display Thick Film Transistor Light Crystal Display Display technologies acronyms10 / 70Which of the following is/are temporary memory storage device type of computer(s)? (i) SRAM, (ii) DRAM, (iii) ROM Both (i) and (ii) Both (ii) and (iii) Both (i) and (iii) only (iii) Volatile vs non-volatile memory11 / 70Which of the following is NOT an example of an input device of a computer? Keyboard Mouse Joystick Printer Classifying peripheral devices12 / 70Which of the following is NOT an example of a proprietary software? Microsoft Windows MacOS iOS Linux Distinguishing free/open-source from closed13 / 70When new software is downloaded from the Internet, the installation file will be saved to the computer in the ________ file format. .exe .Obj .pdf .xls Executable file extensions14 / 70A half byte is known as bit data nibble half bit Computer memory measurements15 / 70If a soft copy is an intangible output, then what is a hard copy? A physical part of the computer A virtual copy of the printout A digital document printed on paper A physical output device Output devices and media16 / 70Which of the following are simple scanners that have the limitation of scanning paper documents only? Sheetfed Flat bed Handheld Handdown Types of hardware scanners17 / 70The keyboard shortcut to minimise desktop window in Windows 10 is: Windows key + Down arrow key Windows key + Up arrow key Windows key + Left arrow key Windows key + Right arrow key Windows key shortcuts18 / 70Which of the following is software with source code that anyone can inspect, modify, and enhance? Open-Source Proprietary Adware Ransomware Open-source software characteristics19 / 70Which of the following is a unique identifier to refer to a specific location in computer memory? Memory Address Value at location Function of location Index Identification of memory cells20 / 70Recycle Bin is a: folder to store deleted files temporarily before permanently deleting them folder that contains the files used for backup file that contains information of files on the disk folder that contains system files Basic Windows file management concept21 / 70What is the result of the following function in MS-Excel 2019? =SUM(A, 1, 2, 3) 600% #VALUE! #NAME? 1600% Unquoted text triggers a name error22 / 70In MS Word 2019, the keyboard shortcut Ctrl+'U' on a selected text is used to apply underline formatting convert to uppercase toggle between lowercase and uppercase undo the previous action Basic text formatting shortcuts23 / 70What is the error value corresponding to the MS-Excel 2019 formula '=D1/0' if D1 contains value 5? #DIV/0! #NAME? #REF! #NULL! Division by zero error code24 / 70Copy, cut and paste operations in MS Word 2019 are typically supported using a buffer called Briefcase Cache Clipboard Recent Files Operating system clipboard usage25 / 70Which keyboard shortcut is used to do Change Case of selected text in MS-Word 2019? Shift + F3 Shift + F4 Shift + F7 Ctrl + F3 Changing text casing26 / 70The value of the MS-Excel 2019 expression =SUM(-7,18/6/3) is: 600% -600% 200% -200% Order of operations: -7 + (18/6/3) = -7 + 1 = -627 / 70If you want to edit a cell in a spreadsheet in MS-Excel 2019, the ________ function key is used. F1 F2 F9 F5 Excel keyboard shortcuts28 / 70If you want to use formulas or functions in MS-Excel, then the formula or function should always begin with which of the following symbols? ! % $ #ERROR! Basic Excel syntax29 / 70Anil wants to know the total number of numeric values in a column in MS-Excel 2019 worksheet. Which of the following functions should he use? IF() COUNT() SUM() AVG() Counting numeric values in ranges30 / 70What approximate value will come in place of the question mark (?) in the following equation? 151.011−419.999+649.991=? 35000% 36500% 37500% 38000% Basic rounding estimation: 151 - 420 + 650 = 38131 / 70If 49x=2.2189, then find the value of x (to the nearest integer value) 420000% 410000% 421000% 435000% Linear equation calculation: x=2.2189×49≈421032 / 70What will come in place of the question mark (?) in the given number series? 123, 140, 106, 157, 89, ? 13900% 19800% 17400% 21400% Alternating series: +17, -34, +51, -68, +8533 / 70The average of the three numbers x, y and z is 120. If the largest number is 140 and the difference between other two is 40, what is the smallest? 9000% 10000% 11000% 12000% System of linear equations: x+y=220,x−y=4034 / 70Aoorv sold an article at 20% profit on CP. When CP is reduced by 10%, SP was reduced by 4%. Profit % on CP is now: 28% 3331% 35% 3721% Percentage tracking: New CP=90, New SP=115.235 / 70The marked prices of a pencil and a pen are in ratio 1:2. Shopkeeper gives 40% discount on pencil. If total discount is 30%, discount on pen is: 18% 20% 25% 30% Weighted average calculation for discounts36 / 70Major' is related to 'Lieutenant' in the same way as 'Squadron Leader' is related to '________' Group Captain Flying Attendant Flying Officer Pilot Officer Equivalent ranks in Army vs. Air Force37 / 70AEHRKN (123456) can be rearranged to form a meaningful word: 3, 1, 6, 5, 2, 4 4, 1, 5, 3, 2, 6 5, 3, 1, 4, 2, 6 6, 1, 5, 3, 4, 2 Rearranging letters to spell "HANKER"38 / 70Select the word from the options that is similar to the given set of words: Daisy : Pansy : Rose Garden Tree Violet Red Finding flower types39 / 70Select the most appropriate description about the given set of words. Stirrup : Anvil : Drum They are used by riders They are parts of the ear They are musical instruments They are used by folk artists Anatomical structures inside the human ear40 / 70Bailadila Mines are in the state of Odisha Tamil Nadu Chhattisgarh Assam Location of famous iron ore mines41 / 70Which icon appears on the far right side of the taskbar when you are NOT connected to a wi-fi network in Windows 11? [Icon 1] [Icon 2] [Icon 3] [Icon 4] Visual UI question (requires image reference)42 / 70Which of the following steps should one use to update the printer driver automatically in Windows 10? Home -> "Printer and devices" -> Right-click -> Select update printer Control Panel -> Right-click -> Printer and devices -> Select Auto update printer Device Manager -> Expand "Printers" -> Right-click -> "Update Driver" -> Search automatically Network -> Printer and devices-> Right-click -> Select automatically update Navigating Windows Device Manager43 / 70A printer's network IP address in Windows OS can be determined through the printer manual device driver Control Panel onboard printer menu Locating device network properties44 / 70Which of the following software is required to combine and compress multiple files and folders into a single file? Winzip Adobe Acrobat Reader MS-Paint Adobe Acrobat Writer File compression utilities45 / 70Which type of disc is a Blu-ray disc? Magnetic Optical Mechanical Electrical Optical storage media classification46 / 70Which of the following access types is used for magnetic tapes? Random access Direct access Sequential access Step mode access Data retrieval methods for tape media47 / 70Which of the following sequence is used to set a default printer in Windows11? Go to Bluetooth & devices > Printers & scanners > select a printer. Then select Set as default. Go to My Network Places > Printers & scanners > select a printer. Then select Set as default. Go to Desktop> Printers & scanners > select a printer. Then select Set as default. Go to Downloads > Printers & scanners > select a printer. Then select Set as default. Windows 11 peripheral management48 / 70Which of the following options is used to customise the look and feel of the desktop in Windows 10? Personalise Refresh View Customise Windows desktop customization49 / 70When you put your computer into hibernation: everything on the computer is saved on the hard disk everything on the computer is saved on Random Access Memory everything on the computer is saved on a compact disk everything on the computer is saved on a digital versatile disk How OS handles RAM data during hibernation50 / 70Which of the following is an unexpected problem with software or hardware? Bug Patch Update Configuration Terminology for system errors/defects51 / 70Which of the following is an HTTP web server? Apache Perl Fedora Lucene Recognizing server software52 / 70A/An' ________ 'refers to an electronic device that allows an individual to make electronic commerce transactions. digital wallet offline wallet mobile card data wallet Digital payment terminology53 / 70What type of application will assist you in locating specific information on the Internet? Search engine Domain Name System Index page Social media Web navigation tools54 / 70In MS-Word, dividing a document into pages and numbering them is called Formatting Orientation Styling Pagination Document layout terminology55 / 70Which of the following is not an operating system for smartphones? Symbian Fedora iOS Android Distinguishing mobile OS from desktop/server OS56 / 70In MS-Word 2019, portrait means the page is oriented horizontally vertically diagonally upside down Page layout and orientation57 / 70Which of the following keyboard shortcuts is used to quickly apply the default date format in MS-Excel 2019? Ctrl + Shift + ^ Ctrl + Shift + % Ctrl + Shift + # Ctrl + Shift + @ Number formatting shortcuts58 / 70Some parts of a web page are associated with links to other pages in the form of a piece of text, icon, image, and so on associated with another page is called a browser URL hyperlink cookies Web navigation elements59 / 70Which of the following is NOT an example of a web browser? MS Office Google Chrome Microsoft Edge Opera Identifying web client applications60 / 70Which of the following is the correct sequence of steps to hide only the third row of an MS-Excel 2019 worksheet? Select rows 2 and 3 -> Right click -> hide Select rows 2, 3, and 4 -> Right click -> hide Select rows 3, and 4 -> Right click -> hide Select rows 3 -> Right click -> hide Row manipulation sequences61 / 70Deepak is a Grade V student. He wants to prepare a chart... Which of the following charts/graphs in MS-Excel 2019 should he use to visualise the trend of population growth in all four cities? Pie chart Cone chart Line chart Surface chart Chart selection for trend visualization62 / 70Suraj wants to save a new workbook in MS-Excel 2019. Which of the following keyboard shortcuts should he use? CTRL + I CTRL + B CTRL + S CTRL + V Basic file operation shortcuts63 / 70In MS-Excel 2019, given picture is an example of a Pie chart Bar chart Line graph Cone chart Visual chart identification (requires image)64 / 70Select the option that is true regarding the following two statements labelled Assertion (A) and Reason (R). (A): Indian President is the head of the State. (R): Indian Parliament consists of President, Lok Sabha and Rajya Sabha. Both A and R are true and R is the correct explanation of A. Both A and R are true but R is not the correct explanation of A. A is true but R is false. A is false but R is true. Both statements are true, but R does not explain A65 / 70Select the option which satisfies the same conditions of placement of the dot as in figure shown here. Option 1 Option 2 Option 3 Option 4 Visual dot placement logic (requires image)66 / 70Which the following groups of items contain only biodegradable items? Wood, grass, plastic Wood, grass, leather Fruit peels, lime juice, pen drive Lime juice, grass, polystyrene cup Differentiating biodegradable materials67 / 70Who was the partner of Leander Paes when he won the 'mixed doubles' at the US Open in the year 2008? Ana Ivanovic Cara Black Dinara Safina Jelena Jankovic Historic tennis tournament winners68 / 70With which of the following was Satyajit Ray associated? Commercial art Classical music Classical dance Direction of films Famous Indian historical figures69 / 70Which of the following political theories advocates the withering away of the state? Capitalism Fascism Marxism Democratic Socialism Core concepts of political ideologies70 / 70The outer electronic configuration of copper is: $3d^{9}4s^{2}$ $3d^{10}4s^{1}$ $3d^{10}4s^{0}$ $3d^{10}4s^{2}$ Exceptional electron configurations of transition metalsYour score is 0%