Excel Formulas Quest

Froggy Jumps

Parties jouées 0

Créer une copie

À propos de cette activité

Fun quiz on common formulas

Créé par

Merry Zapico

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 Excel Formulas QuestVersion en ligne Fun quiz on common formulas par Merry Zapico 1 Which formula adds all numbers in a range? a AVERAGE(A1:A10) b MIN(A1:A10) c SUM(A1:A10) 2 Which formula finds the average value in B2:B20? a AVERAGE(B2:B20) b SUM(B2:B20) c MAX(B2:B20) 3 Which function returns the smallest value in a range? a MIN(C1:C15) b COUNT(C1:C15) c MAX(C1:C15) 4 Which function returns the largest value in a range? a MAX(D1:D12) b AVERAGE(D1:D12) c MIN(D1:D12) 5 Which formula counts numeric cells in E1:E50? a COUNT(E1:E50) b SUM(E1:E50) c COUNTA(E1:E50) 6 Which function counts non-empty cells in F1:F30? a COUNTA(F1:F30) b SUM(F1:F30) c COUNT(F1:F30) 7 Which formula totals only if a condition is met? a AVERAGEIF(A1:A100, ">0", B1:B100) b SUM(A1:A100) c SUMIF(A1:A100, ">0", B1:B100) 8 Which function counts cells meeting a condition? a COUNTIF(G1:G40, ">=10") b AVERAGEIF(G1:G40, ">=10") c SUMIF(G1:G40, ">=10") 9 Which function returns the count of all non-empty cells in H1:H25? a SUM(H1:H25) b COUNTA(H1:H25) c COUNT(H1:H25) 10 Which formula finds the total of values when criteria are met across I1:I100? a COUNTIFS(I1:I100, "Yes") b SUM(I1:I100) c SUMIFS(I1:I100, J1:J100, "Yes")

Froggy Jumps

Excel Formulas QuestVersion en ligne

Fun quiz on common formulas

par Merry Zapico

Which formula adds all numbers in a range?

AVERAGE(A1:A10)

MIN(A1:A10)

SUM(A1:A10)

Which formula finds the average value in B2:B20?

AVERAGE(B2:B20)

SUM(B2:B20)

MAX(B2:B20)

Which function returns the smallest value in a range?

MIN(C1:C15)

COUNT(C1:C15)

MAX(C1:C15)

Which function returns the largest value in a range?

MAX(D1:D12)

AVERAGE(D1:D12)

MIN(D1:D12)

Which formula counts numeric cells in E1:E50?

COUNT(E1:E50)

SUM(E1:E50)

COUNTA(E1:E50)

Which function counts non-empty cells in F1:F30?

COUNTA(F1:F30)

SUM(F1:F30)

COUNT(F1:F30)

Which formula totals only if a condition is met?

AVERAGEIF(A1:A100, ">0", B1:B100)

SUM(A1:A100)

SUMIF(A1:A100, ">0", B1:B100)

Which function counts cells meeting a condition?

COUNTIF(G1:G40, ">=10")

AVERAGEIF(G1:G40, ">=10")

SUMIF(G1:G40, ">=10")

Which function returns the count of all non-empty cells in H1:H25?

SUM(H1:H25)

COUNTA(H1:H25)

COUNT(H1:H25)

Which formula finds the total of values when criteria are met across I1:I100?

COUNTIFS(I1:I100, "Yes")

SUM(I1:I100)

SUMIFS(I1:I100, J1:J100, "Yes")

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 Formulas Quest

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

pizza

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

The Integumentary System

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Excel Formulas QuestVersion en ligne

par Merry Zapico

Which formula adds all numbers in a range?

Which formula finds the average value in B2:B20?

Which function returns the smallest value in a range?

Which function returns the largest value in a range?

Which formula counts numeric cells in E1:E50?

Which function counts non-empty cells in F1:F30?

Which formula totals only if a condition is met?

Which function counts cells meeting a condition?

Which function returns the count of all non-empty cells in H1:H25?

Which formula finds the total of values when criteria are met across I1:I100?

		%
	Anonyme	%
		%
		%