← Assistant & UDC
Past Questions
The base area of a room is 16m² and height is 3m. Then, the volume of the room is:
A)
16m³
B)
48m³
C)
54m³
D)
66m³
To find the volume of a room (which is typically a rectangular prism or cuboid), the formula is: Volume = Base Area × Height.
Given:
1. Base Area = 16 m²
2. Height = 3 m
Calculation:
Volume = 16 m² × 3 m = 48 m³.
Analysis of options:
- Option (a) 16m³ is incorrect as it only represents the base area without considering height.
- Option (b) 48m³ is correct based on the calculation.
- Option (c) 54m³ is incorrect.
- Option (d) 66m³ is incorrect.
What is the square root of (8 + 2√15)?
A)
√5 + √3
B)
2√2 + 2√6
C)
2√5 + 2√3
D)
√2 + √6
To find the square root of an expression in the form (a + 2√b), we look for two numbers x and y such that their sum (x + y) equals 'a' and their product (xy) equals 'b'. This is based on the algebraic identity: (√x + √y)² = x + y + 2√xy.
In the given expression (8 + 2√15):
1. We identify a = 8 and b = 15.
2. We need two numbers that add up to 8 and multiply to 15.
3. The numbers 5 and 3 satisfy these conditions: 5 + 3 = 8 and 5 * 3 = 15.
4. Therefore, we can rewrite the expression as: 8 + 2√15 = 5 + 3 + 2√(5 * 3).
5. This matches the form (√5)² + (√3)² + 2(√5)(√3), which is the expansion of (√5 + √3)².
6. Taking the square root: √(√5 + √3)² = √5 + √3.
Verification of options:
- Option a: (√5 + √3)² = 5 + 3 + 2√15 = 8 + 2√15. (Correct)
- Option b: (2√2 + 2√6)² = 8 + 24 + 2(2√2 * 2√6) = 32 + 8√12 = 32 + 16√3. (Incorrect)
- Option c: (2√5 + 2√3)² = 20 + 12 + 2(2√5 * 2√3) = 32 + 8√15. (Incorrect)
- Option d: (√2 + √6)² = 2 + 6 + 2√12 = 8 + 4√3. (Incorrect)
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 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.
A series of commands and instructions that you group together as a single command to accomplish a task automatically in MS word.
A)
AutoCorrect
B)
Thesaurus
C)
Macro
D)
Grammar Check
A Macro in MS Word is a tool that allows users to record a sequence of commands, keystrokes, and formatting actions and save them as a single command. This is used to automate repetitive tasks, thereby increasing efficiency.
Why other options are incorrect:
- a. AutoCorrect: This is a feature that automatically corrects common misspellings or replaces specific text patterns with others as you type, but it does not group a series of complex commands into a single automated task.
- b. Thesaurus: This is a reference tool used to find synonyms and antonyms for words to improve vocabulary.
- d. Grammar Check: This is a proofing tool that identifies potential grammatical errors in a document and suggests corrections.
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.
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 the primary system software that acts as an intermediary between the computer hardware and the user. Its fundamental purpose is resource management.
1. Why Option (b) is correct: The OS manages critical hardware components such as the CPU (process management), RAM (memory management), and disk drives (file management), while also providing the necessary environment for application software to run.
2. 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), not the OS itself.
- Option (c): Displaying graphics is primarily the role of the Graphics Processing Unit (GPU) and specific display drivers/software.
- Option (d): Storing data is the function of storage hardware (like HDDs or SSDs). While the OS manages how data is stored via a file system, the act of storage is a hardware capability.
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 execute mathematical calculations (arithmetic operations like addition, subtraction, multiplication, and division) and logical comparisons (logic operations like AND, OR, NOT, and XOR).
Analysis of other options:
- Option (a) 'Storing data' is the primary role of Memory (RAM) and Registers.
- Option (b) 'Fetching instructions' is a function of the Control Unit (CU) during the instruction cycle.
- Option (c) 'Controlling I/O operations' is managed by the Control Unit and the I/O interface/controller.
Therefore, option (d) is the only correct description of the ALU's function.
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 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.
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.
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.
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.
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.
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).
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.
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 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 naming convention used to identify and locate a specific resource (such as an HTML page, an image, a PDF, or a video) on the internet. It consists of several parts: the protocol (e.g., http or https), the domain name (e.g., www.example.com), and often a path to a specific file or directory.
Analysis of options:
- Option (a) is incorrect because a browser is a software application (like Chrome or Firefox), not something identified by a URL.
- Option (b) is incorrect because the link between a website and a hosting server is managed by DNS (Domain Name System) and server configuration, not the URL itself.
- Option (c) is correct as it accurately describes the primary function of a URL: acting as the 'address' for a web resource.
- Option (d) is incorrect because server configuration involves settings within the server software (like Apache or Nginx), whereas a URL is a client-side request address.
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 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.
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.
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 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.
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.
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.
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.