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 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

What is the total number of subsets in the following set: {a,b,c,d,e.f,g}

2 / 25

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

3 / 25

The minimum amount of memory required to run an SQL Server Management Studio 2016 is

4 / 25

The sampling technique in which every element of a population has an equal, non-zero probability of been selected in a sample is called ...........

5 / 25

What is the shortcut to save a sheet or file?

6 / 25

What is the short key for special paste?

7 / 25

When the visualization published on the Power BI service is not visible to other people the file has been shared with. What might be the issue?

8 / 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 ............

9 / 25

To remove redundancy from the result of an SQL SELECT, the condition qualifier should be a ............

10 / 25

To move to the previous worksheet, press ..............

11 / 25

What does SUMIF function do?

12 / 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


13 / 25

.............. is the file format to save a worksheet as a template.

14 / 25

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

15 / 25

Per user per dataset, the Power BI desktop has a storage capacity limit up to

16 / 25

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

17 / 25

Which of these is NOT a characteristic of an RDBMS?

18 / 25

You can add an image to a template by clicking the insert picture from the File button on the ................... toolbar

19 / 25

What are the types of data you can source into Power BI?

20 / 25

What is the short key to auto fill colour?

21 / 25

Which type of Power BI visualization is described below?

22 / 25

What is the fundamental function to use to calculate the number of working days minus the custom weekends?

23 / 25

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

24 / 25

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

25 / 25

Which formula lets you add numeric values in a range of cells, ignoring those which are non-numeric, and resulting a difference cell?

Your score is

The average score is 45%


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




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.


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.


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.

Training Calendar

Increase Your Business Productivity

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