Question

    Which of the following symbols/characters is used to

    enter a formula in the cell of an MS-Excel worksheet?
    A Ampersand (&) Correct Answer Incorrect Answer
    B Equal (=) Correct Answer Incorrect Answer
    C Percent (%) Correct Answer Incorrect Answer
    D Dollar ($) Correct Answer Incorrect Answer

    Solution

    In MS-Excel, formulas always begin with an equal sign (=). It tells Excel to treat the input as a formula, not as regular text or numbers. Knowledge Booster: 1. $ is used for absolute cell references. 2. & concatenates text in Excel. 3. % is used for percentage formatting. 4. Formulas can perform arithmetic, logical, and lookup operations.

    Practice Next