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

Explanation

1 Kilobyte (KB) = 1024 bytes

One Megabyte (MB) = 1024 Kilobytes (KB

One Gigabyte (GB) =  1024 Megabytes MB

One Terabyte (TB)= 1024 gigabytes (GB).

The size of information in the computer is measured in:

Kilobytes (KB)

Megabytes (MB)

Gigabytes (GB)

Terabytes (TB)

Last verified on 08-02-2026

Explanation

The standard shortcut key to print a page or document in most Windows applications and web browsers is Ctrl + P

Windows/Linux: Press Ctrl and P together.

Mac OS: Press Command and P together. 

Explanation

• In Microsoft Word, Header and Footer are used to add text, page numbers, or images at the top or bottom of a page.
• They help in document formatting and consistency across multiple pages.

• Location: Insert Tab → Text Group → Header & Footer

Last verified on 17-01-2026