← Assistant & UDC
Past Questions — 2025
___ is used to convert from upper case to lower case and vice versa.
A)
Toggle Case
B)
Sentence Case
C)
Lower Case
D)
Upper Case
In Microsoft Word, the 'Change Case' feature 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 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.
Therefore, Toggle Case is the only option that performs a bidirectional switch (vice versa) of the character cases.
In MS word, how do you apply bold formatting to a selected text?
A)
Ctrl+B
B)
Ctrl+C
C)
Ctrl+P
D)
Ctrl+ X
In Microsoft Word, keyboard shortcuts are used to perform common tasks efficiently.
1. **Ctrl+B**: This is the standard shortcut to apply or remove **Bold** formatting to the selected text.
2. **Ctrl+C**: This shortcut is used to **Copy** the selected text to the clipboard.
3. **Ctrl+P**: This shortcut opens the **Print** dialog box or print preview window.
4. **Ctrl+X**: This shortcut is used to **Cut** the selected text (removing it from its current position and placing it on the clipboard).
Therefore, option 'a' is the correct method for applying bold formatting.
The likes and professions of five friends Rosy, Mary, Lily, Andy and Daisy are given. 1. Rosy likes yellow and is a student. 2. The Librarian likes Green. 3. Mary and Andy like Purple and Blue respectively and neither of them is a Teacher. 4. Lily likes Brown and the Inspector likes Blue. 5. One of the five is a Principal. Which among the following is the wrong pair?
A)
Andy - inspector
B)
Purple - Principal
C)
Daisy- Green
D)
Rosy- Teacher
To solve this puzzle, we map the friends to their colors and professions based on the given clues:
1. **Rosy**: Likes **Yellow** and is a **Student** (Given in clue 1).
2. **Mary**: Likes **Purple** (Given in clue 3). Since she is not a Teacher (clue 3) and the other professions (Student, Inspector, Librarian) are taken or linked to other colors, Mary must be the **Principal**.
3. **Andy**: Likes **Blue** (Given in clue 3). Clue 4 states the **Inspector** likes Blue, so Andy is the **Inspector**.
4. **Lily**: Likes **Brown** (Given in clue 4). Since the only remaining profession is Teacher (as Student, Inspector, Librarian, and Principal are assigned/linked), Lily is the **Teacher**.
5. **Daisy**: The only remaining person. The only remaining color is **Green** (clue 2). Clue 2 states the **Librarian** likes Green, so Daisy is the **Librarian**.
Summary Table:
- Rosy: Yellow | Student
- Mary: Purple | Principal
- Andy: Blue | Inspector
- Lily: Brown | Teacher
- Daisy: Green | Librarian
Evaluating the options:
- a. Andy - Inspector: Correct pair.
- b. Purple - Principal: Correct pair (Mary).
- c. Daisy - Green: Correct pair.
- d. Rosy - Teacher: **Wrong pair**. Rosy is a Student, not a Teacher.
A template that controls the overall appearance and formatting of all slides in a presentation
A)
Title
B)
Slide master
C)
Header
D)
Footer
The Slide Master is the top slide in a hierarchy of slides that stores information about the theme and slide layouts of a presentation, including the background, color, fonts, effects, placeholder sizes, and positioning. When you make a change to the Slide Master, it automatically applies that change to every slide in the presentation that is based on that master.
Why other options are incorrect:
- a. Title: This refers to a specific slide type or a text placeholder used to name the presentation or a specific section; it does not control the formatting of all slides.
- c. Header: A header is a small area at the top of a page or slide used for repetitive information (like a date or document name), but it does not control the overall appearance or formatting of the slide layout.
- d. Footer: Similar to the header, a footer is a small area at the bottom of a slide for page numbers or copyright info; it has no control over the global formatting of the presentation.
Which of the following is a valid email?
A)
@example.com
B)
john@.com
C)
john@example.com
D)
john doe@example.com
A valid email address must follow a specific syntax: [local-part]@[domain].[top-level domain].
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 name cannot start with a dot; there must be a valid domain name (e.g., 'example') between the '@' and the '.com'.
3. Option (c) 'john@example.com' is valid as it contains a local part ('john'), the '@' separator, a domain name ('example'), and a valid top-level domain ('.com').
4. Option (d) 'john doe@example.com' is invalid because standard email addresses cannot contain spaces in the local part unless they are enclosed in double quotes, which is not the case here.
Which of the following is the most secure method for securing wireless networks?
A)
WEP
B)
WPA
C)
WPA2
D)
WIFI
To determine the most secure method among the given options, we must evaluate the evolution of wireless security protocols:
1. **WEP (Wired Equivalent Privacy):** The oldest standard. It is highly insecure and can be cracked in minutes using basic tools due to weak encryption keys.
2. **WPA (Wi-Fi Protected Access):** Introduced as a temporary improvement over WEP. While it introduced TKIP (Temporal Key Integrity Protocol), it still had significant vulnerabilities.
3. **WPA2 (Wi-Fi Protected Access 2):** Replaced WPA and introduced AES (Advanced Encryption Standard), which provides much stronger encryption and is the industry standard for security among the options listed.
4. **WIFI:** This is not a security protocol; it is the general brand name for the wireless networking technology (IEEE 802.11).
While WPA3 is the most modern and secure protocol available today, it is not listed in the options. Therefore, among the provided choices, WPA2 is the most secure method.
Which function can be used to conditionally sum values in a range based on a criterion?
A)
SUMIF
B)
SUMO
C)
TFSUM
D)
TOTALIF
In Microsoft Excel, the SUMIF function is specifically designed to add the cells specified by a given criteria. Its syntax is =SUMIF(range, criteria, [sum_range]), where 'range' is the group of cells to be evaluated, 'criteria' is the condition that must be met, and 'sum_range' is the actual cells to sum.
Analysis of other options:
- b. SUMO: This is not a standard Excel function.
- c. TFSUM: This is not a standard Excel function.
- d. TOTALIF: While 'Total' is a common term, Excel uses 'SUM' for addition; 'TOTALIF' does not exist as a built-in function.
What is the shortcut to duplicate a slide in PowerPoint?
A)
Ctrl+C
B)
Ctrl+X
C)
Ctrl+V
D)
Ctrl+D
In Microsoft PowerPoint, the shortcut key to duplicate a selected slide (or a selected object) is Ctrl+D. This command creates an immediate copy of the selected item without needing to use the clipboard.
Analysis of other options:
- Ctrl+C: This is the shortcut for 'Copy'. It places the selected slide on the clipboard but does not create a duplicate until 'Paste' is used.
- Ctrl+X: This is the shortcut for 'Cut'. It removes the selected slide and places it on the clipboard.
- Ctrl+V: This is the shortcut for 'Paste'. It inserts the content currently held in the clipboard into the presentation.
How many transitions can be applied to one slide?
A)
One
B)
Two
C)
Three
D)
Four
In Microsoft PowerPoint, a 'Slide Transition' is the visual effect that occurs when you move from one slide to the next during a presentation. By design, PowerPoint allows only one transition effect to be assigned to a single slide. If you select a new transition for a slide that already has one, the new transition replaces the previous one. This is distinct from 'Animations,' which are applied to individual elements (text, images, shapes) within a slide; a single slide can have multiple animations, but only one transition.
What does the ‘Freeze Panes’ feature do in Excel?
A)
Securing data
B)
Hiding data
C)
Locking rows/columns
D)
Splitting window
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 few columns contain essential labels that need to be referenced while viewing data further down or to the right.
- Option (a) 'Securing data' is incorrect because securing data involves passwords or protection settings, not visibility.
- Option (b) 'Hiding data' is incorrect because hiding removes data from view entirely, whereas Freeze Panes keeps it visible.
- Option (d) 'Splitting window' is a different feature (Split) that divides the window into separate scrollable areas, whereas Freeze Panes locks a specific section in place.
What is the primary function of a PivotTable in Excel?
A)
To summarize data
B)
To create complex formulas
C)
To enhance graphics
D)
To connect to external databases
A PivotTable is one of the most powerful data analysis tools in MS Excel. Its primary purpose is to take a large, detailed dataset and 'pivot' or reorganize it to summarize the information. It allows users to group data, calculate sums, averages, or counts, and identify patterns without writing complex formulas.
Why other options are incorrect:
- Option b: While PivotTables can perform calculations (Calculated Fields), their primary function is summarization, not the creation of general complex formulas (which is the role of the Formula Bar and functions like VLOOKUP or INDEX/MATCH).
- Option c: PivotTables are data tools, not graphic design tools. While they can be paired with PivotCharts to enhance visuals, the table itself is for data organization.
- Option d: While Excel can connect to external databases (via Power Query or Data Connections), the PivotTable is the tool used to analyze the data *after* it has been imported or selected from a range.
What is the purpose of using the $ symbol in an Excel formula?
A)
To convert currency
B)
To highlight the cell
C)
To indicate absolute reference
D)
To mark important formula
In Microsoft Excel, the dollar sign ($) is used to create an 'Absolute Reference'. By default, cell references in Excel are 'Relative' (e.g., A1), meaning if you copy the formula to another cell, the reference changes based on the relative position. Adding a $ symbol before the column letter (e.g., $A1) or the row number (e.g., A$1) 'locks' that specific part of the reference. If both are locked ($A$1), the reference remains constant regardless of where the formula is copied.
Why other options are incorrect:
- Option (a): While the $ symbol is used as a currency symbol in formatting, in the context of a 'formula' (as specified in the question), it serves a structural purpose for cell referencing, not for currency conversion.
- Option (b): Highlighting cells is done via the 'Fill Color' tool in the Home tab, not through formula symbols.
- Option (d): There is no syntax in Excel formulas to 'mark' a formula as important using the $ symbol; comments or cell notes are used for that purpose.
In MS-Word, AutoCorrect is a feature that automatically correct as you type.
A)
Incorrect sentence
B)
Short, Repetitive
C)
Spelling mistake
D)
Sentences
The question is a fill-in-the-blank style multiple-choice question. The complete sentence should read: 'In MS-Word, AutoCorrect is a feature that automatically corrects spelling mistakes as you type.'
1. **Analysis of AutoCorrect**: AutoCorrect is a built-in feature in Microsoft Word that identifies common typos or misspelled words and automatically replaces them with the correct spelling without requiring user intervention.
2. **Evaluating Options**:
- (a) 'Incorrect sentence': AutoCorrect does not typically rewrite entire sentences for grammatical correctness; that is the role of the Grammar Checker.
- (b) 'Short, Repetitive': While AutoCorrect can be used to create shortcuts for repetitive text, the primary definition of the feature as it 'corrects' is focused on errors.
- (c) 'Spelling mistake': This is the primary function of AutoCorrect—to fix common spelling errors (e.g., changing 'teh' to 'the') instantly.
- (d) 'Sentences': AutoCorrect does not 'correct sentences' in a general sense, but rather specific words or characters within them.
What is the main function of the HTTPS protocol?
A)
To increase website speed
B)
To compress web pages
C)
To improve SEO
D)
To secure data transfer between a user and a website
HTTPS (Hypertext Transfer Protocol Secure) is the secure version of HTTP. Its main function is to encrypt the data sent between a web browser (the user) and a web server (the website) using TLS (Transport Layer Security) or SSL (Secure Sockets Layer). This prevents eavesdroppers from reading sensitive information like passwords or credit card numbers.
Analysis of other options:
- Option (a): HTTPS actually introduces a slight overhead due to the encryption handshake, which can technically make the initial connection slightly slower than HTTP, though modern protocols like HTTP/2 minimize 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 helps SEO), this is a secondary benefit/consequence, not the primary technical function of the protocol.
Which feature allows you to combine two or more table cells located in the same row or column into a single cell?
A)
AutoFit
B)
Merge Cells
C)
Table Style
D)
Split Cells
In MS Word, the 'Merge Cells' feature is specifically used to combine two or more selected cells into one larger cell. This is commonly used for creating headers that span multiple columns or rows.
Here is why the other options are incorrect:
- a. AutoFit: This feature automatically adjusts the width of columns or the height of rows to fit the content or the window size.
- c. Table Style: This refers to predefined formatting (colors, borders, and shading) applied to a table to make it visually appealing.
- d. Split Cells: This is the opposite of merging; it divides a single cell into multiple smaller cells (rows or columns).
Which component of the computer executes instructions from computer programs?
A)
RAM
B)
CPU
C)
GPU
D)
Hard Drive
The Central Processing Unit (CPU) is often referred to as the 'brain' of the computer. Its primary function is to fetch, decode, and execute instructions from computer programs. It consists of the Arithmetic Logic Unit (ALU), the Control Unit (CU), and registers (such as the Program Counter and Instruction Register) that work together to process data and carry out operations.
Why other options are incorrect:
- RAM (Random Access Memory) is volatile memory used to store data and instructions temporarily so the CPU can access them quickly; it does not execute them.
- GPU (Graphics Processing Unit) is a specialized processor designed to accelerate graphics rendering and parallel processing, but the general execution of computer program instructions is the primary role of the CPU.
- Hard Drive is a non-volatile storage device used for long-term data storage; it cannot execute instructions.
What is the role of application software?
A)
To manage hardware
B)
To perform specific tasks for users
C)
To control system resources
D)
To execute system commands
Software is generally divided into two main categories: System Software and Application Software.
1. Application Software (Option b): This is designed to help the end-user perform specific tasks. Examples include word processors (for creating documents), web browsers (for browsing the internet), and spreadsheets (for data analysis). The primary focus is on the user's needs.
2. System Software (Options a, c, and d): These options describe the role of the Operating System (OS) and other system utilities. Managing hardware (a), controlling system resources like CPU and RAM (c), and executing low-level system commands (d) are all functions of system software, which provides the platform upon which application software runs.
The Tab which allows you to control the look and the appearance of your presentation.
A)
Transition tab
B)
Insert tab
C)
Design tab
D)
Animation tab
In Microsoft PowerPoint, the 'Design' tab is specifically dedicated to the visual aesthetics of the presentation. It allows users to apply Themes, choose color schemes, set the slide size, and format the background, all of which control the overall 'look and appearance' of the slides.
Here is why the other options are incorrect:
- a. Transition tab: This controls the visual effect that occurs when moving from one slide to the next (the movement between slides), not the static appearance of the slides themselves.
- 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.
What is the primary purpose of a digital signature in cryptography?
A)
Ensuring data confidentiality
B)
Verifying the integrity and authenticity of data
C)
Encrypting messages
D)
Compressing data
A digital signature is a mathematical scheme used to demonstrate the authenticity of digital messages or documents. It provides three primary security services:
1. Authenticity: It confirms that the message was created by a known sender (the holder of the private key).
2. Integrity: It ensures that the message has not been altered in transit; if even one bit of the data changes, the signature verification will fail.
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. A digitally signed message can still be read by anyone unless it is also encrypted.
- Option (c) Encrypting messages: While digital signatures use asymmetric cryptography (public/private keys), their goal is verification, not hiding the content of the message.
- Option (d) Compressing data: This is the purpose of compression algorithms (like ZIP or JPEG), which reduce file size, and is unrelated to cryptographic security.
Which feature allows you to compare two Excel sheets side by side?
A)
Split
B)
New Window
C)
Arrange All
D)
View Side by Side
The 'View Side by Side' feature in MS Excel (found under the View tab in the Window group) is specifically designed to allow users to view two different workbooks or two windows of the same workbook simultaneously. When this feature is enabled, it often activates 'Synchronous Scrolling,' allowing the user to scroll through both sheets at the same time for easy comparison.
Why other options are incorrect:
- a. Split: This divides a single worksheet into separate panes, allowing you to see different parts of the same sheet, but it does not compare two separate sheets side by side.
- b. New Window: This opens a second instance of the current workbook. While this is a necessary first step to view two sheets of the same file side by side, it is not the feature that actually performs the side-by-side alignment.
- c. Arrange All: This tiles all open Excel windows on the screen. While it can be used to put windows next to each other, 'View Side by Side' is the specific feature dedicated to the comparison functionality, including synchronized scrolling.
The process of applying visual styles and layout elements to text and other elements within a document to enhance its appearance and readability in MS word.
A)
Proofing
B)
Editing
C)
Formatting
D)
Styling
Step-by-step reasoning:
1. Analysis of the definition: The question describes the process of changing the 'visual styles' and 'layout elements' to improve 'appearance and readability'. This refers to the aesthetic and structural presentation of the document rather than the content itself.
2. Evaluating Option (a) Proofing: Proofing refers to the process of checking for spelling, grammar, and punctuation errors (e.g., using the Spell Check tool). It does not deal with visual styles.
3. Evaluating Option (b) Editing: Editing involves changing the actual content of the document—adding, deleting, or rearranging text to improve clarity or accuracy. While it may precede formatting, it is not the process of applying visual styles.
4. Evaluating Option (c) Formatting: In MS Word, formatting is the specific term used for changing the appearance of text (font size, color, bold/italic) and the layout of the page (margins, alignment, spacing). This matches the question's description perfectly.
5. Evaluating Option (d) Styling: While 'Styles' are a feature within MS Word used to apply a set of formatting options quickly, 'Formatting' is the broader, overarching process described in the prompt. Styling is a method of formatting, but formatting is the general process.
What is the primary advantage of using cloud computing?
A)
Improved hardware performance
B)
Increased data security
C)
Scalability and cost efficiency
D)
Enhanced user interface
Cloud computing is primarily defined by its ability to provide on-demand resources.
1. Why Option (c) is correct: Scalability allows users to increase or decrease their computing resources (like storage or processing power) instantly based on demand. Cost efficiency is achieved through a 'pay-as-you-go' model, eliminating the need for heavy upfront investments in physical hardware (CapEx) and shifting it to operational expenditure (OpEx).
2. Why Option (a) is incorrect: Cloud computing does not inherently improve the performance of the hardware itself; rather, it provides access to high-performance hardware owned by the provider. The performance depends on the tier of service purchased, not the concept of cloud computing itself.
3. Why Option (b) is incorrect: While cloud providers offer robust security tools, moving data to the cloud introduces new security challenges (such as third-party access and internet dependency). Therefore, 'increased security' is not the primary universal advantage, as security is a shared responsibility between the provider and the user.
4. Why Option (d) is incorrect: The user interface (UI) is a matter of software design and front-end development. Whether a program is hosted on a local server or in the cloud does not inherently enhance the interface design.
Which network topology does the Internet most closely resemble?
A)
Ring
B)
Mesh
C)
Bus
D)
Star
The Internet is a global system of interconnected computer networks. It most closely resembles a Mesh topology (specifically a partial mesh) because it is designed for high redundancy and reliability. In a mesh topology, nodes are interconnected with multiple other nodes, meaning there are multiple paths for data to travel from a source to a destination. If one link or router fails, the Internet can dynamically route traffic through an alternative path to ensure connectivity.
Why other options are incorrect:
- a. Ring: In a ring topology, data travels in a circle; if one node fails, the entire network can collapse. This is not how the global Internet operates.
- c. Bus: A bus topology uses a single central cable (backbone). This would create a massive single point of failure and cannot scale to a global level.
- d. Star: In a star topology, all nodes connect to a single central hub. While individual local networks (LANs) often use star topologies, the Internet as a whole cannot have one single central hub controlling all global traffic.
In HTTP, what status code indicates that the server cannot find the requested resource?
A)
200 OK
B)
404 Not Found
C)
301 Moved Permanently
D)
500 Internal Server Error
HTTP (Hypertext Transfer Protocol) status codes are divided into five classes based on the first digit.
1. **Option b (404 Not Found)** is the correct answer. The '4xx' class of status codes indicates Client Errors. Specifically, 404 is returned when the server can communicate with the client, but the server cannot find the specific resource (page or file) requested by the client.
2. **Option a (200 OK)** belongs to the '2xx' class (Success). It indicates that the request was successful and the server has returned the requested data.
3. **Option c (301 Moved Permanently)** belongs to the '3xx' class (Redirection). It indicates that the requested resource has been assigned a new permanent URI and any future references to this resource should use the new URI.
4. **Option d (500 Internal Server Error)** belongs to the '5xx' class (Server Errors). It indicates that the server encountered an unexpected condition that prevented it from fulfilling the request, regardless of whether the resource exists or not.
Multitasking in operating systems allows for
A)
Multiple users to share a single device
B)
Devices to run without an OS
C)
A single user to perform multiple tasks at one time
D)
Devices to perform calculation
Multitasking is a feature of modern operating systems that allows a single user to run multiple applications or processes concurrently. Technically, the OS achieves this by rapidly switching the CPU's attention between different tasks (time-sharing), which creates the illusion that all tasks are running simultaneously.
Analysis of options:
- Option (a) refers to 'Multi-user' operating systems, not multitasking.
- Option (b) is incorrect because multitasking is a function *of* the OS; a device cannot perform OS-level multitasking without an OS.
- Option (c) is correct as it describes the core functionality of multitasking from a user's perspective.
- Option (d) describes the general purpose of a computer (computation), not the specific feature of multitasking.