Excel Pre-Test

Froggy Jumps

Played 9

Create copy

About this activity

For Training Purpose

Created by

Vindawati Eka Sundari

Indonesia

Download the paper version to play

Top 10 results

There are still no results for this game. Be the first to stay in the ranking! Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(90)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
pizza

Lorelay Tyana

Romania

(262)

joc despre pizza
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(60)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(132)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.


Froggy Jumps Excel Pre-TestOnline version For Training Purpose by Vindawati Eka Sundari 1 You have two tables: one contains Insured Name and Policy Number, and the other contains Policy Number and Total Premium. How would you use VLOOKUP to add the Total Premium to the first table based on the Policy Number? a =VLOOKUP(Insured Name, Table, Column Index, FALSE) b =VLOOKUP(Policy Number, Table, Column Index, FALSE) c =VLOOKUP(Total Premium, Table, Column Index, TRUE) 2 You receive claim data from multiple branches. Some rows are duplicated based on Claim Number. What steps would you take in Excel to remove these duplicates while keeping only unique claim records? a Use the “Sort” feature b Use the IFERROR() function c Use “Remove Duplicates” and select the Claim Number column 3 A column labeled “Insured Name” contains values like Zurich - Vindawati. How can you split this into two columns: one for the company name and one for the insured name? a Use Flash Fill b Use CONCATENATE c Use Text to Columns with delimiter “-” 4 You want to analyze Total Claim Amount by Region and Insurance Product Type. What Excel feature would you use to summarize and interactively explore this data? a Filter b Conditional Formatting c Pivot Table 5 You want to highlight rows where the Premium Amount exceeds Rp100,000,000 to make them stand out. What Excel feature would you use, and how would you set the condition? a Use “Conditional Formatting” with a “Greater Than” rule b Use “Sort” based on Premium Amount c Use “Data Validation”

Froggy Jumps

Excel Pre-TestOnline version

For Training Purpose

by Vindawati Eka Sundari

You have two tables: one contains Insured Name and Policy Number, and the other contains Policy Number and Total Premium. How would you use VLOOKUP to add the Total Premium to the first table based on the Policy Number?

=VLOOKUP(Insured Name, Table, Column Index, FALSE)

=VLOOKUP(Policy Number, Table, Column Index, FALSE)

=VLOOKUP(Total Premium, Table, Column Index, TRUE)

You receive claim data from multiple branches. Some rows are duplicated based on Claim Number. What steps would you take in Excel to remove these duplicates while keeping only unique claim records?

Use the “Sort” feature

Use the IFERROR() function

Use “Remove Duplicates” and select the Claim Number column

A column labeled “Insured Name” contains values like Zurich - Vindawati. How can you split this into two columns: one for the company name and one for the insured name?

Use Flash Fill

Use CONCATENATE

Use Text to Columns with delimiter “-”

You want to analyze Total Claim Amount by Region and Insurance Product Type. What Excel feature would you use to summarize and interactively explore this data?

Filter

Conditional Formatting

Pivot Table

You want to highlight rows where the Premium Amount exceeds Rp100,000,000 to make them stand out. What Excel feature would you use, and how would you set the condition?

Use “Conditional Formatting” with a “Greater Than” rule

Use “Sort” based on Premium Amount

Use “Data Validation”

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Excel Pre-Test

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

pizza

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

The Integumentary System

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Excel Pre-TestOnline version

by Vindawati Eka Sundari

You have two tables: one contains Insured Name and Policy Number, and the other contains Policy Number and Total Premium. How would you use VLOOKUP to add the Total Premium to the first table based on the Policy Number?

You receive claim data from multiple branches. Some rows are duplicated based on Claim Number. What steps would you take in Excel to remove these duplicates while keeping only unique claim records?

A column labeled “Insured Name” contains values like Zurich - Vindawati. How can you split this into two columns: one for the company name and one for the insured name?

You want to analyze Total Claim Amount by Region and Insurance Product Type. What Excel feature would you use to summarize and interactively explore this data?

You want to highlight rows where the Premium Amount exceeds Rp100,000,000 to make them stand out. What Excel feature would you use, and how would you set the condition?

		%
	Anonymous	%
		%
		%