Explanation

• To split windows or document panes into two in applications like Excel or Word, use the View > Window > Split menu option.
• This command divides the active document window into separate

Explanation

Explanation

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026

Explanation

• CTRL + H is the shortcut key used in most software (like MS Word, Excel) to open the Find and Replace dialog box.
• It allows users to search for a word or phrase and replace it with another.

Additional information:

• CTRL + F: Only opens the Find dialog
• CTRL + G: Opens the Go To dialog
• CTRL + R: Aligns text to the right in word processors

Last verified on 12-03-2026

Explanation

• Machine Language is the lowest-level computer language, written entirely in binary code (0s and 1s).
• It is directly understood by the computer’s CPU without any translation.
• All higher-level languages (like C, Pascal, Basic) are converted into machine language before execution.

Last verified on 12-03-2026

Explanation

• LED (Light Emitting Diode) is a semiconductor device that emits light when electric current passes through it.
• It is widely used in lighting, displays, electronic indicators, and screens.

Additional information:

• Energy efficiency: Up to 90% more efficient than traditional bulbs
  First discovery: H. J. Round – 1907
  Early research: Oleg Losev – 1927
  Practical LED development: James R. Biard – 1961
  First commercial production: October 1962 (Nick Holonyak)

Last verified on 12-03-2026

Explanation

• In presentation software (like MS PowerPoint), special effects used to introduce slides are called Transitions.
• Transitions control how one slide moves to the next during a presentation.
• They can be simple fades, wipes, pushes, or dynamic animations to make the presentation more engaging.

Last verified on 11-03-2026

Explanation

• In MS Excel, to sum values in a range based on a condition, the SUMIF() function is used.
• It allows you to add only the numbers that meet a specific criterion, such as all sales above 1000 or only a certain category.
• This is different from SUM(), which adds all numbers in a range without any condition.

Last verified on 11-03-2026

Explanation

• In MS Excel, a pre-programmed formula is called a Function.
• Functions perform specific calculations or tasks automatically, such as SUM, AVERAGE, or IF.
• They save time by automating repetitive formulas and reducing errors.

Last verified on 11-03-2026

Explanation

• In MS Excel, different functions are used to handle dates and times.
• To display the current date and time, the NOW() function is used.

Additional information:

• DATE() – Returns a date based on year, month, and day
• TODAY() – Returns today’s date only
• TIME() – Constructs a specific time from hours, minutes, and seconds

Last verified on 11-03-2026