Course Content

Course Content

Other Common Functions In MS Excel

How are other Common Functions useful

 

MS Excel consists of 450 formulas feature pre installed in it.

Now we will see that how we can check that any particular function exist or not. For that we can search any function by its name and if it is existing, and it will be shown in the list that appears.

There are different functions like rank, which is used to give rank for particular selected cells.

When we want to count the number of cells in a range that are not empty, we use Count function, we can use it by typing '=count(__)'.

Now if we want to calculate median, we can use the medium function and select the cells for which we want to perform this function.

We can also insert function in Excel, we can do that by going into FORMULA'S tab and clicking on the insert function icon.

In MS Excel there are different functions which we can perform according to our requirement.

FAQs

The other common functions in MS Excel are the following:

  • SUM: Adds up the numbers in a list of cells.
  • AVERAGE: Averages values, for example, to calculate the average of a list of numbers.
  • MAX: Finds the largest value in a list of numbers.
  • MIN: Finds the smallest value in a list of numbers.
  • IF: This function is used to do calculations based on conditions you specify, such as "IF cell A1 has a value greater than 5".

  • SUM Function.
  • Count Function.
  • CountA Function.
  • LEN Function.
  • TRIM Function.
  • RIGHT, LEFT, and MID Function.
  • VLOOKUP.
  • IF Statements.

Despite the fact that every Excel feature has a use case, no one uses every Excel feature. After sifting through the 500+ functions, there are only about 100 or so actually useful features and functions for the majority of current knowledge workers.

Budgeting, creating graphs and charts, and storing and categorising data are the three most popular general purposes for spreadsheet software. Spreadsheet software is used in the corporate world to anticipate future performance, calculate taxes, do basic payroll, create charts, and compute revenues.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere