Question
Which of the following characters is used to create an
absolute address in MS-Excel?Solution
Absolute reference in excel is used when we want to fix the position of the selected cell in any formula so that its value will not change whenever we are changing the cell or copying the formula to other cells or sheets. This is done by putting the dollar ("$") sign before and after the column name of the selected cell. Or else, we can type the F4 function key, which will automatically cover the column alphabet with the dollar.
- The price of a product is increased by Rs. 600. If the old price was 40% less than the new price, then the old price was:
Sana uses x% of her earnings on house rent, then spends 20% of the remaining on groceries, pays Rs. 9400 as miscellaneous bills, and saves Rs. 7240 from...
A company has three departments: A, B, and C. The total monthly salary expenditure is ₹1,200,000. Department A spends 50% of the total salary, Departm...
The monthly incomes of Sarah and David are in the ratio 5:6, respectively, and the respective ratio of their savings is 1:2. If the monthly savings of S...
The incomes of C and D are in the ratio 9:6, while their expenditures are also in the same ratio of 9:6. What is the ratio of the savings of C to that o...
- In 2023, Meena spends 65% of her salary. In 2024, her salary increased by 35%, and she raised her expenditure by 25%. What is the percentage increment in h...
Mahima’s expenditure and savings are in the ratio 5 : 3. Her income increases by 15%. Her expenditure also increases by 18%. By how many % does he sav...
The earnings of ‘X’, ‘Y’, and ‘Z’ are in the ratio 6:2:7 respectively. The average earning of the three friends is Rs. 9,500. If the average...
Anita spends 75% of her monthly income. Next month, her income increased by 16% while her expenditure increased by 11%. Due to this, her monthly savings...
An employee earns a fixed salary and an additional commission of 10% of his fixed salary. The commission received by the employee is Rs. 2500. If he spe...
Relevant for Exams:
