Excel Essentials Challenge

Froggy Jumps

Parties jouées 2

Créer une copie

À propos de cette activité

Excel quiz sprint.

Créé par

daiber Lopez

Guatemala

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 Excel Essentials ChallengeVersion en ligne Excel quiz sprint. par daiber Lopez 1 Which formula returns the sum of a range in Excel? a SUM(A1:A10) b TOTAL(A1:A10) c ADD(A1:A10) 2 What does the VLOOKUP function do? a Looks up a value in the first column and returns a related value b Sums values in a column c Creates a vertical chart 3 Which shortcut selects the entire worksheet? a Ctrl + A b Ctrl + S c Ctrl + Z 4 Which function counts numeric cells only? a COUNT b COUNTA c COUNTIF 5 What is the purpose of a PivotTable? a Summarize and analyze data quickly b Format cells c Create a chart 6 Which operator is used for concatenation in Excel formulas? a * b + c & 7 What does the IF function do? a Filters data b Returns one value if condition is true, another if false c Calculates the mean 8 Which function would you use to find the average ignoring text cells? a SUMIF b AVERAGEIF c MEDIAN 9 Which tab hosts options for data validation? a Review b Data c Formulas 10 What is the correct absolute reference format in Excel? a $A$1 b $A1 c A$1

Froggy Jumps

Excel Essentials ChallengeVersion en ligne

Excel quiz sprint.

par daiber Lopez

Which formula returns the sum of a range in Excel?

SUM(A1:A10)

TOTAL(A1:A10)

ADD(A1:A10)

What does the VLOOKUP function do?

Looks up a value in the first column and returns a related value

Sums values in a column

Creates a vertical chart

Which shortcut selects the entire worksheet?

Ctrl + A

Ctrl + S

Ctrl + Z

Which function counts numeric cells only?

COUNT

COUNTA

COUNTIF

What is the purpose of a PivotTable?

Summarize and analyze data quickly

Format cells

Create a chart

Which operator is used for concatenation in Excel formulas?

What does the IF function do?

Filters data

Returns one value if condition is true, another if false

Calculates the mean

Which function would you use to find the average ignoring text cells?

SUMIF

AVERAGEIF

MEDIAN

Which tab hosts options for data validation?

Review

Data

Formulas

What is the correct absolute reference format in Excel?

$A$1

$A1

A$1

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.

Excel Essentials Challenge

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

The Integumentary System

Froggy Jumps

pizza

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Excel Essentials ChallengeVersion en ligne

par daiber Lopez

Which formula returns the sum of a range in Excel?

What does the VLOOKUP function do?

Which shortcut selects the entire worksheet?

Which function counts numeric cells only?

What is the purpose of a PivotTable?

Which operator is used for concatenation in Excel formulas?

What does the IF function do?

Which function would you use to find the average ignoring text cells?

Which tab hosts options for data validation?

What is the correct absolute reference format in Excel?

		%
	Anonyme	%
		%
		%