Each question in this quiz is timed.
Click the button below to start the quiz.
What is the purpose of a pivot table?
To compare data from different workbooks.
To merge different scenarios.
To summarize data in a three dimensional table.
To highlight formula errors.
To perform a what-if analysis on a data 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 cannot do this with Excel, but I can import my chart into PowerPoint, edit it, and reinsert it into Excel.
This is not really a chart, but an image composed of shapes and drawings.
I copy an image to the clipboard, select the columns of the chart by clicking on them, and then paste the image.
I select the chart, then select a chart type from the Chart Styles gallery .
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?
I can only enter a date in cell B4, not any other type of value.
First I should delete the date with the DELETE key.
I should change the number formatting of the cell.
I should type a space before entering the value 10.5.
I simply enter 10.5 in the cell and the value will display correctly.
Which chart type is best for comparing the product quality test scores?
A doughnut chart
A radar chart
A bar chart
A line chart