Tables (Insert Table) and benefits in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a table from data range A1 to D10.

Excel

ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:D10"), , [1]).Name = "MyTable"

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

AxlTable

BxlNo

CxlYes

DxlRange

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlNo when the range has headers causes wrong table setup.

Use xlYes to indicate the range has headers when inserting a table.

2fill in blank

medium

Complete the formula to reference the entire 'Sales' table in Excel.

Excel

='Sales'[1]

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

A[#Totals]

B[#Data]

C[#Headers]

D[#All]

Attempts:

3 left

💡 Hint

Common Mistakes

Using [#Data] excludes headers and totals.

The [#All] specifier references the whole table including headers and totals.

3fill in blank

hard

Fix the error in the formula to sum the 'Amount' column in the 'Expenses' table.

Excel

=SUM(Expenses[1][Amount])

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

A[#Data]

B[#All]

C[[Amount]]

D[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using [[Amount]] causes syntax error.

Using [Amount] alone is incorrect syntax.

Use [#Data] to sum only the data rows in the 'Amount' column, excluding headers and totals.

4fill in blank

hard

Fill both blanks to create a table from range B2 to E15 with headers.

Excel

ActiveSheet.ListObjects.Add([1], Range("B2:E15"), , [2]).Name = "DataTable"

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

AxlSrcRange

BxlSrcExternal

CxlYes

DxlNo

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlSrcExternal when data is from a range.

Using xlNo when headers exist.

Use xlSrcRange to specify a range source and xlYes to indicate headers exist.

5fill in blank

hard

Fill all three blanks to create a dictionary of word lengths for words longer than 4 letters.

Excel

{ [1]: [2] for [3] in words if len([3]) > 4 }

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

Aword

Blen(word)

Dlen(words)

Attempts:

3 left

💡 Hint

Common Mistakes

Using len(words) instead of len(word).

Using inconsistent variable names.

This dictionary comprehension maps each word to its length if the word is longer than 4 letters.