Home
About
Programs
CBT
School Portal
Projects
Contact
Blog

Enroll Now

August 31, 2026

Data Analysis

Welcome to your Data Analysis

None

What is the purpose of a chart in Excel or Power BI?

Choose the best answer.

To make data easier to understand visually

To delete data

To password protect a file

To send an email

None

Think about turning numbers into a picture.

Which symbol must every Excel formula begin with?

Choose the correct symbol.

None

Think about the symbol that tells Excel to calculate.

In Excel what do you call a saved collection of rows and columns of data?

Choose the correct term.

A worksheet

A formula

A macro

A pivot

None

It is the grid you enter data into.

Which Excel feature lets you quickly summarize large amounts of data?

Choose the correct feature.

Pivot Table

Text Box

Comment

Hyperlink

None

It lets you group and summarize data interactively.

Which Excel function adds up a range of numbers?

Choose the correct function.

COUNT

SUM

AVERAGE

MAX

None

The name is exactly what it does.

Which Excel function counts how many cells contain numbers?

Choose the correct function.

COUNT

SUM

VLOOKUP

None

The name describes exactly what it does.

What does a cell reference like B2 mean in Excel?

Choose the best explanation.

Column B row 2

Row B column 2

Sheet B page 2

Bold text size 2

None

The letter always comes first and refers to the column.

Which Excel function finds the average of a range of numbers?

Choose the correct function.

SUM

AVERAGE

COUNT

MODE

None

The name describes exactly what it calculates.

In Power BI what is used to visually represent data such as bar charts and pie charts?

Choose the correct term.

Queries

Visuals

Relationships

Measures

None

Think about the charts themselves.

What is Power BI mainly used for?

Choose the best answer.

Editing videos

Visualizing and analyzing data

Sending emails

Writing code

None

Think about charts dashboards and reports.

Previous Start Quiz Next

Time's up

← Back to Blog & News

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Empowering Future Innovators. Tech skills for students, delivered in schools, camps & online.

Portals

CBT Portal Login
View Test Results
Parent/School Portal
Partner with Us

Contact

Built to empower future innovators.