Basic Computer: MS Excel Formulas & Functions MCQ — 15 Practice Questions with Answers

Explanation

The error #DIV/0! in Excel indicates that a formula is trying to divide a number by zero or by an empty cell treated as zero. In the assertion, =B2/C2 divides the value in B2 by the value in C2. If C2 contains 0, the operation is division by zero. The reason states the exact rule behind the error: division by zero cannot give a valid numeric answer. Therefore both A and R are true, and R correctly explains A.

Explanation

AVERAGE calculates the arithmetic mean of the selected numbers. MAX returns the largest value in a range, and MIN returns the smallest value. COUNT counts how many cells in the selected range contain numbers. Reading List II with these standard meanings gives I-3, II-1, III-4 and IV-2. The question tests function purpose, not formula spelling, so the key is to recall what each common Excel function returns.

Explanation

In Excel, the SUM function adds numeric values. A colon between two cell references means a continuous range, so B2:B5 covers B2, B3, B4 and B5. The stem names four consecutive cells, so a range formula is the most direct form. =SUM(B2,B5) would add only the first and last cells, while ADD is not the standard Excel function. A formula must also begin with the equal sign. Therefore, =SUM(B2:B5) is the correct answer.

Explanation

The reference $C$4 is an absolute cell reference. The dollar sign before C locks the column, and the dollar sign before 4 locks the row. Therefore, when a formula containing $C$4 is copied elsewhere, Excel keeps the reference as $C$4. The question asks for the incorrect statement. Automatic change from C4 to C5 is behaviour of a relative reference such as C4, not of the absolute reference $C$4. Hence option D is incorrect.

Explanation

Excel uses a colon to show a continuous range of cells. Therefore A1:A5 means A1, A2, A3, A4 and A5 together. The SUM function then adds all numeric values in that range. The stem asks for all values from A1 to A5, so the formula must include both the correct function name and the correct range operator. =SUM(A1:A5) satisfies both conditions.