In LibreOffice Calc and Microsoft Excel, you can perform basic calculations such as addition, subtraction, multiplication, and division directly in cells using formulas. Here’s a quick guide on how to use these operations.

 1. Addition (`+`)
   - Formula: `=A1 + B1`
   - Example: If A1 contains `10` and B1 contains `5`, then:
     =A1 + B1
     
     Result would be: `15`

 2. Subtraction (`-`)
   - Formula: `=A1 - B1`
   - Example: If A1 contains `10` and B1 contains `5`, then:
     =A1 - B1
     
     Result is: `5`

 3. Multiplication (``)
   - Formula: `=A1  B1`
   - Example: If A1 contains `10` and B1 contains `5`, then:
     =A1  B1
     
     Result: `50`

 4. Division (`/`)
   - Formula: `=A1 / B1`
   - Example: If A1 contains `10` and B1 contains `5`, then:
     =A1 / B1
     Result: `2`

 5. Exponentiation (`^`)
   - Formula: `=A1 ^ B1`
   - Example: If A1 contains `3` and B1 contains `2`, then:
     =A1 ^ B1
       Result: `9` (3 raised to the power of 2)

 6. Using the SUM Function for Adding Multiple Cells
   - Formula: `=SUM(A1:A5)`
   - Example: If cells A1 through A5 contain `1`, `2`, `3`, `4`, and `5`, then:
     =SUM(A1:A5)
     
     Result: `15`

 Additional Tips
- Start every formula with an `=` sign so Excel or Calc knows you’re entering a formula.
- Combining Operations: You can combine multiple operations in one formula. For example:
  excel
  =(A1 + B1)  C1
  
This will add A1 and B1 and then multiply the result by C1.