explain any five functions in excel
Answers
5 Powerful Excel Functions That Make Work Easier
- 5 Powerful Excel Functions That Make Work EasierThe SUM Function. The sum function is the most used function when it comes to computing data on Excel. ...
- 5 Powerful Excel Functions That Make Work EasierThe 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. ...
- 5 Powerful Excel Functions That Make Work EasierThe 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. ...
- 5 Powerful Excel Functions That Make Work EasierThe 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. ...
- 5 Powerful Excel Functions That Make Work EasierThe 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.
The functions are conditional formatting, Vlook up, Pivot table etc.
- The functions in excel can be explained as -
1. Conditional formatting
It allows the user to add unique formatting to spreadsheet cells matching specified requirements. The data's patterns and trends may become more apparent with its usage.
2. Vlookup
It helps to pull out the exact pieces of information that are required. For example in a sheet having a restaurant menu, it can be used to figure out vegetarian dishes
3. Pivot table
A dataset may be summarised in a number of different ways, which is helpful. This method will mechanically import all information from an entire table without any breaks.
4. Text to column
Using this method, data may be easily divided into numerous columns according to predetermined parameters. It may break text using a space or a comma or a dash.
5. Concatenate Formula
It is possible to merge the contents of various cells using this amazingly simple method.
#SPJ2