Question
In Microsoft Excel, which function is commonly used to
combine multiple text strings into a single text value?Solution
The CONCATENATE() function (or CONCAT in newer Excel versions) combines two or more text strings into a single string.
A tank can be filled by Pipe A in 24 minutes and by Pipe B in 30 minutes. Both pipes are opened together and after some time Pipe B is closed. If the ta...
Pipes 'A' and 'B' have the capacity to fill a tank in 12 hours and 15 hours, respectively. Conversely, pipe 'C' can drain the same tank in 20 hours. Ini...
Three pipes A, B and C are connected to a reservoir. Pipe A can fill it in 16 minutes, pipe B in 24 minutes, while pipe C can empty it in 12 minutes. Pi...
Pipe 'X' is capable of emptying a tank in 15 hours. When Pipe 'Y', which adds 2.4 liters of water per hour, is also used, it takes 25 hours to empty the...
Pipe ‘A’ can fill a tank in 25 hours while pipe ‘B’ can empty it in 30 hours. They were operated on alternate hours starting with pipe ‘A’. ...
A tank can be filled by two pipes, A and B, in 15 minutes and 20 minutes, respectively. Both pipes are opened together, but after 5 minutes, pipe A is c...
Two pipes M and N can fill a tank in 16 hours and 24 hours respectively. The pipes were opened together, but pipe N stopped working after sometime and t...
Pipes 'J' and 'K' can fill a tank in 12 hours and 18 hours respectively, while pipe 'L' can empty it in 36 hours. All pipes are opened together when the...
Pipe A and Pipe B together can fill the tank in 15 hours. The capacity of the pipe A is 20% of the capacity of the pipe B. How much time will pipe B alo...
The work done by a man, a woman and a child are in the ratio of 4 :3: 1. There are 15 men, 20 women and 30 children in a factory. Their weekly wages amo...
Relevant for Exams:
