Final answer:
The question seems to ask for help writing Excel formulas using absolute and relative references, but the provided cell references and intended calculations are unclear, possibly due to typos. Accurate construction of formulas requires clarity on the patterns and calculations needed.
Step-by-step explanation:
Understanding how to write formulas in Microsoft Excel with absolute and relative cell references is essential for working with data efficiently. An absolute reference is designated by the dollar sign ($), which tells Excel to keep the reference constant regardless of where the formula is copied. For instance, $C$4 will always refer to cell C4, even if the formula is moved or copied elsewhere. Relative references, on the other hand, change when copied to a different cell because they are relative to the position where they are written. When providing the formula for the highlighted cells, we must discern from the context whether to use absolute or relative cell references based on the needs of the computation.
Unfortunately, the given question does not provide clear instruction on whether absolute or relative references should be used for each specific part of the provided formulas. Additionally, some of the provided references such as E$3,4 or $F$2,4 do not follow standard Excel notation and could be typos or incorrect formatting. Without further clarification on the conventions being used or the intended operations, it is difficult to provide accurate formulas.
To correct and improve the formulas, we need clarity on the patterns of the data and the calculations required. Once this information is available, one can write formulas that accurately process and compute the necessary values within Excel using the combination of absolute and relative cell references that the task requires.