Explanation

MAN (Metropolitan Area Network): City or district coverage

• LAN (Local Area Network): Small area, e.g., home, office
• WAN (Wide Area Network): Covers countries or continents, e.g., Internet
• PAN (Personal Area Network): Very small area, e.g., devices connected via Bluetooth

Explanation

• MS Excel 2016 can perform calculations using formulas like SUM, subtraction, multiplication, and division.
• However, a formula referring to a non-existent range or name will produce an error.

Additional information:

• =SUM(Sales)-A3: ❌ Produces an error if ‘Sales’ is not a defined range or named range.
• *=SUM(A1:A5)0.5: ✅ Multiplies the sum of A1:A5 by 0.5.
• =SUM(A1:A5)/(10-10): ✅ Produces #DIV/0! error (division by zero) but Excel can calculate it.
• =SUM(A1:A5)-10: ✅ Subtracts 10 from the sum of A1:A5.

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

• In MS Excel, the IF function is used to return one value if a condition is TRUE and another if it is FALSE.
  • The correct syntax always includes:
  =IF(LogicalTest, TrueResult, FalseResult)

Additional information:

• LogicalTest: Condition to evaluate (e.g., A1>50)
• TrueResult: Value returned if condition is TRUE
• FalseResult: Value returned if condition is FALSE
• Example: =IF(A1>50, "Pass", "Fail")

Last verified on 07-03-2026

Explanation

• In MS Word, Ctrl + ] increases the font size of selected text by 1 point.
• Similarly, Ctrl + [ decreases the font size by 1 point.

Additional information:

• Shortcut to increase font: Ctrl + ]
• Shortcut to decrease font: Ctrl + [

Last verified on 07-03-2026

Explanation

• In MS Word, these options are used to enhance the appearance of text.
• They are part of Font formatting tools in the Home tab → Font group → Text Effects and Typography.

Additional information:

• Superscript: Raises text above normal line
• Subscript: Lowers text below normal line
• Shadow: Adds shadow behind text
• Outline: Shows text as outlined letters
• Emboss: Makes text appear raised
• Engrave: Makes text appear carved into the page

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

An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Last updated 15-feb-2026

Explanation

• Ctrl + E is the shortcut used to apply center alignment in MS Word.

Additional information:

• Ctrl + L → Left Alignment
• Ctrl + R → Right Alignment
• Ctrl + J → Justify Alignment

Last verified on 06-03-2026