0
0

MS Excel — Basic Functions & Formulas

Introduction

MS Excel is widely used for calculations, data analysis, and record maintenance in banks, offices, and businesses. Questions on basic functions and formulas test your ability to work with numbers efficiently using Excel’s built-in tools.

This pattern is one of the most frequently asked areas in Computer Aptitude because it reflects real-life spreadsheet usage.

Pattern: MS Excel — Basic Functions & Formulas

Pattern

The key idea is to identify the correct Excel function or formula used to perform simple calculations like addition, averaging, counting, and finding maximum or minimum values.

Step-by-Step Example

Question

Which MS Excel function is used to calculate the average of numbers in cells A1 to A5?

  • A. SUM(A1:A5)
  • B. COUNT(A1:A5)
  • C. AVERAGE(A1:A5)
  • D. MAX(A1:A5)

Solution

  1. Step 1: Understand the calculation requirement

    The task is to find the average (mean) of values stored in cells A1 to A5.

  2. Step 2: Recall common Excel functions

    • SUM() → Adds values
    • COUNT() → Counts numeric cells
    • AVERAGE() → Calculates mean value
    • MAX() → Finds highest value

  3. Step 3: Match the requirement with the correct function

    To calculate the mean, Excel uses the AVERAGE() function.

  4. Final Answer:

    AVERAGE(A1:A5) → Option C

  5. Quick Check:

    AVERAGE adds all values and divides by the count automatically ✅

Quick Variations

• Adding values in cells → SUM()

• Counting numeric entries → COUNT()

• Finding highest value → MAX()

• Finding lowest value → MIN()

• Simple addition → =A1+B1

Trick to Always Use

  • Step 1 → Identify what is asked: total, average, count, highest, or lowest.
  • Step 2 → Match keywords:
    • Total / Sum → SUM()
    • Average / Mean → AVERAGE()
    • How many numbers → COUNT()
    • Highest → MAX()
    • Lowest → MIN()

Summary

Summary

  • Basic Excel functions handle everyday numerical calculations.
  • SUM, AVERAGE, COUNT, MAX, and MIN are the most tested functions.
  • Functions always start with an equals sign (=).
  • Cell ranges are written using a colon (e.g., A1:A5).

Example to remember:
Total → SUM | Mean → AVERAGE | Highest → MAX | Lowest → MIN

Practice

(1/5)
1. Which MS Excel function is used to add all the numeric values present in cells B1 to B10?
easy
A. SUM(B1:B10)
B. COUNT(B1:B10)
C. AVERAGE(B1:B10)
D. MAX(B1:B10)

Solution

  1. Step 1: Identify the requirement

    The task is to add all numeric values in the given range.

  2. Step 2: Recall Excel functions

    SUM() is used to calculate the total of values.

  3. Final Answer:

    SUM(B1:B10) → Option A.

  4. Quick Check:

    SUM adds all values in the selected cells automatically ✅
Hint: Total of numbers always means SUM().
Common Mistakes: Choosing AVERAGE instead of calculating total.
2. Which MS Excel function counts only the numeric entries in a selected range of cells?
easy
A. COUNTA()
B. COUNT()
C. SUM()
D. MIN()

Solution

  1. Step 1: Understand what needs to be counted

    The question specifies counting numeric values only.

  2. Step 2: Match with Excel counting functions

    COUNT() counts cells that contain numbers.

  3. Final Answer:

    COUNT() → Option B.

  4. Quick Check:

    Text cells are ignored by COUNT() ✅
Hint: Numbers only = COUNT().
Common Mistakes: Confusing COUNT() with COUNTA().
3. Which MS Excel function is used to find the largest value from cells C1 to C8?
easy
A. MIN(C1:C8)
B. AVERAGE(C1:C8)
C. MAX(C1:C8)
D. SUM(C1:C8)

Solution

  1. Step 1: Identify the requirement

    The task is to find the highest value.

  2. Step 2: Recall comparison functions

    MAX() returns the largest number in a range.

  3. Final Answer:

    MAX(C1:C8) → Option C.

  4. Quick Check:

    MAX always outputs the greatest numeric value ✅
Hint: Highest value = MAX().
Common Mistakes: Choosing SUM instead of MAX.
4. Which MS Excel function is used to determine the smallest value in a range of cells?
medium
A. MAX()
B. AVERAGE()
C. COUNT()
D. MIN()

Solution

  1. Step 1: Understand the comparison requirement

    The task is to find the lowest value.

  2. Step 2: Match with correct function

    MIN() returns the smallest number.

  3. Final Answer:

    MIN() → Option D.

  4. Quick Check:

    MIN compares all values and selects the smallest ✅
Hint: Lowest number = MIN().
Common Mistakes: Selecting MAX instead of MIN.
5. Which MS Excel formula correctly adds the values in cell A1 and B1?
medium
A. =SUM(A1,B1)
B. =A1+B1
C. =ADD(A1:B1)
D. =TOTAL(A1,B1)

Solution

  1. Step 1: Identify the operation

    The task is to add two specific cells.

  2. Step 2: Recall basic Excel formulas

    Excel allows direct arithmetic using + operator.

  3. Final Answer:

    =A1+B1 → Option B.

  4. Quick Check:

    The + operator performs direct addition in Excel ✅
Hint: Two-cell addition = A1 + B1.
Common Mistakes: Using non-existent functions like ADD or TOTAL.

Mock Test

Ready for a challenge?

Take a 10-minute AI-powered test with 10 questions (Easy-Medium-Hard mix) and get instant SWOT analysis of your performance!

10 Questions
5 Minutes