Scribd
Upload
7 views4 pages

Excel Functions and Formulas Exercises

This document provides practical exercises for various Excel functions and formulas, covering basic arithmetic, statistical functions, logical operations, and text manipulation. Each section includes a brief explanation of the function followed by an exercise to apply the concept. The exercises range from simple calculations to more advanced functions like VLOOKUP and filtering data.

Uploaded by

luckynguya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views4 pages

Excel Functions and Formulas Exercises

This document provides practical exercises for various Excel functions and formulas, covering basic arithmetic, statistical functions, logical operations, and text manipulation. Each section includes a brief explanation of the function followed by an exercise to apply the concept. The exercises range from simple calculations to more advanced functions like VLOOKUP and filtering data.

Uploaded by

luckynguya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Excel Functions and Formulas - Practical Exercises

1. Basic Arithmetic Operations

- Use =A1+A2, =A1-A2, =A1*A2, =A1/A2 to perform arithmetic.

Exercise: Enter values in cells A1 and A2. Calculate the sum, difference, product, and quotient.

2. SUM, AVERAGE, MIN, MAX

- =SUM(A1:A10), =AVERAGE(A1:A10), =MIN(A1:A10), =MAX(A1:A10)

Exercise: Create a list of 10 numbers. Find the sum, average, minimum, and maximum.

3. IF Function

- =IF(A1>50, "Pass", "Fail")

Exercise: Check if marks in A1 are greater than 50. Return "Pass" or "Fail".

4. Nested IF

- =IF(A1>=80, "A", IF(A1>=60, "B", "C"))

Exercise: Grade students based on marks in A1.

5. COUNT, COUNTA, COUNTIF, COUNTIFS

- =COUNT(A1:A10), =COUNTA(A1:A10), =COUNTIF(A1:A10, ">50")


Excel Functions and Formulas - Practical Exercises

Exercise: Count how many cells are not empty and how many values are above 50.

6. VLOOKUP and HLOOKUP

- =VLOOKUP(lookup_value, table_array, col_index, FALSE)

- =HLOOKUP(lookup_value, table_array, row_index, FALSE)

Exercise: Create a student table and search for scores using VLOOKUP.

7. CONCATENATE / CONCAT / TEXTJOIN

- =CONCATENATE(A1, " ", B1), =TEXTJOIN(" ", TRUE, A1, B1)

Exercise: Join first and last names in separate cells.

8. LEFT, RIGHT, MID, LEN

- =LEFT(A1, 3), =RIGHT(A1, 2), =MID(A1, 2, 3), =LEN(A1)

Exercise: Extract parts of a string and count characters.

9. TODAY, NOW, DATE, YEAR, MONTH, DAY

- =TODAY(), =NOW(), =DATE(2025,6,1), =YEAR(A1), =MONTH(A1), =DAY(A1)

Exercise: Show the current date, time, and extract year, month, day from a date.
Excel Functions and Formulas - Practical Exercises

10. ROUND, ROUNDUP, ROUNDDOWN

- =ROUND(A1, 1), =ROUNDUP(A1, 1), =ROUNDDOWN(A1, 1)

Exercise: Round numbers to nearest, up, or down to 1 decimal place.

11. TEXT Function

- =TEXT(A1, "dd-mm-yyyy"), =TEXT(A1, "$#,##0.00")

Exercise: Format dates and currency values using TEXT.

12. AND, OR, NOT

- =AND(A1>50, B1<100), =OR(A1>50, B1<100), =NOT(A1>50)

Exercise: Use logical functions to check conditions.

13. IS Functions

- =ISNUMBER(A1), =ISTEXT(A1), =ISBLANK(A1)

Exercise: Test the type of data in cells.

14. INDIRECT, ADDRESS

- =INDIRECT("A"&1), =ADDRESS(1,1)
Excel Functions and Formulas - Practical Exercises

Exercise: Reference cells indirectly using row and column numbers.

15. UNIQUE, SORT, FILTER (Excel 365/2021+)

- =UNIQUE(A1:A10), =SORT(A1:A10), =FILTER(A1:A10, A1:A10>50)

Exercise: Remove duplicates, sort a list, and filter values above 50.

You might also like