Explanation

• LED (Light Emitting Diode) is a semiconductor device that emits light when electric current passes through it.
• It is widely used in lighting, displays, electronic indicators, and screens.

Additional information:

• Energy efficiency: Up to 90% more efficient than traditional bulbs
  First discovery: H. J. Round – 1907
  Early research: Oleg Losev – 1927
  Practical LED development: James R. Biard – 1961
  First commercial production: October 1962 (Nick Holonyak)

Last verified on 12-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

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

• In MS Word 2016, page margins define the space between the text and the edge of the page.
• Common margin types are: Top, Bottom, Left, Right.
• “Center” is not a page margin type.

Last verified on 10-03-2026

Explanation

• The MOD function in Excel returns the remainder after division of one number by another.
  • Syntax: =MOD(Number, Divisor)
  • Example: =MOD(10, 3) → Result = 1 (10 ÷ 3 leaves remainder 1)

Last verified on 07-03-2026

Explanation

Line spacing shortcuts:

• Ctrl + 1 → 1.0
• Ctrl + 2 → 2.0
• Ctrl + 5 → 1.5

Last verified on 07-03-2026

Explanation

• In MS-Word 2016, a subscript is a number or letter written slightly below the normal text.
• Commonly used in chemical formulas, mathematical expressions, and scientific writing.
• Example: H₂O → the “2” is a subscript.

Additional information:

• Superscript: Written above the normal text (e.g., x²)

Last verified on 19-01-2026

Explanation

• A watermark is a faint design or text appearing behind the main content of a document.
  In Word, you can use:
  Text – Example: Confidential, Draft
  Image – Example: Company logo or signature

Last verified on 06-03-2026

Explanation

Explanation

• In MS Excel, all formulas and functions start with the equal sign (=).
• This tells Excel to perform a calculation instead of treating the input as plain text.

Last verified on 10-02-2026