Microsoft Excel 2021365 - Beginner to Advanced - Finding the st Value

The video tutorial explains how to create a formula in Excel to determine the closest guess to the number of sweets in a jar, using functions like ABS, INDEX, and MATCH. It also covers how to evaluate formulas and create an exact match formula for precise guessing.

What is the main objective of the game described in the video?

• To find the closest guess to the actual number of sweets.

• To guess the exact number of sweets in the jar.

• To guess the number of sweets based on the jar's size.

• To guess the number of sweets without any formula.

What does the ABS function return?

• The negative value of a number.

• The square root of a number.

• The absolute value of a number, always positive.

• The percentage value of a number.

Why is the ABS function important in the formula?

• It converts percentages to decimals.

• It ensures all values are positive for accurate comparison.

• It calculates the average of the guesses.

• It helps in formatting the numbers.

Which function is used to find the closest guess to the actual number?

• SUM

• VLOOKUP

• AVERAGE

• INDEX and MATCH

What is the role of the MIN function in the formula?

• To calculate the average difference.

• To find the minimum difference between the actual number and guesses.

• To find the maximum difference.

• To sum up all the differences.

How does the formula change if the winner must guess the exact number?

• It uses a simple INDEX and MATCH for an exact match.

• It uses a COUNTIF function to count exact matches.

• It uses a SUM function to add all guesses.

• It uses a VLOOKUP function for exact match.

Who is declared the winner when the exact number of sweets is guessed?

• Ming

• Sarah

• Vin

• John