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