Microsoft Excel All Formulas. Excel sheet formulas,

-

 


Microsoft Excel is a powerful spreadsheet software that allows users to perform various calculations, data analysis, and create charts and graphs. Here are some of the basic formulas and functions in Excel, along with their descriptions:

1.                       SUM:

·         Description: Adds the values of a range of cells.

·         Formula: =SUM(number1, [number2], ...)

2.                       AVERAGE:

·         Description: Calculates the average of a range of cells.

·         Formula: =AVERAGE(number1, [number2], ...)

3.                       COUNT:

·         Description: Counts the number of cells containing numeric values in a range.

·         Formula: =COUNT(value1, [value2], ...)

4.                       MAX:

·         Description: Returns the highest value in a range of cells.

·         Formula: =MAX(number1, [number2], ...)

5.                       MIN:

·         Description: Returns the lowest value in a range of cells.

·         Formula: =MIN(number1, [number2], ...)

6.                       IF:

·         Description: Checks if a condition is true or false and returns different results based on the evaluation.

·         Formula: =IF(logical_test, value_if_true, value_if_false)

7.                       VLOOKUP:

·         Description: Searches for a value in the first column of a table array and returns a corresponding value from another column.

·         Formula: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

8.                       HLOOKUP:

·         Description: Searches for a value in the first row of a table array and returns a corresponding value from another row.

·         Formula: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

9.                       CONCATENATE:

·         Description: Joins multiple text strings together.

·         Formula: =CONCATENATE(text1, [text2], ...)

10.               LEN:

·         Description: Returns the number of characters in a cell or text string.

·         Formula: =LEN(text)

11.               LEFT/RIGHT/MID:

·         Description: Extracts a specified number of characters from the left, right, or middle of a text string, respectively.

·         Formula: =LEFT(text, num_chars), =RIGHT(text, num_chars), =MID(text, start_num, num_chars)

12.               DATE:

·         Description: Creates a date using the year, month, and day values provided.

·         Formula: =DATE(year, month, day)

13.               NOW:

·         Description: Returns the current date and time.

·         Formula: =NOW()

14.                       TODAY:

·         Description: Returns the current date.

·         Formula: =TODAY()

15.                       ROUND:

·         Description: Rounds a number to a specified number of decimal places.

·         Formula: =ROUND(number, num_digits)

These are just a few of the many formulas and functions available in Microsoft Excel. Excel provides a wide range of capabilities for data manipulation, analysis, and reporting, making it a valuable tool for various tasks, from simple calculations to complex data modeling.

Top of Form

 

Comments

Post a Comment

Popular posts from this blog

World as a global village: Leering to live together

-
Image
  World as a global village: Leering to live together World as a global village Defining Globalization Globalization is the international integration of people, companies and governments of different nations through exchange of world views, products, ideas and other aspects of a culture. It marginalizes geographical boundaries and creates a highly integrated world. With the introduction of technologies like steam locomotives, engines, telecommunications and most recently internet ones, the world has reached a new level of interdependence of economic and cultural activities. Of the many factors leading to the idea of Globalization some include, demographic changes, improvement in communications and transportation technologies, capitalism and a shift towards economic liberalization, deregulation and privatization.   Impact of globalization Institutionalized or otherwise, 'Globalization has multidimensional impact on the lives of people all across the globe. It influenc...
Read more

The education system in Pakistan, like in many other countries, is designed to provide formal education to its population and equip students with the necessary knowledge and skills for their future endeavors, #AIOU

-
Image
  The education system in Pakistan, like in many other countries, is designed to provide formal education to its population and equip students with the necessary knowledge and skills for their future endeavors. However, there are differences between the education system in Pakistan and those in various parts of the world. Here are some key points of comparison:   1.     Structure and Levels of Education : ·          Pakistan: The education system in Pakistan typically consists of three main levels - primary education (grades 1 to 5/8), secondary education (grades 6/9 to 10/11), and higher secondary education (grades 11/12). After that, students can pursue higher education at colleges or universities. ·          World: Education systems in different countries can vary significantly, but most follow a similar structure of primary, secondary, and higher education. However, the duration ...
Read more
-
Image
  Microsoft PowerPoint is a powerful presentation software that allows users to create and deliver visually engaging slideshows. It offers a wide range of features and functionalities to help you design effective presentations. Here's a step-by-step guide on how to make the most of PowerPoint for a complete presentation:   1.     Creating a New Presentation : ·          Open PowerPoint and click on "New Presentation" to start a new slideshow. ·          Choose a design theme or create a custom design by selecting "Blank Presentation." 2.     Slide Layout : ·          Choose the appropriate slide layout for each slide (title slide, content slide, image slide, etc.). ·          To change the layout, go to the "Home" tab and click on "Layout." 3.     Adding Content : ·  ...
Read more