Excel Formulas Mastery

Froggy Jumps

(1)

Played 38

Create copy

About this activity

Test your formula skills.

Created by

Nova Bel Supang

Philippines

Download the paper version to play

Top 10 results

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

Do you want to stay in the Top 10 of this game? Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
pizza

Lorelay Tyana

Romania

(261)

joc despre pizza
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(90)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!

		%
	Anonymous	%
		%
		%

Print your game

Excel Formulas Mastery


Froggy Jumps Excel Formulas MasteryOnline version Test your formula skills. by 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

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

The Integumentary System

Froggy Jumps

pizza

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Excel Formulas MasteryOnline version

by 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?