Explanation

• Alt + Shift + F1 / Shift + F11 → Insert a new worksheet

Additional information:

• Shift + F10 → Open shortcut/context menu
• Ctrl + Page Up → Previous worksheet
• Ctrl + Page Down → Next worksheet

Last verified on 15-07-2026

Explanation

• A Cell is the intersection of a row and a column in a spreadsheet such as MS Excel.
• Each cell has a unique cell address, such as A1, B5, or C10.
• Rows are identified by numbers: 1, 2, 3, ...
• Columns are identified by letters: A, B, C, ...
• A cell can contain text, numbers, formulas, or functions.

Last verified on 09-08-2026

Explanation

Formula=SUM(AB:BC)

- SUM: Adds numbers.

- AB:BC: Selects all columns from AB to BC.

Explanation

Microsoft Excel Shortcut Keys

- Ctrl + H: Find and Replace

- Ctrl + F: Find text or data

- Ctrl + G: Go To a specific cell or range

- Ctrl + P: Print worksheet or workbook

Last updated on 26 Oct 2026

Explanation

• The formula to calculate the total of cells B2 to B10 in Excel is =SUM(B2:B10)
• SUM: The built-in Excel function used to add numbers.
• B2:B10: The continuous cell range from row 2 to row 10 in column B..
• Purpose: Calculates the total.

Last updated on 26 Oct 2026