MSK Institute • Shikohabad
Loading Page Content...
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Connecting serverPlease wait...
💻 Practical Labs🚀 Free Demo📜 Verified Certificates
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Before diving into complex multi-variable functions, mastering basic arithmetic operations and understanding mathematical operator precedence (order of operations) is essential for building accurate financial forecasts, invoices, and budgets.
Excel uses standard keyboard arithmetic operators:
| Operator | Math Operation | Example Formula | Result |
|---|---|---|---|
| + | Addition | =A2 + B2 | Sum of two cells |
| - | Subtraction | =A2 - B2 | Difference between two cells |
| ***** | Multiplication | =A2 * B2 | Product of two cells |
| / | Division | =A2 / B2 | Quotient of two cells |
| ^ | Exponentiation (Power) | =A2 ^ 2 | Squares the value in A2 |
| % | Percentage Operator | =A2 * 18% | Computes 18% of A2 |
When combining multiple arithmetic operators in a single formula, Excel evaluates them in a strict mathematical hierarchy:
() are evaluated first.^).Imagine calculating the total bill for 2 shirts at $30 each plus a $5 shipping fee:
=30 + 5 * 25 * 2 = 10, then adds 30 + 10 = 40. Wrong answer!=(30 + 5) * 230 + 5 = 35, then multiplies 35 * 2 = 70. Correct answer!Instead of manually typing cell addresses like "C14" and risking typos:
=.A2 with your mouse (Excel automatically writes "A2" and highlights it in blue).B2 (Excel automatically writes "B2" and highlights it in red).By default, Excel shows the numerical results of formulas on the grid. To verify all calculations across your entire worksheet simultaneously:
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
| Previous Lesson | Next Lesson |
|---|---|
| Understanding Formula Bar | AutoSum and Status Bar Calculations |
Test your understanding of this lesson with 5 questions. Each question has one correct answer.