Basic Excel: Expenses Tracker

Froggy Jumps

Jugadas 76

Crear copia

Sobre esta actividad

Build a simple monthly expense sheet

Creada por

SABINO

Estados Unidos

Descarga la versión para jugar en papel

Top 10 resultados

Todavía no hay resultados para este juego. ¡Sé el primero en aparecer en el ranking! 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

Salva a la Ranita

Melanie Rodriguez

Estados Unidos

(334)

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

(97)

Repasamos el vocabulario de la unidad
Sabiduría animal

Educaplay Educational Resources

España

(15298)

Conviértete en un genio del Reino Animal
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

(170)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.

		%
	Anónimo	%
		%
		%

Imprime tu juego

Basic Excel: Expenses Tracker


Froggy Jumps Basic Excel: Expenses TrackerVersión en línea Build a simple monthly expense sheet por 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

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.

Basic Excel: Expenses Tracker

Froggy Jumps

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

Salva a la Ranita

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

Sabiduría animal

Froggy Jumps

El valle de los lobos

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

Basic Excel: Expenses TrackerVersión en línea

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