[go: up one dir, main page]
Scribd
Upload
19 views1 page

Excel Notes With Formulas

This document provides a list of common formulas used in MS Excel, including SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, IF, SQRT, ROUND, and CONCATENATE. Each formula is accompanied by an example for clarity. It serves as a quick reference guide for users looking to perform basic calculations and data manipulation in Excel.

Uploaded by

taniatariq21
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
19 views1 page

Excel Notes With Formulas

This document provides a list of common formulas used in MS Excel, including SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, IF, SQRT, ROUND, and CONCATENATE. Each formula is accompanied by an example for clarity. It serves as a quick reference guide for users looking to perform basic calculations and data manipulation in Excel.

Uploaded by

taniatariq21
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
You are on page 1/ 1

MS Excel Notes with Formulas

Q1. What is the formula for sum in MS Excel?


The formula is =SUM(range). Example: =SUM(A1:A5)

Q2. What is the formula for average in Excel?


The formula is =AVERAGE(range). Example: =AVERAGE(B1:B10)

Q3. How to find the maximum value?


Use =MAX(range). Example: =MAX(C1:C20)

Q4. How to find the minimum value?


Use =MIN(range). Example: =MIN(D1:D10)

Q5. How to count numeric values?


Use =COUNT(range). Example: =COUNT(E1:E15)

Q6. How to count all filled cells?


Use =COUNTA(range). Example: =COUNTA(F1:F20)

Q7. How to use IF function?


Use =IF(condition, value_if_true, value_if_false). Example: =IF(A1>50, "Pass", "Fail")

Q8. How to find square root?


Use =SQRT(number). Example: =SQRT(144)

Q9. How to round numbers?


Use =ROUND(number, num_digits). Example: =ROUND(3.14159, 2)

Q10. How to concatenate text?


Use =CONCATENATE(text1, text2, ...). Example: =CONCATENATE("Hello", " ", "World") or
=TEXTJOIN(" ", TRUE, A1:A3)

You might also like