Basic Excel: Expenses Tracker

Froggy Jumps

Parties jouées 76

Créer une copie

À propos de cette activité

Build a simple monthly expense sheet

Créé par

SABINO

United States

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

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

Basic Excel: Expenses Tracker


Froggy Jumps Basic Excel: Expenses TrackerVersion en ligne Build a simple monthly expense sheet par SABINO 1 What is the first step to start the exercise sheet? a Open Word and create a new document b Open Excel and start a new blank workbook c Open Excel and load a template 2 Which column headers should be in Row 1? a Type, Value, Time, Details b Category, Amount, Date, Notes c Item, Total, Day, Comments 3 What data goes under the Amount column? a Notes about expenses b Monetary expense amounts c Dates of transactions 4 What format should the Amount column be set to? a Date format b Currency format c Percentage format 5 How should the header row appear after formatting? a Bold with a background color b Italic with a border c Underlined with no fill 6 What border action helps clarity for the table? a Add borders to the table b Hide borders c Use dotted lines only 7 Which data row contains Rent for the sample? a Row 6 b Row 1 c Row 2 8 What is the date format used in the sample data? a DD-MM-YYYY b YYYY-MM-DD c MM/DD/YY 9 What does B7 calculate in the sheet? a Total expenses (SUM B2:B6) b Average expense (AVERAGE B2:B6) c Count of entries (COUNT B2:B6) 10 What does B8 calculate in the sheet? a Maximum expense (MAX B2:B6) b Average expense (AVERAGE B2:B6) c Total expenses (SUM B2:B6) 11 How are the Total and Average labels entered? a A7: Grand Total and A8: Median b A7: Total and A8: Average c A7: Sum and A8: Mean 12 Which cells contain the total and average formulas? a A7 and A8 b B7 and B8 c C7 and C8 13 What is the purpose of inserting a Pie Chart? a Visualize spending by category b Compare currencies c Show yearly trend 14 Which columns are selected to create the pie chart? a B and D (B2:D6) b A and B (A2:B6) c A and C (A2:C6) 15 Which menu path creates the chart? a View > Pie Chart b Data > Pie Chart c Insert > Pie Chart 16 Which data should be included in the chart data range? a Dates and notes (C2:D6) b Categories and amounts (A2:B6) c Only amounts (B2:B6) 17 What is a good practice after creating the table? a Apply borders and formatting b Hide the worksheet c Delete the data 18 What label corresponds to the sum of B2:B6? a Total b Sum c Average 19 What label corresponds to the average of B2:B6? a Average b Median c Mean 20 Which action completes the bonus task? a Create a Bar Chart of B2:B6 b Create a Line Chart of A2:A6 c Create a Pie Chart of A2:B6

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.

Basic Excel: Expenses Tracker

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

Ethos, Pathos, and Logos Quiz

Froggy Jumps

The Integumentary System

Froggy Jumps

pizza

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Basic Excel: Expenses TrackerVersion en ligne

par SABINO

What is the first step to start the exercise sheet?

Which column headers should be in Row 1?

What data goes under the Amount column?

What format should the Amount column be set to?

How should the header row appear after formatting?

What border action helps clarity for the table?

Which data row contains Rent for the sample?

What is the date format used in the sample data?

What does B7 calculate in the sheet?

What does B8 calculate in the sheet?

How are the Total and Average labels entered?

Which cells contain the total and average formulas?

What is the purpose of inserting a Pie Chart?

Which columns are selected to create the pie chart?

Which menu path creates the chart?

Which data should be included in the chart data range?

What is a good practice after creating the table?

What label corresponds to the sum of B2:B6?

What label corresponds to the average of B2:B6?

Which action completes the bonus task?