Question
Which of the following symbols/characters is used to
enter a formula in the cell of an MS-Excel worksheet?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.
More MS Office Questions
15.99% of 549.99 ÷ 11.17 = ? ÷ 20.15
74.91% of 639.95 – 599.98% of 45 + 119.987 = ?
(4.88 × 5.76)2 - ?2 = 39.89 × 19.86
- What approximate value will come in place of the question mark (?) in the following question? (Note: You are not expected to calculate the exact value.)
- What approximate value will come in place of the question mark (?) in the following question? (Note: You are not expected to calculate the exactvalue.)
(1800.23 ÷ 29.98) + (816.32 ÷ 23.9) + 1634.11 = ?
1449.98 ÷ 50.48 × 10.12 = ? × 2.16
36.05 × 5.02 + 12.052 = ? + 9.09 × 4.04Â
(31.9)3 + (34.021)² - (16.11)3 - (42.98)² = ?
