Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - work with the LET function

This video tutorial covers advanced Excel formulas, focusing on the Let and Lambda functions. It begins with an introduction to these functions, followed by a practical exercise using the Let function to create variable names for filtering data. The tutorial then shifts to the Lambda function, demonstrating how to create a Count IFS formula. Finally, it guides viewers through creating a custom function using Lambda, testing it to ensure it works correctly.

Which two new Excel formulas are introduced in this section?

• Sum and Average

• IF and COUNTIF

• Let and Lambda

• VLOOKUP and HLOOKUP

What is the primary purpose of the Let function in Excel?

• To perform mathematical operations

• To sort data

• To define variable names for ranges

• To create charts

In the Let function exercise, which city is used as a filter criterion?

• Tokyo

• New York

• Paris

• London

What does the Count IFS formula allow you to do?

• Average cells with multiple criteria

• Sum cells with a single criterion

• Count cells with a single criterion

• Count cells with multiple criteria

Which company name is used in the Count IFS example?

• Excel Ltd

• Micro World

• Tech Corp

• Data Inc

What is the first step in creating a Lambda function?

• Test the function

• Define the output

• Write the formula

• Specify parameters or variables

What is the final step in creating a custom function using Lambda?

• Create a chart

• Export the data

• Save the workbook

• Test the function in a cell

What is the name of the custom function created from the Lambda?

• Filter Sales Data

• Sum Team Sales

• Count Company Sales

• Calculate Sales

Which Excel feature is used to manage custom functions?

• Data Validation

• Name Manager

• Conditional Formatting

• Pivot Table

What is the result of the custom function when tested?

• 5

• 3

• 2

• 4