Explanation

• B2:B6 in MS Excel represents a range of cells.
• B2 is the starting cell, while B6 is the ending cell.
• The range includes B2, B3, B4, B5, and B6.
• All these cells are located in Column B.
• A colon : is used in Excel to indicate a range of cells.

Last verified on 08-08-2026

Explanation

• Numeric values are right-aligned by default in MS Excel.
• This makes numbers easier to read and compare in columns.
• Text values are left-aligned by default.
• Users can change the alignment manually if needed.

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

• Charts in MS Excel are added from the Insert tab.
• The Insert tab contains the Charts group for creating different chart types.
• Users can create Column, Bar, Line, Pie, Area, Scatter, and other charts.
• Charts help present data visually for easier analysis.

Last verified on 27-07-2026

Explanation

=AVERAGE(B1:B5)

• Calculates the average of range B1 to B5.
• Alternative: =SUM(B1:B5)/5.

Last updated 24-07-2026 by NA

Explanation

• Pressing F11 instantly creates a chart from the selected data on a separate chart sheet.
• First, select the data range, then press F11 to generate the default chart.

Additional information:

• F1 → Open Help
• F2 → Edit the active cell
• F4 → Repeat the last action / Toggle absolute references in formulas
• Alt + F1 → Create a chart embedded in the current worksheet

Last verified on 23-07-2026

Explanation

• The formula =AVERAGE(B1:B5) calculates the arithmetic mean (average) of the values in cells B1 to B5.

Additional information:

• SUM() → Adds values
• MAX() → Returns the largest value
• MIN() → Returns the smallest value
• COUNT() → Counts numeric cells

Last verified on 23-07-2026

Explanation

• The correct formula to add values in Excel is =SUM(A1:A2).
• The SUM function adds numbers from the selected cell range.
• Excel formulas always begin with the =` (equal) sign.
• A1:A2 means all cells from A1 to A2.

Last verified on 14-07-2026

Explanation

• Pressing the Alt key alone does not edit the contents of a cell.
• The Alt key is mainly used to access the Ribbon shortcuts and menu commands.
• In MS Excel, you can edit a cell by double-clicking the cell, pressing F2, or clicking in the Formula Bar.

Last verified on 21-07-2026

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