Advanced Spreadsheet Mastery

Froggy Jumps

Parties jouées 3

Créer une copie

À propos de cette activité

Challenging spreadsheet skills quiz.

Créé par

ALEXIES CANILLO

Philippines

Téléchargez la version pour jouer sur papier

Top 10 résultats

Il n'y a toujours pas de résultats pour ce jeu. Soyez le premier à apparaître dans le classement! Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi


Froggy Jumps Advanced Spreadsheet MasteryVersion en ligne Challenging spreadsheet skills quiz. par ALEXIES CANILLO 1 Which feature summarizes large data sets and allows quick grouping? a Solver b Conditional Formatting c PivotTable 2 Which function is best for finding a value with multiple criteria? a INDEX/MATCH with multiple criteria b SUMIF c VLOOKUP with approximate match 3 Which tool allows you to automate repetitive tasks in Excel? a Macros b Data Validation c Data Tables 4 What feature helps validate data entry to a list of allowed values? a Named Ranges b Data Validation c Sparklines 5 Which formula returns the position of an item in a range? a MATCH b OFFSET c INDEX 6 Which function returns the smallest value meeting a condition? a MINIFS b SUMIFS c MAXIFS 7 Which feature visualizes data trends with color rules? a Conditional Formatting b Flash Fill c Pivot Chart 8 What tool analyzes data for patterns and says if the data is normal? a Data Analysis Toolpak b Power Query c Goal Seek 9 Which method creates a dynamic range that expands with data? a Named Constants b Structured Tables (Excel Tables) c PivotTable

Froggy Jumps

Advanced Spreadsheet MasteryVersion en ligne

Challenging spreadsheet skills quiz.

par ALEXIES CANILLO

Which feature summarizes large data sets and allows quick grouping?

Solver

Conditional Formatting

PivotTable

Which function is best for finding a value with multiple criteria?

INDEX/MATCH with multiple criteria

SUMIF

VLOOKUP with approximate match

Which tool allows you to automate repetitive tasks in Excel?

Macros

Data Validation

Data Tables

What feature helps validate data entry to a list of allowed values?

Named Ranges

Data Validation

Sparklines

Which formula returns the position of an item in a range?

MATCH

OFFSET

INDEX

Which function returns the smallest value meeting a condition?

MINIFS

SUMIFS

MAXIFS

Which feature visualizes data trends with color rules?

Conditional Formatting

Flash Fill

Pivot Chart

What tool analyzes data for patterns and says if the data is normal?

Data Analysis Toolpak

Power Query

Goal Seek

Which method creates a dynamic range that expands with data?

Named Constants

Structured Tables (Excel Tables)

PivotTable

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Advanced Spreadsheet Mastery

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Advanced Spreadsheet MasteryVersion en ligne

par ALEXIES CANILLO

Which feature summarizes large data sets and allows quick grouping?

Which function is best for finding a value with multiple criteria?

Which tool allows you to automate repetitive tasks in Excel?

What feature helps validate data entry to a list of allowed values?

Which formula returns the position of an item in a range?

Which function returns the smallest value meeting a condition?

Which feature visualizes data trends with color rules?

What tool analyzes data for patterns and says if the data is normal?

Which method creates a dynamic range that expands with data?

		%
	Anonyme	%
		%
		%