Q.1 What are the functions in Excel ?
Q.2 Write about Sum and Autosum Function ?
Q.3 What does Average Function do?
Q.4 What is MAX,MIN function ?
Topic- function of excel
Answers
Explanation:
1.Excel Functions That Make Work Easier
The SUM Function. The sum function is the most used function when it comes to computing data on Excel. ...
The TEXT Function. Text function is a useful tool that helps convert a date (or number) into a text string in a particular format. ...
The VLOOKUP Function. ...
The AVERAGE Function. ...
The CONCATENATE Function.
2.sum function....You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
autosum function...AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range.
3.The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text.
4.The Microsoft Excel MAX function returns the largest value from the numbers provided.
The Microsoft Excel MIN function returns the smallest value from the numbers provided.
Plz mark me brainliest
prish123 is right.............