Data Analysis Fundamental using Excel

It is important to format data correctly to prevent errors in your analysis

• True

• False

Which option is available to format a sparkline?

• Formatting a sparkline as a pie

• Highlighting the highest value in the data set

• Adding a pattern to sparkline bars

• Showing values on a sparkline.

• Linking sparklines to data in a SQL Server database

You want to create a chart to show revenue by product category and year. Which chart type is suitable?

• Pie chart

• Clustered column chart

• Line chart

• Radar chart

• Area chart

Excel tables are only useful for formatting columns and rows in different colors.

• True

• False

You should be careful when you use Recommended PivotTable or PivotTable, because they are difficult to change after they have been created

• True

• False

What options are not available when you format a PivotChart?

• Color combinations and monochromatic color schemes

• Adding a data table.

• Adding pictures

• Adding a trendline.

• Showing error bars.

Once you have added a calculated field to a PivotTable, you cannot delete it.

• True

• False

You have a PivotTable displaying data that is split into more than 50 categories. How would you make it easy for a user to focus on a single category of the data?

• Drag the category field to the rows area in the PivotTable field options

• Drag the category field to the filters area in the PivotTable field options.

• Drag the category field to the values area in the PivotTable field options.

• Drag the category field to the columns area in the PivotTable field options.

• Right-click the category field and select Add as Slicer.

Which function would you use to get the current date and time?

• TODAY()

• MONTH()

• NOW()

• TIME()

• NETWORKDAYS()

Treemap and sunburst charts are available in all versions of Excel

• True

• False