What are the basic formulas in excel?



What are the basic formulas in excel?..

Answer / Vivek Pandey

The basic formulas in Excel include:
- SUM (n SUM(A1:A5) calculates the sum of a rangen)
- AVERAGE (AVERAGE(B1:B5) calculates the average of a rangen)
- MIN (MIN(C1:C5) finds the minimum value in a rangen)
- MAX (MAX(D1:D5) finds the maximum value in a rangen)
- COUNT (COUNT(E1:E5) counts cells with numbers in a rangen)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the formula for count in excel?

1 Answers  


How do I get rid of div o error in excel?

1 Answers  


Can I just buy excel without office?

1 Answers  


How do you check a value in a range in excel?

1 Answers  


How do you split first word in excel?

1 Answers  


What is the formula in excel to subtract multiple cells?

1 Answers  


Why a database is better than a spreadsheet?

1 Answers  


How do you put a formula in a spreadsheet?

1 Answers  


How do I get rid of bold lines in excel?

1 Answers  


What is index match used for?

1 Answers  


How do you color code in excel?

1 Answers  


Can you do a lookup in excel?

1 Answers  


Categories