Microsoft Excel ( Form 4, Accounting Commercial )

Yes or No

Played 0

Create copy

About this activity

True/false quiz on Excel basics for accounting.

Created by

YAKILI LMS

Cameroon

Download the paper version to play

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

Is it created with Artificial Intelligence? - Complete game

Educaplay Educational Resources

Spain

(17)

Images, songs... Nothing is what it seems anymore. Are they generated with AI, or are they real?
Foot and Ankle Anatomy Quiz

Thilaxshi Suresh

United Kingdom

(9)

Test your knowledge of the bones, joints, and muscles of the foot and ankle with this interactive quiz. Answer with ✅ if the statement is correct and ❌ if it is incorrect.
Adjective Checker

Erika Moreno

Ecuador

(14)

In this game, you will have to determine if the adjective provided accurately describes the noun. Test your knowledge of adjectives and see if you can spot the correct matches!
Is it true?

Educaplay Educational Resources

Spain

(59)

Answer if the following sentences about general culture are true or not.
Grammys for best song/record

Educaplay Educational Resources

Spain

(50)

Answer if these songs won the Grammy for Best Song or Record of the Year (the general ones, category Grammys do not count)

		%
	Anonymous	%
		%
		%

Print your game

Microsoft Excel ( Form 4, Accounting Commercial )


Microsoft Excel ( Form 4, Accounting Commercial )Online version True/false quiz on Excel basics for accounting. by 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 )

Yes or No

About this activity

Created by

Download the paper version to play

Top Games

Yes or No

Is it created with Artificial Intelligence? - Complete game

Yes or No

Foot and Ankle Anatomy Quiz

Yes or No

Adjective Checker

Yes or No

Is it true?

Yes or No

Grammys for best song/record

Microsoft Excel ( Form 4, Accounting Commercial )Online version

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