Past Questions

The 'Freeze Panes' feature in Microsoft Excel is used to keep specific rows or columns visible while scrolling through the rest of the worksheet. This is particularly useful for large datasets where the header row or the first column contains essential labels that need to remain in view for context. - Option (a) 'Securing data' refers to protecting sheets or workbooks with passwords, not freezing panes. - Option (b) 'Hiding data' refers to the 'Hide' feature, which removes rows or columns from view entirely. - Option (d) 'Splitting window' refers to the 'Split' feature, which divides the window into separate scrollable areas, whereas Freeze Panes specifically locks the position of headers.

To find the day of the week for 26th January 1950, we use the standard calendar formula: Day = (Date + Month Code + Year Code + Leap Year Code + Century Code) mod 7. 1. **Date**: 26 2. **Month Code (January)**: For a non-leap year, the code for January is 0 (or 1 depending on the system; using the standard 033 614 625 035 system, Jan is 0). Since 1950 is not a leap year, we use 0. 3. **Year**: We take the last two digits of the year: 50. 4. **Leap Year Code**: Divide the last two digits by 4 (ignore remainder): 50 ÷ 4 = 12. 5. **Century Code (1900-1999)**: The code for the 1900s is 0. Calculation: Total = 26 (Date) + 0 (Month) + 50 (Year) + 12 (Leap Year) + 0 (Century) Total = 88 Now, divide the total by 7 to find the remainder: 88 ÷ 7 = 12 with a remainder of 4. According to the day code (0=Sunday, 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday): Remainder 4 corresponds to Thursday. Therefore, 26th January 1950 was a Thursday.

A digital signature is a mathematical scheme used to demonstrate the authenticity of digital messages or documents. It provides three main security services: 1. Authenticity: It confirms that the message was created by a known sender (non-repudiation). 2. Integrity: It ensures that the message has not been altered in transit; if a single bit of the data changes, the signature becomes invalid. 3. Non-repudiation: The sender cannot deny having sent the message. Why other options are incorrect: - Option (a) Ensuring data confidentiality: This is the purpose of Encryption, not digital signatures. Signatures do not hide the content of the message. - Option (c) Encrypting messages: While digital signatures use asymmetric cryptography (public/private keys), their purpose is to sign/verify, not to encrypt the message body for secrecy. - Option (d) Compressing data: This is the purpose of data compression algorithms (like ZIP or JPEG), which reduce file size and have nothing to do with cryptographic security.

In word processing software (like Microsoft Word), 'Change Case' is a feature that allows users to modify the capitalization of selected text. 1. **Toggle Case (Option a):** This specific function switches the case of every letter. If a letter is uppercase, it becomes lowercase; if it is lowercase, it becomes uppercase. This matches the requirement of converting 'from upper case to lower case and vice versa'. 2. **Sentence Case (Option b):** This capitalizes only the first letter of the first word in a sentence and leaves the rest in lowercase. 3. **Lower Case (Option c):** This converts all selected text to lowercase letters, regardless of their original state. 4. **Upper Case (Option d):** This converts all selected text to uppercase letters, regardless of their original state.

From the bar graph, take the number of girls for 2021–2024 and find their average, and similarly take the number of boys for 2021–2024 and find their average. Since both averages are over the same 4 years, the ratio of averages is the same as the ratio of the total numbers. So, Average girls : Average boys = (Total girls in 2021–2024) : (Total boys in 2021–2024). Using the values from the graph, this ratio comes out to 11 : 13. Therefore, the correct option is (a) 11:13. Why the others are incorrect: - (b) 13:11 is the reverse of the required ratio. - (c) 11:15 does not match the totals from the graph. - (d) 15:11 is also the reverse/mismatched ratio and not supported by the data.

The coding logic used here is the 'Opposite Letter' or 'Reverse Alphabet' pattern. In this pattern, the 1st letter of the alphabet (A) is paired with the last letter (Z), the 2nd (B) with the second-to-last (Y), and so on. The formula for the position of the opposite letter is (27 - current position). Verification of TABLE -> GZYOV: - T (20th) -> 27 - 20 = 7th (G) - A (1st) -> 27 - 1 = 26th (Z) - B (2nd) -> 27 - 2 = 25th (Y) - L (12th) -> 27 - 12 = 15th (O) - E (5th) -> 27 - 5 = 22nd (V) Applying the same logic to CHAIR: - C (3rd) -> 27 - 3 = 24th (X) - H (8th) -> 27 - 8 = 19th (S) - A (1st) -> 27 - 1 = 26th (Z) - I (9th) -> 27 - 9 = 18th (R) - R (18th) -> 27 - 18 = 9th (I) Therefore, CHAIR is written as XSRZI. Comparing this to the options: - Option a (XRZSI) is incorrect (R and S are swapped). - Option b (XZSRI) is incorrect (Z and S are swapped). - Option c (XSRZI) is correct. - Option d (XSZRI) is incorrect (Z and R are swapped).

To find how many times the hands of a clock are in a straight line but opposite in direction, we are looking for the number of times the hour hand and minute hand are exactly 180 degrees apart. 1. In a 12-hour period, the hands are opposite each other exactly 11 times, not 12. This is because the 'opposite' position occurs once every hour, but between 5:00 and 7:00, the hands are opposite only once (exactly at 6:00). 2. Specifically, the hands are opposite at approximately: 5:10, 6:00, 7:05, 8:11, 9:16, 10:22, 11:27, 12:33, 1:38, 2:44, and 3:49. 3. Since a full day consists of 24 hours (two 12-hour cycles), the total number of times the hands are opposite is 11 × 2 = 22. Comparison with other options: - Option (a) 20: Incorrect calculation. - Option (c) 24: Incorrectly assumes it happens exactly once every hour. - Option (d) 48: Incorrectly assumes it happens twice every hour (which would include coinciding hands).

Step-by-step solution: 1. **Identify given values and unify units**: - Radius of sphere ($R$) = 2.1 dm = 21 cm. - Length (height) of cylinder ($h$) = 7 cm. 2. **Calculate Volume of the Sphere**: - Volume $V_s = \frac{4}{3} \pi R^3 = \frac{4}{3} \pi (21)^3$. - $V_s = \frac{4}{3} \pi (9261) = 12348\pi$ cm³. 3. **Find Radius of the Cylinder ($r$)**: - Since the sphere is converted into a cylinder, their volumes are equal ($V_s = V_c$). - $\pi r^2 h = 12348\pi$ - $r^2 (7) = 12348$ - $r^2 = 1764$ - $r = \sqrt{1764} = 42$ cm. 4. **Calculate Total Surface Area (TSA) of the Sphere**: - $TSA_{sphere} = 4 \pi R^2 = 4 \pi (21)^2 = 4 \pi (441) = 1764\pi$ cm². 5. **Calculate Total Surface Area (TSA) of the Cylinder**: - $TSA_{cylinder} = 2\pi r(r + h) = 2\pi (42)(42 + 7)$ - $TSA_{cylinder} = 84\pi (49) = 4116\pi$ cm². 6. **Find the Ratio**: - Ratio = $\frac{TSA_{cylinder}}{TSA_{sphere}} = \frac{4116\pi}{1764\pi}$ - Dividing both by 588: $4116 / 588 = 7$ and $1764 / 588 = 3$. - Ratio = 7:3. Therefore, option (d) is correct.

Step-by-step solution: 1. **Determine A's efficiency**: A can complete the job in 15 days. Therefore, A's work rate (efficiency) is 1/15 of the job per day. 2. **Determine B's efficiency**: The problem states that B is twice as fast as A. This means B's work rate is 2 times that of A. B's efficiency = 2 * (1/15) = 2/15 of the job per day. 3. **Calculate combined efficiency**: When A and B work together, their daily work rates are added. Combined efficiency = (1/15) + (2/15) = 3/15. 4. **Simplify the combined efficiency**: 3/15 simplifies to 1/5 of the job per day. 5. **Calculate total time**: The time taken to complete the job is the reciprocal of the combined efficiency. Time = 1 / (1/5) = 5 days. Comparing with options: - a. 3 days: Incorrect. - b. 8 days: Incorrect. - c. 10 days: Incorrect. - d. 5 days: Correct.

To find the code for 'is', we compare the given phrases to isolate the words: 1. Compare (A) 'pitnasom' = 'bring me water' and (B) 'na jo tod' = 'water is life'. - Common word in English: 'water' - Common code in language: 'na' - Therefore, 'water' = 'na'. 2. Compare (B) 'na jo tod' = 'water is life' and (D) 'jo lin kot' = 'life and death'. - Common word in English: 'life' - Common code in language: 'jo' - Therefore, 'life' = 'jo'. 3. Now look at phrase (B) again: 'na jo tod' = 'water is life'. - We know 'na' = 'water' and 'jo' = 'life'. - The only remaining word in the English phrase is 'is' and the only remaining code is 'tod'. - Therefore, 'is' = 'tod'. Verification of other options: - 'jo' represents 'life'. - 'na' represents 'water'. - 'fn' does not appear in any of the given codes.

Option B is correct: 144.

The logic behind this sequence is based on the number of letters in the English word for the number provided on the left side of the equation. 1. For 'FLT11' (treating the number 11): The word is 'ELEVEN'. It has 6 letters. However, looking at the pattern of the results (R, T, E, N), we check the last letter of the word for the number: - 11 (ELEVEN) -> Last letter is 'N'. (Does not match R) Let's re-evaluate based on the number of letters in the word for the number: - 11 (ELEVEN) = 6 letters. 6th letter of alphabet is F. (Does not match R) Let's look at the words for the numbers and their lengths: - 11: ELEVEN (6 letters) - 2222: TWO THOUSAND TWO HUNDRED TWENTY TWO (Too long) Let's look at the numbers as single digits or repeated digits: - 11: ELEVEN (6 letters) - 2222: TWO TWO TWO TWO (16 letters) Let's try the word for the number itself: - 11: ELEVEN (6 letters) - 2222: TWO THOUSAND TWO HUNDRED TWENTY TWO Wait, look at the sequence of results: R, T, E, N. These are the last letters of the words for the numbers 1, 2, 3, 4 in a specific language or a specific pattern. Actually, look at the numbers: 11, 2222, 3333, 4444, 5555. The digits are 1, 2, 3, 4, 5. - 1 (ONE) -> ends in E - 2 (TWO) -> ends in O - 3 (THREE) -> ends in E - 4 (FOUR) -> ends in R Let's try the word for the number of digits: - 11 (Two digits) -> TWO -> ends in O - 2222 (Four digits) -> FOUR -> ends in R Let's try the word for the number of the digit itself: - 1 (ONE) -> 3 letters - 2 (TWO) -> 3 letters - 3 (THREE) -> 5 letters - 4 (FOUR) -> 4 letters - 5 (FIVE) -> 4 letters Let's look at the pattern again: R, T, E, N. These are the last letters of the words: FOUR, EIGHT, TEN, SEVENTEEN? No. Let's try the words for the numbers 11, 2222, 3333, 4444: - 11: ELEVEN (Ends in N) - 2222: TWO THOUSAND TWO HUNDRED TWENTY TWO (Ends in O) Let's look at the sequence R, T, E, N. These are the last letters of the words for 4, 10, 1, 10? No. Actually, the pattern is based on the word for the number of the digit repeated: - 11: (1 is ONE) -> 3 letters. 3rd letter of alphabet is C. - 2222: (2 is TWO) -> 3 letters. 3rd letter is C. Let's try the word for the number of digits: - 11: TWO (3 letters) - 2222: FOUR (4 letters) - 3333: FOUR (4 letters) - 4444: FOUR (4 letters) - 5555: FOUR (4 letters) Let's look at the results again: R, T, E, N. If we look at the words for the numbers 1, 2, 3, 4, 5: ONE, TWO, THREE, FOUR, FIVE. Last letters: E, O, E, R, E. Wait, look at the letters R, T, E, N. These are the last letters of the words for 4, 10, 1, 10? No. Let's try: 11 -> ELEVEN (6 letters). 6th letter from end of alphabet (Z=1, Y=2, X=3, W=4, V=5, U=6) is U. Let's try the word for the number of the digit: 1 -> ONE (3 letters). 3rd letter from end is X. 2 -> TWO (3 letters). 3rd letter from end is X. Let's try the word for the number of the digit, then the last letter of that word: 1 -> ONE -> E 2 -> TWO -> O 3 -> THREE -> E 4 -> FOUR -> R 5 -> FIVE -> E Wait, the sequence is R, T, E, N. If we look at the numbers 11, 2222, 3333, 4444, 5555 as indices for the alphabet: 11th letter = K 22nd letter = V Let's try the word for the number of the digit, and then the letter at that position in the alphabet: 1 -> ONE (3 letters) -> C 2 -> TWO (3 letters) -> C Let's try the word for the number of the digit, and then the letter at that position in the word 'FOURTEEN' or similar? Actually, the pattern is: 11: ELEVEN (6 letters) -> 6th letter of alphabet is F. (Not R) Let's look at the letters R, T, E, N. These are the last letters of the words: FOUR, EIGHT, NINE, TEN? No. Let's try the word for the number of the digit, and then the last letter of the word for that number of letters: 1 -> ONE (3 letters) -> THREE -> E 2 -> TWO (3 letters) -> THREE -> E Let's try the word for the number of the digit, and then the last letter of the word for that number of letters: 11 -> 1 (ONE) -> 3 letters -> THREE -> E 2222 -> 2 (TWO) -> 3 letters -> THREE -> E Let's try the word for the number of the digit, and then the last letter of the word for that number of letters: 11 -> 11 (ELEVEN) -> 6 letters -> SIX -> X 2222 -> 2222 (TWO THOUSAND...) -> too many Let's look at the sequence R, T, E, N. These are the last letters of: FOUR, EIGHT, NINE, TEN. 4, 8, 9, 10. 11 -> 4? (1+1=2, 2^2=4) 2222 -> 8? (2+2+2+2=8) 3333 -> 9? (3+3+3+3=12, no. 3*3=9?) 4444 -> 10? (4+4+4+4=16, no) Let's try: 11: 1+1 = 2. Word 'TWO'. Last letter 'O'. 2222: 2+2+2+2 = 8. Word 'EIGHT'. Last letter 'T'. 3333: 3+3+3+3 = 12. Word 'TWELVE'. Last letter 'E'. 4444: 4+4+4+4 = 16. Word 'SIXTEEN'. Last letter 'N'. 5555: 5+5+5+5 = 20. Word 'TWENTY'. Last letter 'Y'. Verification: 11: 1+1 = 2 -> TWO -> O (Wait, the question says R. Let me re-read. FLT11=R. Maybe FLT is a hint? F=6, L=12, T=20. 6+12+20 = 38. 38+11=49. No.) Wait, if 2222=T, 3333=E, 4444=N, then the logic 2+2+2+2=8 (EIGH**T**), 3+3+3+3=12 (TWELV**E**), 4+4+4+4=16 (SIXTEE**N**) is perfect. Now check 11: 1+1=2 (TW**O**). But the question says R. Is it possible the first one is 44? 4+4=8 (EIGH**T**)? No, it says FLT11. Wait, if the first one is 44, then 4+4=8 (T). But it says R. What if the first one is 4? FOUR -> R. If the first one is 4, then 4=R, 8=T, 12=E, 16=N, 20=Y. 11 is not 4. But maybe the 'FLT' is a distraction or a typo for '4'. Or maybe 11 is treated as 1+1=2, and the word is 'FOUR' for some reason? No. Let's check the sum of digits for the others again: 2+2+2+2 = 8 -> EIGH**T** 3+3+3+3 = 12 -> TWELV**E** 4+4+4+4 = 16 -> SIXTEE**N** 5+5+5+5 = 20 -> TWENT**Y** This pattern is extremely consistent for the last three. The first one 'FLT11=R' might be a typo for '4=R' or '44=R' (though 4+4=8=T). If the pattern is sums of 4, 8, 12, 16, 20, then the last letter of the words (FOUR, EIGHT, TWELVE, SIXTEEN, TWENTY) are R, T, E, N, Y. Therefore, 5555 -> 5+5+5+5 = 20 -> TWENTY -> Y.

The Internet is a global system of interconnected computer networks. It most closely resembles a Mesh topology because it consists of a vast number of nodes (routers, servers, and computers) connected to multiple other nodes. This redundancy ensures that if one path or node fails, data can be rerouted through an alternative path to reach its destination, which is the fundamental characteristic of a mesh network. Why other options are incorrect: - Ring: In a ring topology, each node is connected to exactly two other nodes, forming a single continuous pathway. If one link breaks, the entire network can fail. - Bus: A bus topology uses a single central cable (the backbone) to which all devices are connected. This is not scalable for a global network and creates a single point of failure. - Star: In a star topology, all nodes are connected to a single central hub. While individual local networks (LANs) often use star topologies, the Internet as a whole cannot rely on a single central hub because it would be impossible to manage and would be a catastrophic point of failure.

HTTPS stands for Hypertext Transfer Protocol Secure. It is the secure version of HTTP. The main function of HTTPS is to encrypt the data sent between a user's web browser and the server (website), ensuring that sensitive information (like passwords or credit card details) cannot be intercepted or read by unauthorized third parties. It achieves this by using TLS (Transport Layer Security) or its predecessor, SSL (Secure Sockets Layer). Why other options are incorrect: - Option (a): HTTPS does not inherently increase website speed; in fact, the encryption process can add a tiny amount of overhead, though modern protocols like HTTP/2 mitigate this. - Option (b): Compression is handled by other mechanisms (like Gzip or Brotli), not by the HTTPS protocol itself. - Option (c): While Google and other search engines use HTTPS as a ranking signal (meaning it can indirectly help SEO), the 'main function' of the protocol is security, not SEO improvement.

Cloud computing is defined by the delivery of computing services—including servers, storage, databases, networking, and software—over the internet. 1. Why 'c' is correct: The primary advantages of cloud computing are scalability (the ability to increase or decrease resources instantly based on demand) and cost efficiency (shifting from Capital Expenditure/CapEx on physical hardware to Operational Expenditure/OpEx via a 'pay-as-you-go' model). 2. Why 'a' is incorrect: Cloud computing does not inherently improve the performance of the physical hardware itself; it simply provides access to hardware managed by a provider. Performance depends on the tier of service purchased. 3. Why 'b' is incorrect: While cloud providers offer robust security tools, moving data to the cloud can sometimes introduce new security risks (shared responsibility model). Therefore, 'increased security' is not the primary universal advantage compared to on-premise systems. 4. Why 'd' is incorrect: The user interface (UI) is a matter of software design and front-end development, not a characteristic of the underlying cloud infrastructure.

Digital citizenship refers to the responsible, ethical, and safe use of technology. 1. Option (b) 'Respecting others’ privacy online' is a core pillar of digital citizenship. It involves understanding the importance of data protection, seeking consent before sharing others' information, and maintaining boundaries in digital interactions. 2. Option (a) 'Sharing false information' (misinformation/disinformation) is irresponsible as it can lead to panic, confusion, and social harm. 3. Option (c) 'Cyberbullying' is a violation of digital ethics and is often illegal, involving the harassment of others via digital platforms. 4. Option (d) 'Piracy' refers to the unauthorized copying or distribution of copyrighted material, which is an illegal act and a breach of intellectual property rights. Therefore, only option (b) represents a positive and responsible behavior in the digital world.

In Microsoft Excel, the 'View Side by Side' feature (found under the View tab in the Window group) allows a user to display two different workbooks (or two windows of the same workbook) next to each other for easy comparison. When this feature is activated, it often enables 'Synchronous Scrolling,' allowing both sheets to scroll up or down simultaneously. Why other options are incorrect: - a. Split: This divides a single worksheet into multiple panes, allowing you to see different parts of the same sheet at once, but it does not compare two separate sheets side by side. - b. New Window: This opens a second window of the current workbook. While this is a necessary first step to view two different sheets of the same file side by side, the 'New Window' command itself only opens the window; it does not arrange them for comparison. - c. Arrange All: This tiles all open Excel windows on the screen (Cascaded, Horizontal, Vertical, or Tiled). While it helps in organizing windows, 'View Side by Side' is the specific feature designed for direct comparison and synchronized movement.

A web browser is a software application used to locate, retrieve, and display content on the World Wide Web (WWW). It interprets HTML code and other web languages to render a visual webpage for the user. Analysis of options: - Option (a) 'To manage files' is the purpose of a File Manager (e.g., Windows Explorer or macOS Finder). - Option (b) 'To create graphics' is the purpose of graphic design software (e.g., Adobe Photoshop or CorelDRAW). - Option (c) 'To design websites' is the purpose of a Web Development environment or IDE (e.g., Visual Studio Code) and design tools (e.g., Figma). - Option (d) is correct because the fundamental role of a browser (like Google Chrome, Mozilla Firefox, or Safari) is to allow users to enter a URL or search term to access and navigate through websites.

In Microsoft PowerPoint, the shortcut Ctrl+D is specifically designed to 'Duplicate' the selected object or slide. When a slide is selected in the Slide Navigation pane, pressing Ctrl+D immediately creates an exact copy of that slide directly below the original. Here is why the other options are incorrect: - Ctrl+C: This is the 'Copy' command. It copies the slide to the clipboard, but it does not create a duplicate on the canvas until a 'Paste' command is issued. - Ctrl+X: This is the 'Cut' command. It removes the selected slide from the presentation and places it on the clipboard. - Ctrl+V: This is the 'Paste' command. It inserts the content currently held in the clipboard into the presentation.

To determine the most secure method among the options, we must evaluate the evolution of wireless security protocols: 1. **WEP (Wired Equivalent Privacy):** This was the first security standard for Wi-Fi. It is now considered highly insecure because its encryption keys can be cracked in minutes using basic software tools. 2. **WPA (Wi-Fi Protected Access):** Introduced as a temporary replacement for WEP. While it improved security via TKIP (Temporal Key Integrity Protocol), it still had vulnerabilities and is no longer considered secure. 3. **WPA2 (Wi-Fi Protected Access 2):** This replaced WPA and introduced AES (Advanced Encryption Standard), which provides much stronger encryption. For a long period, it has been the industry standard for securing wireless networks. (Note: While WPA3 exists today, it is not listed in the options provided). 4. **WIFI:** This is not a security protocol; it is the general term for the wireless networking technology itself. Comparing the options, WPA2 is significantly more secure than WEP and WPA.

Android applications are packaged into a file format known as APK, which stands for Android Package Kit. An APK file is essentially a ZIP-formatted archive that contains all the necessary elements for an app to run on the Android operating system, including the compiled code (dex files), resources, manifest file, and assets. Why other options are incorrect: - b. EXE: This is the 'Executable' file format used primarily by Microsoft Windows to run programs. - c. ZIP: While an APK is technically based on the ZIP compression format, 'ZIP' is a general-purpose archive format and not the specific packaging format for Android apps. - d. JAR: This stands for Java Archive. While Android apps are written in Java/Kotlin, JAR files are used for general Java libraries and desktop applications, whereas Android uses the specialized APK format for installation on mobile devices.

An Operating System (OS) is system software that acts as an intermediary between the computer user and the computer hardware. Its primary purpose is to manage the system's resources efficiently. This includes: 1. Process Management (CPU scheduling), 2. Memory Management (RAM allocation), 3. Device Management (controlling peripherals via drivers), and 4. File Management (organizing data on disks). Why other options are incorrect: - Option (a): Performing calculations is the primary function of the Central Processing Unit (CPU), specifically the Arithmetic Logic Unit (ALU). - Option (c): Displaying graphics is primarily the role of the Graphics Processing Unit (GPU) and the display driver, although the OS facilitates this communication. - Option (d): Storing data is the function of storage devices (Hard Disk, SSD, RAM), whereas the OS merely manages how that data is stored and retrieved.

A valid email address must follow a specific syntax defined by internet standards (RFCs). It generally consists of three parts: a local part (username), the '@' symbol, and a domain part. 1. Option (a) '@example.com' is invalid because it lacks the local part (the username before the '@' symbol). 2. Option (b) 'john@.com' is invalid because the domain part cannot start with a dot; it must have a valid domain name (e.g., 'example') before the top-level domain ('.com'). 3. Option (c) 'john@example.com' is valid. It has a local part ('john'), the '@' symbol, and a properly formatted domain ('example.com'). 4. Option (d) 'john doe@example.com' is invalid because email addresses cannot contain spaces. Spaces are not permitted characters in a standard email address unless the local part is enclosed in double quotes, which is not the case here.

In presentation software like Microsoft PowerPoint, the 'Design' tab is specifically used to control the overall visual appearance of the presentation. It allows users to change the slide theme, choose color schemes, adjust the slide size, and apply background styles to ensure a consistent look across all slides. Why other options are incorrect: - a. Transition tab: This controls how the presentation moves from one slide to the next (the movement between slides), not the overall look. - b. Insert tab: This is used to add elements to a slide, such as images, tables, shapes, and charts. - d. Animation tab: This controls the movement of individual objects (text, images) within a single slide.

In Microsoft Excel, the dollar sign ($) is used to create an 'Absolute Reference'. By default, cell references in formulas are 'Relative' (e.g., A1), meaning they change when the formula is copied or dragged to another cell. Adding a $ symbol before the column letter (e.g., $A1) locks the column, and adding it before the row number (e.g., A$1) locks the row. Using both (e.g., $A$1) locks the specific cell regardless of where the formula is moved. Why other options are incorrect: - Option (a): While the $ symbol is used as a currency symbol in formatting, in the context of an Excel 'formula', it serves a structural purpose for referencing, not for currency conversion. - Option (b): Highlighting cells is done through the 'Fill Color' or 'Conditional Formatting' tools, not via formula symbols. - Option (d): There is no specific symbol used to 'mark' formulas as important; importance is managed through cell notes, comments, or naming ranges.