Important formulas boats and streamsquantitative aptitude. Mathematical formula for competitive exams math shortcut. Find all the shortcut keys that will save you time and increase productivity. Complete a cell entry and move to the left in the selection.
Heres the complete list of ms excel function key f1 to f12 shortcuts. Find the speed of stream and speed of boat in still water. Webdings character set and equivalent unicode characters. The shortcut f4 will also deftly cycle through all the combinations of locked and unlocked locations or data when a formula in a cell is being edited. Video lectures to prepare quantitative aptitude for placement tests and competitive exams like mba, bank exams, rbi, ibps, ssc, sbi, rrb, railway, lic, mat.
Sir ek question puchhna tha sir application download karne ke bad. Aptitude made easy problems on boats and streams1, basics and. I pulled out my top 10 useful excel shortcuts theres something here for everyone, from beginner to advanced. Quick access to excel formula bar via keyboard by susan harkins in microsoft office, in hardware on july 24, 2008, 5. If a boat or a swimmer moves in the same direction of the stream then it is. Technically, you cannot drag without using a mouse.
Ghatna chakra 100 shortcut mind math tricks pdf download. Problems on boats and streams1, basics and methods, shortcuts, tricks. Codes are not case sensitive, and all of the below are written in uppercase. Whenever you need to enter the same formula in multiple cells, you have several options.
Delete the character to the left of the insertion point, or delete the selection. On the basis of these ideas we will learn trick and tips of shortcut boats and streams. Find the shortcuts and mind tricks on boats and stream problems for ibps poclerk exams, candidates those who are preparing can make use. Bear in mind that most of these will lower your criminal rating by 1,000 points when used. Aspirants those who are preparing for the upcoming examination can use this. Note that many of these cheats have equivalents in the random text cheat code list further down the page though each set has a. This video will help you in understanding the shortcuts for solving problems on boats and streams and formulas for calculating the upstream. Given a boat travels downstream with speed d kmhr and it travels with speed u kmhr upstream.
So, here in this page we give few examples on boats and streams shortcut tricks. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and. You can enter the first formula and the use control d to fill down. Time speed and distance shortcuts pdf onlinemath4all.
Assume that a man can row at the speed of x x kmhr in still. Shortcut tricks on boats and streams are one of the most important topics in exams. Learn about the various shortcuts and formulas to solve the questions related to boats and streams. A premium quality boat according to the national marine manufacturer association, crownline boats pride themselves in offering a valueoriented. When the boat moves with the current of the river i. Downstream in water, the direction of a boat along with the stream is downstream. Keyboard shortcuts speed up your modeling skills and save time. But i suppose what you mean is that you want to autofill the formula without using a mouse.
It evolved as a concept so that there can be a uniform platform. Download our app today to manage recruitment when ever and. Boats and streams formula problem solving shortcut. Basically i want a keyboard shortcut that makes me jump to the formula bar. And with the above setting made, then the f2 key, which is normally a shortcut to open and edit directly into a cell, now becomes just a shortcut to the formula bar. Pressing f4 several times will cycle through the various forms of mixed. It is easy enough to select cell c1 and doubleclick the autofill handle to send the formula all the way down. As you all know we have started a new learn series to help with your preparations for various exams like ibps po, ibps rrb scale i officer. Let speed of boat in still water be bkmhr and speed of stream be skmhr. If in the question, you are provided with the upstream and the downstream speed u and d respectively, to determine the speed of boat and stream the formula goes like.
Online aptitude preparation material with practice question bank, examples, solutions and explanations. Select a 2019 crownline boats model crownline boats are a rapidly growing modern company in the watercraft industry. Best 5 shortcuts on boats and stream problems for ibps po. The big list of excel function key f1 to f12 shortcuts. Download gradeup, the best government exam app for preparation. You can doubleclick the fill handle after youve entered the first formula. Further down this page youll see the full getvoip infographic and you can also get a free pdf download of the 29 essential excel hacks below the list of top 10 shortcuts.
Boats and streams quantitative aptitude tutorial with easy tricks, tips, short cuts explaining the concepts. If you manage your time then you can do well in those exams. Boats and streams problems are frequently asked problems in competitive exams. If the water is not moving then it is called still water. Boats and streams chapter is one of the important topics in quantitative aptitude questions. Find the ratio of speed of the boat in still water to that of the speed of the stream. Percent is derived from a phrase in latin per centum which means per hundred. We invite you to join the evergrowing family of boaters who experience a reassuring difference with formula. I have already created shortcut keys for paste values and paste formats but i dont see the option to create shortcut keys for paste formulas. Boats and streams tips tricks and questions for cat exam. How to calculate amp usage aboard a boat commuter cruiser.
Boats and streams aptitude test, questions, shortcuts. Dig into the knowledge base, tips and tricks, troubleshooting, and so much more. Here ibpsguide team have given the list of all important aptitude shortcuts pdf to download. And, of course time takes a huge part in competitive exams. Since our top focus at excel shortcut is to transform our readers into excel jedi masters, we have provided the shortcut or least amount of possible keystrokes to summon each feature. The characters that appear in the unicode character column of the following table are generated from unicode numeric character references, and so they should appear correctly in any web browser that supports unicode and that has suitable fonts available, regardless of the operating system. Watch out though, the gates may not be open and you may let your competitor through instead. Best 5 shortcuts on boats and stream problems for ibps poclerk exams 2017 dear readers, here we have given the best 5 shortcuts on boats and stream problems for ibps poclerk 2017, candidates those who are preparing for the upcoming sbi clerkibps exams 2017 can make use of it. You can select all cells and use control enter instead of just. You can follow the question or vote as helpful, but you cannot reply to this thread. That difference is the result of finetuned design, authentic craftsmanship and a companywide insistence on excellence.
A boat runs at 20 kmph along the stream and 10 kmph against the stream. Boats and streams shortcut tricks math shortcut tricks. Useful shortcuts and mind tricks on boats and stream problems. Find the shortcuts and mind tricks on boats and stream problems for ibps po clerk exams, candidates those who are preparing can make use. You may want to start your selection with the active cell or move the active cell after the selection is made. Suppose a man can row a boat at a speed of r kmhr in still water and covers the same distance up and down in. If you think that how to solve boats and streams questions using boats and streams shortcut tricks, then further studies will help you to do so. Quick access to excel formula bar via keyboard techrepublic. For making mixed and absolute cells in formulas, press the f4 key while typing the cell reference to add dollar signs. Download shortcut easily create shortcuts to your favorite web browsers you can access from the comfort of your desktop, opening your default web browser.
Shortcuts for working with excel formulas financial. Boat and stream boat and stream problems tricksconcept. Formulas and functions microsoft excel shortcuts table of contents worksheets and workbooks view row and column selection ribbon control pivot tables operating within a cell navigating and selecting cells help and menus group selection general excel general cell control formulas and functions formatting text and numbers dialog boxes borders. Subtotal formula shortcut does anyone know a shortcut for the subtotal sum formula subtotal9,c1. Boats and streams formula boats and streams shortcuts. Strategies and tricks to solve boat and stream question hitbullseye. The shortcut allows the driver to cut the corner short and potentially gain a big lead. This is one of the most important sections in competitive.
What is the shortcut in putting dollar sign in an excel. The shortcuts provided are of course, the shortest way to use these features without applying custom shortcuts or using a third party application. What is the shortcut to drag a formula in excel without. Note that this shortcut depends on the location of the active cell in a selection. There might be data down to cells a and b or a5000 and b5000, thats unknown. C1, use shift and down arrow key to the cells you need formula in. View profile view forum posts forum guru join date 07202009 location lakeland, fl. If the speed of boat or swimmer is x kmh and the speed of the stream is y kmh then, speed of boat upstream x. Do the rest for the other cells, and you have used wingdings symbols. Also, always have with you the basic speed formula, question. Important aptitude shortcuts pdf mind tricks download in pdf.
Delete the character to the right of the insertion point, or delete the selection. Windows 10 specifications and excel short cut keys. Trickshortcutquestion in hindi boat and stream formula boat and. It adds a bit more chaos to a track already has more than its fair share.
We provide examples on boats and streams shortcut tricks. Competitive exams are fill with maths where you need mathematical formula. So, mathematical formulas are very important and necessary for doing maths. Type the below codes during gameplay to trigger the prescribed effects. A very short cut and much easier to work with, imo. This shortcut saves you the alternative of having to go back through excels menu items to set formula calculation back to automatic. Shortcuts to solve problems on boats and streams jagran josh. Shortcut tricks to solve boats and streams questions. Another way is to click in a blank cell and go to insert symbol font. This shortcut will select all cells that dont match the value in the active cell in a column, or selection within a column.
Boats and streams shortcut tricks are very important thing to know for your exams. If a boat or a swimmer moves in the opposite direction of the stream then it is called upstream. Take a bike pcj works well and ride it as fast as you can into the pole position strip club. Boat is moving against the direction of the stream. So, here in this page we put together all basic mathematical formula. Boats and streams is one of the most common topics in quantitative section of all the entrance exams.
167 1486 1164 739 307 1365 696 23 595 1300 203 1499 390 1297 1671 506 1451 405 1093 178 1119 1510 526 1545 447 221 1652 1146 1208 328 51 238 1407 125