Question

The correct sequence to enter a formula in MS-Excel that contains a built-in function is: A. Type an opening parenthesis \((\). B. Press enter to get result. C. Select an empty cell. D. Select the range of cells and type a closing parenthesis \()\). E. Type an equal sign \((=)\) and then type a function.

• A. A, B, C, D, E
• B. C, E, A, D, B
• C. E, A, C, D, B
• D. E, B, A, C, D

Hint:

In Excel, first select a cell, then type \(=\), function name, parentheses, cell range, and press Enter.

Answer 1

The Correct Option is B

Concept:
In MS-Excel, formulas always begin with an equal sign. Built-in functions such as SUM, AVERAGE, COUNT, etc. are written using parentheses.

Step 1: Select an empty cell.
First, the user selects the cell where the answer should appear. \[ \text{First step} = C \]

Step 2: Type equal sign and function name.
Every Excel formula begins with: \[ = \] For example: \[ =SUM \] \[ \text{Second step} = E \]

Step 3: Type opening parenthesis.
After the function name, an opening parenthesis is typed. \[ \text{Third step} = A \]

Step 4: Select range and close parenthesis.
Then the range of cells is selected and the closing parenthesis is typed. \[ \text{Fourth step} = D \]

Step 5: Press Enter.
Finally, pressing Enter gives the result. \[ \text{Fifth step} = B \] Thus, the correct sequence is: \[ C,\ E,\ A,\ D,\ B \] \[ \therefore \text{Correct Answer is (B)} \]