All MCQs

Conditional Formatting applies visual styles when cell values meet defined rules.
It can draw attention to low marks without changing the underlying numbers.

A PivotTable summarizes large tabular data by selected categories and measures.
It can reorganize totals interactively without manually writing many separate formulas.

A column chart clearly compares the magnitude of values across discrete categories.
The alternatives are intended for different data relationships or structures.

Filtering temporarily hides rows that do not meet selected criteria.
The complete dataset remains available and can be restored by clearing the filter.

Descending sorting arranges numeric values from largest to smallest.
It changes row order while preserving the relationship among values in each row.

Dragging the fill handle can repeat formulas and continue patterns such as dates or numbers.
It speeds repetitive entry while adjusting relative references when appropriate.

A dollar sign before B locks the column, while the row has no dollar sign.
This mixed reference is useful when one dimension must stay constant.

Dollar signs before both the column and row create an absolute reference.
The formula continues to point to cell A1 regardless of where it is copied.

A1 is a relative reference, so it adjusts according to the formula’s new position.
Copying downward changes the row relationship from row 1 to row 2.

COUNTIF applies a criterion and counts matching cells.
It is more selective than COUNT, which counts numeric cells without the same condition logic.

IF tests a condition and returns one result when true and another when false.
It is suited to two-outcome logical decisions such as pass or fail.

COUNT reports how many cells in a range contain numeric values.
It does not total the values or manipulate text and dates in the same way as the alternatives.