Spreadsheet Formatting & Formula Quiz

Froggy Jumps

Jugadas 2

Crear copia

Sobre esta actividad

Test your spreadsheet skills with these questions!

Creada por

Latoya

Jamaica

Descarga la versión para jugar en papel

Top 10 resultados

#	Jugador	Acierto	tiempo
1	Latoya 24 de Julio de 2025	% 85	01:40

¿Quieres aparecer en el Top 10 de este juego? 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
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.
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!
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(99)

Repasamos el vocabulario de la unidad

		%
	Anónimo	%
		%
		%

Imprime tu juego

Spreadsheet Formatting & Formula Quiz


Froggy Jumps Spreadsheet Formatting & Formula QuizVersión en línea Test your spreadsheet skills with these questions! por Latoya 1 Which formatting tool makes column titles stand out? a Data validation b Bold text c Merge cells 2 Which formatting option is best for displaying money values? a Number b Percentage c Currency 3 What does applying currency format do to numeric values? a Adds dollar signs and decimal places b Adds dollar signs ONLY c Adds 2 decimal places ONLY 4 Which of the following is the best reason to use the 'Merge Cells' feature in a spreadsheet? a To center a heading across multiple columns b To delete extra columns c To hide data in some columns 5 What is the purpose of using consistent formatting in a spreadsheet? a To improve clarity and organization b To confuse readers c To use more colors 6 A student formats the first heading in bold and center alignment, but leaves others plain. This is an example of: a Data validation b Accurate formatting c Inconsistent formatting 7 What type of formatting should be used for column headings? a Strikethrough b Bold and center-aligned c Regular text 8 What formula would you use to add up total expenses in a column? a =COUNT(B2:B6) b =SUM(B2:B6) c =MULTIPLY(B2:B6) 9 If cell C2 contains gross pay and cell B2 contains tax, what formula could be used to calculate the net pay? a =B2+C2 b =C2-B2 c =SUM(C2:B2) 10 Which formula calculates overtime pay if the employee worked 8 hours at $500 per hour? a =500/8 b =8+500 c =8*500 11 Which formula would you use to calculate the total expenses from cells B2 to B6? (see image) a =SUM(B2:B6) b =AVERAGE(B2:B6) c =MAX(B2:B6) 12 Which formula would you use to find the average cost of the expenses listed in cells B2 to B6? (see image) a =SUM(B2:B6) b =AVERAGE(B2:B6) c =MAX(B2:B6) 13 What does the formula =MAX(B2:B6) calculate? (see image) a The total of all expenses b The largest expense value c The smallest expense value

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.

Spreadsheet Formatting & Formula Quiz

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

Quiz de Culpa mía película

Froggy Jumps

Sabiduría animal

Froggy Jumps

Salva a la Ranita

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

Spreadsheet Formatting & Formula QuizVersión en línea

por Latoya

Which formatting tool makes column titles stand out?

Which formatting option is best for displaying money values?

What does applying currency format do to numeric values?

Which of the following is the best reason to use the 'Merge Cells' feature in a spreadsheet?

What is the purpose of using consistent formatting in a spreadsheet?

A student formats the first heading in bold and center alignment, but leaves others plain. This is an example of:

What type of formatting should be used for column headings?

What formula would you use to add up total expenses in a column?

If cell C2 contains gross pay and cell B2 contains tax, what formula could be used to calculate the net pay?

Which formula calculates overtime pay if the employee worked 8 hours at $500 per hour?

Which formula would you use to calculate the total expenses from cells B2 to B6? (see image)

Which formula would you use to find the average cost of the expenses listed in cells B2 to B6? (see image)

What does the formula =MAX(B2:B6) calculate? (see image)