Further data analytics

Which Excel function calculates the average of a range of data?

• A = Sum()
• B = Average()
• C = Count()
• D = Median()

What is the benefit of using descriptive statistic in excel?

• It allows you to edit data quickly
• it helps you summarize and understand large datasets.
• it automatically formats your spreadsheet
• it creates presentation

You have a list of exams scores and want to find the most frequent score. What function would be most appropriate?

• MODE
• STANDARD DEVIATION
• MIN
• MAX

Which of the following are key sections of a Dashboard?

• Pie charts
• Text boxes describing dashboard contents
• Scatter plots
• Heat maps

What is a Slicer used for in data analysis?

• Sorting data in a pivot table
• Creating new columns in a table
• Adding interactive filters to a pivot table and associated charts
• Calculating averages in a pivot table

What does a timeline feature allow in data visualization?

• It enables data sorting in alphabetical order.
• It allows for the creation of new data points.
• It facilitates the visualization of data from specific time periods in tables or charts.
• It generates statistical summaries of the data.

What is the primary purpose of a dashboard in data analysis?

• Storing raw data for future reference
• Generating complex statistical models
• Making data understandable to external viewers through visualizations
• Sorting and organizing data in a database

What is primary function of the scenario manager in excel?

• To generate random scenarios for data analysis
• To create and manage multiple versions of a workbook
• To store and compare different sets of input values for a model or formula
• To automate repetitive tasks in excel

What is the main purpose of the Goal seek option in excel?

• To create custom charts and graphs
• To analyze large data sets using statistical functions
• To find the optimal input value to achieve a desired result in a formula
• To format cells and apply conditional formatting

The empirical rule can be used to predict the data range within which audit variables can fall ?

• True
• False