WorksheetsBusiness Analytics Quiz
Total questions: 20
Worksheet time: 10mins
A ......................... is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.
Pivot Table
Table
Chart
Function
.............................allows you to move text from one column into another, effectively splitting text entries into two separate spaces.
Text to Columns
LEN
Concatenate
Vlookup
.....................is an Excel function to look up data in a table organized vertically
VLOOKUP
HLOOKUP
DATE
MATCH
is an example of ........................... in action
Conditional Formatting
COUNT Function
Data Sort
LIST Function
..................... function is used to join several text strings into 1 Text String
ADD
MARKUP
CONCATENATE
ADD_TEXT
This image can be seen under ......................... in Excel workbook
Data Sort
Data Filter
Data Validation
Data Verification
Excel uses ................ rule to determine order of calculation
BODMAS
BDOMAS
BODAMS
BODSAM
....................... is used in a formula to lock its reference in a row or column
&
$
#
*
..................... is a cloud-based business analysis and intelligence service by Microsoft
Power BI
Qlik
SAP
Tableau
In Power BI,
"Power BI Service" is delivered as ..................
SaaS (Software as a Service)
Desktop
Mobile
Program
'.csv' can be used to analyze data more than 10 lakh records
True
False
................................. chart can be used for comparison if the number of categories is quite small (up to five, but not exceeding seven categories)
Column Chart
Column Histogram
Bar Charts
Line Charts
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
Line Charts
Pie Charts
Histogram
Heat Maps
Given in this image is an example of ......................... chart type
Column Chart
Bar Chart
Stacked Column
Scatter Chart
Pick the option which is NOT True
Why is Excel a popular spreadsheet program in the world?
Easy to learn and get started
Huge Community Support
Continuously supported by Microsoft
Connect to multiple databases and analyse infinite datasets
"Cntrl + D" in Excel will do perform the below activity
Copy paste date
Undo selected fields
Delete cells
Fill Cells down
Turning data analysis into visual representations such as charts, graphs, and histograms to more easily consume data
Descriptive analytics
Data Visualization
Data mining
Visual analysis
Using databases, statistics, and machine learning (ML) to uncover trends in large datasets is ...................................
Statistical analysis
Data Mining
Data cleaning
Data Visualization
Business intelligence combines ................... , ..............
+ data visualization & data tools and infrastructure best practices to help organizations
Business Analytics & Data mining
Business Analytics & ERP
Data Mining & ERP
Data mining & ERP
............................... is NOT an example of a (BI: Business Intelligence) Tool
Microsoft Power BI
Tableau
Qlik
Zoho
