Skip to content

📘 Formulas & Functions in Excel

🔹 What is a Formula?

A formula is a user‑defined expression that performs calculations using cell references, constants, and operators.
Example: =A1 + B1 adds values in cells A1 and B1.

🔹 What is a Function?

A function is a predefined, built‑in operation in Excel that simplifies complex calculations.
Example: =SUM(A1:A10) adds all values from A1 to A10.

⚖️ Difference Between Formula and Function

Aspect Formula Function
Definition User‑created expression Predefined operation
Flexibility Customizable, but manual Ready‑made, efficient
Example =A1 + B1 * C1 =AVERAGE(A1:A10)
Ease of Use Requires knowledge of operators Simplifies complex tasks

🚀 How Functions Overcome Limitations of Formulas

  • Efficiency: Functions handle repetitive or complex tasks quickly.
  • Error Reduction: Functions reduce manual errors in long formulas.
  • Advanced Operations: Functions perform tasks formulas alone cannot (e.g., =STDEV(), =LEN(), =IF()).
  • Scalability: Functions adapt easily to ranges and large datasets.

🔢 Operators Used in Formulas

OperatorMeaningExample
+Addition=A1 + B1
-Subtraction=A1 - B1
*Multiplication=A1 * B1
/Division=A1 / B1
^Exponentiation=A1 ^ 2
%Percentage=A1 * 10%
=Equal to=A1 = B1
<>Not equal to=A1 <> B1
>Greater than=A1 > B1
<Less than=A1 < B1
>=Greater than or equal to=A1 >= B1
<=Less than or equal to=A1 <= B1
&Text concatenation=A1 & B1

📝 Practice Questions

Part A: Formulas

  1. Write a formula to calculate the total cost if Quantity = B2 and Price = C2.
  2. Create a formula to find the square of a number in cell A5.
  3. Write a formula to calculate the percentage increase from A1 to B1.

Part B: Functions

  1. Use a function to calculate the average marks of students listed in cells B2:B11.
  2. Write a function to find the maximum sales value from cells C2:C20.
  3. Use a function to count how many cells in D2:D15 contain numbers.
  4. Apply the IF function: If sales in cell E2 are greater than 5000, return “Target Achieved”, otherwise “Target Not Met”.

Part C: Mixed

  1. Combine formula and function: Calculate the total sales in column F, then add a fixed bonus of 1000.
  2. Use concatenation (&) with a function: Display student name (A2) with their average marks (AVERAGE(B2:D2)).