Excel Pre-Test

Froggy Jumps

Jugadas 9

Crear copia

Sobre esta actividad

For Training Purpose

Creada por

Vindawati Eka Sundari

Indonesia

Descarga la versión para jugar en papel

Top 10 resultados

Todavía no hay resultados para este juego. ¡Sé el primero en aparecer en el ranking! Inicia sesión para identificarte.

Crea tu propio juego gratis desde nuestro creador de juegos

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto

El valle de los lobos

Marcos Signes

España

(107)

20 preguntas de este maravilloso libro
Sabiduría animal

Educaplay Educational Resources

España

(15392)

Conviértete en un genio del Reino Animal
Salva a la Ranita

Melanie Rodriguez

Estados Unidos

(337)

Contesta las siguientes multiplicaciones correctamente para salvar a la ranita y evitar que caiga al agua, mucha suerte!
Quiz de Culpa mía película

Yamila Chavez

Argentina

(171)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(99)

Repasamos el vocabulario de la unidad


Froggy Jumps Excel Pre-TestVersión en línea For Training Purpose por 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-TestVersión en línea

For Training Purpose

por 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”

Puedes integrar el juego en un LMS compatible con LTI 1.1 o LTI 1.3 como Canvas, Moodle, o Blackboard. De esta manera podrás guardar las puntuaciones automáticamente en el libro de calificaciones de esa plataforma.

Excel Pre-Test

Froggy Jumps

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

El valle de los lobos

Froggy Jumps

Sabiduría animal

Froggy Jumps

Salva a la Ranita

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

Excel Pre-TestVersión en línea

por 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?

		%
	Anónimo	%
		%
		%