Start learning 50% faster. Sign in now
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.
In a given years, A sold 1800 caps while B sold 45% more number of caps than A and C sold 20% less number of caps than B. Find the ratio between the num...
A spent 35% and 20% of his monthly salary on food and rent, respectively. Of the remaining amount, he gave 15% and 20% to his mother and brother, respec...
After increase in the price of coffee by 15%, a person is able to buy 3 kg less for Rs. 1,840. Find the original and increased price of the coffee per kg?
Pokemon's expenditure exceeds his savings by 40%. He allocates 30% of his total expenditure towards rent, which amounts to Rs. 2100. Calculate Pokemon's...
The station master decides that the length of the rectangular digital board be increased by 5% and the width be reduced to 7%. Find out the total change...
A man invested all his current month income in starting of a new business in which he spends 30% in advertisement 15% of remaining in furniture 20% of r...
The monthly salary of a person is Rs.30000. He spent a% on rent and (a+5)% on EMI. From the remaining, he spend 45% on Education. Find amount spent on E...
In a test, P got 25% of total marks and failed by 60 marks while Q got 45% of total marks which is 23 more than passing marks. Find the total marks of t...
What % of 115 is 23?