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

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

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Color 20

Color 10

Color 5

Color 15