Explanation

• Bluetooth is a short-range wireless technology used for exchanging data between devices.

Bluetooth Classes and Ranges:

• Class 1 → 100 m (~328 ft)
• Class 2 → 10 m (~30 ft) most common
• Class 3 → 1 m (~3 ft)

Last verified on 07-03-2026

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 PowerPoint, the Rehearse Timing feature allows you to record the time spent on each slide.
• This helps in automatic slide advancement during presentations.

Additional information:

• Location: Slide Show → Rehearse Timings
• Function: Records time per slide and saves it

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

• Mail Merge in MS Word 2016 is used to create multiple documents automatically using a data source.
• It helps send letters, labels, or envelopes to many recipients at once.

Four main Mail Merge document types:

• Form Letters
• Envelopes
• Mailing Labels
• Catalogue (Directory)

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