Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Business Analytics Quiz

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

A ......................... is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

a)

Pivot Table

b)

Table

c)

Chart

d)

Function

2.

.............................allows you to move text from one column into another, effectively splitting text entries into two separate spaces.

a)

Text to Columns

b)

LEN

c)

Concatenate

d)

Vlookup

3.

.....................is an Excel function to look up data in a table organized vertically

a)

VLOOKUP

b)

HLOOKUP

c)

DATE

d)

MATCH

4.

is an example of ........................... in action

a)

Conditional Formatting

b)

COUNT Function

c)

Data Sort

d)

LIST Function

5.

..................... function is used to join several text strings into 1 Text String

a)

ADD

b)

MARKUP

c)

CONCATENATE

d)

ADD_TEXT

6.

This image can be seen under ......................... in Excel workbook

a)

Data Sort

b)

Data Filter

c)

Data Validation

d)

Data Verification

7.

Excel uses ................ rule to determine order of calculation

a)

BODMAS

b)

BDOMAS

c)

BODAMS

d)

BODSAM

8.

....................... is used in a formula to lock its reference in a row or column

a)

&

b)

$

c)

#

d)

*

9.

..................... is a cloud-based business analysis and intelligence service by Microsoft

a)

Power BI

b)

Qlik

c)

SAP

d)

Tableau

10.

In Power BI,

"Power BI Service" is delivered as ..................

a)

SaaS (Software as a Service)

b)

Desktop

c)

Mobile

d)

Program

11.

'.csv' can be used to analyze data more than 10 lakh records

a)

True

b)

False

12.

................................. chart can be used for comparison if the number of categories is quite small (up to five, but not exceeding seven categories)

a)

Column Chart

b)

Column Histogram

c)

Bar Charts

d)

Line Charts

13.

You will use this ............................... which are best suited for trend-based visualizations of data over a period of time, esp. when the number of data points is very high

a)

Line Charts

b)

Pie Charts

c)

Histogram

d)

Heat Maps

14.

Given in this image is an example of ......................... chart type

a)

Column Chart

b)

Bar Chart

c)

Stacked Column

d)

Scatter Chart

15.

Pick the option which is NOT True

Why is Excel a popular spreadsheet program in the world?

a)

Easy to learn and get started

b)

Huge Community Support

c)

Continuously supported by Microsoft

d)

Connect to multiple databases and analyse infinite datasets

16.

"Cntrl + D" in Excel will do perform the below activity

a)

Copy paste date

b)

Undo selected fields

c)

Delete cells

d)

Fill Cells down

17.

Turning data analysis into visual representations such as charts, graphs, and histograms to more easily consume data

a)

Descriptive analytics

b)

Data Visualization

c)

Data mining

d)

Visual analysis

18.

Using databases, statistics, and machine learning (ML) to uncover trends in large datasets is ...................................

a)

Statistical analysis

b)

Data Mining

c)

Data cleaning

d)

Data Visualization

19.

Business intelligence combines ................... , ..............

+ data visualization & data tools and infrastructure best practices to help organizations

a)

Business Analytics & Data mining

b)

Business Analytics & ERP

c)

Data Mining & ERP

d)

Data mining & ERP

20.

............................... is NOT an example of a (BI: Business Intelligence) Tool

a)

Microsoft Power BI

b)

Tableau

c)

Qlik

d)

Zoho