Question

Functions in Excel are grouped for easy reference. Locate the Insert Function button (Fx button) to bring up the Insert Function dialog box. How many different ways exist to look for a function? What are they? Select one of these functions and provide information on what it does and what it needs to work properly. Make sure you choose a unique function.

Answer 1

Following are the different ways that exist to look for a function

Option 1: Insert function button (Fx button) on the Formulas ribbon.

Option 2 : More Functions from arrow near Auto sum icon on Home ribbon.

Option 3: Function Library on the Formulas ribbon.

Option 4: Shift + F3

Option 5: Enter = followed by first letter of the function.

"NETWORKDAYS.INTL"

What it does -

This function returns the number of whole working days between two dates with custom weekend parameters.

What it needs -

1. Start date, End date, Weekend (Optional), Holidays(Optional)

2. If start date later than end date, then value will be negative.

3. Enter date in specified format.

Example : NETWORKDAYS.INTL(DATE(2020,1,1),DATE(2020,12,31),1,0) will give 262 days.