Online Data Analysis Test

 

 

Test and improve your knowledge of Data Analysis with fun multiple choice exams you can take online.

Numerous skills and knowledge areas are covered during this assessment. This includes:

Data Analysis, Microsoft Excel, Power BI, Python and Microsoft Office Productivity.

/25

25 Questions | 30 Minutes

Get ready to upgrade your skills take an online test in Data Analytics, to check your skills. After every test, know where you stand and what to do next to succeed.

1 / 25

How can you print an embedded chart from an excel sheet?

2 / 25

............. is the common expression language used on Power BI

3 / 25

............ is the formula to use when you want to add two cells (A1 and A2) together.

4 / 25

................. is a symbol that represents the multiplication arithmetic operator.

5 / 25

If you want to perform a trend analysis of price data in a year, you can use the following excel functions:

Goal Seek

Forecast Sheet

Solver

6 / 25

A z-score tells you .........

7 / 25

What do the normal distribution and the exponential density function have in common?

8 / 25

The divide symbol is ........

9 / 25

The cell reference of a range of cells that starts in B1 and goes over to column G and down to roll 10 is ............

10 / 25

If you need to perform a data impose a certain formula on multiple tables/sheets. What operation can you perform so that you don't have to redo the procedure every time?

11 / 25

What is the short key to editing a cell?

12 / 25

Excel is a .....................

13 / 25

............ is the shortcut to create a chart from a selected range of data.

14 / 25

The shortcut to define a name to a table is ...........

15 / 25

Which of the following functions can you not perform using the Conditional Formatting option?

16 / 25

Which of the following formula will you use to make a number in cell C 10% smaller than the number in cell C3?

17 / 25

An excel workbook is a collection of .................

18 / 25

A BCNF relation is also known as ..........

19 / 25

What is the short key to auto fill colour?

20 / 25

In Power BI Query editor, what do you translate the currently selected columns to attribute-value pairs, combined with the rest of the values in each role in an organized manner?

21 / 25

................... is the formula to calculate standardized normal random variable

22 / 25

Which is the appropriate option to change the data source of an existing file?

23 / 25

If each tuple has the relation R within R, then this type of relation is called ............

24 / 25

What does SUMIF function do?

25 / 25

Which type of Power BI visualization is described below?

Your score is

The average score is 42%

0%

Please click the stars to rate the quiz

Schedule An Online Test For Hiring

Pre-employment testing is a standardized method to test job candidates on their qualifications for a job during the recruitment process.

Simplify your pre-employment skill tests by letting our platform do the hard work. Increase diversity & reduce bias with our pre-employment skill testing platform. Improve Experience. Reduce Costs. Intuitive Platform.

UrBizEdge offers skill assessment tests that will transform your hiring process, helping you decrease your time to hire while increasing the quality of your hires.

Test Schedule Form

 

Verification

xls-icon-3379

Microsoft Excel Tutorial

Excel is the world’s most used spreadsheet program. Example use areas: Data analytics; Project management; Finance and accounting. This tutorial covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts etc.

pbi

Power BI Tutorial

A Business Intelligence and Data Visualization tool for converting data from various data sources into interactive dashboards and analysis reports. Power BI offers cloud-based services for interactive visualizations with a simple interface for end users to create their own reports and dashboards.

fm

Financial Modeling Tutorial

Step by Step guide to Financial Modeling in Excel. These videos will aid you in learning to build a simple integrated financial statement model.

Increase Your Business Productivity

Get the special edge you need. Register for our premium classes today.