NEW
Font size
WorksheetsData Analysis Fundamental using Excel
Total questions: 12
Worksheet time: 6mins
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
What is the benefit of creating a Data Model?
You can create charts more easily.
It is easier to work with financial data in Data Models.
Calculations are performed faster within a Data Model.
You can create relations between data from more than one source.
Data Models enable you to create maps within Excel.
Importing or linking external data to your Data Model is a deprecated feature.
True
False
