10th Class Computers Science Microsoft Excel Question Bank MS-Excel 2010

  • question_answer
    In the function, = SUBSTITUTE ("Mathematics", "Ma", "Ve", 1), what does the number 1 indicate?

    A) Reference to the cell containing text.

    B) Instance number of new text to be replaced.

    C) Instance number of old text to be replaced.

    D) None of these

    Correct Answer: C

    Solution :

    It specifies which occurrence of old text you want to replace with new text. If nothing is specified then by default first occurrence is replaced.


You need to login to perform this action.
You will be redirected in 3 sec spinner