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