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