Explanation

• Conditional formatting highlights cells automatically based on set conditions or rules (e.g., values greater than 100).
• It helps in quickly analyzing data trends by using colors, icons, or data bars.

Last verified on 02-09-2026

Explanation

• Alt + Tab is used to switch between open applications or windows.
• Hold Alt and press Tab to move through currently open windows.
• It is a useful shortcut for multitasking.

Additional information:

• Alt + F4 — Close the active window
• Windows + Tab — Open Task View
• Ctrl + Tab — Switch between tabs
• Windows + D — Show/Hide desktop

Last verified on 24-08-2026

Explanation

• The CPU (Central Processing Unit) is the brain/heart of the computer.
• It processes data and executes instructions.
• It controls other parts of the system.

Additional information:

• First commercial CPU: Intel 4004 (1971)
• Invented by: Italian physicist Federico Faggin
• CPU Examples: Clock speeds – 3.0 GHz, 3.5 GHz, 4.0 GHz, 4.5 GHz, 5.0 GHz

Last updated by NA on 09-09-2026

Explanation

• The default page orientation in MS Word is Portrait.
• Portrait orientation means the page height is greater than its width.
• This orientation is commonly used for documents, letters, and reports.

Additional information:

• Page orientation can be changed from Layout → Orientation.
• Landscape mode is mainly used for tables and wide content.

Last verified on 17-01-2026

Explanation

• Clip Art consists of ready-made images or illustrations that can be inserted into a document.
• In older versions of MS Word, Clip Art was accessed through Insert → Picture → Clip Art.
• It can be used to make documents more attractive and visually informative.
• Clip Art may include illustrations, symbols, drawings, and decorative images.

Last verified on 10-08-2026

Explanation

• Auto Save is a feature that automatically saves changes to a document at regular intervals.
• It helps reduce the risk of losing unsaved work if the program closes unexpectedly.

Additional information:

• Save manually saves the current document.
• Save As saves the document with a new name, location, or file format.

Last verified on 09-08-2026

Explanation

• Slide Sorter View displays all slides of a presentation as miniature representations (thumbnails).
• It allows users to view, arrange, reorder, copy, and delete slides easily.
• Slide Sorter View is especially useful for managing the overall sequence of a presentation.

Additional information:

• Slide Show displays slides in full-screen presentation mode.
• Outline View mainly displays the text content and structure of slides.

Last verified on 09-08-2026

Explanation

• Page Up: Move the cursor or page up one screen.

Additional information:

• Ctrl + Home: Move to the top of a document.
  
• Ctrl + End: Move to the bottom of a document.
• Page Down: Move the cursor or page down one screen.

Last verified on 09-08-2026

Explanation

• Charles Babbage is credited with designing the first mechanical computer.
• He is widely regarded as the Father of the Computer.
• Difference Engine → Designed in the 1820s
• Analytical Engine → Described in 1837

Additional information:

• Ada Lovelace → Wrote an algorithm for the Analytical Engine
• Alan Turing → Pioneer of theoretical computer science

Last verified on 09-08-2026

Explanation

• Memory (RAM): Temporary, volatile, fast access
• Storage (HDD/SSD): Permanent, non-volatile, slower than RAM
• Example Memory: RAM in computers (4GB, 8GB, 16GB)
• Example Storage: Hard disk, SSD (256GB, 512GB, 1TB)
• Purpose: Memory = active tasks, Storage = long-term data

Last verified on 17-01-2026