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.
Quantity I: A bag contains 5 red, 7 blue, and 8 green balls. Two balls are drawn randomly. What is the probability that both balls drawn are green?
...Quantity I:Â An article is marked 36% above its cost price and then sold at a disc...
Quantity I: In how many ways can a committee consisting of 2 Managers and 5 Team Leaders be selected from a group of 7 Managers ...
Pawan, Qureshi, and Ram started a business with initial investments of Rs. (x + 1500), Rs. x, and Rs. (x - 1000), respecti...
Quantity-I: The area of a triangle is 72 cm². The base of the triangle is 12 cm. Find the height of the triangle.
Quantity-II: The area of a rec...
Quantity I: The age of A is sixteen times that of her son B. If the age of B is 4 years, what is the age of A?
Quantity II: The ratio between the...
Quantity I: There are two types of animals in a pet shop. Some are puppies and some are kittens. Each kitten takes 8 biscuits and each puppy takes 11 bi...
Quantity I: The ratio of the ages of A and B is 3:1, and the ratio of the ages of B to C is 3:5. If C’s age after 20 years equals A’s current age, a...
In the question, two quantities i.e. Quantity I and Quantity II are given. Solve the given quantities to establish the correct relation between them an...
Quantity I: A shopkeeper bought 300 pens for Rs 1200. He wanted to sell them at a profit so that he got 36 pens for free. At what profit percent should ...
Relevant for Exams:
