Explanation

• =SUM(A1:A10) is the formula used to calculate the sum of cells A1 through A10.
• The SUM function adds values in a specified range of cells.
• It is one of the most commonly used spreadsheet functions.
• The colon (:) indicates a continuous range of cells.
• It works in spreadsheet software like Excel and Google Sheets.

Last verified on 08-06-2026

Explanation

• Charles Babbage's computer was called the Analytical Engine.
• He was an English mathematician, inventor, and mechanical engineer.
• He designed the Analytical Engine, a general-purpose mechanical computer concept.
• Babbage worked on the Analytical Engine during the 19th century until his death in 1871.
• The Analytical Engine was designed to perform calculations and follow programmed instructions.
• Charles Babbage is widely known as the “Father of the Computer.”

Last verified on 10-08-2026

Explanation

• The thin black cross-shaped pointer in MS Excel is used to complete lists and fill patterns.
• It is known as the Fill Handle.
• The Fill Handle appears at the bottom-right corner of the selected cell.
• Dragging it can automatically fill adjacent cells with data, formulas, numbers, dates, or patterns.
• It can extend sequences such as 1, 2, 3, 4... or Monday, Tuesday, Wednesday...
• It saves time by automatically completing repetitive data.

Last verified on 10-08-2026

Explanation

• Data, sort is used for arranging data in ascending/descending order in MS Excel.
• Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).
• Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

Last verified on 10-08-2026

Explanation

• Shift + Enter inserts a manual line break in MS Word without starting a new paragraph.
• It moves the cursor to the next line while keeping the text within the same paragraph.

Additional information:

• Enter: Starts a new paragraph.
• Ctrl + Enter: Page break.

Last verified on 09-08-2026

Explanation

• The first or main page of a website is commonly called the Homepage.
• It usually provides an overview of the website and links to other important pages.
• The homepage is often the default or starting page visitors see when they visit a website.

Additional information:

• Webpage → A single page on a website
• Website → Collection of related webpages
• URL → Address of a webpage or website
• Web browser → Software used to access websites

Last verified on 09-08-2026

Explanation

• Slide Sorter View main purpose is to rearrange, move, copy, delete, or organize slides easily.
• Its in PowerPoint displays all slides as small thumbnails on one screen.
• It is especially useful for checking the overall sequence and structure of a presentation.
• It can also help manage slide transitions across multiple slides.

Last verified on 09-08-2026

Explanation

• 1 billion bytes = 1 Gigabyte (GB).

Additional information:

• 1 GB = 1,000,000,000 bytes (10⁹ bytes).
• 1 MB = 1,000,000 bytes (10⁶ bytes).
• 1 TB = 1,000,000,000,000 bytes (10¹² bytes).

Last verified on 09-08-2026

Explanation

• GUI stands for Graphical User Interface.
• It is a type of user interface that allows users to interact with electronic devices using icons, windows, menus, and buttons instead of typing commands.
• The first GUI was developed at Xerox PARC in the early 1980s.

Additional information:

• CLI – Command Line Interface
• CUI – Character User Interface
• VUI – Voice User Interface
• NUI – Natural User Interface

Last verified on 03-07-2026

Explanation

• Ctrl + F is the shortcut key used to search/find text within a document in MS Word 2016.
• It opens the Navigation Pane, where you can type the word or phrase you want to find.

Additional information:

• Ctrl + H: Find and Replace.
• Ctrl + S: Save the document.
• Ctrl + O: Open an existing document.
• Ctrl + N: Create a new document.

Last verified on 09-08-2026