Question
In MS Excel 365, which of the following is an example of
absolute reference pointing to cell A1?Solution
In Excel, $A$1 is an absolute reference, meaning it will not change when the formula is copied to another cell. The dollar signs ($) lock both the column and the row. Knowledge Booster: 1. A1 is a relative reference that adjusts when copied. 2. Absolute references are essential for fixed-value formulas. 3. Mixed references like $A1 or A$1 lock only one dimension. 4. Shortcut: Press F4 to toggle reference types.
A and B are two friends. 9 years hence, age of A will become 2.5 times the present age of B, and the age of B will become 30% less than the present age ...
Which of the following is a video format?
- In four years, the total age of 'Ravi' and 'Manoj' will be 60 years. Twelve years ago, Ravi was 10 years younger than Manoj. What will be Manoj's age 3 yea...
The total age of A, B and C six years hence will be 89 years. Find the age of C five years hence, if the present age of A and B is 33 years and 24 years...
Currently, the ages of Rahul and Ritesh are in a ratio of 7:3. If we look back three years, the ages of Ritesh and Ramesh had a ratio of 1:3. Knowing th...
- The present age ratio of M and N is 7:9. In 6 years, their age ratio will be 5:6. Find the present age of M.
The present average age of ‘A’ and ‘B’ is 10 years, present average age of ‘A’ and ‘C’ is 6 years and present average age of ‘B’ and...
- The current age ratio of 'P' and 'Q' is 4:7 respectively. The ratio of the age of 'P' six years from now and the age of 'Q' six years ago is 5:6 respective...
The ratio of the present ages of Ginni and Binni is 9:2 respectively. Ginni is ‘n’ years older than Binni. If after 5 years, the ratio of the ages o...
Determine the average current age of 'A' and 'B', given that six years ago, 'A' was 12 years younger than 'B', and twelve years from now, the ratio of t...
Relevant for Exams:
