You can set up dynamic calendar grid on an excel worksheet with a series of formulas, as explained in this article. Use this handy cheat sheet to discover great functions and tips to help you get the most out of excel. Make easy maths,math shortcuts,math magic tricks,learn math,vedic maths tricks,easy maths,maths tricks in hindi,number tricks,maths online,maths for fast. The face or dial of watch is a circle whose circumference is divided into 60 equal parts, called minute spaces. Shortcut trick for solving calendar problems in reasoning. If you want to quickly calculate age based on date of birth in excel withoput remembering formulas, please try the kutools for excel s. Hindi how to attempt logical reasoning questions in. In either case, all formulas and functions are entered in a cell and must begin with an equal sign.
Heading rows which you want to repeat on every page. The answers are explained in elaborated manner to get clear subject knowledge. The formula is checking which of the next 4 years are divisible by 4. Calendar and clock questions asked in ssc cgl exam. You can customize the calendar to any style as you need. That formula, cool, is the same formula in every cell from b5. Calendar trick day finding pascal calendar program years that start on sunday. So these are some tricks to solve the calendar questions in competitive exams, these tricks will surely help you to solve the questions and will save time, and also will get the good scoring in reasoning. These problems may be asked in your railway exams or various other competitive exams. This formula is slightly different from zellers formula. Reasoning and general intelligence clock and calendar clock. In this pdf, you will find many math shortcut methods pdf. Math shortcuts methods and tricks i dont need to say the importance of aptitude in competitive exams. Divide the last two digits of the year by four and add it to the result in step 1.
F2 edits the active cell and positions the insertion point at the end of the cell contents. After changing the month or year in corresponding cell, dates of the monthly calendar will dynamically adjust to the specified month or year. Calendar in excel with one formula array entered, of. Create calendar pdf with holidays of any country using our online tool. Use our pdf calendar maker and create pdf calendar with your own events. Important math formulas for ssc exam download in pdf. It also moves the insertion point into the formula bar when editing in a cell is turned off. This formula works only for the gregorian calendar. Vlookup, index, match, rank, average, small, large, lookup, round, countifs, sumifs, find, date, and many more. The list of important maths topics and its formulas are given here. I have always been mathematically oriented, but now im stuck on something that no one yet has been able to explain to me. Schedule no meeting time blocks instead of multitasking, set aside time without interruptions. Important aptitude shortcuts pdf mind tricks download in pdf. Easiest shortcut trick to solve clock related problems in.
This includes all the important math tips and tricks to solve questions quickly and accurately. Important formula for calendar aptitude tips calendar. Important shortcuts and mind tricks for number series questions in aptitude section download in pdf. How to solve calendar problems question and answers. When people multitask, often they do multiple things badly, says david sanbonmatsu, university of utah professor of psychology.
This example assumes the start date will be provided as the first of the month. Simple way to solve calender problems in aptitude section. Solve calendar questions using zellars formula short trick for calendar questions. Looking at cell c6 in the image below you can see the calendar formula uses the if function and references the jansun1 named formula. Aptitude shortcuts pdf and mind tricks tips in pdf. Dear readers, aptitude shortcut methods and tricks for number series questions were given below. If you want the current leap year also to be considered tweak the formula like this.
Add month code and year codes to the result obtain in step 3. Important shortcuts and mind tricks for number series. Number of days more than the complete weeks are called odd days in a given period. Calendar problems trick in aptitude find cube root of a number in 5 seconds find square of 21,31,41,51,61,71,81 in 5 seconds multiplication of 98. Calendar calendar problem tricks calendar reasoning. Ultimate math shortcuts and tricks pdf day today gk. What formula would allow you to determine the day of the week on which someone was born. Mcqs with answers download pdf pdf free download questions and answers along with detailed explanation and answers in an easy and understandable way. Calendar and dates problems with solutions for bank exams. Excel formulas and functions for dummies cheat sheet. A printable 2020 calendar pdf template with the prior and next month. Percent is derived from a phrase in latin per centum which means per hundred. If you do not have a reference day, follow these 5 steps step 1.
It evolved as a concept so that there can be a uniform platform. Every year divisible by 4 is a leap year, if it is not a century. The smaller hand is called the hour hand or short hand and the larger one is called minute hand or long hand. The face or dial of clock is a circle whose circumference is divided into 60 equal parts, named minute spaces. Time and calendar questions tricks in hindi thegkadda. Indianstudyhub is providing all rrb ntpc calender and dates. Also, the clock is divided into 60 equal minute divisions. Clocks and calendars aptitude basics, practice questions, answers and explanations prepare for companies tests and interviews. She has taught science courses at the high school, college, and graduate levels. Then change the locale to one of the arabic locales. Add month code and year codes to the result obtain in step3.
In 60 minutes, minute hand gains 55 minute spaces over the hour hand. Before you start solving these problems, you must remember below given important points because they will be used. Create calendar in excel with one formula by using arrayentered formula. Candidates those who are all preparing for ssc mains and all other competitive examination can use this material. Is there any trick in excel to change the gregorian date. Calendar problems trick in aptitude aptitude for dummies. In this article you will see what is behind the formula. Download topic wise tips and tricks pdf math capsule for score more in competitive exams. This formula will always give the next leap year even if the current date belongs to a leap year. Calendrical calculations, nachum dershowitz and edward m.
It is the time consuming part for most of the aspirants. So, just have a look over the concept to solve calendar problems 1 year 12 months 12 months 52 weeks 1. Lets set those named formulas aside for a moment and look at the next formula in the calendar cells. You can remember the following points relating to the concepts of calendar. Add the quotient value in step 3 to result obtain in step 1. Tricks to solve calendar question pdf click here download mobile computer save. Topic wise tips and tricks pdf is a complete math capsule for all the chapters.
Reingold a book about converting between different calendars. Here are seven simple calendar tricks you can use to bring your productivity to the next level. Here ibpsguide team have given the list of all important aptitude shortcuts pdf to download. Excel calendar template date formulas explained my. Quantitative aptitude tricks by ramandeep singh page 2 more tricks on simplification and download pdf. Reasoning and general intelligence clock and calendar. Now in the page setup window go to sheet tab and specify following things. Logical reasoning clocks and calendars updated on may 2020. Easiest shortcut trick to solve clock related problems in reasoning for ssc cgl tier1 exam in this post, i will give you the trick for solving problems based on clock. Addition tricks and calendar trick ive searched the net to no avail.