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.
A dishonest seller, at the time of selling and purchasing uses weight 22% less and 30% more per kg respectively. Find the approx. percent profit earned ...
Jupiter borrowed a sum of Rs 31,500 from Mars at the rate of 14% per annum for 3 years. He added some more money in it and lent it to Saturn at the rat...
A shopkeeper bought 60 kg of apples at ₹80 per kg and 40 kg of oranges at ₹60 per kg. If he wants to make a profit of 20% on the total cost, at what...
- Two goods, E and F, cost Rs. 400 and Rs. 600, respectively. If E is sold at a profit of 18% and F at a loss of 10%, determine the overall profit or loss.
If a boat travels 15 km more in downstream than in upstream in 3 hours and if the speed of the Boat in still water is 17 kmph. Find the distance tra...
- A trader purchases an article for Rs. 2,600. It is marked at 20% above cost price and then sold after offering a discount of Rs. 200. Determine the profit ...
An article with a cost price of Rs. 400 is marked up by 40% above its cost price and sold after a discount of 15%. Calculate the ...
A shopkeeper bought article ‘A’ for Rs. ‘x’ and marked it 25% above its cost price and sold it for Rs. 2600. Marked price of article ‘B’ is ...
Prateek bought 2 items at the same price. He sold one item at 20% profit and another item at 25% profit. What is the overall percentage profit he made?
An article is marked at a price that is 42% higher than its cost price, and its marked price is Rs. 12,070. If a discount of 20% is offered on the marke...
Relevant for Exams:
