| 1. |
What According To You Are The Top 5 Functions In Excel? |
|
Answer» While there are 450+ functions in Excel and there is no SET criterion to SELECT the top FIVE, here are the ones I believe are worthy:
I have CHOSEN the above functions as these are not very basic and are quite useful for someone who does analysis in Excel. You can also consider the following functions - SUMPRODUCT, TEXT, SUM, AVERAGE, and LEN/LEFT/RIGHT/MID. Again, there is no right or wrong answer to this. Just make sure you know the functions that you mention. While there are 450+ functions in Excel and there is no set criterion to select the top five, here are the ones I believe are worthy: I have chosen the above functions as these are not very basic and are quite useful for someone who does analysis in Excel. You can also consider the following functions - SUMPRODUCT, TEXT, SUM, AVERAGE, and LEN/LEFT/RIGHT/MID. Again, there is no right or wrong answer to this. Just make sure you know the functions that you mention. |
|