BASICS_OF_EXCEL and its formulas to calculate Examples.
- 1. V BCom Basics of excel
- 2. Basics of Excel Statistical Functions Math function, Statistical Functions, Text Functions, Logical Functions plotting data in graph form, different types of graph , formatting graph (giving professional look to the graph)
- 3. Statistical Functions These are some most common and useful functions. These include the COUNT function, COUNTA function, COUNTBLANK function, COUNTIFS function. Lets discuss one by one:
- 7. 4. COUNTIFS function COUNTIFS function is the most used function in Excel. The function will work on one or more than one condition in a given range and counts the cell that meets the condition.
- 8. Mathematical Function in Excel SUM AVERAGE AVERAGEIF MOD ROUND
- 9. 1. SUM
- 10. 2. Sumif
- 11. SUMIF
- 15. Ans
- 19. 3. TEXT FUNCTION
- 20. Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail.