Explanation

• Purpose: Prevents text from being hidden in the binding
• Location: Can be added to left or top depending on binding type
• Adjustable in: Layout > Margins > Custom Margins > Gutter

Explanation

• Optical Fiber Systems are utilized in Telecommunication Systems to transmit data as light signals through thin glass or plastic fibers.
• It enabling high-speed internet, voice, and data communications over long distances.

Last verified on 03-04-2026

Explanation

• To split windows or document panes into two in applications like Excel or Word, use the View > Window > Split menu option.
• This command divides the active document window into separate

Explanation

• In MS Excel, different functions are used to handle dates and times.
• To display the current date and time, the NOW() function is used.

Additional information:

• DATE() – Returns a date based on year, month, and day
• TODAY() – Returns today’s date only
• TIME() – Constructs a specific time from hours, minutes, and seconds

Last verified on 11-03-2026

Explanation

• In MS Word 2016, the Home Tab contains tools for text formatting and editing.
• Common options include Font, Font Color, and Styles.
• Columns is found under the Layout Tab, not Home Tab.

Last verified on 10-03-2026

Explanation

• AVERAGEIF calculates the average of cells that meet a specific condition.
• Formula: =AVERAGEIF(range, criteria, [average_range])
• Useful for conditional averaging in large datasets.

Last verified on 08-03-2026

Explanation

In a network with 25 computers, a full mesh topology requires the most extensive cabling. 

Mesh Topology: Every node is connected to every other node, creating 300 unique connections for 25 computers.

Last updated 15-feb-2026

Explanation

Macros in Microsoft Office automate repetitive, multi-step tasks

Such as formatting reports, cleaning data, or generating daily backups—into a single click or keyboard shortcut.

They significantly increase productivity, ensure 100% consistency, and reduce human error 

Last updated 15-feb-2026

Explanation

• In Microsoft PowerPoint 2003 and earlier versions, Slide Design and Slide Layout are found in the Format menu.
• PowerPoint 2003 uses a menu-based interface.
• From PowerPoint 2007 onward, Microsoft introduced the Ribbon interface.
• In newer versions, Slide Design is under the Design tab, while Slide Layout is under the Home tab.
• Therefore, Format Menu is the correct answer for PowerPoint 2003 and earlier.

Last verified on 28-07-2026

Explanation

The most suitable and primary reason to use Macros in MS Office (Word, Excel, PowerPoint) is to automate repetitive tasks

Last updated 15-feb-2026