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

Explanation

The Miraj event took place on the 27th of Rajab in the 10th (621 A.D) year of Prophethood.

Prophet Muhammad (SAW) was staying at the house of Umm Hani on the night of Miraj.

That night, Angel Jibreel came to the Prophet (SAW) and took him on the journey of Israa and Miraj.

During Miraj, Hazrat Adam and Hazrat Muhammad (SAW) met at the first heaven.

The event is mentioned in Surah Bani Israel.

It is also known as 'Isra and Mi'raj' or 'Shab-e-Meraj'. 

• Isra: Night journey from Makkah to Masjid Al-Aqsa.
• Mi’raj: Journey from Masjid Al-Aqsa to the heavens.

Gifts of the 27th of Rajab:

• The five prescribed daily prayers.
• The last part of the chapter of Al-Baqara (Amanar-Rasulu).

Last verified on 07-03-2026