Explanation

• PowerPoint is used for Create presentations from scratch or a template.
• Add text, images, art, and videos.
• Select a professional design with PowerPoint Designer.

Last verified on 03-04-2026

Explanation

• Ctrl + N shortcut key is used to create a new, blank document
• Save Document: Ctrl + SO
• Open Document: Ctrl + O
• Print Document: Ctrl + P (or Ctrl+F2 for Preview)
• Undo/Redo: Ctrl + Z (Undo),Ctrl + Y (Redo)
• Bold/Italic/Underline: Ctrl + B, Ctrl + I, Ctrl + U
• Center Alignment: Ctrl + E
• Insert Hyperlink: Ctrl + K
• Find/Replace: Ctrl + F (Find), Ctrl + H (Replace)

Last updated question by NA on 07 May 2026

Explanation

• The dollar sign ($) is used to create an absolute cell reference in MS Excel.

Additional information:

• Absolute Reference: $D$2 (Row and column fixed)
• Relative Reference: D2 (Row and column change)
• Mixed Reference: $D2 (Column fixed)
• Mixed Reference: D$2 (Row fixed)
• Shortcut Key: F4 toggles between reference types.

Last verified on 18-07-2026

Explanation

• LCD = Liquid Crystal Display
• LCD is a flat-panel display technology.
• It is used in televisions, computer monitors, smartphones, calculators, and other electronic devices.
• It uses liquid crystals to control light and produce images.

Last verified on 07-09-2026

Explanation

• Ctrl + A: Select All

Additional information:

• Ctrl + C: Copy
• Ctrl + V: Paste
• Ctrl + X: Cut
• Ctrl + Z: Undo

Last verified on 02-07-2026

Explanation

In MS Word, the default alignment for a paragraph is Left (or Left-aligned)

This setting aligns text along the left margin, leaving the right edge ragged

Shortcut: Ctrl+L 

Last updated by NA 15-feb-2026

Explanation

• Ctrl + Shift + D applies double underline to selected text in MS Word.

Additional information:

• Ctrl + U — Single underline
• Ctrl + Shift + W — Underline words only
• Ctrl + B — Bold
• Ctrl + I — Italic

Last verified on 25-08-2026

Explanation

• To add the values in A1 and A2, enter =A1+A2.
• In Excel, the plus (+) operator is used to add values from cells.
• Excel calculates the result automatically.
• The SUM function can also be used: =SUM(A1,A2).

Last verified on 24-08-2026

Explanation

• In MS Word, Header and Footer options are found in the Insert tab.
• Go to the Insert tab on the top ribbon.
• Look for the Header & Footer group.
• Click on Header or Footer to pick a design or create your own

Last updated 07-09-2026 by NA

Explanation

• The =NOW() function in MS Excel returns the current date and time.
• It is updated automatically whenever the worksheet is opened or calculations are performed.

Additional information:

• =TODAY() - returns the current date (without time)
• =YEAR() - returns the year from a given date
• =MONTH() - returns the month from a given date
• =DAY() - returns the day from a given date
• =HOUR() - returns the hour from a given time
• =MINUTE() - returns the minute from a given time
• =SECOND() - returns the second from a given time

Last verified on 10-08-2026