Excel Formulas Mastery

Froggy Jumps

(1)

Parties jouées 38

Créer une copie

À propos de cette activité

Test your formula skills.

Créé par

Nova Bel Supang

Philippines

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	Brenna 13 Août 2025	% 88	07:11
2	Pearl 13 Août 2025	% 88	07:30
3	Leira Jumalon 13 Août 2025	% 86	05:48
4	Keann Sam Uy 13 Août 2025	% 86	06:55
5	Angelo 13 Août 2025	% 84	07:34
6	Kaye Angelie 13 Août 2025	% 84	08:24
7	david 13 Août 2025	% 82	08:35
8	dan aldrei 13 Août 2025	% 78	06:28
9	Ocampos CG 13 Août 2025	% 76	06:56
10	Kate 13 Août 2025	% 76	08:52

Voulez-vous apparaître dans le Top 10 de ce jeu? 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

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.
pizza

Lorelay Tyana

Romania

(261)

joc despre pizza
The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
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!

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Excel Formulas Mastery


Froggy Jumps Excel Formulas MasteryVersion en ligne Test your formula skills. par 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

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Excel Formulas MasteryVersion en ligne

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