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

The video tutorial explains how to use calculated fields in pivot tables. It starts with an introduction to calculated fields, followed by a demonstration of removing and adding fields. The tutorial then guides viewers through creating a calculated field, including naming and formula construction. It also covers formatting calculated fields and calculating average profit over 12 months. Finally, it introduces a method to represent values using symbols for positive and negative numbers.

What is the primary purpose of a calculated field in a pivot table?

• To create charts

• To format existing fields

• To perform calculations using existing field headers

• To add new data sources

When creating a calculated field for sales tax, what is the first step?

• Constructing the formula

• Formatting the field

• Selecting the data source

• Naming the calculated field

What is a limitation when constructing formulas in calculated fields?

• You cannot use cell references

• You cannot use field headers

• You cannot use more than one field

• You cannot perform arithmetic operations

How can you format a calculated field to match another column?

• By using the default format

• By applying custom formatting

• By changing the data source

• By renaming the field

What calculation is used to find the average profit over 12 months?

• Profit minus 12

• Profit plus 12

• Profit divided by 12

• Profit multiplied by 12

What symbols are used to represent positive and negative values in custom formatting?

• Stars and circles

• Check and cross marks

• Up and down arrows

• Plus and minus signs

Which color is recommended for a more visually appealing representation of positive values?

• Color 20

• Color 10

• Color 5

• Color 15