Explanation

Explanation

• In presentation software (like MS PowerPoint), special effects used to introduce slides are called Transitions.
• Transitions control how one slide moves to the next during a presentation.
• They can be simple fades, wipes, pushes, or dynamic animations to make the presentation more engaging.

Last verified on 11-03-2026

Explanation

• In MS Excel, to sum values in a range based on a condition, the SUMIF() function is used.
• It allows you to add only the numbers that meet a specific criterion, such as all sales above 1000 or only a certain category.
• This is different from SUM(), which adds all numbers in a range without any condition.

Last verified on 11-03-2026

Explanation

• In MS Excel, a pre-programmed formula is called a Function.
• Functions perform specific calculations or tasks automatically, such as SUM, AVERAGE, or IF.
• They save time by automating repetitive formulas and reducing errors.

Last verified on 11-03-2026

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 Excel 2016, the UPPER() function is used to convert text to uppercase letters.
• It changes all lowercase characters in a cell to capital letters.

Additional information:

• LOWER() – Converts text to lowercase
• PROPER() – Capitalizes the first letter of each word

Last verified on 11-03-2026

Explanation

A webpage address is called a URL,

URL: Uniform Resource Locator.

URL consists of five parts:

1. Scheme
2. Subdomain
3. Top-level domain
4. Second-level domain
5. Subdirectory

Last updated 18-02-2026

Explanation

• Secondary storage is used to store data permanently or for long-term use.
• Examples include Flash Drives, Floppy Disks, and Optical Disks.
• RAM (Random Access Memory) is primary memory.
• It is used for temporary storage while the computer is running.
• Therefore, RAM is not considered secondary storage.

Last verified on 11-03-2026

Explanation

• Computer memory is measured in bytes.
• 1 Kilobyte (KB) = 1024 bytes, so memory in bytes = 960 × 1024.
• Total bytes = 983,040 bytes (960 × 1024 = 983,040).

Last verified on 11-03-2026

Explanation

• Microcomputers are small computers designed for personal or business use.

• They are built around a central processing unit (CPU or processor), which executes instructions and controls the system.
• Processors are the brain of microcomputers, enabling them to perform calculations, run software, and manage hardware.

Last verified on 11-03-2026