Explanation

• FR in government file management stands for Further Reference.
• It indicates that the file should be kept for future consultation or reference.
• Such files may be needed again for administrative, legal, or policy purposes.
• The notation helps officials classify and preserve important records.

Last verified on 08-07-2026

Explanation

• PDF/A is a special version of PDF designed for long-term archival preservation of electronic documents.
• It ensures that documents remain readable and unchanged for many years.
• PDF/A embeds all required fonts and does not rely on external content.
• It is widely used by governments, libraries, courts, and archives.

Last verified on 08-07-2026

Explanation

• HLOOKUP searches for a value in the first horizontal row of a table and returns a value from a specified row in the same column.
• The "H" in HLOOKUP stands for Horizontal.
• It is used when data is arranged across rows instead of down columns.
• HLOOKUP is useful for looking up values in horizontally organized tables.

Additional information:

• VLOOKUP → Searches in a vertical (first) column

Last verified on 08-07-2026

Explanation

• SOP stands for Standard Operating Procedure.
• It is a written document that provides step-by-step instructions for performing routine tasks consistently and correctly.
• SOPs improve efficiency, quality, safety, and accountability in organizations.
• They help employees follow the same standard process.

Last verified on 08-07-2026

Explanation

• Cross-reference in MS Word is used to link to another part of the same document.
• It creates references to headings, figures, tables, footnotes, bookmarks, and numbered items.
• Cross-references update automatically when the referenced item changes.
• It is especially useful in long reports, research papers, and books.
• It helps readers quickly navigate within the document.

Last verified on 08-07-2026

Explanation

• Demi-Official (D.O.) letters are written in the first person with a personal tone.
• They are used between government officers to discuss official matters in a friendly and informal manner.
• A D.O. letter helps speed up action on important official issues.

Last verified on 08-07-2026

Explanation

• Phishing is a cybercrime where fake emails, messages, or websites are used to steal sensitive information like passwords or bank details.
• It tricks users into believing the message is from a trusted source.
• Criminals often use social media, email, or SMS for phishing attacks.
• The main goal is identity theft or financial fraud.

Last verified on 21-06-2026

Explanation

• COUNTA() counts only non-empty cells in a selected range.
• It counts cells containing numbers, text, logical values (TRUE/FALSE), errors, and formulas that return values.
• It does not count completely empty cells.
• COUNTA() is commonly used for counting filled entries in datasets.

Additional information:

• COUNT() → Counts only numeric cells
• COUNTBLANK() → Counts empty (blank) cells
• COUNTIF() → Counts cells matching a specific condition
• COUNTIFS() → Counts cells matching multiple conditions

Last verified 08-07-2026

Explanation

• The Indian Ocean lies between Africa and Australia.
• It is the third-largest ocean in the world.
• The Indian Ocean is bordered by Africa, Asia, Australia, and Antarctica.
• Area: About 70.56 million km²
• Deepest Point: Java (Sunda) Trench – about 7,258 meters

Last verified on 08-07-2026

Explanation

• The Paris Agreement (2015) is an international treaty on climate change.
• Adopted: 12 December 2015
• Effective Date: 4 November 2016
• Adopted at: Paris, France (COP21)
• Framework: United Nations Framework Convention on Climate Change (UNFCCC)
• Members/Parties: About 195 Parties (194 countries + the European Union)

Last verified on 08-07-2026