Trace the formula, then check what copying changes.
Review range sums, arithmetic order, relative and mixed references, sheet names and explicit error handling.
Your count is the number of matching keys among six selected questions in this edition. It is not an Excel level, job threshold, certificate or percentile. Every answer, explanation and complete guide is available at every count.
Six deliberately small checks
These six tasks separate formula evaluation from reference movement. They cover a range SUM containing text, multiplication before addition, a relative reference beside an absolute factor, a mixed reference copied diagonally, a quoted sheet name and IFERROR. The formulas use English function names, comma argument separators and A1 notation in both interfaces. A local Excel installation may display translated function names or use another list separator; that changes how you enter a formula, not the stated task.
Copy a new example one coordinate at a time
In an unscored example, C4 contains =B4*$G$2. Copy it two rows down to C6: the relative B4 becomes B6, while $G$2 stays fixed. For =$B4+C$2 copied from C4 to D5, the answer is =$B5+D$2. The dollar before a column locks that column; the dollar before a row locks that row. Work out the row and column displacement before combining the pieces, rather than treating every dollar as locking an entire expression.
Separate displayed text from numeric inputs
Write down each cell’s stored type before evaluating a range. SUM over a referenced range ignores text, including a number stored as text; ordinary addition with + is a different operation and can produce an error. For arithmetic, mark parentheses first and then apply operator precedence. In =6+4*3, the product is 12 and the result is 18; =(6+4)*3 instead gives 30. Do not infer the operation from an answer that merely looks familiar.
An error replacement does not repair its cause
IFERROR supplies a chosen result when its first expression produces an error. That can make a report readable, but it can also hide a missing lookup or invalid divisor if the replacement is an unexplained zero. Practise returning a clear message on a disposable worksheet, then inspect the original expression separately. A message saying Check input should lead you to the input; it does not establish that the remaining workbook is correct or that an error was harmless.
Predict, copy and compare on a disposable file
Create a new workbook with invented quantities and one fixed rate. Predict three copied formulas on paper before using Excel’s fill or copy command. Compare the formula bar, not only the resulting numbers: two different formulas can coincide on one set of inputs. Change the rate and one quantity, then check whether each output follows the intended reference. Keep this exercise separate from live operational sheets so that experimenting does not change someone else’s figures.
Read a missed item as a specific review cue
A missed mixed-reference question suggests reviewing which coordinate was fixed in that question. It does not demonstrate a general inability to use spreadsheets. A correct choice also does not prove that you could build, audit and maintain a workbook without visible alternatives. Compare your selected option with the complete explanation, name the precise step that differed, and make a new example with different cells. Repeating the identical bank after reading its keys can measure memory as well as understanding.
A formula recognition guide has a narrow remit
This original guide supports six knowledge decisions. It does not inspect an uploaded workbook, execute your formulas, assess macros, cover every function or issue a Microsoft qualification. The examples are independently written; Microsoft documentation supports selected behavioural rules rather than endorsing this product. Use the current documentation for your installed version when doing real work. No time bonus, recruitment tier, population norm or guaranteed learning gain is attached to your count.