Explanation

• The active cell is the currently selected cell in a spreadsheet.
• It is usually highlighted with a heavy/thick border.
• Data entered from the keyboard is placed into the active cell.
• Only one cell is normally active at a time.

Last verified on 26-08-2026

Explanation

• In Excel, pressing Enter normally moves the active cell down one row.
• If the current cell is B4, pressing Enter moves the selection to B5.
• This is the default behavior unless the Enter key direction has been changed in Excel settings.

Last verified on 26-08-2026

Explanation

• The keyboard shortcut to select an entire row in Microsoft Excel is Shift + Spacebar.
• This command selects all cells in the current active row.
• For highlighting a column, CTRL+space is used.

Last updated by NS on 06 May 2026

Explanation

• Pencil work is not an element of the spreadsheet interface.
• Active Cell, Menu Bar, and Workbook are associated with a spreadsheet environment.
• The Active Cell is the currently selected cell where data can be entered or edited.
• A Workbook is an Excel file containing one or more worksheets.

Last verified on 26-08-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

• “Monthly Wages” and “Final Approval Rating” are descriptive text entries.
• In a spreadsheet, such text is called a Label.
• Labels are used to identify or describe data in cells.

Additional information:

• A value is usually a number.
• A formula performs a calculation.

Last verified on 25-08-2026

Explanation

• Microsoft Excel is the spreadsheet program in the Microsoft Office Suite.
• It is used for calculations, data entry, analysis, tables, and charts.
• Excel organizes data into rows and columns.
• It supports formulas and functions for performing calculations.

Last verified on 25-08-2026

Explanation

• The Excel SORT function has 4 arguments in its full syntax.
• Syntax: SORT(array, [sort_index], [sort_order], [by_col])
• Only the array argument is required.
• The other three arguments are optional.

Last verified on 25-08-2026

Explanation

• Ctrl + 1 opens the Format Cells dialog box in MS Excel.
• It provides options for Number, Alignment, Font, Border, Fill, and Protection.
• It is a useful shortcut for quickly formatting selected cells.

Additional information:

• Ctrl + 5 — Strikethrough
• Ctrl + 6 — Show/Hide objects
• Ctrl + F10 — Maximize/restore active window

Last verified on 25-08-2026

Explanation

• CAD Chart is not a standard MS Excel chart type.
• Bar Chart is a standard Excel chart type.
• Waterfall Chart is also available in modern versions of Excel.
• Scatter Chart is a standard Excel chart type.

Last verified on 24-08-2026