MS Excel: formulas, functions and charts MCQ - Practice Questions with Answers

Relative and absolute references stand in contrast. A relative reference such as A1 changes when the formula is copied, so copying =A1+B1 from C1 down to C2 shifts both references one row to give =A2+B2. An absolute reference uses dollar signs before the column and row, as in $A$1, and stays fixed wherever it is copied. Since both statements describe these behaviours correctly, both are right.

In Microsoft Excel, a formula is entered by first typing the equals sign. This tells Excel that the cell should calculate a result rather than store ordinary text. A full stop is punctuation and does not start an Excel formula. An asterisk is used inside formulas for multiplication, but it is not the opening marker. A vertical bar is not used to begin formulas in Excel. Therefore, the equals sign is the required beginning character for formulas such as =A1+B1 or =SUM(A1:A5).

A key idea is that using cell references is better than typing fixed numbers, because the result updates when the source cells change. The formula =A1+B1 therefore recalculates whenever A1 or B1 changes, so it does not keep showing the same value. This makes the assertion false. The reason correctly states why references behave this way, so the reason is true and it explains why the assertion fails. Hence the assertion is false while the reason is true.

Chart selection must match the purpose of the data. Column or bar charts compare categories, line charts show trends over time, and pie charts show parts of one whole, such as percentage share of expenditure heads. The relation between two numeric variables, such as study hours and marks, is not a part-of-whole question. A scatter chart is identified as the suitable chart for the relationship between two numeric variables, so using a pie chart for that relation is incorrect.

In MS Excel, the POWER function takes two arguments: the number and the power, separated by a comma, so = POWER (2,3) is the correct form among the printed choices. The expression using 2^3 places an exponent expression where the function expects separated arguments. The expression using 2*3 supplies multiplication inside a single argument instead of two arguments. The expression using 2#3 uses an invalid separator for this function.