Explanation

• Name: Shirin Ebadi
• Country: Iran
• Award: Nobel Peace Prize
• Year: 2003
• Recognition: Human rights and democracy

Last verified on 02-09-2026

Explanation

• Referencing means referring to or retrieving data from another cell or worksheet.
• In Excel, a reference to another sheet can be written as =Sheet2!A1.
• This allows data from one worksheet to be used in another worksheet.
• It is especially useful for linking related data across multiple sheets.

There are Three types of Cell reference in Excel.

1. Relative
2. Absolute
3. Mixed

Last verified on 26-08-2026

Explanation

• Shortcut Key: Ctrl + Enter
• Ribbon Path: Layout → Breaks → Page
• Purpose: Start a new page
• Works In: Microsoft Word
• Type: Manual Page Break

Last verified on 03-04-2026

Explanation

• Type: Operating System (Unix-like)
• Kernel Released: 17 September 1991
• Developer: Linus Torvalds
• License: Open-source (GNU General Public License)
• Common Distributions: Ubuntu, Debian, Fedora, Red Hat, Linux Mint

Last verified on 10-07-2026

Explanation

Turkmenistan Capital is Ashgabat.

Turkmenistan Currency is Turkmen New Manat.

Turkmenistan official language is Turkmen; Russian.

Turkmenistan located is in Continent Asia.

Turkmenistan Primary Religion is Islam.

Turkmenistan Head of Govt. is President – Serdar Berdimuhamedow.

Turkmenistan Parliament called Mejlis.

Last verified on 16-06-2026

Explanation

• Purpose: Prevents text from being hidden in the binding
• Location: Can be added to left or top depending on binding type
• Adjustable in: Layout > Margins > Custom Margins > Gutter

Explanation

• In MS Excel 2016, a Column Chart displays data as vertical bars.
• It is especially useful for comparing values across categories clearly.
• Column charts make it easy to visualize differences and trends at a glance.

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

• In MS Excel, the shortcut Ctrl + Shift + & is used to apply an outline border to selected cells.

Additional information:

• Ctrl + Shift + _ → Remove outline border
• Ctrl + Shift + $ → Apply currency format
• Ctrl + Shift + % → Apply percentage format
• Ctrl + Shift + # → Apply date format

Last verified on 06-03-2026

Explanation

The most suitable and primary reason to use Macros in MS Office (Word, Excel, PowerPoint) is to automate repetitive tasks

Last updated 15-feb-2026