Search Previous Year Questions

The correct answer is - Print

Key Points

• Print Command
• The Print command is located within the File menu (also known as the Backstage view) and is used to generate a hard copy of a document.
• It allows users to select a printer, specify the number of copies, and choose specific page ranges.
• In MS Word, the keyboard shortcut Ctrl + P serves as a quick way to access the Print settings.
• Before printing, Word displays a Print Preview, which shows exactly how the document will appear on paper.

Additional Information

• Save
• This command is used to store the document digitally on a storage device like a hard drive or cloud storage.
• It ensures that any edits or changes made to the soft copy are preserved for future use.
• Close
• The Close command exits the active document window without closing the entire Microsoft Word application.
• It helps in clearing the workspace when a specific task is finished.
• Options
• The Options menu provides access to advanced settings such as Proofing, Display, and Language preferences.
• It allows for the customization of the Word interface, including the Ribbon and Quick Access Toolbar.
• Hard Copy vs. Soft Copy
• A Hard Copy refers to a physical printout of a document on paper.
• A Soft Copy refers to the digital version of a file viewed on a computer monitor or electronic screen.

The correct answer is - Font availability affects how text is rendered and substituted

Key Points

• Font Substitution
• If a specific font used in a document is not installed on the system, Microsoft Word automatically selects a replacement font that is available.
• This process, known as font substitution, can lead to variations in how the text appears, as the replacement font may have different visual characteristics.
• Font Metrics and Spacing
• Every font has unique font metrics, including character width, height, and spacing (kerning).
• Even if a substituted font looks similar, its physical dimensions often differ, causing text reflow where lines break at different points, altering the overall layout.
• Text Rendering Engines
• The way a device's operating system handles text rendering and anti-aliasing can vary, affecting the crispness and exact positioning of characters.

Additional Information

• Embedding Fonts
• To maintain layout consistency, Word allows users to embed fonts directly into the document file.
• This ensures that the original fonts travel with the file, preventing the need for font substitution on other devices.
• PDF (Portable Document Format)
• Exporting a document as a PDF is the standard method to "freeze" the layout, as it preserves fonts and formatting as a fixed graphic representation.
• Standard Fonts
• Using standard system fonts (like Arial, Calibri, or Times New Roman) minimizes compatibility issues because these are pre-installed on most operating systems.
• TrueType and OpenType
• These are the common formats for scalable fonts; while highly compatible, variations in versions between different OS updates can still cause minor rendering shifts.

The correct answer is - HTTPS includes encryption for secure communication while HTTP does not

Key Points

• HTTPS (Hypertext Transfer Protocol Secure)
• HTTPS is the secure version of HTTP, which is the primary protocol used to send data between a web browser and a website.
• The "S" at the end of HTTPS stands for Secure, indicating that all communications between the browser and the website are encrypted.
• It uses encryption protocols to secure communications, specifically Transport Layer Security (TLS) or formerly, Secure Sockets Layer (SSL).
• Unlike HTTP, which sends data as plain text, HTTPS ensures that sensitive information like passwords or credit card numbers cannot be easily intercepted by hackers.

Additional Information

• Port Numbers
• HTTP typically uses Port 80 for communication.
• HTTPS uses Port 443 by default to establish a secure connection.
• SSL/TLS Certificates
• To use HTTPS, a website must obtain an SSL/TLS Certificate from a trusted Certificate Authority (CA).
• These certificates provide authentication, proving to the user that the website they are visiting is legitimate and not a fraudulent site.
• Data Integrity
• HTTPS provides data integrity, meaning that the data cannot be modified or corrupted during transfer without being detected.
• This prevents man-in-the-middle attacks where a third party tries to alter the information being sent.

The correct answer is - To automatically discover and index new and updated pages across the Web

Key Points

• Web Crawlers
• Also known as spiders or bots, these are automated software programs that systematically browse the World Wide Web.
• Their primary function is to discover new content, which includes web pages, images, videos, and PDF documents.
• They follow hyperlinks from one page to another to build a map of the internet's structure.
• The data gathered is sent back to the search engine's index, a massive database that stores information for search results.
• Crawlers ensure search accuracy by identifying updates to existing pages and removing dead links from the database.

Additional Information

• The Indexing Process
• After crawling, the search engine processes the page content to understand its keywords and relevance.
• The Search Index acts like the index at the back of a book, allowing the engine to retrieve results in milliseconds.
• Robots.txt
• This is a text file used by website owners to provide instructions to web crawlers.
• It specifies which parts of a website should be disallowed or excluded from the crawling process to protect private data or save server bandwidth.
• Crawl Budget
• Search engines allocate a specific crawl budget to every website, determining how many pages a bot will crawl within a certain timeframe.
• Factors like site speed and content quality influence how often a crawler visits a specific domain.

The correct answer is - Logging out of the email account and closing the browser after use

Key Points

• Session Termination
• Logging out ensures that the session token stored in the browser is invalidated, preventing any subsequent user from accessing the account without credentials.
• On a shared computer, failing to log out leaves the active session open, making the account vulnerable to unauthorized access.
• Closing the browser after logging out provides an additional layer of security by clearing temporary session data.

Additional Information

• Incognito or Private Browsing
• Using Incognito Mode prevents the browser from saving browsing history, cookies, or site data locally on the machine.
• Even when using private modes, it is still necessary to log out manually to ensure the server-side session is closed.
• "Remember Me" Feature
• The "Remember me" option saves login credentials in the browser's cache or cookies.
• On public or shared devices, this feature should never be used as it allows others to log in automatically.
• Multi-Factor Authentication (MFA)
• Two-Factor Authentication (2FA) adds security by requiring a second form of identification (like an OTP) beyond just the password.
• It is highly effective in preventing access even if a password is compromised or a user forgets to log out.
• Password Security
• Writing down a password on a physical note near a computer is a major security risk known as "visual hacking."
• Passwords should be complex and managed through secure digital password managers rather than physical notes.

The correct answer is - Choose a file name and storage location for the workbook

Key Points

• Save As Command
• When saving a workbook for the first time, the Save As dialog box automatically appears to prompt the user for initial file details.
• It allows the user to specify a unique file name, which helps in identifying the document later.
• The command enables the selection of a specific storage location, such as a local hard drive, a USB flash drive, or cloud storage like OneDrive.
• It also provides the option to choose the file format or extension (e.g., .xlsx, .csv, or .pdf) based on the user's requirements.

Additional Information

• Difference between Save and Save As
• Save: Updates the current file with the latest changes without prompting for a name or location if the file has already been saved.
• Save As: Used to create a duplicate or a new version of an existing file under a different name or in a different format.
• Keyboard Shortcuts
• The standard keyboard shortcut for the Save command is Ctrl + S.
• In Microsoft Excel, the F12 key functions as a direct shortcut to open the Save As dialog box.
• File Extensions
• The default file extension for Excel workbooks since the 2007 version is .xlsx.
• Workbooks that contain Macros must be saved with the .xlsm extension to maintain functionality.

The correct answer is - It becomes harder to identify the content later

Key Points

• Identification and Retrieval
• Renaming a file with a non-descriptive name like "abc.xlsx" makes it difficult to recognize the subject matter or purpose of the worksheet without opening it.
• Descriptive filenames act as a primary metadata identifier that helps in locating specific information quickly within a file system.
• In professional settings, clear naming is a fundamental part of data management to ensure consistency and ease of access.
• Workflow Efficiency
• Poor naming conventions lead to reduced productivity as users waste time searching through multiple generic files to find the correct data.
• Using specific names improves collaborative efficiency, allowing other users to understand the file's content immediately.

Additional Information

• Excel File Integrity
• Renaming the prefix of a file (the name before the dot) does not affect the internal data, formulas, or cell formatting.
• The file remains functional and can be opened by Microsoft Excel as long as the file extension (e.g., .xlsx, .xls, .csv) remains unchanged and compatible.
• Best Practices for File Naming
• Experts recommend including dates, version numbers, and keywords in the filename to maintain organization.
• Avoiding special characters and using underscores or CamelCase can help maintain compatibility across different operating systems.
• File Extensions
• The .xlsx extension is the default format for Microsoft Excel 2007 and later versions, based on the Office Open XML standard.
• Renaming the extension itself (e.g., changing .xlsx to .txt) may cause the file to become unreadable by the application, but renaming the name "abc" does not.

The correct answer is - Right click column C and choose Insert; the new column appears to the left of column C

Key Points

• Column Insertion Logic
• In Microsoft Excel, when a user inserts a new column, the application is designed to place it specifically to the left of the currently selected column.
• To create a gap between existing columns B and C, the user must target Column C as the reference point for the insertion.
• The process involves interacting with the column header, which is the lettered area at the top of the worksheet.
• Once Insert is selected from the right-click context menu, the data previously in column C (and all columns to its right) shifts one position to the right.

Additional Information

• Keyboard Shortcuts
• A faster way to perform this action is by selecting the column and pressing the Ctrl + Plus (+) key combination on the keyboard.
• This shortcut bypasses the need for the right-click context menu.
• Ribbon Interface Method
• Users can also navigate to the Home tab on the Excel ribbon.
• Under the Cells group, clicking the arrow next to Insert and choosing Insert Sheet Columns achieves the same result.
• Inserting Multiple Columns
• If a user highlights multiple columns (e.g., C, D, and E) and selects insert, Excel will add the equivalent number of blank columns to the left of the selection.
• Row Insertion Contrast
• While columns insert to the left, rows in Excel are always inserted above the selected row.

The correct answer is - Use Save As to create a separate experimental copy

Key Points

• Save As
• The Save As command allows a user to create a duplicate file with a different name or file path.
• By using this function, the master document remains in its original state, ensuring that experimental formatting does not permanently alter the source content.
• It facilitates version control, allowing users to keep multiple iterations of the same project for comparison.
• This is the most effective way to maintain data integrity when testing complex features like styles, macros, or layout changes.

Additional Information

• Save vs. Save As
• The Save command (shortcut Ctrl + S) updates the current file by overwriting the previous version with new changes.
• The Save As command (shortcut F12 in Windows) opens a dialog box to define a new filename or file format (e.g., .docx to .pdf).
• AutoSave and Version History
• In modern MS Word versions (Office 365), AutoSave continuously saves changes to the cloud; if not careful, this can overwrite the master document automatically.
• Version History allows users to view and restore previous versions of a document stored on OneDrive or SharePoint.
• Templates
• To avoid modifying a master layout, users can save a document as a Word Template (.dotx), which opens as a new, unsaved document every time it is used.

The correct answer is Names make formulas more readable.

Key Points

• Using meaningful names for cells or ranges improves the readability of formulas.
• Named ranges make formulas easier to understand compared to cell references like A1, B2, etc.
• For example:
• =SUM(B2:B10) is less descriptive.
• =SUM(Sales) is much clearer.
• This makes formulas easier to create, review, and maintain.

Additional Information

• Advantages of Named Ranges:
• Improve formula readability and understanding.
• Reduce errors in complex formulas.
• Make debugging and auditing easier.
• Help in managing large worksheets efficiently.
• Why Other Options Are Incorrect:
• Option 1: Names do not affect workbook opening on devices.
• Option 2: Names do not convert formulas into text.
• Option 4: Named ranges do not hide the formula bar.
• Important Points:
• Named ranges improve clarity and usability.
• They are especially useful in financial models and large spreadsheets.