New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
RichPin shows how to identify a rear axle on a Jeep Grand Cherokee to determine the correct replacement part. The first thing to do is to identify the axle by cleaning the fill plug on the back cover. Look at the inscription of the plug to find out the style of the rear end. In this example, Rich has a "Dana" style rear end. To determine if it is a 35 or 44 Dana, look at the web area to the right of the plug to locate the number. The two steps outlined in this video allow you to identify the ...
When defining fields in FileMaker Pro 10, one has to choose what type of field to decide for a database. There are two fields that accommodate special handling of data. They are time and time stamp fields. When one decides a field under manage>database,there is a option for "type". Under that, there is time and time stamp. The "time" one determines the time while the "time stamp" determines the time and date. This will help in preparing a proper and detailed database system.
Dougsimmsonline shows how to determine whether or not 2 triangles are similar. Not only does he go on to show that they are but he describes step by step how to do the math to find missing angles. He does this process twice to show one set of triangles being similar and show the other set of triangles as not being similar. Doug is using a large computer touch screen as his drawing board to show you how this process is done.
In this tutorial, the author shows how to determine if a point lies on a given line which is in Point Slope Form. To show the method he takes a sample point order pair and an equation of a line in its point slope form. Now he substitutes the value of the x, y order pair and the equation of the line, and solves the equation on both the sides. If both sides match it means that the point lies on the given line, or else it does not lie on the current line. In this video, the instructor shows how ...
This is a tutorial about how to prove the congruency (equality) of two triangles when the values of two angles and an included side of each triangle is given. The author of this video instructs the viewer that it should be first determined whether the values of two angles of one triangle are the same as those of two angles of the other triangle. Then one must seek to determine the equality of sides included in those angles in both the triangles. When it is found that these three values in one...
Sewing is an expensive enough hobby without having to factor in repair costs, as well. You can save money (and have more cash to spend on fabric and notions!) by fixing your own machine at home. This video shows you how to clean and fix the bobbin case area, which can often get cluttered with lint and fuzz.
If you're like us, you always begged your parents to let you get a parrot (What? They make you look like a pirate when perched on your shoulder), but they never consented because of the noise factor.
Learn how to choose ladies underwear. There’s a lot more to picking a pair of panties than thinking they look cute in the store. This video outlines all the different factors in choosing the perfect panties.
Two-factor authentication (also known as 2FA) adds a necessary additional layer of security to your username and password in many important apps. On Instagram, 2FA requires you to confirm it's you attempting to log in, with a special code sent to you via text message. Enter the code and you're in ... but what happens when you need to log in and don't have access to your phone?
If you're in the market for a new lawn mower, there are plenty of options, and it might be hard making a decision on which one is right for you. This video breaks down what you need to consider before buying a lawn mower and how to find one that best fits your needs.
In this tutorial, we learn how to determine if lines are parallel or perpendicular. You will be given two straight line equations. First, remember that parallel lines have equal slope, identical to each other. Perpendicular lines have negative reciprocal slopes. For example, 2/3 and -3/2 would be a perpendicular line. If you think of parallel lines, then you can graph them to see what they look like when written down. Then, graph the other lines to see what they look like as well. Once you un...
At a loss as to whom you should vote for in the next election? In this clip from TekZilla, we learn about VoteEasy, a web app built to help United States citizens determine which candidates' views align most closely with their own. For details, and to get started learning which candidates are most like you, watch this video guide.
In this video, we learn how to understand and determine equivalent fractions. If you have an equation with an equivalent fraction, you will first multiply the first numerator by the second denominator. Then, you will divide this answer by the denominator of the first fraction. After you do this, it will give you the correct answer. You can also do the reverse multiplication for this to check your answer and make sure you are correct. You can get an answer no matter what the numbers in the equ...
The continuity test is one of the least well-known but useful functions on a multi-meter. It allow you to determine whether a fuse works by touching the contacts to it, which allows you to diagnose all sorts of electrical problems. This video will show you how continuity tests work and give you some examples of using them to find problems in household devices like a lawnmower.
Infrared photos are photos that are taken in such a way that they absorb light from beyond the visual spectrum, giving your pictures a cool, surreal effect. This video will teach you everything you need to know to take them yourself. You'll learn how to determine if you have a camera that will work, get the proper filter, and take the photo. It's pretty quick and easy if you have the right equipment, and looks really, really cool.
This video shows you how to milk a cow with your bare hands. Wipe the udder with alcohol based wipes, to make sure it is clean. Place your stool at the side of the cow, towards the back end. Remove a little wax from the teats before starting. Squeeze the teats firmly with a regular motion. A cow should be milked twice a day. If the udder is pendulous then use a flatter pan rather than an milking bucket. The richness of the pasture will determine how much milk the cow delivers. Rainfall and th...
Viewers learn that a net is the shape formed by "unfolding" a 3-dimensional figure, so a net shows all the faces that make up the surface area of the figure. Viewers are then asked to determine what type of 3-dimensional figure can be made from a given net (note that a cylinder has 2 circular bases, a pyramid has triangular faces, a cone has 1 circular base, and a prism has rectangular faces). Students are also asked to determine if a given net can be used to make a cube. This video will bene...
David Wilcox and Caitlyn Szyska demonstrate how to use a compass without a problem. Parts of a compass include the ring, the orienteering arrow, magnetic needle, direction of travel arrow and declination scale. First, hold the compass out in front of you, making sure you hold it level. Move your whole body and point the direction of travel arrow to the object that you want to reach. Move the ring until the magnetic needle is lined up with the orienteering arrow pointing north. Once they are l...
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.
How do you know if you should lose weight is a question people often ask. For the most part the need for weight loss should be determined by how you feel in your own body. There are some calculations that doctors use to determine if you need to lose weight. One of those calculations is BMI or Body Mass Index. BMI is based upon a fairly difficult equation. BMI is figured by multiplying your weight by 703 then dividing by your height squared. A body mass index over 25 is considered overweight. ...
Learn how to develop your intuition by dowsing with a pendulum. In this video hosted by Andrea Hess of Soul Realignment, Hess is teaching dowsing with a pendulum to determine "yes" or "no" (or "undetermined") answers to specific questions. As told here, the pendulum is controlled by your subconscious mind, but the information is determined by one's higher self. One is not to ask questions that start with "Should I..." or "Am I supposed to..." as there is no "Should" or divine plan we need to ...
There are three main line types in fishing, but how do you know what you should be using? In this video tutorial, a fisherman will give you some tips so you can decide for yourself. Take action: determine bait type, determine type of fish to catch, and look at line weight and strength. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple...
This experiment uses a ballistic pendulum to determine the launch velocity of a metal ball. This is compared to a measurement of the launch velocity found using projectile motion. You may wish to emphasize why energy is not conserved in the initial impact of the ball into the ballistic pendulum, but momentum is, and conversely why energy is conserved as the pendulum rises but momentum is not conserved.
In this video tutorial, Chris Pels will show how to determine what capabilities a user’s browser has when viewing pages in an ASP.NET web site. First, learn how to access an instance of the HttpBrowserCapabilities object from the ASP.NET Request object associated with the web page request. Next, see the different information available in the HttpBrowserCapabilities object such as the type of browser and whether the user’s browser supports JavaScript and Cookies. Then see an example of how to ...
So you've been invited to a poker game, but you don't know the difference between a straight and a flush. Well, this how to video is here to make sure you don't lose all your money, or your shirt. This Texas Hod'em lesson teaches you how to determine the ranking for various hands. It runs through all possible winning hands in Texas Hold'em and explains their rank. At the end of the video you will be tested on your newly acquired knowledge of Texas Hold'em hands. Are you holding the nuts or ar...
Use red cabbage to determine the pH of different common household items. Great experiment for kids. Begin by cutting up a red cabbage. Put in a blender and blend it. Put in a coffee maker and turn it on. After all has come through, turn off the coffee maker and let it cool. Now test it and determine the pH of different household items.
The hook is a common shot missed in golf. If you understand the factors that cause a hook and make a few adjustments to your golf swing, it can be easily corrected. See how it's done.
Snapchat just rolled out a feature that lets you create custom Filters and Lenses. While the average Geofilter won't run you more than a few bucks, it's not that hard to exponentially jack up the price. Amazingly enough, Snapchat's latest attempt to monetize their platform can ultimately cost you as much as $999.99. Ignore the penny, let's call that a cool grand.
More prescriptions for antibiotics are written for ear infections than any other type of infection. A new study comparing the incidence and causes of ear infections in children between the ages of six months and three years found that the incidence of ear infections over the last decade has dropped significantly since the 1980s.
In an early morning blog, Jimmy Alamparambil of the Unity team announced a major new update to their ARKit plugin. Developers now can use Unity and ARKit to create AR experiences and test directly from Unity's editor, without deploying to the device.
There is no such thing as too much space when it comes to our smartphones. Space is the great equalizer of all things. No matter how many awesome features a device has, the amount of storage space available will always be a determining factor. Be it music, apps or photos, it's easy to fill up your phone's memory fast.
This video shows us how to build a garden bench out of cinder blocks. Before you get started, you need to refer to the How To sheet #320 for all your materials and make sure you have everything you need.
Installing shelves in a closet turns dead space into useful storage. You Will Need:
Azimuth is simply the angle of an object in the sky along the horizon. Yes, it's spherical trigonometry but it's not difficult! Check out this video and in just a few minutes you will be able to solve azimuth problems on your own.
In this video, the instructor shows how to collect like terms and factorize. When you are given a linear equation, the first thing you do is to try to organize it. Pair up the like terms. Add the numerical coefficients of terms with the same variables. This is called collecting the like terms. In case you see any common factor across all the terms, pull it out and tag it to the parenthesis. In this way, you can factorize the equation. Next, bunch together your like terms and sum them up. The ...
Cancer doesn't discriminate, and anyone can get this disease. However, some factors can increase your likelihood of developing cancer.
Watch the following video to understand the steps necessary when simplifying square roots. To simplify expressions with radicals, follow these simple steps:
While this costume makeup look seems inspired by the likes of Louis XIV, it's actually based on a funky dunky Rococo costume worn by a contestsant on "X Factor" named Prince Poppycock.
Papaya's are a tropical fruit that is very healthy and a little sweet. But knowing when it's ripe is the true challenge. It boils down to a few factors that include color, smell and other visual cues. In this video you will get tips on what to look for as well as alternatives to getting your papaya to ripen.
