Typing Settings

Cursor won't advance until you press the correct key

Enable or disable backspace to correct mistakes

Play sounds when typing

FinancePractice all formula categories

Key Characters

=Formula start
$Absolute ref
:Range
,Arguments
()Function
Loading...
Show GuideHide Guide

Learn as you practice

Finance practice guide

Finance mode practices the notation used in spreadsheet formulas. It combines letters and numbers with punctuation whose position matters: equals signs, range colons, argument commas, dollar signs, and parentheses. The tool checks transcription; it does not calculate a workbook or provide financial advice.

Start with references, then choose a function family

Select Cell References to work on references such as A1, $A$1, and A1:B10. A colon describes a range. A dollar sign fixes the following column or row when a formula is copied in a spreadsheet: $A1 fixes the column, A$1 fixes the row, and $A$1 fixes both.

The other categories focus on lookup, math and statistics, logical, text, date, and financial functions. Choose five items when learning a category, then increase to 10, 15, or 20. All Categories mixes function families. New Formulas replaces the current block without changing your selected category.

=SUM(B2:B6)
=B2*$E$1
The first example adds the values from B2 through B6. In the second, B2 is relative while $E$1 stays fixed when copied. Pay attention to the colon in the first line and the two dollar signs in the second.

Break a formula into meaningful groups

Read the opening =, the function name, the opening parenthesis, each argument, and the closing parenthesis as separate groups. This makes a missing comma easier to find than treating the whole formula as an undifferentiated string. Quoted text and comparison operators deserve the same attention as cell names.

Nested formulas add another pair of parentheses for each function call. Before typing the final characters, check which function each closing parenthesis belongs to. Copy capitalization and separators exactly as displayed. A localized spreadsheet may use different separators; this drill follows its displayed syntax rather than your spreadsheet’s locale.

=IF(C2>=100,"Review","OK")
C2>=100 is the condition. The comma introduces the text returned when it is true, and the next comma introduces the false result. Both strings need their quotation marks, and the final parenthesis closes IF.

Use mistakes to choose the next block

If you repeatedly miss $ or :, return to Cell References for a shorter block. If letters are accurate but parentheses are often missing, choose a function category and slow down at the end of each expression. If quotation marks are the problem, logical and text functions give you useful repetition.

Keep accuracy and raw WPM together when evaluating progress. A nested lookup formula requires different reaches from a short SUM expression, so comparing their speeds alone can be misleading. First improve reliability within one category, then use All Categories to check whether that reliability carries across formats.

Common questions

Are these formulas calculated?
No. TypingDuck checks whether you type the displayed characters. It does not evaluate functions, validate a workbook, or check the values in referenced cells.
Can I replace a comma with a semicolon?
Not in an exact-text drill. Even if your spreadsheet locale uses semicolons, copy the separator shown here to complete the exercise.
Do formula results prove my finance knowledge?
No. These exercises measure typing performance on formula-shaped text. They do not assess accounting knowledge, investment decisions, or spreadsheet-model correctness.