Scribd
Upload
4 views3 pages

Excel Practical Functions Guide

The document provides a comprehensive list of practical Excel functions and features organized into sections including basic functions, formatting, logical functions, data analysis, lookup functions, date functions, and additional practical questions. Each section contains specific formulas and instructions for performing various tasks in Excel. This resource serves as a quick reference guide for users to enhance their Excel skills.

Uploaded by

mphatsolukhele707
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
4 views3 pages

Excel Practical Functions Guide

The document provides a comprehensive list of practical Excel functions and features organized into sections including basic functions, formatting, logical functions, data analysis, lookup functions, date functions, and additional practical questions. Each section contains specific formulas and instructions for performing various tasks in Excel. This resource serves as a quick reference guide for users to enhance their Excel skills.

Uploaded by

mphatsolukhele707
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

EXPANDED EXCEL PRACTICAL QUESTIONS AND ANSWERS

SECTION A: BASIC FUNCTIONS


1. Sum:
=SUM(B2:B10)

2. Count numbers:
=COUNT(A1:A20)

3. Count text:
=COUNTIF(C:C,"Paid")

4. Average:
=AVERAGE(D2:D12)

5. Maximum:
=MAX(B2:B30)

6. Minimum:
=MIN(B2:B30)

SECTION B: FORMATTING & DATA HANDLING


7. Percentage:
=45/60

8. Sort data:
Home → Sort & Filter → A to Z

9. Filter records:
Home → Filter → choose condition

10. Merge cells:


Home → Merge & Center

11. Wrap text:


Home → Wrap Text

12. Freeze top row:


View → Freeze Top Row

SECTION C: LOGICAL & MATH FUNCTIONS


13. IF function:
=IF(B2>=50,"Pass","Fail")

14. Nested IF:


=IF(B2>=75,"Distinction",IF(B2>=50,"Pass","Fail"))

15. Discount price:


=B2 - (B2*C2)

16. VAT:
=B2*0.16

17. Absolute reference:


$B$2

SECTION D: DATA ANALYSIS


18. Create table:
Insert → Table

19. Remove duplicates:


Data → Remove Duplicates

20. Insert chart:


Insert → Column Chart

21. Count empty cells:


=COUNTBLANK(A1:A50)

22. Count non-empty cells:


=COUNTA(A1:A50)

SECTION E: LOOKUP FUNCTIONS


23. VLOOKUP example:
=VLOOKUP(A2, D2:F20, 2, FALSE)

24. HLOOKUP example:


=HLOOKUP(A2, B1:F5, 3, FALSE)

25. XLOOKUP example:


=XLOOKUP(A2, D2:D20, E2:E20)

SECTION F: DATE FUNCTIONS


26. Today:
=TODAY()

27. Now:
=NOW()

28. Add days:


=TODAY()+7

29. Calculate age:


=DATEDIF(B2, TODAY(), "Y")

SECTION G: EXTRA PRACTICAL QUESTIONS


30. Convert text to uppercase:
=UPPER(A2)

31. Convert text to lowercase:


=LOWER(A2)

32. Join text:


=CONCAT(A2," ",B2)

33. Remove spaces:


=TRIM(A2)

34. Round number:


=ROUND(B2,2)

You might also like