← Assistant & UDC
Past Questions — 2025
A template that controls the overall appearance and formatting of all slides in a presentation
A)
Title
B)
Slide master
C)
Header
D)
Footer
In presentation software (such as Microsoft PowerPoint or Google Slides), the Slide Master is the top slide in a hierarchy that stores information about the theme and slide layouts of a presentation. When you make a change to the Slide Master, it automatically applies that change to every slide in the presentation, ensuring a consistent look and feel (fonts, colors, logos, and background).
Why other options are incorrect:
- a. Title: This refers to a specific text element or a specific type of slide used to introduce the presentation.
- c. Header: This is a section at the top of a page or slide used for repetitive information, but it does not control the overall formatting of the entire presentation.
- d. Footer: This is a section at the bottom of a slide used for page numbers or dates, but it does not control the global appearance or layout of the slides.
What type of cable is used for most modern Ethernet networks?
A)
Coaxial cable
B)
Fiber optic cable
C)
Twisted pair cable
D)
Shielded cable
Step-by-step reasoning: 1. Ethernet networks are the standard for Local Area Networks (LANs). 2. While early Ethernet used coaxial cables (10Base2, 10Base5), modern Ethernet standards (such as 10BASE-T, 100BASE-TX, and 1000BASE-T) primarily utilize Twisted Pair cabling. 3. Specifically, Unshielded Twisted Pair (UTP) cables (like Cat5e, Cat6, and Cat6a) are the most common choice for connecting computers to switches and routers due to their cost-effectiveness and ease of installation. 4. Analysis of options: (a) Coaxial cable is obsolete for modern LANs; (b) Fiber optic is used for high-speed backbones or long distances, but not for 'most' end-user network connections; (d) Shielded cable (STP) is a specific type of twisted pair used in high-interference environments, but is not as common as standard twisted pair overall.
What is the default file extension used by Excel 2016 and later versions?
A)
xls
B)
xlsx
C)
.xlsm
D)
.xIsb
Step-by-step reasoning:
1. Microsoft Excel transitioned from the binary file format (.xls) to the Office Open XML format starting with Excel 2007.
2. The default file extension for a standard workbook in Excel 2007, 2010, 2013, 2016, and later versions is .xlsx.
3. Analysis of options:
- (a) .xls: This was the default extension for Excel 97-2003. It is a legacy binary format.
- (b) .xlsx: This is the correct default XML-based format for modern Excel versions.
- (c) .xlsm: This is used specifically for workbooks that contain Macros (VBA code). It is not the 'default' for a standard workbook.
- (d) .xlsb: This is the Excel Binary Workbook format, used for very large spreadsheets to improve performance and reduce file size, but it is not the default.
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 correct because the '4xx' class of status codes indicates Client Errors. Specifically, 404 is the standard response code indicating that the server was able to communicate with the client, but the server could not find what was requested (the resource does not exist at the specified URL).
2. **Option a (200 OK)** is incorrect because '2xx' codes indicate Success. 200 OK means the request was successful and the server returned the requested data.
3. **Option c (301 Moved Permanently)** is incorrect because '3xx' codes indicate Redirection. 301 means the requested resource has been permanently moved to a new URL.
4. **Option d (500 Internal Server Error)** is incorrect because '5xx' codes indicate Server Errors. 500 means the server encountered an unexpected condition that prevented it from fulfilling the request, regardless of whether the resource exists or not.
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 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.
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 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.
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 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.
Which of the following exemplifies responsible digital citizenship?
A)
Sharing false information
B)
Respecting others’ privacy online
C)
Cyberbullying
D)
Piracy
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.
What is the primary purpose of web browser?
A)
To manage files
B)
To create graphics
C)
To design websites
D)
To access and navigate websites
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.
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 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.
What does an operating system primarily do?
A)
To perform calculations
B)
To manage computer hardware and software resources
C)
To display graphics
D)
To store data
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.
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 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.
Which component of the computer executes instructions from computer programs?
A)
RAM
B)
CPU
C)
GPU
D)
Hard Drive
The CPU (Central Processing Unit) is often referred to as the 'brain' of the computer. Its primary function is to fetch, decode, and execute instructions from computer programs. It performs the basic arithmetic, logical, control, and input/output (I/O) operations specified by the instructions.
Why other options are incorrect:
- RAM (Random Access Memory) is volatile primary storage used to hold data and instructions temporarily so the CPU can access them quickly; it does not execute instructions.
- GPU (Graphics Processing Unit) is a specialized processor designed to accelerate graphics rendering and parallel processing tasks, but it is not the general-purpose executor of program instructions.
- Hard Drive is a non-volatile secondary storage device used for long-term data storage; it cannot execute instructions directly.
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 a powerful data summarization tool in Microsoft Excel. Its primary purpose is to take a large, detailed dataset and reorganize it into a concise summary table. It allows users to group data, calculate sums, averages, or counts, and 'pivot' (rotate) the axes to view the data from different perspectives without changing the original source data.
Why other options are incorrect:
- Option b: While PivotTables use calculations, they are not used to 'create complex formulas'; that is the role of the Formula Bar and functions like VLOOKUP, INDEX-MATCH, or complex nested IF statements.
- Option c: Enhancing graphics is the function of Charts, Shapes, and SmartArt, not PivotTables.
- Option d: While Excel can connect to external databases via Power Query or Data Connections, the PivotTable itself is the tool used to analyze the data *after* it has been imported or selected from a range.
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 correct [spelling mistakes] as you type.'
1. **AutoCorrect Definition**: AutoCorrect is a built-in feature in Microsoft Word that identifies and corrects common misspellings, typos, and capitalization errors in real-time without the user having to manually run a spell-check.
2. **Evaluating Options**:
- (a) 'Incorrect sentence': AutoCorrect does not typically rewrite entire incorrect sentences for grammar; that is the role of the Grammar Checker.
- (b) 'Short, Repetitive': This does not fit the grammatical or functional context of the feature.
- (c) 'Spelling mistake': This is the primary function of AutoCorrect (e.g., changing 'teh' to 'the').
- (d) 'Sentences': AutoCorrect does not 'correct sentences' in a general sense, but rather specific words or phrases.
Therefore, 'Spelling mistake' is the most accurate fit for the blank.
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 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.
What is the significance of a URL in web technology?
A)
Identifies a browser
B)
Links a website to a hosting server
C)
Specifies the address of a resource on the web
D)
Provides server configuration
A URL (Uniform Resource Locator) is a standardized way of specifying the location of a resource (such as a webpage, image, or document) on the internet. It consists of several parts: the protocol (e.g., http, https), the domain name (e.g., google.com), and often a specific path to a file or directory.
Why other options are incorrect:
- Option (a): A browser is a software application (like Chrome or Firefox); it is not identified by a URL.
- Option (b): While a URL points to a resource hosted on a server, the 'linking' process (mapping a domain to an IP address) is handled by the DNS (Domain Name System), not the URL itself.
- Option (d): Server configuration involves settings within the server software (like Apache or Nginx) and is not provided by the URL.
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 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.
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: These are programs designed to help the user perform specific tasks. Examples include word processors (MS Word), web browsers (Google Chrome), spreadsheets (MS Excel), and media players. Therefore, option (b) is correct.
2. System Software: This category includes the Operating System (OS) and utility software. Its primary role is to manage the computer's hardware and provide a platform for application software to run.
Analyzing the other options:
- Option (a) 'To manage hardware' is the primary role of System Software (specifically the OS).
- Option (c) 'To control system resources' (like CPU, RAM, and Disk space) is a function of the Operating System.
- Option (d) 'To execute system commands' refers to the shell or command interpreter, which is part of the System Software.
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
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.
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 or object 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 or object, removing it from its original location and placing it on the clipboard.
Therefore, option (a) is the correct method for applying bold formatting.
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 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.
What is the role of the ALU in a microprocessor?
A)
Storing data
B)
Fetching instructions
C)
Controlling I/O operations
D)
Performing arithmetic and logic operations
The ALU (Arithmetic Logic Unit) is a fundamental component of the Central Processing Unit (CPU) or microprocessor. Its primary role is to carry out all mathematical calculations and logical comparisons.
1. **Arithmetic Operations**: This includes addition, subtraction, multiplication, and division.
2. **Logic Operations**: This includes comparisons such as AND, OR, NOT, and XOR, as well as determining if a value is equal to, greater than, or less than another value.
Why other options are incorrect:
- **Option a (Storing data)**: This is the role of registers (for temporary storage) and RAM/Hard Drives (for long-term storage).
- **Option b (Fetching instructions)**: This is the role of the Control Unit (CU), specifically using the Program Counter (PC) and Instruction Register (IR).
- **Option c (Controlling I/O operations)**: This is managed by the Control Unit and the I/O interface/controllers.
Android applications are packaged in what file format?
A)
APK
B)
EXE
C)
ZIP
D)
JAR
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.
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
The question describes the process of modifying the appearance of a document. In MS Word, 'Formatting' refers to the process of changing the visual characteristics of text (such as font size, color, bold/italic, alignment) and the layout of the page (such as margins, spacing, and indentation) to improve readability and aesthetics.
Why other options are incorrect:
- a. Proofing: This refers to the process of checking for spelling, grammar, and punctuation errors (e.g., using the Spelling & Grammar tool).
- b. Editing: This involves changing the actual content of the document, such as rewriting sentences, deleting paragraphs, or rearranging the structure of the text.
- d. Styling: While 'Styles' are a feature in MS Word used to apply a set of formatting characteristics consistently, 'Formatting' is the broader, overarching term for the process described in the question.
Page 1
← Prev
Next →