Computer Knowledge PYQs

The correct answer is 'Real Time Gross Settlement'

Key Points

• Real Time Gross Settlement (RTGS):
• RTGS is a continuous process of settling payments on an individual order-by-order basis without netting debits with credits across the books of a central bank.
• Real Time: This implies that the processing of instructions happens at the same time they are received rather than at a later time or in batches.
• Gross Settlement: This means the settlement of funds transfer instructions occurs individually. Since the settlement takes place in the books of the central bank (such as the Reserve Bank of India), the payments are final and irrevocable.
• RTGS is primarily used for high-value transactions that require immediate clearing and settlement to ensure financial stability and reduce systemic risk.
• It is a safe and secure system for funds transfer, as it is managed and operated by the country's central banking authority.

Additional Information

• Rapid Transfer of Government Savings:
• This is an incorrect term and does not represent any standard financial or banking protocol. While governments do have systems for managing savings and transfers, they do not operate under this specific acronym or nomenclature.
• Regular Transaction Gateway System:
• This is a fictional term. While "Payment Gateways" exist to facilitate online transactions between merchants and customers, they are distinct from the "Settlement Systems" like RTGS that handle the actual movement of money between banks.
• Real Time General Service:
• This is an incorrect expansion of the acronym. While RTGS provides a service in real-time, the word "General" does not capture the "Gross Settlement" nature of the transaction, which is the defining technical characteristic of the system.

Important Points

• In India, the RTGS system is managed by the Reserve Bank of India (RBI).
• The minimum amount to be remitted through RTGS is ₹2,00,000, with no upper ceiling for maximum transactions.
• Unlike NEFT (National Electronic Funds Transfer), which settles transactions in half-hourly batches, RTGS settles transactions individually and instantly throughout the day.
• With effect from December 2020, the RTGS system has been made available 24/7/365 in India, making it one of the few countries globally to operate such a system round the clock.
• RTGS transactions use the IFSC (Indian Financial System Code) to identify the specific bank branch where the beneficiary holds an account.

The correct answer is Dogpile

Key Points

• A meta-search engine is an information retrieval tool that does not maintain its own database or web crawler. Instead, it sends a user's query to multiple primary search engines and aggregates the results into a single, unified list.
• Dogpile is a classic example of a meta-search engine. It functions by fetching and combining results from major engines like Google, Yahoo, and Bing to provide a more comprehensive set of links than any single engine might provide alone.
• Google and Bing are categorized as primary search engines because they use their own proprietary algorithms and crawlers (such as Googlebot) to index the web and build their own searchable databases.
• Yahoo currently functions as a web portal and search engine that primarily relies on Bing for its search results, but it is not considered a meta-search engine in the same category as Dogpile.

Additional Information

• Other notable examples of meta-search engines include MetaCrawler, Excite, Mama, and SurfWax.
• The main advantage of a meta-search engine is efficiency; it allows users to see a broader range of results from different sources simultaneously without having to visit each search engine individually.
• Meta-search engines are particularly effective for obscure queries or when a user wants to compare how different algorithms rank the same information.
• Some modern privacy-focused tools like DuckDuckGo also utilize meta-search techniques by pulling data from hundreds of individual sources to supplement their own results.

The correct answer is A grid-based program used to organize, calculate and analyze data in rows and columns

Key Points

• MS Excel is a spreadsheet application developed by Microsoft that is part of the MS Office suite.
• The fundamental purpose of a spreadsheet is to provide a grid-based environment where data can be systematically organized into rows and columns.
• Each individual box in this grid is called a Cell, which is the intersection of a row and a column.
• Excel allows users to perform mathematical calculations, statistical analysis, and data visualization using various formulas and functions.
• The other options are incorrect because drawing is the primary function of graphics software like MS Paint, sending emails is the function of email clients like MS Outlook, and playing media is the function of media players like VLC.

Additional Information

• An Excel file is technically called a Workbook, and it can contain multiple Worksheets (tabs).
• In a worksheet, Rows are identified by numbers (1, 2, 3...) and Columns are identified by letters (A, B, C...).
• The Cell Address is a combination of the column letter and row number (e.g., A1, C10).
• Modern versions of Excel support up to 1,048,576 rows and 16,384 columns per worksheet.
• Key features of Excel include Pivot Tables, VLOOKUP, Data Validation, and Macros for automation.

The correct answer is To send and receive messages

Key Points

• Electronic mail, commonly known as email, is a method of exchanging digital messages between people using electronic devices such as computers, smartphones, and tablets.
• The primary purpose of email is to facilitate communication by allowing users to send and receive messages over the internet or a local area network.
• Option 2 is incorrect because internet browsing is the primary function of web browsers like Google Chrome, Mozilla Firefox, or Microsoft Edge.
• Option 3 is incorrect because while emails can be archived, permanent data storage is the primary function of hard drives, cloud storage services, and databases.
• Option 4 is incorrect because social media usage refers to platforms like Facebook, Instagram, or LinkedIn, which are distinct from the direct messaging architecture of email.

Additional Information

• The first email was sent by Ray Tomlinson in 1971. He is also responsible for introducing the @ symbol to separate the user name from the destination server.
• Email operates based on specific protocols: SMTP (Simple Mail Transfer Protocol) is used for sending emails, while POP3 (Post Office Protocol) or IMAP (Internet Message Access Protocol) are used for receiving and managing emails.
• Modern email services often include spam filters to block unsolicited messages and encryption to ensure the privacy and security of the communication.
• An email address typically consists of three parts: the username, the @ symbol, and the domain name (e.g., user@example.com).

The correct answer is Only (ii), (iii) or (iv)

Key Points

• An email address is fundamentally composed of two segments separated by the @ (at) symbol.
• The Username (also known as the local-part) is the portion that appears before the @ symbol. It identifies the specific user or mailbox on a server. Because it is the first part, it cannot be the last part.
• The Domain Name is the portion that appears after the @ symbol. This constitutes the last part of the email address.
• The domain name can represent various entities: it can be a Company domain name (used by businesses for their employees, e.g., employee@microsoft.com), a Website name (often used for official site communications, e.g., info@testbook.com), or an Email service provider name (like Gmail, Outlook, or Yahoo, e.g., user@gmail.com).
• Therefore, while (ii) Company domain name, (iii) Website name, and (iv) Email service provider name all describe valid forms of the domain portion (the last part), the Username (i) is strictly the first part.

Additional Information

• The Domain Name System (DNS) is responsible for translating the domain part of the email address into an IP address so that the Simple Mail Transfer Protocol (SMTP) can deliver the message to the correct server.
• Email addresses are governed by RFC 5322 standards, which define the syntax and length requirements.
• A Top-Level Domain (TLD) such as .com, .org, .in, or .edu is a mandatory component of the domain name section located at the very end of the address.
• The @ symbol was first chosen for email by Ray Tomlinson in 1971 to distinguish between the user and the host machine.
• The maximum length of an email address is generally 254 characters, while the local-part (username) is limited to 64 characters.

The correct answer is Thumbnails (Thumbnails)

Key Points

• Thumbnails are reduced-size versions of pictures or videos, used to help in recognizing and organizing them, serving the same role for images as a normal text index does for words.
• In Microsoft Word 2016, thumbnails allow users to see a miniature representation of each page or image in the document, making it significantly easier to navigate through long files or visual assets.
• Thumb drives are incorrect because they are physical USB flash memory storage devices used for data transfer and storage, not for image scaling within a document.
• Thumb documents is not a standard technical term used in Microsoft Office or computer science.
• A Preview pane is a user interface element in Windows File Explorer or email clients that allows you to see the contents of a file without opening it, but it is not the term for the reduced-size image itself.

Additional Information

• To view page thumbnails in Word 2016, a user can navigate to the View tab on the Ribbon and check the box for Navigation Pane. Within the pane, the Pages tab displays the thumbnails.
• The term Thumbnail was adopted because these small images are roughly the size of a human thumbnail.
• In web design, thumbnails are essential for improving page load speed, as the browser does not need to download the full-resolution image until the user clicks on the smaller version.
• Microsoft Word also uses thumbnails in the Insert Picture dialog box to help users identify which file they want to import into their document.

The correct answer is Pie chart

Key Points

• A Pie chart is a circular statistical graphic divided into slices to illustrate numerical proportion. In a pie chart, the arc length of each slice is proportional to the quantity it represents, making it the ideal tool for showing how a whole is divided into various parts or categories.
• Line charts are primarily used to display trends over time or continuous data points. They are not designed to show the relative proportions of a total dataset at a single point in time.
• Column charts (or Bar charts) are best suited for comparing values across different categories or showing changes over a period of time. While they can show relative sizes, they do not emphasize the part-to-whole relationship as effectively as a pie chart.
• Scatter charts (or XY plots) are used to observe and show relationships or correlations between two different numeric variables. They do not represent categorical proportions.

Additional Information

• For a Pie chart to be effective, the sum of all categories must equal 100%.
• It is generally recommended to use pie charts only when there are a small number of categories (typically 6 or fewer) to maintain readability.
• A Donut chart is a variation of the pie chart with a blank center, which can sometimes be used to improve readability or include additional information in the center.
• When comparing multiple datasets that each have their own proportions, a Stacked Bar Chart is often a better alternative than multiple pie charts.

The correct answer is Both a and b

Key Points

• AutoFit is a feature in Microsoft Excel that automatically adjusts the width of a column or the height of a row to accommodate the largest value in that selection.
• Method A: One of the fastest ways to AutoFit a column is to hover the mouse pointer over the right boundary of the column header (the lettered area at the top) until the pointer turns into a double-headed arrow, then double-click.
• Method B: Users can also select the column, right-click the header, and access formatting options. While the standard right-click menu often emphasizes Column Width (for manual entry), the AutoFit logic is integrated into the column management interface, making both methods standard practices for content-based adjustment.
• Option (3) is typically used for entering a specific numerical value for the width rather than automatically fitting the content, although the AutoFit Column Width command is located under the Format button in the Cells group of the Home tab.

Additional Information

• The keyboard shortcut to AutoFit column width in Excel is Alt + H + O + I.
• To AutoFit multiple columns at once, select the desired columns (or the entire worksheet by pressing Ctrl + A) and then double-click the boundary of any one of the selected column headers.
• If a cell displays #####, it usually means the column is too narrow to display the numeric content or date, and using AutoFit will resolve this issue.
• Wrap Text is a related feature that keeps the column width fixed but increases the row height to display all text on multiple lines within the cell.

The correct answer is Insert > Drop Cap

Key Points

• In Microsoft Word, a Drop Cap is a large capital letter used as a decorative element at the beginning of a paragraph or section.
• To insert a drop cap, you must navigate to the Insert tab on the Ribbon. Within the Text group, you will find the Drop Cap command.
• The Home tab (Option 2) is primarily used for Font and Paragraph formatting, such as bolding, alignment, and Styles, but it does not contain the Drop Cap tool.
• The Format menu (Option 3) was part of the legacy Menu Bar interface found in Word 2003 and earlier versions. In modern versions of Word (2007 onwards), these functions are organized into Ribbon tabs.
• The keyboard shortcut Ctrl + Shift + D (Option 4) is used to apply double underlining to the selected text, not to create a drop cap.

Additional Information

• When applying a Drop Cap, users can choose between two main styles: Dropped (the letter is within the paragraph) and In margin (the letter is placed in the left margin).
• By default, a drop cap spans three lines of text, but this can be customized to span more or fewer lines using the Drop Cap Options dialog box.
• The Drop Cap Options also allow users to change the Font of the dropped letter and adjust the Distance from text.
• This feature is commonly used in newsletters, magazines, and novels to provide a professional and visually appealing start to a chapter or article.

The correct answer is LARGE + UNIQUE

Key Points

• To extract the nth largest unique value, a combination of functions is required to first handle the duplication and then identify the specific rank.
• The UNIQUE function is used to return a list of distinct values from a specified range, effectively removing all duplicates. For example, if a list is [10, 10, 9, 8], UNIQUE will return [10, 9, 8].
• The LARGE function is used to return the k-th largest value in a data set. Its syntax is LARGE(array, k), where k is the position from the largest value.
• By combining them as LARGE(UNIQUE(range), n), the spreadsheet first generates a list of unique numbers and then selects the nth largest value from that specific list.
• MAX + FILTER is incorrect because MAX only returns the single highest value (the 1^st largest) and does not support finding the 2^nd or 3^rd largest value without complex nesting.
• SORT + MIN is incorrect because MIN identifies the smallest value in a range, which is the opposite of finding the largest.
• UNIQUE + MIN is incorrect because it would only allow you to find the absolute smallest unique value, not the nth largest.

Additional Information

• The UNIQUE function is a Dynamic Array function available in Microsoft Excel 365, Excel 2021, and Google Sheets.
• If you use the LARGE function on a range that contains duplicates without using UNIQUE, the function will count each duplicate as a separate rank. For instance, in the set [10, 10, 9], LARGE(range, 2) would return 10, whereas LARGE(UNIQUE(range), 2) would return 9.
• The SMALL function is the mathematical opposite of LARGE and is used to find the nth smallest value in a data set.
• In older versions of Excel that do not support the UNIQUE function, extracting the nth largest unique value typically requires complex Array Formulas involving FREQUENCY, MATCH, and ROW functions.

The correct answer is FTP

Key Points

• FTP, which stands for File Transfer Protocol, is the standard network protocol specifically designed for the transfer of computer files between a client and a server over a network.
• It is the primary protocol used to upload (load) or download (retrieve) files, allowing users to manage files on a remote system efficiently.
• HTTP (Hypertext Transfer Protocol) is primarily used for web communication and transferring hypertext (web pages), though it can be used for file downloads, it is not its specialized purpose like FTP.
• TCP/IP (Transmission Control Protocol/Internet Protocol) is the underlying suite of protocols that powers the internet; FTP operates as an application layer protocol on top of the TCP/IP stack.
• OSI (Open Systems Interconnection) is a conceptual reference model that standardizes the functions of a telecommunication or computing system into seven layers; it is not a protocol used for file retrieval.

Additional Information

• FTP uses two separate channels for communication: Port 21 is used for the Control Connection (commands and replies), and Port 20 is typically used for the Data Connection (actual file transfer).
• Because standard FTP transmits data in plain text (including usernames and passwords), secure versions like SFTP (SSH File Transfer Protocol) and FTPS (FTP over SSL/TLS) were developed to encrypt data.
• The Client-Server Model in FTP involves a user running an FTP client (like FileZilla) to connect to a remote FTP server where the files are stored.
• FTP supports both binary and ASCII transfer modes to ensure that different types of files (like images vs. text documents) are handled correctly during the transfer process.

The correct answer is em

Key Points

• The em unit is a relative length unit in CSS (Cascading Style Sheets). It is relative to the font-size of the parent element. If a parent element has a font size of 20px, then 1em in the child element is equal to 20px.
• rem (Root em) is relative to the font-size of the root element, which is the html tag. This makes it more predictable than em because it does not change based on nesting levels.
• vh (Viewport Height) is a unit representing 1% of the height of the viewport (the browser window size). It is used to make elements scale based on the screen height.
• vw (Viewport Width) is a unit representing 1% of the width of the viewport. It is commonly used for responsive typography and layout containers that need to fill the screen width.
• The core logic of the em unit is that it allows for scalable designs where the size of child elements maintains a proportional relationship with their containers.

Additional Information

• By default, most web browsers set the root font size to 16px. Therefore, 1rem or 1em (at the root level) usually defaults to 16 pixels unless specified otherwise by the developer.
• When em is used on the font-size property, it is relative to the parent. However, when used on other properties like padding or margin, it is relative to the font-size of the element itself.
• Using relative units instead of absolute units (like px or pt) is a fundamental practice in Responsive Web Design to ensure accessibility for users who resize their text for better visibility.
• The em unit was originally a concept in typography, representing the width of the capital letter M in a particular typeface.

The correct answer is It searches for specific text or values so the user can review or edit those cells

Key Points

• The Find feature is a fundamental tool in spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc used to quickly locate specific information within a large dataset.
• When a spreadsheet contains many entries, manually scrolling to find a specific data point is inefficient; the Find command automates this by scanning the entire worksheet or workbook for a match based on user input.
• The primary purpose of this feature is navigation and identification, allowing the user to jump directly to a cell to review its contents or perform an edit.
• Option 1 is incorrect because changing fonts is a Formatting function, which is handled through the Home tab or Format menu.
• Option 3 is incorrect because deleting cells based on criteria is usually handled by Filtering, Clear Contents, or Find and Replace (if replacing with nothing), whereas Find alone only locates data.
• Option 4 is incorrect because Sorting is a separate data management feature used to organize data in alphabetical, numerical, or chronological order.

Additional Information

• The standard keyboard shortcut to activate the Find feature is Ctrl + F on Windows and Command + F on macOS.
• The Find and Replace dialog box (often accessed via Ctrl + H) extends this functionality by allowing users to search for a value and automatically substitute it with a new value across the entire sheet.
• Advanced search options within the Find tool include Match Case (to distinguish between uppercase and lowercase letters) and Match entire cell contents (to find cells that contain only the specific search term).
• In Microsoft Excel, the Find feature can also be used to search for specific cell formatting, such as finding all cells that are highlighted in a specific color or have a specific border style.

The correct answer is They change the natural order so A1+A2 is done before multiplying by (B1-B2)

Key Points

• In spreadsheet applications like Microsoft Excel or Google Sheets, formulas follow a standard mathematical hierarchy known as Operator Precedence or BODMAS/PEMDAS.
• The natural order of operations dictates that Multiplication and Division are performed before Addition and Subtraction.
• Brackets (or Parentheses) have the highest priority in this hierarchy. They are used to group parts of a formula and force those calculations to happen first, regardless of the operators involved.
• In the formula =(A1+A2)*(B1-B2), the brackets ensure that the sum of A1 and A2 is calculated first, and the difference between B1 and B2 is calculated second.

Only after these two results are obtained does the multiplication occur.

• Without the brackets, the formula =A1+A2*B1-B2 would calculate A2*B1 first, then add A1 and subtract B2, which would result in a completely different numerical value.

Additional Information

• BODMAS stands for Brackets, Orders (Exponents/Roots), Division, Multiplication, Addition, and Subtraction.
• PEMDAS stands for Parentheses, Exponents, Multiplication, Division, Addition, and Subtraction.
• If a formula contains nested brackets (brackets inside brackets), the software evaluates the innermost set of brackets first.
• Using brackets is a best practice in complex spreadsheet modeling to ensure the logic of the calculation is clear and to prevent errors caused by the default order of operations.

The correct answer is .doc

Key Points

• .doc is the primary file extension used by Microsoft Word for documents created in versions 97 through 2003. It stands for Document.
• In newer versions of Microsoft Word (from Word 2007 onwards), the default extension was updated to .docx, which is based on the Office Open XML format.
• .xlm is an extension used for Microsoft Excel Macro files, specifically for legacy Excel 4.0 macros. It is not associated with word processing.
• .png stands for Portable Network Graphics. It is a popular raster graphics file format used for images and does not contain text document data.
• .txt is the extension for Plain Text files. These files contain only unformatted text and are typically opened with basic editors like Notepad or TextEdit, lacking the rich formatting features of MS Word.

Additional Information

• Microsoft Word is a component of the Microsoft Office productivity suite, first released in 1983.
• Other common extensions in the Microsoft Office ecosystem include .xls or .xlsx for Microsoft Excel and .ppt or .pptx for Microsoft PowerPoint.
• The .doc format stores information such as alignment, font styles, tables, and images within a single binary file.
• Modern Word applications can still open and edit .doc files using Compatibility Mode to ensure the layout remains consistent with older versions.

The correct answer is They impersonate reputable organisations and create a false sense of panic.

Key Points

• Phishing is a form of cyberattack where attackers masquerade as a trusted entity to deceive victims into revealing sensitive information such as usernames, passwords, and credit card details.
• The core logic of a phishing email is to use social engineering tactics. By impersonating reputable organisations (like banks, government agencies, or tech companies), attackers leverage the victim's trust.
• Creating a false sense of urgency or panic is a hallmark of these emails. Phrases like 'Your account will be deactivated' or 'Unauthorized login attempt detected' are used to pressure the user into clicking a malicious link or downloading an infected attachment without careful verification.
• Option 1 is incorrect because phishing emails usually provide fraudulent contact information or links to spoofed websites designed to capture data, rather than legitimate customer service numbers.
• Option 2 is incorrect because phishing relies on emotional triggers; calm and neutral language is less likely to provoke the immediate, impulsive action that attackers desire.
• Option 4 is incorrect because many phishing campaigns are sent in bulk and use generic greetings (e.g., 'Dear Valued Customer'). Furthermore, they frequently contain poor grammar and spelling errors, which serve as red flags for observant users.

Additional Information

• Spear Phishing: A more sophisticated and targeted version of phishing aimed at a specific individual, group, or organization, often using personal details to appear more convincing.
• Whaling: A type of phishing that specifically targets high-profile executives or senior leaders within a company.
• Vishing and Smishing: Phishing techniques carried out via voice calls (Vishing) or SMS/text messages (Smishing).
• Prevention: To defend against phishing, it is recommended to use Multi-Factor Authentication (MFA), verify the sender's email domain, and use email security filters that flag suspicious content.

The correct answer is Data Form

Key Points

• A Data Form in Microsoft Excel is a dialog box that displays one complete record (row) at a time, making it easier to view, enter, or change data in a large range or table.
• It provides specific buttons to add new records, edit current data, and delete existing rows without having to scroll horizontally across many columns.
• The Criteria button within the Data Form allows users to search for and display only those records that meet specific logical conditions or text matches.
• Data Structure refers to the conceptual organization and storage format of data (like arrays or linked lists) and is not a specific interactive feature for record management in Excel.
• Conditional Formatting is a tool used to apply visual styles (colors, icons, data bars) to cells based on the data they contain, but it does not provide a form interface for data entry or deletion.
• Cell Styles are predefined sets of formatting characteristics (such as font size, borders, and cell shading) used to quickly apply a consistent look to cells, rather than managing data records.

Additional Information

• The Form command is a hidden feature in modern Excel versions; users must manually add it to the Quick Access Toolbar or the Ribbon via Excel Options.
• A Data Form can handle a maximum of 32 fields (columns). If your dataset exceeds this limit, Excel will display an error message stating the data range is too complex.
• When using the Criteria function, you can use wildcard characters like the asterisk (*) to represent a series of characters or the question mark (?) to represent a single character.
• The Data Form automatically recognizes Column Headers and uses them as labels for each field in the dialog box.

The correct answer is Ctrl + Shift + Space

Key Points

• A non-breaking space is a special character that prevents an automatic line break at the position where it is inserted. In Microsoft Word, the keyboard shortcut to insert a non-breaking space is Ctrl + Shift + Space.
• This is used to keep two words or elements together on the same line, such as a title and a name (e.g., Mr. Smith), a date (e.g., October 12), or a value and its unit (e.g., 100 km).
• Ctrl + Space: This shortcut is used to Clear All Formatting from the selected text, resetting it to the default font and style of the document.
• Alt + Space: This shortcut opens the System Menu (Restore, Move, Size, Minimize, Maximize, Close) for the active window in the Windows operating system.
• Shift + Space: In Microsoft Word, this usually functions as a standard space, but in Microsoft Excel, it is used to select the entire row.

Additional Information

• To visualize non-breaking spaces in a document, you can enable Formatting Marks by clicking the Show/Hide (¶) icon on the Home tab. A non-breaking space appears as a small degree symbol (°), whereas a regular space appears as a small dot.
• Similarly, a non-breaking hyphen can be inserted using Ctrl + Shift + Hyphen (-) to prevent words connected by a hyphen from being split across two lines.
• These formatting tools are essential for professional document layout and desktop publishing to ensure text remains readable and logically grouped.

The correct answer is Cell Protection

Key Points

• To prevent users from modifying, moving, or deleting data within a specific cell or worksheet in Microsoft Excel, the Cell Protection feature is utilized.
• The process involves two primary steps: First, ensuring the Locked property is enabled for the specific cells (found under Format Cells > Protection), and second, activating the Protect Sheet command located in the Review tab.
• By default, all cells in an Excel worksheet are Locked, but this lock remains inactive until the Protect Sheet feature is turned on.
• Data Validation is used to control the type of data or the values that users enter into a cell (such as dropdown menus or date ranges), but it does not stop a user from deleting the cell content or changing the cell entirely if they have edit permissions.
• Format Cells is the menu where protection settings are configured, but it is not the functional tool that enforces the protection itself.
• Conditional Formatting is a tool used to change the visual appearance (color, font, etc.) of cells based on specific criteria and does not provide security or editing restrictions.

Additional Information

• Protect Workbook: This feature is used to protect the structure of the workbook, preventing users from adding, deleting, hiding, or renaming worksheets.
• Passwords: Excel allows users to set an optional password when protecting a sheet to ensure that only authorized individuals can disable the protection.
• Permissions: When enabling Protect Sheet, Excel provides a list of checkboxes allowing the author to grant specific permissions to users, such as the ability to Select locked cells, Format columns, or Use AutoFilter.
• The keyboard shortcut to open the Format Cells dialog box is Ctrl + 1.

The correct answer is To create reusable content

Key Points

• The Building Blocks feature in Microsoft Word is specifically designed to allow users to create, store, and reuse content such as text, graphics, and formatting.
• This feature helps in maintaining consistency across documents and saves time by preventing the need to recreate complex elements like disclaimers, company addresses, or custom headers.
• Building Blocks are managed through the Building Blocks Organizer, where users can preview, edit, or delete saved items.
• While Styles (Option 2) are used for formatting text, and Templates (Option 4) are blueprints for entire documents, Building Blocks are modular components that can be inserted into any part of a document.
• Common examples of built-in building blocks include Cover Pages, Equations, Footers, Headers, and Page Numbers.

Additional Information

• Quick Parts: This is the gallery where many Building Blocks are stored. You can access it via the Insert tab in the Text group.
• AutoText: A specific type of building block that stores text and graphics for automatic insertion. It is one of the oldest forms of reusable content in Word.
• Storage: Custom building blocks are typically saved in a special template file named Building Blocks.dotx or the Normal.dotm template, ensuring they are available across different sessions.
• Shortcut: To quickly create a new building block from selected content, users can press Alt + F3 to open the Create New Building Block dialog box.