Excel Formulas Mastery

Froggy Jumps

(1)

Jugadas 38

Crear copia

Sobre esta actividad

Test your formula skills.

Creada por

Nova Bel Supang

Filipinas

Descarga la versión para jugar en papel

Top 10 resultados

#	Jugador	Acierto	tiempo
1	Brenna 14 de Agosto de 2025	% 88	07:11
2	Pearl 14 de Agosto de 2025	% 88	07:30
3	Leira Jumalon 14 de Agosto de 2025	% 86	05:48
4	Keann Sam Uy 14 de Agosto de 2025	% 86	06:55
5	Angelo 14 de Agosto de 2025	% 84	07:34
6	Kaye Angelie 14 de Agosto de 2025	% 84	08:24
7	david 14 de Agosto de 2025	% 82	08:35
8	dan aldrei 14 de Agosto de 2025	% 78	06:28
9	Ocampos CG 14 de Agosto de 2025	% 76	06:56
10	Kate 14 de Agosto de 2025	% 76	08:52

¿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

Quiz de Culpa mía película

Yamila Chavez

Argentina

(170)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.
El valle de los lobos

Marcos Signes

España

(107)

20 preguntas de este maravilloso libro
Sabiduría animal

Educaplay Educational Resources

España

(15379)

Conviértete en un genio del Reino Animal
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(98)

Repasamos el vocabulario de la unidad
Salva a la Ranita

Melanie Rodriguez

Estados Unidos

(335)

Contesta las siguientes multiplicaciones correctamente para salvar a la ranita y evitar que caiga al agua, mucha suerte!

		%
	Anónimo	%
		%
		%

Imprime tu juego

Excel Formulas Mastery


Froggy Jumps Excel Formulas MasteryVersión en línea Test your formula skills. por Nova Bel Supang 1 What is a formula in Excel? a A saved layout element. b An expression that calculates a value. c A type of chart. 2 Which symbol must every formula in Excel start with? a # b / c = 3 Give an example of a simple addition formula in Excel. a A1+B1 b =A1-B1 c =A1+B1 4 How do you write a formula to multiply the value in A2 by 5? a =A2/5 b =5A2 c =A25 5 What does the formula =SUM(A1:A5) do? a Finds the average of A1 to A5 b Adds the values in cells A1 through A5. c Counts the cells A1 to A5 6 What are cell addresses in Excel? a References to specific cells, like A1. b Names of worksheets c Formulas for cells 7 Give an example of a cell address. a A0 b 1A c A1 8 Which is vertical in Excel—columns or rows? a Rows are vertical. b Neither; both are horizontal. c Columns are vertical. 9 Which is horizontal in Excel—columns or rows? a Both are diagonal. b Rows are horizontal. c Columns are horizontal. 10 Why do we use parentheses in Excel formulas? a To make it look nice b To start a formula c To control order of operations. 11 Write the formula for adding the numbers in A1 and B1, then multiplying the sum by C1. a =(A1+B1)+C1 b =A1+B1C1 c =(A1+B1)C1 12 If A1=2 and A2=4, what is the result of =A1+A2? a 8 b 4 c 6 13 If A1=2, B1=3, and C1=2, what is =A1+(B1C1)? a 8 b 10 c 7 14 What does =A1+B1 become when copied one row down using relative reference? a =A1+B2 b =A2+B2 c =A2+B1 15 If C1 contains =A1+5 and is copied to C2, what will C2 contain? a =A1+10 b =A2+5 c =A2+10 16 Why does Excel adjust cell references when copying a formula? a Because formulas copy automatically b Because the system renames cells c Because relative references adjust when copied. 17 How do you keep a cell reference fixed when copying a formula? a Use $ in the reference (absolute reference). b Use a named range c Turn off calculation 18 If =A1+$B$1 is copied from C1 to C2, which reference will change? a Both A1 and B1 will change b $B$1 will change c A1 will change to A2. 19 Name one situation where you should use an absolute reference. a When copying a formula to many cells b When you want all references to move c To keep a fixed tax rate across cells. 20 What is a relative reference? a A fixed reference that never changes b A reference to a named range c A cell reference that changes when copied. 21 What is an absolute reference? a A fixed cell reference that does not change when copied. b A formula that cannot be copied c A reference that changes when copied 22 In the format $B$3, which is locked—the column, the row, or both? a Only the column is locked. b Only the row is locked. c Both column B and row 3 are locked. 23 What is the main advantage of using relative references? a They adapt when copied to new cells. b They do not adjust c They are always fixed 24 What is the main advantage of using absolute references? a Keeps specific cells fixed when copying. b They are easier to type c They always reference neighboring cells 25 Which type of reference would you use for a fixed tax rate in a formula? a Relative reference b Mixed reference c Absolute reference 26 Which type of reference would you use to calculate each row’s total separately? a Mixed reference b Absolute reference c Relative reference 27 True or False: Relative references use $ signs. a Sometimes b False c True 28 True or False: Absolute references use $ signs. a Sometimes b False c True 29 What happens if you forget to use $ for a constant value? a It will change when copied (becomes relative). b Nothing c It becomes a name 30 What is the effect of copying =A1B$1 to the next row? a =A2C$1 b =A2B$1 c =A1B$1 31 If a formula is =A1+$B$1 and $B$1 contains 10, what happens to $B$1 when copied? a Changes to 11 b Becomes 0 c Stays the same (remains 10). 32 Which reference type is best for formulas you will copy to many locations? a Relative reference b Mixed reference c Absolute reference 33 How would you calculate the total price if quantity is in A2 and price per item is in B2? a =A2/B2 b =A2+B2 c =A2B2 34 How would you calculate total expenses if amounts are in C1 to C5? a =SUM(C1,C5) b =SUM(C1:C5) c =AVERAGE(C1:C5) 35 Which formula multiplies cell A1 by 5 and then adds cell B1? a =A15+B1 b =(A15)+B1% c A1(5+B1) 36 Which formula multiplies the sum of A1 and B1 by C1? a =A1+B1C1 b A1+B1C1 c =(A1+B1)C1 37 If you want to calculate commission using a fixed rate in D1, what kind of reference should D1 be? a Mixed reference b Relative reference c $D$1 38 If a discount rate is stored in $C$1, how do you apply it to price in B2? a =$C$1+B2 b =B2$C$1 c B2/$C$1 39 Which function is best for adding a large range of numbers quickly? a AVERAGE b ADD c SUM 40 Which key must be pressed after typing a formula to see the result? a Enter b Space c Escape 41 Why is it important to start formulas with = in Excel? a To tell Excel it's a formula. b To format as text c To start a chart 42 What happens if you forget the = sign in a formula? a Excel will ask for input b It will calculate automatically anyway c It will be treated as text, not a formula. 43 Why would you copy a formula instead of writing it again? a To apply the same calculation to other cells quickly. b It changes the data c It's more accurate 44 What happens if you copy a relative reference down 5 rows? a Row numbers stay the same b Column letters change instead c Row numbers increase by 5 (e.g., A1→A6). 45 What happens if you copy an absolute reference down 5 rows? a Becomes relative b Reference stays the same (no change). c Reference shifts 46 How can you quickly apply the same formula to multiple cells? a Use a macro only b Use the fill handle to drag or double-click. c Re-type it 47 Which formula calculates the total cost by multiplying quantity and price, then adding tax from $C$1? a =(A1+B1)C1 b =(A1B1)+$C$1 c =A1B1+C1 48 How does Excel know which operation to do first? a Order of operations (precedence). b User instruction c It does random choice 49 What is the difference between =A1+(B1C1) and =(A1+B1)C1? a First multiplies A1C1 then adds B1 b First: B1C1 then add A1; second: (A1+B1) then multiply by C1. c Both give the same result 50 How can understanding cell references improve your Excel skills? a It only matters for charts b It helps build correct, reusable formulas. c It slows down calculations

Excel Formulas Mastery

Froggy Jumps

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

El valle de los lobos

Froggy Jumps

Sabiduría animal

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

Salva a la Ranita

Froggy Jumps

Excel Formulas MasteryVersión en línea

por Nova Bel Supang

What is a formula in Excel?

Which symbol must every formula in Excel start with?

Give an example of a simple addition formula in Excel.

How do you write a formula to multiply the value in A2 by 5?

What does the formula =SUM(A1:A5) do?

What are cell addresses in Excel?

Give an example of a cell address.

Which is vertical in Excel—columns or rows?

Which is horizontal in Excel—columns or rows?

Why do we use parentheses in Excel formulas?

Write the formula for adding the numbers in A1 and B1, then multiplying the sum by C1.

If A1=2 and A2=4, what is the result of =A1+A2?

If A1=2, B1=3, and C1=2, what is =A1+(B1*C1)?

What does =A1+B1 become when copied one row down using relative reference?

If C1 contains =A1+5 and is copied to C2, what will C2 contain?

Why does Excel adjust cell references when copying a formula?

How do you keep a cell reference fixed when copying a formula?

If =A1+$B$1 is copied from C1 to C2, which reference will change?

Name one situation where you should use an absolute reference.

What is a relative reference?

What is an absolute reference?

In the format $B$3, which is locked—the column, the row, or both?

What is the main advantage of using relative references?

What is the main advantage of using absolute references?

Which type of reference would you use for a fixed tax rate in a formula?

Which type of reference would you use to calculate each row’s total separately?

True or False: Relative references use $ signs.

True or False: Absolute references use $ signs.

What happens if you forget to use $ for a constant value?

What is the effect of copying =A1*B$1 to the next row?

If a formula is =A1+$B$1 and $B$1 contains 10, what happens to $B$1 when copied?

Which reference type is best for formulas you will copy to many locations?

How would you calculate the total price if quantity is in A2 and price per item is in B2?

How would you calculate total expenses if amounts are in C1 to C5?

Which formula multiplies cell A1 by 5 and then adds cell B1?

Which formula multiplies the sum of A1 and B1 by C1?

If you want to calculate commission using a fixed rate in D1, what kind of reference should D1 be?

If a discount rate is stored in $C$1, how do you apply it to price in B2?

Which function is best for adding a large range of numbers quickly?

Which key must be pressed after typing a formula to see the result?

Why is it important to start formulas with = in Excel?

What happens if you forget the = sign in a formula?

Why would you copy a formula instead of writing it again?

What happens if you copy a relative reference down 5 rows?

What happens if you copy an absolute reference down 5 rows?

How can you quickly apply the same formula to multiple cells?

Which formula calculates the total cost by multiplying quantity and price, then adding tax from $C$1?

How does Excel know which operation to do first?

What is the difference between =A1+(B1*C1) and =(A1+B1)*C1?

How can understanding cell references improve your Excel skills?

What is the difference between =A1+(B1C1) and =(A1+B1)C1?