Protected Learning Content

AICPE Gurukul content is created for learning purposes. Printing, copying and unauthorized reuse are restricted.

AICPE Learning Hub MS Office Applications
Chapter 16
Excel Formulas and Basic Calculations
Previous Data Entry and Cell Formatting in Excel Next Excel Functions: SUM, AVERAGE, MIN, MAX and COUNT
Chapter 16 | Excel Calculation Skills

Excel Formulas & Basic Calculations

Formulas are the real power of Excel. In this chapter, you will learn how to perform addition, subtraction, multiplication, division, balance calculation, AutoSum and basic formula-based reports.

Start Learning Practice Task

Formula Rule

Every Excel formula starts with an equal sign.

Operators

Use +, -, *, / for basic calculations.

Cell Reference

Use cell addresses such as A1, B2 and C5 in formulas.

AutoSum

Quickly calculate total of selected values.

Learning Objectives

After This Chapter, You Will Be Able To

This chapter helps you calculate values in Excel accurately.

Create Formula

Write formulas beginning with equal sign.

Use Operators

Use addition, subtraction, multiplication and division.

Use References

Calculate using cell references instead of fixed values.

Use AutoSum

Quickly calculate totals using AutoSum and SUM function.

Simple Meaning

What is an Excel Formula?

A formula is an instruction that tells Excel to calculate something.

1 Easy Explanation

A formula in Excel is used to perform calculations automatically. It can add, subtract, multiply, divide or calculate totals using cell values. Every formula begins with an equal sign.

Definition: An Excel formula is an expression that starts with = and performs calculation using values, operators and cell references.
Professional Tip: Use cell references like C2-D2 instead of typing values manually. This makes formulas update automatically when data changes.
fee-calculation.xlsx Formula Mode
E2
=C2-D2
ABCDE
1NameCourseTotal FeePaidBalance
2AmitMS Office50003000=C2-D2
3PriyaExcel40004000=C3-D3
Calculation Operators

Basic Operators Used in Excel

Operators are symbols used to perform calculations.

+

Addition

Adds values. Example: =A1+B1

-

Subtraction

Subtracts values. Example: =C2-D2

*

Multiplication

Multiplies values. Example: =A2*B2

/

Division

Divides values. Example: =A2/B2

Remember: Excel uses * for multiplication and / for division.
Cell References

Using Cell References in Formulas

Cell references make formulas flexible and automatic.

2 Why Use Cell References?

Instead of typing =5000-3000, write =C2-D2. If the value in C2 or D2 changes, Excel will automatically update the result.

Cell Reference: A cell address used in a formula, such as A1, B2, C10 or D5.

3 Practical Examples

  • =C2-D2 calculates balance fee.
  • =B2*C2 calculates quantity × rate.
  • =D2/12 calculates monthly value.
  • =A2+B2+C2 adds three cell values.
  • =SUM(C2:C10) calculates total of a range.
AutoSum

Using AutoSum for Quick Total

AutoSum helps calculate totals quickly without typing the full formula manually.

Step Action Example
Step 1 Select the cell where total should appear Select C8
Step 2 Click AutoSum button Home tab → AutoSum
Step 3 Check the selected range =SUM(C2:C7)
Step 4 Press Enter Total appears automatically
Professional Tip: Always check the selected range before pressing Enter after AutoSum.
Basic Functions

Common Calculation Functions

Functions are ready-made formulas in Excel.

Function Use Example
SUM Adds values =SUM(C2:C10)
AVERAGE Finds average value =AVERAGE(C2:C10)
MIN Finds lowest value =MIN(C2:C10)
MAX Finds highest value =MAX(C2:C10)
COUNT Counts numeric values =COUNT(C2:C10)
Before and After

Example: Fee Balance Calculation

Formulas make fee records faster and more accurate.

Manual Calculation

Amit: Total Fee 5000, Paid 3000, Balance 2000.
Priya: Total Fee 4000, Paid 4000, Balance 0.
Rahul: Total Fee 3000, Paid 1500, Balance 1500.

Problem: Every value is calculated manually.

Formula-Based Calculation

Name Total Fee Paid Balance Formula Balance
Amit 5000 3000 =B2-C2 2000
Priya 4000 4000 =B3-C3 0
Rahul 3000 1500 =B4-C4 1500
Total Balance 3500
Interactive Demo

Try Basic Calculations

Click buttons to see formula examples and results.

Formula Example

Select any calculation above to see the formula and result.

Practical Task

Create a Fee Calculation Sheet

Complete these steps inside MS Excel.

Office Task: Formula-Based Fee Record

Common Mistakes

Mistakes Students Should Avoid

Formula mistakes can create wrong reports, so accuracy is important.

Wrong Habits

  • Forgetting to start formula with = sign.
  • Typing values manually instead of using cell references.
  • Using x instead of * for multiplication.
  • Using wrong cell address in formulas.
  • Not checking AutoSum selected range.
  • Copying formulas without checking results.

Correct Habits

  • Always start formulas with = sign.
  • Use cell references for automatic calculation.
  • Use * for multiplication and / for division.
  • Check cell addresses carefully.
  • Verify selected range before using AutoSum.
  • Review final results after copying formulas.
Remember: A small formula mistake can affect the complete report. Always check formulas and results.
Test Your Understanding

Quick Quiz

Select the correct answers and check your score.

1. Every Excel formula starts with:

Every Excel formula starts with the equal sign.

2. Which operator is used for multiplication in Excel?

Excel uses * for multiplication.

3. Which operator is used for division?

Excel uses / for division.

4. Formula =C2-D2 is commonly used to:

=C2-D2 subtracts the value in D2 from the value in C2.

5. Cell reference means:

A cell reference is a cell address such as A1 or C2 used in formulas.

6. AutoSum is mainly used to:

AutoSum quickly calculates the total of a selected range.

7. Function =SUM(C2:C10) is used to:

SUM adds the values in the selected range.

8. Which function finds the highest value?

MAX finds the highest value in a range.

9. Which is a formula mistake?

Using the wrong cell address gives wrong formula results.

10. Best formula habit is:

Using cell references and checking results makes calculations reliable.
Quick Revision

Remember These Points

Revise these before moving to Chapter 17.

Formula

An Excel calculation expression that starts with equal sign.

Operators

Use + for addition, - for subtraction, * for multiplication and / for division.

Cell Reference

Cell address used in formulas, such as A1, B2 or C10.

AutoSum

Quickly calculates total of selected values.

Basic Functions

SUM, AVERAGE, MIN, MAX and COUNT are common calculation functions.

Next Step

Now learn Excel functions in more detail.

Previous Chapter Next Chapter: Excel Functions