Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Item

The video tutorial explains the difference between calculated fields and calculated items in Excel pivot tables. It provides a step-by-step guide on how to create a calculated item, using the example of calculating the percentage of total profit for the product 'Royal Oak'. The tutorial also covers formatting issues and how to apply percentage formatting to calculated items. Additionally, it explains how to delete calculated items and fields from a pivot table.

What is the main difference between calculated fields and calculated items in pivot tables?

• Calculated fields can only be used with numerical data.

• Calculated items are used for formatting purposes only.

• Calculated fields are more complex than calculated items.

• Calculated fields use fields in calculations, while calculated items use items within fields.

In the example provided, what is the purpose of using a calculated item for the product 'Royal Oak'?

• To calculate the total sales of Royal Oak.

• To find the average sales price of Royal Oak.

• To determine the percentage of total profit that Royal Oak accounts for.

• To compare Royal Oak's sales with other products.

What is the first step in creating a calculated item for a specific product?

• Select the product field and click on 'Calculated Item'.

• Select the product field and click on 'Calculated Field'.

• Select the country field and click on 'Calculated Item'.

• Select the region field and click on 'Calculated Field'.

Why did the calculated item initially display a value of 0?

• The number formatting was not applied.

• The pivot table was not refreshed.

• The formula was incorrect.

• The data source was missing.

What is a simple way to apply percentage formatting to all calculated items at once?

• Refresh the pivot table to apply formatting.

• Drag the country field beneath the product field and format them together.

• Use a macro to automate the process.

• Manually format each item individually.

What should you do if you want to delete a calculated item from a pivot table?

• Refresh the pivot table to remove it.

• Remove it directly from the pivot table.

• Select it from the drop-down in 'Fields, Items and Sets' and click delete.

• Clear all data from the pivot table.

Why is it important to refresh the pivot table after making changes to the original data?

• To save the changes permanently.

• To ensure the pivot table reflects the updated data.

• To apply new formatting styles.

• To delete unnecessary fields automatically.