Microsoft Excel ( Form 4, Accounting Commercial )

Sí o No

Jugadas 0

Crear copia

Sobre esta actividad

True/false quiz on Excel basics for accounting.

Creada por

YAKILI LMS

Camerún

Descarga la versión para jugar en papel

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

OPEN UP 5 UNIT 3: THERE IS/ARE, THERE WAS, THERE WERE

karen blixen

España

(11)

Estudiamos el grammar de la Unidad
¿Está creado con Inteligencia Artificial?

Educaplay Educational Resources

España

(6207)

Imágenes, canciones... Ya nada es lo que parece. ¿Están hechas con IA o son reales?
¿Es verdad?

Educaplay Educational Resources

España

(244)

Responde si las siguientes frases sobre cultura general son verdaderas o no.
Grammys a mejor canción/grabación

Educaplay Educational Resources

España

(126)

Responde si estas canciones ganaron el Grammy a Mejor canción o grabación del año (los generales, no cuentan los Grammys de categorías)
Preguntas sobre futbol para niños

Telminator Boom

España

(96)

Un juego de preguntas y respuestas para niños sobre el fútbol. Deberán responder con ✅ o ❌ a una serie de afirmaciones relacionadas con este deporte.

		%
	Anónimo	%
		%
		%

Imprime tu juego

Microsoft Excel ( Form 4, Accounting Commercial )


Microsoft Excel ( Form 4, Accounting Commercial )Versión en línea True/false quiz on Excel basics for accounting. por YAKILI LMS 1 Dates can only be entered as mm/dd/yyyy in Excel. Yes No 2 Excel can use the SUM function to total a column of numbers. Yes No 3 Excel can only sum numbers if they are entered as integers; decimals are not supported. Yes No 4 In Accounting format, negatives are always shown as red with a minus sign. Yes No 5 You can create a basic accounting template in Excel with Debit and Credit columns. Yes No 6 A formula with relative references (like A1) updates when copied to another cell. Yes No 7 PivotTables delete the underlying data when you refresh them. Yes No 8 Excel can format numbers as currency and display amounts in XAF for Cameroon. Yes No 9 You can insert charts in Excel to visualize sales data. Yes No 10 VLOOKUP can return values from columns to the left of the lookup column. Yes No 11 Adjust column widths so headers and data are fully visible. Yes No 12 Enter dates in a consistent date format (e.g., dd/mm/yyyy). Yes No 13 Format monetary columns to the Accounting format. Yes No 14 Use the General format for monetary values to avoid decimal places. Yes No 15 Dates can be entered as text and Excel will sort them correctly. Yes No 16 Create a new workbook and save it with a descriptive name. Yes No 17 Use the first worksheet to list Date, Description, Debit, and Credit columns. Yes No 18 Save the workbook as a Word file (.docx) to keep the ledger. Yes No 19 Debit and Credit columns can store letters and numbers interchangeably. Yes No 20 The header row should be in row 2 to leave row 1 for a title. Yes No 21 You can apply a number format to a selected range to control how numbers appear. Yes No 22 Decimals can be increased or decreased using the Increase Decimal and Decrease Decimal commands. Yes No 23 Borders cannot be applied to merged cells. Yes No 24 In the Accounting format, negative values are shown with a minus sign before the amount. Yes No 25 The Accounting format aligns the currency symbol to the left and uses parentheses for negative values. Yes No 26 The Format Cells dialog cannot change the font style. Yes No 27 Currency or accounting formats display numbers with a currency symbol. Yes No 28 The Format Cells dialog lets you set numbers, alignment, font, borders, and fill. Yes No 29 Formatting cells can only be applied to one cell at a time. Yes No 30 Dates must be entered in ISO format (YYYY-MM-DD) for the date format to show correctly. Yes No 31 Net profit is calculated as Gross profit minus operating expenses. Yes No 32 Cost of Goods Sold equals Opening stock plus Purchases. Yes No 33 Depreciation using straight-line method is (Cost - Residual value) / Useful life. Yes No 34 Accumulated depreciation increases the book value of assets. Yes No 35 Revenue is the same as net income. Yes No 36 Current ratio is current assets divided by current liabilities. Yes No 37 Gross profit is calculated as Sales minus Cost of Goods Sold. Yes No 38 Return on investment (ROI) = Net profit / Cost of investment. Yes No 39 Net profit equals Sales minus Cost of Goods Sold. Yes No 40 The acid-test ratio is calculated as Current liabilities divided by Quick assets. Yes No 41 The AVERAGE function calculates the mean of a range of numbers. Yes No 42 The IF function can perform a logical test and return different results. Yes No 43 The SUM function adds all the numbers in a selected range. Yes No 44 MAX returns the most frequently occurring value. Yes No 45 CONCATENATE multiplies two numbers. Yes No 46 IFERROR counts how many errors appear in a range. Yes No 47 VLOOKUP can search for a value in any column of the table and return a value from the same row. Yes No 48 VLOOKUP searches for a value in the first column of a table and returns a value in the same row. Yes No 49 SUMIF adds values in a range that meet a specified criterion. Yes No 50 PMT function calculates the future value of a loan. Yes No

Microsoft Excel ( Form 4, Accounting Commercial )

Sí o No

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Sí o No

OPEN UP 5 UNIT 3: THERE IS/ARE, THERE WAS, THERE WERE

Sí o No

¿Está creado con Inteligencia Artificial?

Sí o No

¿Es verdad?

Sí o No

Grammys a mejor canción/grabación

Sí o No

Preguntas sobre futbol para niños

Microsoft Excel ( Form 4, Accounting Commercial )Versión en línea

por YAKILI LMS

Dates can only be entered as mm/dd/yyyy in Excel.

Excel can use the SUM function to total a column of numbers.

Excel can only sum numbers if they are entered as integers; decimals are not supported.

In Accounting format, negatives are always shown as red with a minus sign.

You can create a basic accounting template in Excel with Debit and Credit columns.

A formula with relative references (like A1) updates when copied to another cell.

PivotTables delete the underlying data when you refresh them.

Excel can format numbers as currency and display amounts in XAF for Cameroon.

You can insert charts in Excel to visualize sales data.

VLOOKUP can return values from columns to the left of the lookup column.

Adjust column widths so headers and data are fully visible.

Enter dates in a consistent date format (e.g., dd/mm/yyyy).

Format monetary columns to the Accounting format.

Use the General format for monetary values to avoid decimal places.

Dates can be entered as text and Excel will sort them correctly.

Create a new workbook and save it with a descriptive name.

Use the first worksheet to list Date, Description, Debit, and Credit columns.

Save the workbook as a Word file (.docx) to keep the ledger.

Debit and Credit columns can store letters and numbers interchangeably.

The header row should be in row 2 to leave row 1 for a title.

You can apply a number format to a selected range to control how numbers appear.

Decimals can be increased or decreased using the Increase Decimal and Decrease Decimal commands.

Borders cannot be applied to merged cells.

In the Accounting format, negative values are shown with a minus sign before the amount.

The Accounting format aligns the currency symbol to the left and uses parentheses for negative values.

The Format Cells dialog cannot change the font style.

Currency or accounting formats display numbers with a currency symbol.

The Format Cells dialog lets you set numbers, alignment, font, borders, and fill.

Formatting cells can only be applied to one cell at a time.

Dates must be entered in ISO format (YYYY-MM-DD) for the date format to show correctly.

Net profit is calculated as Gross profit minus operating expenses.

Cost of Goods Sold equals Opening stock plus Purchases.

Depreciation using straight-line method is (Cost - Residual value) / Useful life.

Accumulated depreciation increases the book value of assets.

Revenue is the same as net income.

Current ratio is current assets divided by current liabilities.

Gross profit is calculated as Sales minus Cost of Goods Sold.

Return on investment (ROI) = Net profit / Cost of investment.

Net profit equals Sales minus Cost of Goods Sold.

The acid-test ratio is calculated as Current liabilities divided by Quick assets.

The AVERAGE function calculates the mean of a range of numbers.

The IF function can perform a logical test and return different results.

The SUM function adds all the numbers in a selected range.

MAX returns the most frequently occurring value.

CONCATENATE multiplies two numbers.

IFERROR counts how many errors appear in a range.

VLOOKUP can search for a value in any column of the table and return a value from the same row.

VLOOKUP searches for a value in the first column of a table and returns a value in the same row.

SUMIF adds values in a range that meet a specified criterion.

PMT function calculates the future value of a loan.