LET function for named calculations in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to assign the value 10 to the name 'x' using LET.

Excel

=LET(x, [1], x + 5)

Drag options to blanks, or click blank then click option'

A10

Bx

C15

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'x' instead of a number for the value

Assigning 5 instead of 10

The LET function assigns 10 to the name 'x'. Then it adds 5 to 'x', resulting in 15.

2fill in blank

medium

Complete the LET formula to calculate the area of a rectangle with length 8 and width 3.

Excel

=LET(length, 8, width, [1], length * width)

Drag options to blanks, or click blank then click option'

A5

B3

C11

Dlength

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong number for width

Using 'length' instead of a number

The width is assigned the value 3. The formula multiplies length (8) by width (3) to get 24.

3fill in blank

hard

Fix the error in the LET formula to correctly calculate the average of 4 and 6.

Excel

=LET(a, 4, b, 6, ([1] + b) / 2)

Drag options to blanks, or click blank then click option'

A6

Bb

C4

Da

Attempts:

3 left

💡 Hint

Common Mistakes

Using the number 4 directly instead of the name 'a'

Using 'b' twice in the formula

The formula uses 'a' and 'b' as names for 4 and 6. Using 'a' in the calculation fixes the error.

4fill in blank

hard

Fill both blanks to create a LET formula that calculates the perimeter of a rectangle with length 7 and width 2.

Excel

=LET([1], 7, [2], 2, 2 * (length + width))

Drag options to blanks, or click blank then click option'

Alength

Bperimeter

Cwidth

Darea

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'perimeter' or 'area' as variable names instead of 'length' and 'width'

Swapping length and width names

The names 'length' and 'width' are assigned 7 and 2 respectively. The formula calculates perimeter as 2*(length + width).

5fill in blank

hard

Fill all three blanks to create a LET formula that calculates the total cost with price 15, quantity 4, and tax rate 0.1.

Excel

=LET([1], 15, [2], 4, [3], 0.1, price * quantity * (1 + tax))

Drag options to blanks, or click blank then click option'

Aprice

Bquantity

Ctax

Dcost

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'cost' as a name instead of price, quantity, or tax

Mixing up the order of names

The names 'price', 'quantity', and 'tax' are assigned 15, 4, and 0.1 respectively. The formula calculates total cost including tax.