FutureReadyASEAN

Data Wizard / Beginner courses

DATA WIZARD

Beginner Courses

KarateKid-yellow-belt

Introduction To Excel
(30 minutes)

Bring your spreadsheets to life using the industry standard for displaying information.

Introduction To Power BI & Excel
(20 minutes)

Dive deep into data and start displaying your findings in business-savvy dashboards.

Get Started With Microsoft Cognitive Services
(10 minutes)

Get to know the top Application Programming Interfaces (APIs) innovators use to reshape the world of AI.

START LEARNING

Take The Test

Data Wizard-Beginner

Introduction To Excel
(30 minutes)

To highlight a group of cells, which of the following shortcut keys can be used?

Ctrl + Space Bar

Shift + Space Bar

Ctrl + Arrow Keys

Shift + Arrow Keys

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

Autosum

Pivot Table

V-Lookup

None of the above

What do IF statements allow one to do?

Add, subtract, multiply or divide

Make logical comparisons between conditions

Make logical comparisons between numbers

None of the above

Which of the following charts can be created using Excel?

Pie Chart

Histogram

Trendlines

All of the above

START LEARNING

Take The Test

Data Wizard-Beginner

Introduction To Power BI & Excel
(20 minutes)

Which of the following is not an Excel advanced BI modelling and reporting feature?

Power Pivot

Power View

OneDrive

None of the above

Which of the following about uploading Excel data to Power BI is incorrect?

Your data file can only be stored and imported from a local drive

Your data needs to be formatted as a table

Each column of data should be labelled with a proper heading

All of the above

How are the steps involved in importing an excel file from a local drive in Power BI?

Files > Get data > Local file

Files > Local file > Get data

Local file > File > Get data

Get data > Files > Local file

What does the Scheduled Refresh feature do?

Resets your dataset

Connects information from your workbook directly to the datasource and query, and loads any data that has changed

Resets any visualizations that have been pinned to the dashboard

None of the above

START LEARNING

Take The Test

Data Wizard-Beginner

Get Started With Microsoft Cognitive Services
(10 minutes)

Microsoft Cognitive Services gives our apps a human side. Which of the following is an artificial intelligent category it provides?

Speech

Vision

Language

All of the above

In the case studies, which Cognitive Services API did Uber use in their application to verify their drivers' identity?

Voice

Face

Language Understanding

Computer Vision

Which of the following useful information can be extracted by the Text Analysis API?

Sentiment

Language

Key Phrases

All of the above

Which of the following is true about Microsoft Cognitive Services?

To use Cognitive Services APIs, a deep understanding of machine learning is a prerequisite

The Knowledge API category provides the Recommendations API

The Bing Spell Check API does not provide powerful spell check capabilities

None of the above

Try Again!

Sorry you did not pass your test but you're nearly there.

Questions to try again

TRY AGAIN

Congratulations!

You have passed your test and collected a star.

CONTINUE

DATA WIZARD

Introduction To Excel (30 minutes)

Introduction To Power BI & Excel (20 minutes)

Get Started With Microsoft Cognitive Services (10 minutes)

Introduction To Excel
(30 minutes)

Introduction To Power BI & Excel
(20 minutes)

Get Started With Microsoft Cognitive Services
(10 minutes)