PivotTable layouts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the PivotTable layout to Tabular form.

Excel

pivotTable.RowAxisLayout [1] xlTabularRow

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

A.

B:

C=

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot (.) instead of equals (=) causes syntax errors.

Using colon (:) or plus (+) is invalid for assignment.

In Excel VBA, to assign a layout to a PivotTable, use the assignment operator =.

2fill in blank

medium

Complete the code to set the PivotTable layout to Outline form.

Excel

pivotTable.RowAxisLayout [1] xlOutlineRow

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

A+

B=

C:

D.

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot (.) instead of equals (=) causes errors.

Using colon (:) or plus (+) is invalid here.

The assignment operator = is used to set the PivotTable layout property.

3fill in blank

hard

Fix the error in the code to set the PivotTable layout to Compact form.

Excel

pivotTable.RowAxisLayout [1] xlCompactRow

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

A+

B:

C.

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot (.) instead of equals (=) causes syntax errors.

Using colon (:) or plus (+) is invalid.

The correct operator to assign a value is =. Using other symbols causes errors.

4fill in blank

hard

Fill both blanks to create a PivotTable and set its layout to Tabular form.

Excel

Set pivotTable = worksheet.PivotTables([1])
pivotTable.RowAxisLayout [2] xlTabularRow

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

A"SalesPivot"

B=

C.

D"DataPivot"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting quotes around the PivotTable name.

Using dot (.) instead of equals (=) for assignment.

First, specify the PivotTable name as a string with quotes. Then use = to assign the layout.

5fill in blank

hard

Fill all three blanks to create a PivotTable, set its layout to Outline form, and refresh it.

Excel

Set pivotTable = worksheet.PivotTables([1])
pivotTable.RowAxisLayout [2] xlOutlineRow
pivotTable.[3]

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

A"SummaryPivot"

B=

CRefreshTable

DRefresh

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect method name like RefreshTable.

Forgetting quotes around the PivotTable name.

Using dot (.) instead of equals (=) for assignment.

Use the PivotTable name as a string, assign the layout with =, and call the Refresh method to update the PivotTable.