MCQ
Basic Computer: MS Excel Formulas & Functions MCQ - Practice Questions with Answers
Solve 15 Basic Computer: MS Excel Formulas & Functions questions for RAS/RPSC preparation.
Practice questions
Q1Assertion (A): In Excel, a formula such as =B2/C2 may display the error #DIV/0! if C2 contains 0. Reason (R): Division by zero does not produce a valid numeric result in Excel. Choose the correct option.
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.
Q2Match List I with List II for common Excel functions. List I: I. AVERAGE II. MAX III. MIN IV. COUNT List II: 1. Returns the largest value 2. Counts numeric entries 3. Returns the arithmetic mean 4. Returns the smallest value Select the correct answer.
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.
Q3In MS Excel, which formula correctly adds the values in cells B2, B3, B4 and B5?
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.
Q4Which of the following statements about the Excel cell reference $C$4 is incorrect?
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.
Q5Which formula correctly adds all values from cell A1 to cell A5 in MS Excel?
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.
You've seen 5 of 15 sample questions
Unlimited practice on Basic Computer: MS Excel Formulas & Functions comes with the RAS Test Series + Practice pack or Gate Pass.
More questions
6Which formula correctly adds the values from cell A1 to cell A5 in MS Excel?
7In MS Excel, which symbol is used at the beginning of a formula entered in a cell?
8Match List I with List II. List I: I. SUM II. AVERAGE III. COUNT IV. MAX List II: a. Gives the largest value b. Counts numeric entries c. Adds values d. Gives the arithmetic mean Choose the correct matching.
9Consider the following statements about the Excel reference $B$2. Statement I: The dollar signs fix both the column and the row in the reference. Statement II: If a formula containing $B$2 is copied to another cell, the reference remains $B$2. Which of the above statements is/are correct?
10Consider the following statements about the Excel formula =AVERAGE(A1:A5). Assertion (A): Blank cells in the range A1:A5 are ignored while calculating the average. Reason (R): The AVERAGE function divides the sum by the count of numeric values, not by the total number of cells in the range.
11Which character tells MS Excel that the entry typed in a cell should be treated as a formula?
12Assertion (A): If the formula =5+2 is entered in an Excel cell and Enter is pressed, the cell normally displays 7. Reason (R): Excel calculates a formula and displays its result in the worksheet cell, while the formula can be seen in the formula bar when that cell is selected. Choose the correct option.
13In MS Excel, which symbol must normally be typed first when you enter a formula in a worksheet cell?
14Match the MS Excel functions with their usual purpose. List I: I. AVERAGE II. MAX III. COUNT IV. MIN List II: 1. Finds the smallest value 2. Counts numeric entries 3. Finds the largest value 4. Calculates the arithmetic mean
15Statement I: In Excel, A1 is a relative cell reference. Statement II: In Excel, $A$1 is an absolute cell reference because both the column and the row are fixed. Which option is correct?