Scribd
Upload
16 views2 pages

Essential Excel Functions Guide

The document provides a list of basic Excel functions along with their descriptions and examples. Functions include SUM, AVERAGE, MAX, MIN, COUNT, IF, AND, OR, and text manipulation functions like CONCATENATE and TRIM. Each function is accompanied by a brief explanation and a sample formula for clarity.

Uploaded by

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

Essential Excel Functions Guide

The document provides a list of basic Excel functions along with their descriptions and examples. Functions include SUM, AVERAGE, MAX, MIN, COUNT, IF, AND, OR, and text manipulation functions like CONCATENATE and TRIM. Each function is accompanied by a brief explanation and a sample formula for clarity.

Uploaded by

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

Lab 1

Basic Excel Functions

1. SUM()
o Adds a range of numbers.
o Example: =SUM(A1:A5)
2. AVERAGE()
o Calculates the mean of numbers.
o Example: =AVERAGE(B2:B6)
3. MAX()
o Returns the maximum value.
o Example: =MAX(C1:C10)
4. MIN()
o Returns the minimum value.
o Example: =MIN(D1:D10)
5. COUNT()
o Counts the number of numeric entries in a range.
o Example: =COUNT(E1:E10)
6. COUNTA()
o Counts the number of non-empty cells (both text and numbers).
o Example: =COUNTA(F1:F10)
7. IF()
o Conditional function returning different outputs based on condition.
o Example: =IF(G1>50, "Pass", "Fail")
8. AND()
o Checks if all conditions are TRUE.
o Example: =AND(H1>40, H2>40)
9. OR()
o Checks if any condition is TRUE.
o Example: =OR(I1>40, I2>40)
10. NOT()
o Reverses the logical value.
o Example: =NOT(J1>50)
11. LEN()
o Counts the number of characters in a cell.
o Example: =LEN(K1)
12. LEFT()
o Extracts characters from the left.
o Example: =LEFT(L1,3)
13. RIGHT()
o Extracts characters from the right.
o Example: =RIGHT(M1,2)
14. MID()
o Extracts characters from the middle.
o Example: =MID(N1,2,3)
15. CONCATENATE() or CONCAT()
o Joins two or more strings.
o Example: =CONCAT(O1," ",P1)
16. TRIM()
o Removes extra spaces.
o Example: =TRIM(Q1)
17. UPPER()
o Converts text to uppercase.
o Example: =UPPER(R1)
18. LOWER()
o Converts text to lowercase.
o Example: =LOWER(S1)
19. PROPER()
o Capitalizes first letter of each word.
o Example: =PROPER(T1)
20. NOW()
o Returns current date and time.
o Example: =NOW()
21. TODAY()
o Returns current date.
o Example: =TODAY()

You might also like