MS Excel Formulas | MCQs

Explanation

=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.

The colon : denotes a continuous range of cells.

Explanation

Let's calculate:

F7 = 12

H12 = 30

Formula: F7 * H12 = 12 * 30 = 360

Explanation

In MS Excel, the $ symbol locks the row and/or column in a cell reference (e.g., $A$1).

This is used in formulas to create an absolute reference that does not change when copied.