Microsoft Excel Pretest

2

What is the purpose of a pivot table?

2

If I fill out the PivotTable Field list as below to create a pivot table, what will be the result? SalesPerson then Region to Row Field, Sales to Value Field, Month to Report Filter (Accept Default Options)

2

In this column chart, the columns are represented by images. What method can be used to insert images in place of traditional columns in such a chart?

2

I entered a date in cell B4 that I wish to replace with the value 10.5 (to be used in calculations) and have it display as “10.5” (without the quotes).
How can I do this?

To assess Excel Skills

Microsoft Excel Pretest

Microsoft Excel Pretest

What is the purpose of a pivot table?

If I fill out the PivotTable Field list as below to create a pivot table, what will be the result? SalesPerson then Region to Row Field, Sales to Value Field, Month to Report Filter (Accept Default Options)

In this column chart, the columns are represented by images. What method can be used to insert images in place of traditional columns in such a chart?

I entered a date in cell B4 that I wish to replace with the value 10.5 (to be used in calculations) and have it display as “10.5” (without the quotes).
How can I do this?

Which chart type is best for comparing the product quality test scores?

To assess Excel Skills

Microsoft Excel Pretest

Microsoft Excel Pretest

What is the purpose of a pivot table?

If I fill out the PivotTable Field list as below to create a pivot table, what will be the result? SalesPerson then Region to Row Field, Sales to Value Field, Month to Report Filter (Accept Default Options)

In this column chart, the columns are represented by images. What method can be used to insert images in place of traditional columns in such a chart?

I entered a date in cell B4 that I wish to replace with the value 10.5 (to be used in calculations) and have it display as “10.5” (without the quotes). How can I do this?

Which chart type is best for comparing the product quality test scores?

I entered a date in cell B4 that I wish to replace with the value 10.5 (to be used in calculations) and have it display as “10.5” (without the quotes).
How can I do this?