Question

write the different types of Excel formulas​

Answer 1

Answer:

The basics of Excel formulas

Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

Formula is an expression that calculates values in a cell or in a range of cells.

For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.

Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)

You can find all available Excel functions in the Function Library on the Formulas Tab:

Answer 2

Explanation:

1. VLOOKUP( )

VLOOKUP is a smart function that looks for a given value in a MS Excel table and returns the corresponding entry without much ado. Whether you need to know more about the product name that has an ID= pO76908, or a student named “Henry”, VLOOKUP would search it for you.

Syntax for VLOOKUP

=VLOOKUP (“Po76908”, product, 5, true)

=VLOOKUP (value being searched, table, column number, whether table is sorted or not)

2. SHEET( )

Microsoft’s Excel's SHEET( ) function helps managers find the number of the referenced sheet with the help of a single argument, which is the name of the sheet in question.

In case the reference is omitted, the SHEET ( ) the number of the sheet is returned.

If a valid sheet name is not given as reference, #REF! error is returned.

In case there is no sheet by the reference name, even though it is a valid name construct, #N/A error is returned.

Suggested read - Eight Useful Microsoft Excel Shortcuts That You Should Know

3. WORKDAY ( ) / NETWORKDAYS ( )

Simple as it may sound, while handling multiple projects, project managers often find it difficult to ascertain the start or end date of a project stage, or find out the number of workdays to be assigned for a particular job.

WORKDAY ( ) : It finds the end date after taking the no: of working days and start date as inputs.

NETWORKDAYS ( ) : Finds out the number of working days between the given dates (with Saturday and Sunday being taken as a weekend or non-working days.)

Thank you!

Please follow me