Search Previous Year Questions

The correct answer is Z20.

Key Points

• MS Excel is in tabular format consisting of rows and columns.
• Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns. Row runs horizontally while Column runs vertically.
• Each row is identified by row number, which runs vertically at the left side of the sheet.
• Each column is identified by column header, which runs horizontally at the top of the sheet.

Additional Information

• ​Early Microsoft employee Charles Simonyi is the man behind some of the company's most successful software, including Word and Excel
• Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data.

The correct answer is option 2,

Key Points

• The 'Sections' feature in MS PowerPoint enables users to organize large presentations into manageable and logical groupings.
• It helps in streamlining navigation during both the editing and presentation phases by dividing the slides into distinct sections.
• Sections allow users to focus on specific parts of the presentation without being overwhelmed by the entire slide deck.
• This feature is particularly useful when dealing with complex or multi-topic presentations, ensuring better structure and clarity.
• Users can rename, collapse, or expand sections for easier navigation, enhancing productivity in managing large presentations.

Additional Information

• Slide Organization in PowerPoint
• PowerPoint includes features like 'Sections,' 'Slide Sorter View,' and 'Outline View' to help users manage and organize content efficiently.
• 'Slide Sorter View' provides a thumbnail view of all slides, enabling easier rearrangement.
• 'Outline View' focuses on text content, offering a structured view of the presentation.
• Benefits of Using Sections
• Enhances collaboration when working on different parts of the presentation.
• Improves workflow by allowing users to concentrate on specific sections.
• Reduces clutter and simplifies navigation in presentations with numerous slides.
• Other Navigation Features in PowerPoint
• Slide Master: Helps maintain consistent design across slides.
• Hyperlinks: Facilitates linking between slides or external resources.
• Slide Zoom: Enables focused navigation on specific slides during presentations.
• PowerPoint for Large Presentations
• For presentations with hundreds of slides, features like 'Sections' and 'Slide Sorter View' are essential for effective management.
• Grouping slides into sections ensures logical flow and improved audience engagement.

The correct answer is they allow users to type passwords securely.

Key Points

• Virtual keyboards or Online keyboards are commonly provided by Internet banking websites because they allow users to type passwords securely.
• Virtual Keyboard is an online application to enter password with the help of a mouse.
• A picture of a keyboard is displayed on a computer screen and the user points and clicks on the pictures of keys to enter text.
• The Virtual Keyboard is designed to protect password from malicious “Spyware” and “Trojan Programs”.
• It is more difficult for malware to monitor the display and mouse to obtain the data entered via the virtual keyboard,
• Virtual Keyboard provides additional security when typing confidential data such as user names, passwords and credit card numbers.

The correct answer is Impact printer

Key Points

• Dot-matrix printer  is a type of computer printing in which ink is applied to a surface and a low-resolution dot matrix is used for layout.
• It is also called an Impact printer.
• Dot-matrix printers employ a print head that goes back and forth or up and down on the page and prints by impact, striking an ink-soaked cloth ribbon on the paper, similar to a typewriter or line printer's print mechanism.
• Not only can a dot matrix printer create any patterns, but it can also print specified characters.
• Impact printer printers are noisy yet popular.
• There is no direct contact between the ink ribbon and the paper with non-impact printers.

The correct answer is option 3,

The correct answer is F2.

Key Points

• F2 is the default keyboard shortcut in MS PowerPoint 365 to start editing text inside a selected shape or text box.
• When a shape or text box is selected, pressing F2 directly activates the editing mode, allowing users to modify the text content.
• This shortcut is specifically designed for convenience and saves time compared to manually double-clicking on the shape or text box.
• F2 is widely recognized across different versions of PowerPoint, making it a universal shortcut for text editing.
• Using keyboard shortcuts like F2 significantly enhances productivity and workflow efficiency while working with presentations.

Additional Information

• Keyboard Shortcuts in MS PowerPoint:
• Ctrl + M: Adds a new slide to the presentation.
• Ctrl + D: Duplicates the selected slide.
• Alt + Shift + Up/Down Arrow: Moves slides up or down in the slide order.
• Ctrl + P: Activates the pen tool while presenting in slideshow mode.
• Ctrl + Z: Undoes the last action.
• Text Editing in PowerPoint:
• Text boxes and shapes are primary tools for adding content to slides.
• Double-clicking or using F2 allows users to quickly access the text-editing mode.
• Formatting options like font size, color, and alignment can be adjusted using the toolbar or ribbon.
• Keyboard shortcuts like Ctrl + B (bold) and Ctrl + I (italic) enhance text formatting efficiency.
• Productivity Benefits of Shortcuts:
• Keyboard shortcuts streamline workflows by reducing dependency on mouse navigation.
• They help users perform repetitive tasks faster, enhancing overall productivity.
• Memorizing key shortcuts can significantly improve presentation creation time.
• PowerPoint Versions:
• MS PowerPoint 365 is the latest subscription-based version, offering regular updates and cloud-based features.
• Older versions like PowerPoint 2016 and PowerPoint 2019 support many of the same shortcuts.
• Shortcuts remain consistent across versions, ensuring ease of use for long-time users.

The correct answer is:

option 1) Routers

Key Points

• Routers are used to connect networks that use similar protocols (e.g., connecting two IP-based networks). They operate at the network layer (Layer 3) of the OSI model and forward data based on IP addresses.
• Switches (Option 2) operate at the data link layer (Layer 2) and are used to connect devices within the same network (not different networks).
• Gateways (Option 3) are used to connect networks with different protocols (e.g., translating between TCP/IP and legacy systems).
• Dial-up routers (Option 4) are a specific type of router used for modem-based connections, not general network interconnections.

Important Points

• Routers are the primary devices for interconnecting similar protocol networks (e.g., linking two LANs or a LAN to a WAN).
• They manage traffic between networks by routing packets based on IP addresses.
• Switches handle local traffic, while gateways deal with protocol conversion.

Thus, the correct answer is Router

The correct answer is DVD ROM.

Key Points

• DVD ROM is not an example of solid-state storage device.
• DVD ROMs use an optical system (laser technology) to read and write data, not solid-state electronics. The other options listed (Memory Card, USB Flash Drives) are indeed examples of solid-state storage devices.
• Solid-state storage devices are the type of computer storage devices that store data electronically.
• It has no moving parts (no reels of tape, no spinning discs, no laser beams, etc.).
• The solid storage devices are made from silicon microchips.

Additional Information

• Some of the following types of solid-state storage devices-
• Flash memory
• USB Flash Drives
• Memory stick
• Memory cards
• Smart cards
• Multimedia card
• DVD is a digital optical disc data storage format that was invented and developed in 1995 and published in late 1996.
• The medium can store any kind of digital data and has been commonly used for software and other computer files as well as video programs that have been viewed on DVD players.
• DVDs provide a higher storage capacity than compact discs of the same dimensions.

The correct answer is Shift + F11.

Key Points

Shift + F11 in Microsoft Excel 2016 should you use to insert a new worksheet for Windows 10 operating system.

• F11 Creates a chart of the data in the current range.
• SHFT+F11 inserts a new worksheet.
• ALT+F11 opens the Microsoft Visual Basic Editor, in which macro can be created.

Additional Information 

• F3 Displays the Paste Name dialog box.
• SHFT+F3 displays the Insert Function dialog box.
• F7 Displays the Spelling dialog box to check to spell in the active worksheet or selected range.
• CTRL+F7 performs the Move command on the workbook window when it is not maximized.
• F5 Displays the Go To dialog box.
• CTRL F5 restores the window size of the selected workbook window in Microsoft Excel.

Compiler: Computer software that translates source code written in a high-level language into a set of machine-language instructions that can be understood by a digital computer’s CPU.

• It scans the entire program and translates the whole of it into machine code at once.
• A Compiler always generates an intermediary object code.
• It will need further linking. Hence more memory is needed.
• Source code → Compiler → Machine code → Output
• Compilers are very large programs, with error-checking and other abilities.
• The compiler can diagnose grammatical errors only

The correct answer is PING.

Key Points

• PING
• ​It sends packets of data to a specific IP address on a network.
• It is a simple way to test the response of an internet connection.
• It is a Command Prompt command used to test the ability of the source computer to reach a specified destination computer.

Additional Information

• TELNET
• ​It is a network protocol used to virtually access a computer and to provide a two-way, collaborative and text-based communication channel between two machines.
• It follows a user command Transmission Control Protocol/Internet Protocol (TCP/IP) networking protocol for creating remote sessions.
• URL
• ​It stands for Uniform Resource Locator.
• It is a unique identifier used to locate a resource on the Internet.
• MSCONFIG
• ​It is a system utility to troubleshoot the Microsoft Windows startup process.
• It allows us to manage startup selection, Safe Boot, enable or disable Windows Services, find & launch system tools like Performance Monitor, Resource Monitor.