point out 10 formulas in microsoft excel, and mention each of them in detail
Answers
Answer:
Seven Basic Excel Formulas For Your Workflow
=SUM(number1, [number2], …) ...
=SUM(A2:A8) – A simple selection that sums the values of a column.
=SUM(A2:A8)/20 – Shows you can also turn your function into a formula. ...
=AVERAGE(number1, [number2], …) ...
=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)
Explanation:
Microsoft Excel formulas with examples
Excel provides formulas for almost anything, and there exist tens or even hundreds of different functions in modern versions of Microsoft Excel. So, if you encounter a task for which you cannot work out a solution, most likely you are missing out on a formula that can do it for you. Before spending hours and hours on performing manual calculations, take a few minutes to review the following resources. It is a selection of the most popular MS Excel formulas with examples, grouped by categories.
Excel percentage formula
How to calculate percentage in Excel - a few examples of percentage formula for Excel such as calculating percentage of total, calculating percent change (percentage increase formula), formula to calculate amount and total by percentage, and more.
Compound interest formula in Excel - shows how to calculate daily, monthly, and yearly compounding.
Excel sum formulas
How to sum a column in Excel - 5 ways to sum a column in Excel.
SUMIF formula in Excel - formula examples to conditionally sum cells.
SUMIFS formulas in Excel - sum formula to add up cells based on more than one criteria.
Excel SUM in array formulas - how to use the SUM function in array formulas to add up values with multiple AND criteria.
Count formula in Excel
Excel formula to count cells with text
Formula to count blank cells (COUNTBLANK)
Another formula to count blank and not blank cells (COUNTIF)
COUNTIF formula in Excel - formula examples to conditionally count cells based on exact and partial match, count duplicates and unique values, and more.
COUNTIFS formula in Excel - count cells with multiple criteria.
Average formula in Excel
How to calculate average in Excel - formula examples of AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS functions.
Calculating moving average in Excel - formula examples to calculate a simple moving average in Excel for the last N days, weeks, months or years.
Weighted average formula in Excel - two easy ways to calculate weighted average in Excel, by using the SUM and SUMPRODUCT functions.
Excel date formulas
How to convert text to date in Excel - a handful of formulas to convert text to date.
How to convert Excel date to text - formula to cover a date to a text string in a specified format.
Excel DATE formula examples - how to get a serial number representing a date, add and subtract dates in Excel, return a date based on values in other cells, convert a text string to a date, plus a few advanced Excel DATE formula examples.
Formulas to calculate days in Excel (WEEKDAY, DAY functions) - date formulas to return a day of week from date, get the number of days in the year, find how many days are between two dates and more.
How to calculate months in Excel (MONTH and EOMONTH functions) - examples of Excel date formula to extract month from date, get the first and last day of the month, convert month name to number and more.
Calculating week number in Excel (WEEKNUM function) - how to use date formulas in Excel to get week number from date, convert week number to date, get a week number in a month, sum values by week number, and more.
How to add and subtract dates in Excel - date formulas to add and subtract days, weeks, months and years.
How to calculate difference between two dates (DATEDIF function) - Excel date formula to calculate difference between two dates in days, weeks, months or years.
Calculating weekdays in Excel (WORKDAY and NETWORKDAYS) - using date formula in Excel to calculate workdays with custom weekend parameters and holidays.
Convert date to year & calculate age from date of birth - Excel age formulas, and a few other date formulas to extract year from date, convert date to month and year, determine leap years.
Time formulas in Excel
How to use NOW and TIME functions to insert time - formula examples to insert today's date and time in Excel as a dynamic automatically updatable value and static unchangeable timestamp.
Convert time to decimal number, hours, minutes or seconds - variety of formulas to change time to decimal number, hours, minutes or seconds, convert text to time and vice versa.
How to calculate time in Excel - a few formulas to add and subtract times, calculate time difference, elapsed time, and more.