← Assistant & UDC
Past Questions
Each pixel on a computer screen is composed of how many colour dots?
A)
24
B)
16
C)
8
D)
3
Each pixel on a standard color computer screen is composed of 3 color dots (subpixels): Red, Green, and Blue (RGB). By combining these three primary colors of light at varying intensities, the screen can produce a wide spectrum of colors. Options 'a' (24), 'b' (16), and 'c' (8) are incorrect because they refer to common color depths (the number of bits used to represent a color), not the physical number of color dots that make up a single pixel.
The temporary storage that can be used to compensate for a difference in data rate and data flow between devices
A)
Buffer
B)
Bus
C)
Channel
D)
Modem
The correct option is 'a' (Buffer). A buffer is a temporary physical memory storage area used to hold data while it is being transferred between devices or processes that operate at different speeds or data rates. It acts as a temporary holding zone to prevent data loss and ensure smooth data flow. In contrast, a 'Bus' (option b) is a communication system that transfers data between computer components; a 'Channel' (option c) is a transmission path or medium for signals; and a 'Modem' (option d) is a device that modulates and demodulates signals for communication over telephone or cable lines.
Which services allows users to connect to and use cloud-based apps over the Internet?
A)
Service-as-a-Software (SaaS)
B)
Software-as-a-Service (SaaS)
C)
Software-and-a-Server (SaaS)
D)
Software-as-a-Server (SaaS)
Option 'b' is correct because Software-as-a-Service (SaaS) is a cloud computing model that allows users to connect to and use cloud-based applications over the Internet (such as Microsoft Office 365, Gmail, or Salesforce). Options 'a', 'c', and 'd' are incorrect because they use incorrect terminology ('Service-as-a-Software', 'Software-and-a-Server', and 'Software-as-a-Server') which do not exist as standard cloud computing service models.
A tools which are used to mark a specific location within a document, allowing you to quickly navigate to that location later
A)
Immersive reader
B)
Editor
C)
Bookmark
D)
Outline
The correct option is 'c' (Bookmark). In word processing applications like Microsoft Word, a 'Bookmark' is a feature used to identify a specific location or text selection that you name for future reference, allowing you to quickly navigate back to it.
- 'Immersive reader' (a) is an accessibility tool designed to improve reading comprehension and focus.
- 'Editor' (b) is a tool used to check spelling, grammar, and writing style.
- 'Outline' (d) is a document view that displays the hierarchical structure of headings and text.
Which of the following is not cloud service?
A)
Dropbox
B)
iCloud
C)
OneDrive
D)
Copilot
Copilot is an artificial intelligence (AI) companion and chatbot developed by Microsoft, rather than a cloud storage or cloud hosting service. In contrast, Dropbox (a), iCloud (b), and OneDrive (c) are all well-known cloud storage services designed for storing, sharing, and synchronizing files over the internet.
An excel function that allows you to filter a range of data based on criteria you define.
A)
Sorting
B)
Formula
C)
Filter
D)
Pivot
The correct option is 'c' (Filter). The FILTER function in Excel (or the Filter tool) is specifically designed to screen a range of data and display only the rows that meet the criteria you define.
- 'Sorting' (option a) rearranges the order of the data (e.g., alphabetically or numerically) but does not hide or filter any records.
- 'Formula' (option b) is a general term for any mathematical or logical equation in Excel, not a specific filtering tool.
- 'Pivot' (option d) refers to PivotTables, which are used to summarize, aggregate, and analyze large datasets rather than simply filtering a range of data based on a condition.
In MS words, a tools to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics
A)
Clipboard
B)
Hyper link
C)
Format Painter
D)
Editor
The Format Painter is a tool in MS Word that allows you to copy all of the formatting from one object (such as text or a graphic) and apply it to another, saving time and ensuring consistency.
- **Clipboard (a)** is incorrect because it is a temporary storage area for text or graphics that have been cut or copied, not a formatting tool.
- **Hyper link (b)** is incorrect because it is used to create a clickable link to another document, webpage, or location.
- **Editor (d)** is incorrect because it is a feature used to check spelling, grammar, and writing style.
Which of the following devices provides the communication between a computer and the outer world?
A)
Compact Disc
B)
Input/Output
C)
Drivers
D)
Magnetic Storage
Input/Output (I/O) devices act as the communication interface between the computer and the external world. Input devices (like keyboards and mice) allow users to send data to the computer, while output devices (like monitors and printers) present the processed data back to the user.
- Compact Disc (a) and Magnetic Storage (d) are storage media used to store data, not to facilitate real-time communication with the outer world.
- Drivers (c) are software programs that allow the operating system to communicate with hardware devices, rather than physical communication devices themselves.
Whitespace used to place text or images in the left margin of a manual, next to the main body of the text in MS words.
A)
Indent
B)
Margin notes
C)
Break
D)
Orientation
In MS Word, 'Margin notes' (or marginalia) refer to the whitespace in the margins (typically the left margin) utilized to place supplementary text, icons, or images alongside the main body of the document.
- **Indent (Option a)** is the distance between the margin and the text paragraph, used for formatting text alignment rather than placing separate elements in the margin.
- **Break (Option c)** is used to separate pages, columns, or sections in a document.
- **Orientation (Option d)** refers to the page layout direction, which can be either Portrait or Landscape.
In MS Excel, a rectangular area formed by the intersection of a column and arow
A)
Address
B)
Cell
C)
Column
D)
Value
In MS Excel, a 'Cell' is the correct answer because it is the fundamental rectangular box formed by the intersection of a vertical column and a horizontal row where data is entered.
- Option 'a' (Address) is incorrect because it is the unique identifier (like A1) of a cell, not the physical area itself.
- Option 'c' (Column) is incorrect because a column is a vertical series of cells.
- Option 'd' (Value) is incorrect because it refers to the actual data or content stored inside a cell, not the intersection area.
In MS Excel, if you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. This is called?
A)
Relative reference
B)
Mixed reference
C)
Absolute reference
D)
Normative reference
An absolute reference in Excel (e.g., $A$1) uses a dollar sign ($) before both the column letter and the row number to lock the cell reference, ensuring it remains constant when copied to any other cell.
- **Relative reference (a)** changes automatically based on the relative position of rows and columns when copied (e.g., A1).
- **Mixed reference (b)** locks only the row or only the column, but not both (e.g., $A1 or A$1).
- **Normative reference (d)** is not a valid Excel term.
Which of the following is designed to control the operations of a computer?
A)
Open-Source software
B)
Application Software
C)
System Software
D)
Utility Software
System Software (Option c) is designed to control, integrate, and manage the individual hardware components of a computer system, as well as provide a platform for application software to run (e.g., Operating Systems like Windows or Linux).
- Application Software (Option b) is incorrect because it is designed to perform specific user-oriented tasks (e.g., MS Word, web browsers) rather than controlling the computer's operations.
- Utility Software (Option d) is incorrect because it is a subset of system software designed to analyze, configure, optimize, or maintain the computer (e.g., antivirus, disk defragmenters).
- Open-Source Software (Option a) is incorrect because it refers to a software licensing model where the source code is publicly available, not a functional category of software.
The latest Al feature introduce by Microsoft in MS Office is
A)
ChatGPT
B)
Copilot
C)
WordTune
D)
BrowseAI
Microsoft introduced Copilot as an AI assistant in its Office/Microsoft 365 products.
The premade function in Excel, which counts all cells in a range that has values, both numbers and letters.
A)
COUNT
B)
COUNTA
C)
COUNTIF
D)
COUNTIFS
The correct option is 'b' (COUNTA).
1. **Why COUNTA is correct**: The COUNTA function in Excel stands for 'Count All'. It counts the number of cells in a range that are not empty, meaning it includes cells containing numbers, text, logical values, error values, or empty text ("").
2. **Why other options are incorrect**:
- **COUNT (a)**: Only counts cells that contain numeric values (numbers, dates, etc.), ignoring text.
- **COUNTIF (c)**: Counts cells that meet a single specified condition or criterion.
- **COUNTIFS (d)**: Counts cells that meet multiple specified conditions or criteria.
Which of the following tools is used to read a HTML page and render it?
A)
Web server
B)
Web casting
C)
Web browser
D)
None of these
1. **Web browser (Option c)** is the correct tool used to read HTML documents, interpret their tags, and render them as visual, interactive web pages for the user.
2. **Web server (Option a)** is incorrect because its primary role is to store, process, and deliver web pages to clients upon request, not to render them.
3. **Web casting (Option b)** is incorrect as it refers to broadcasting media presentations over the Internet using streaming media technology.
4. **None of these (Option d)** is incorrect because Option c is the correct answer.
A-set of toolbars at the top of the window in MS word designed to help you quickly find the commands that you need to complete a task is called
A)
Ribbon
B)
Menu bar
C)
Tools bar
D)
Clipboard
The correct option is 'a' (Ribbon). The Ribbon is the tabbed toolbar system introduced in MS Word 2007 that sits at the top of the window, organizing commands into logical groups (tabs) to help users quickly find what they need. 'Menu bar' (option b) refers to the traditional text-based menus used in older versions of Word (2003 and earlier). 'Tools bar' (option c) is a generic term and not the official name of this interface element. 'Clipboard' (option d) is a temporary storage area for copied or cut text and graphics, not a toolbar system.
What is the access point (AP) ina wireless LAN?
A)
anetworking device that allows wireless-capable devices to connect to a wired network
B)
wireless devices itself
C)
both device that allows wireless devices to connect to a wired network and wireless devices itself
D)
Allofthe above
An Access Point (AP) is a networking hardware device that connects directly to a wired router, switch, or hub via an Ethernet cable, and projects a Wi-Fi signal to a designated area, allowing wireless-capable devices to connect to the wired network. Option 'b' is incorrect because client devices (like laptops or smartphones) are wireless clients, not the access point itself. Consequently, options 'c' and 'd' are also incorrect as they include option 'b'.
Internet works on
A)
packet switching
B)
circuit switching
C)
both packet switching and circuit switching
D)
data switching
The Internet works on packet switching. In a packet-switched network, data is broken down into smaller blocks called packets. Each packet is routed independently from the source to the destination using protocols like TCP/IP, allowing multiple users to share the same network resources efficiently. Circuit switching (option b) is incorrect because it establishes a dedicated, continuous physical path between the sender and receiver for the duration of the communication, which is typical of traditional landline telephone networks but not the Internet. Consequently, options c and d are also incorrect.
Which of the following is not the advantage of 5G network.
A)
greater speed in the transmissions
B)
alower latency
C)
agreater number of connected devices
D)
lowcost for roll-out
The correct option is 'd' because rolling out a 5G network is highly expensive. It requires significant capital investment for new infrastructure, including a dense network of small cell stations, fiber-optic backhaul, and expensive spectrum licenses, making 'low cost for roll-out' incorrect as an advantage. On the other hand, options 'a' (greater speed in transmissions), 'b' (lower latency), and 'c' (greater number of connected devices) are all well-established, key advantages of 5G technology compared to previous generations.
What was the name of the first network?
A)
ASAPNET
B)
ARPANET
C)
CNNET
D)
NSFNET
ARPANET (Advanced Research Projects Agency Network) was the world's first operational packet-switching network and the predecessor to the modern Internet. It was established in 1969 by the U.S. Department of Defense's Advanced Research Projects Agency (ARPA). Other options are incorrect because: NSFNET (National Science Foundation Network) was created much later in 1985 to connect supercomputing centers; ASAPNET and CNNET are not historically recognized computer networks.
Which of the following networks extends a private network across public networks?
A)
virtual private network
B)
local area network
C)
storage area network
D)
enterprise private network
A Virtual Private Network (VPN) is designed to extend a private network across a public network (such as the Internet), allowing users to send and receive data securely as if their devices were directly connected to the private network.
- Option 'b' (Local Area Network) is incorrect because it is restricted to a small, localized physical area like a home or office.
- Option 'c' (Storage Area Network) is incorrect because it is a specialized network used to provide block-level data storage access.
- Option 'd' (Enterprise Private Network) is incorrect because it refers to a network built by an organization to connect its various locations, but it does not specifically define the mechanism of extending a private network over public infrastructure in the way a VPN does.
High speed Internet works on
A)
Optical fiber
B)
Coaxial cable
C)
Twisted pair cable
D)
Unshielded twisted pair cable
Optical fiber is the correct answer because it uses light pulses to transmit data through glass or plastic strands, allowing for extremely high-speed internet (gigabits per second) with minimal signal loss over long distances. Coaxial cables (b), twisted pair cables (c), and unshielded twisted pair cables (d) use electrical signals over copper wires, which are much slower, have lower bandwidth, and are highly susceptible to electromagnetic interference and signal degradation over distance.
What kind of transmission medium is most appropriate to carry data in a computer network that is exposed to electrical interferences?
A)
Unshielded twisted pair
B)
Optical fiber
C)
Coaxial cable
D)
Microwave
Optical fiber is the most appropriate transmission medium for environments with high electrical interference because it transmits data as pulses of light rather than electrical signals. Since light is completely immune to electromagnetic interference (EMI) and radio frequency interference (RFI), optical fiber ensures error-free data transmission. In contrast, Unshielded Twisted Pair (UTP) (a) and Coaxial cable (c) use copper wires that are highly susceptible to electrical noise. Microwave (d) is a wireless medium that can be affected by atmospheric conditions and electromagnetic disturbances.
Which supports a Bi-Directional flow of data in both directions at the same time (simultaneous flow)?
A)
Full Duplex
B)
Halfduplex
C)
Simplex
D)
Allofthese
Full Duplex transmission mode allows data to flow in both directions simultaneously (at the same time), similar to a telephone conversation where both parties can speak and listen concurrently. In contrast, Half-duplex (option b) allows bi-directional communication but only one direction at a time (like a walkie-talkie), and Simplex (option c) allows data transmission in only one direction (unidirectional, like a television broadcast). Therefore, 'All of these' (option d) is incorrect.
A vendor sells lemon at the rate of 5 for Rs 14 gaining 40 %. For how much did he buy a dozen lemons?
A)
Rs 20
B)
Rs 24
C)
Rs 28
D)
Rs 32
Option B is correct: Rs 24.