Data Analysis and Visualization

Which of these tools is used for data cleaning and transformation?

• Power BI

• Power Apps

• Power Pivot

• Power Query

Which of these is not an example of a relational database management system?

• Ms SQL Server

• MySQL

• PostgreSQL

• MongoDB

• OracleDB

The type of data analytics that answers the question 'what happened?' is known as

You are required to carry out an analysis to answer the question 'Why?' What type of data analytics is this?

• Predictive

• Diagnostic

• Prescriptive

• Descriptive

The first step to carrying out a data analysis project is

• Gathering data

• Defining objectives

• Cleaning data

• Asking business questions

The stage in the data analysis process where you fix the inconsistencies in data to ensure data accuracy is the

• Transformation stage

• Visualization stage

• Analyzation stage

• Presentation stage

In Excel, from which tab do you import data to the Power Query editor?

• Home Tab

• Insert Tab

• Data Tab

• Formula Tab

The shortcut to turn a data range into a table in Excel, is

• Cltr + T

• Cltr + Table

• Alt + T

• Alt + Table

Which of these is an example of absolute referencing in Excel

• C1

• $C1

• $C$1

• C$1

According to the order of operation, the answer for this expression will be 5+2*5-(3+4) =