This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the funct ...more
In this how to video, you will learn how to speed up your Azureus Vuze program. First, open up Azureus Vuze. Next, go to advanced, option, and click preferences. Select preferences and change the port to a number between 49152 to 65535. Once it is changed, go to transfer and m ...more
How To Make Your Television Play Anything in 3D It could be a while before studios release home versions of big pictures like Avatar (rumored 2011) and Alice in Wonderland in 3D. But you don't need to wait. Provided that you have a 3D-capable HDTV, turning it into a 3D home t ...more
International Pet Travel: Taking Your Pet Animal to a Foreign Country If you are taking a pet to another country (permanently or for a visit), contact that country's consulate or embassy for information about any requirements that you must meet. A list of consulates can be fo ...more
It's summer again and it's time to get out of the house and there's no better way than with a fun game like some improvised baseball. You don't need a whole team of people all you need is a bat, a ball and another person to play with. Home Run Derby is a classic game that can ...more
The video is about how to find the variance of the set of data. They found the variance by using the variance formula. Variance formula was represented by square of S, whereas S is the Standard Deviation. Variance is got by the summation of the difference between the average ...more
In this tutorial the instructor shows how to calculate the greatest common factor, or GCF. While computing greatest common factor, you are pulling out the smallest exponents of any common factors along with the factor. Finding the greatest common factor is similar to finding t ...more
To find the slope of a line you must have two points and then you must plug in the two points into the slope formula. The slope formula is m= y2-y1 over x2-x1. If the slope is a fraction be sure to reduce to the lowest. Remember if a number is divided into zero it is zero, if ...more
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more
Watchers of this video will learn how to find the "lowest common multiple", the lowest whole number that can be divided by each of two numbers evenly. For example, the lowest common multiple of 8 and 12 is the lowest number of which 8 and 12 are both factors. To find the lowes ...more
Kill in the Defender Shadow Arena Challenge in the Drowned Pass on the Xbox 360 game Darksiders. You need to enter the Shadow Realm and defeat four portals to free Vulgrim. For Defender, you must keep at least one Undead Soldier alive throughout the time limit (5:00). Here yo ...more
To set yourself up for this trick you must first take a plain deck of cards and slit it anywhere. Then flip the top card on the bottom half from the bottom half of the deck. Memorize the card and put it back into the deck. Keep cutting the deck several more times. Once you are ...more
Figure out the 17th puzzle, entitled "The Bunker", in Assassin's Creed 2. Code wheel puzzle: Here’s a tricky one; your clues are “<” and “2,” and the only advice you’ll get from your handlers is that maybe there’s “something we can count” on the strange symbols. In this case t ...more
Visitazione's Secret: This is Tomb number 6. The grave of all graves. The entrance to the tomb is on top of the first level of the building's roof. You can pretty easily climb the building on the eastern face and then shimmy around to the north face and continue up. There's a ...more
Fitting In: Find your way to the, uh, video arcade and you'll get a cut scene introducing you to the next mission. You'll be introduced to a number of new, basic gameplay mechanics, so nothing's too difficult. At first, you'll learn to blend. Simply walk into the center of a g ...more
Thanks to Apple's awesome user interface, it is extraordinarily easy to set your default printer. Instead of guessing which printer your document printed to, be certain of where it is every time. Stop chasing that printed document around your home or office and set your Mac t ...more
If you've ever been asked to find the GCF, or Greatest Common Factor, of a series of numbers or algebraic expressions, check out this video to learn how. The methods for finding the greatest common factor for a series of numbers and for an algebraic expression are similar. S ...more
Make life easier by printing to your nearest PC printer the first time, every time. You Will Need * A printer * A PC * The printer’s model number * The printer’s manufacturer Step 1: Check connection and power Check to see if the printer is properly connected and powered on. ...more
Turn your possessions into cash and become an online selling machine. You will need: Something to sell, a computer with internet access, an eBay account, a digital camera, shipping supplies, something to sell,a computer with internet access, an eBay account, a digital camera, ...more
Do you sometimes wish you were an only child? Yeah, so does your irritating little brother or sister. You Will Need * Imagination * Self-control * A little kindness Step 1: Find solutions Figure out exactly what your little brother or sister does that annoys you, then come ...more
Have an old bike combination lock that you can't remember the code for? If it's a simply four-digit cable lock, you can easily figure out the combination with a quick peck-and-go method. Best of all, this technique doesn't require any tools or special know-how, and let's you r ...more
What you need All you need is little program named Cheat Engine, and you can download it from here. And it is totally free. Log in to your Facebook account When you logged in Facebook go to game. Prepare Cheat Engine When you load the game, don't start it. Open the Cheat ...more
Download Cheat Engine You can get Cheat Engine here. After downloading, install it on your computer. Log Into Christmas Crunch Log into your Facebook account and go to MindJolt's Christmas Crunch game. Open Cheat Engine / Play Game Open the Cheat Engine and start the game ...more
In this tutorial, we learn how to change your air filter on a 2008 Ninja motorcycle. You will need: a number 5 Allen wrench, a screwdriver, and a new air filter. First, take the side cover off your bike with your screwdriver. After you remove this, set it down to the side as w ...more
It's easy to get around in the 2010 Ford Lincoln MKX, because it has a built-in navigation system. But how do you use it? How do you find your way around? This video will show you the steps necessary to set a waypoint on the touch screen inside the 2010 Lincoln MKX. Getting di ...more
It doesn’t matter how long ago your last geometry class was, you can still impress your friends by finding a geometric mean. The geometric mean can be used to find the average of numbers with out unusually high or low results effecting the result. The geometric mean of two nu ...more
Whether you're wielding an iPhone, iPad, Mac, Android phone or tablet, or even a Windows PC, this little-known secret holds the key to effortless assistance and unwavering obedience. Intrigued? I thought so. Let's say a friend or family member needs the email address of someb ...more
Apple released iOS 17.4 on March 5 with over 30 new features, but now it's iOS 17.5's turn for the spotlight. The update, currently in beta, gives us a few interesting updates and changes for iPhone, including a new word game, and there's even a sneak peek at what could be com ...more
There's a powerful tool on your iPhone that can fine-tune your iOS experience based on what you're doing and when, and it's completely customizable. With it, you can control what notifications appear or are silenced, who can call you, which Home Screen pages you want to view, ...more
The last iOS software update was a modest one, but iOS 17.4 has a lot more for your iPhone, including changes to emoji, Podcasts, security, Safari, widgets, Apple Cash, CarPlay, and more. Many of the exciting changes in iOS 17.4, as well as iPadOS 17.4, apply to users in the ...more
If you're ever curious about your iPhone's battery health, there are easy-to-access stats that let you know the last charge amount, which apps are eating away at most of your power, and even your battery's remaining capacity. Now, a new update makes it easier to know how well ...more
Are you thinking of switching from an iPhone to an Android phone? Before you make a permanent change from Apple to the other side, it's good to try out the other ecosystem and see if it makes sense for you. If you can't get your hands on an Android phone to try it out, you can ...more
Apple last month released iOS 17.2, its biggest iPhone software update since iOS 17.0, with 60 new features. Now, as of Jan. 22, we have iOS 17.3. Overall, it's not the behemoth software update that iOS 17.2 was, but it has a few exciting new things you'll definitely want to k ...more
Using different sounds on your iPhone for different notifications can help you determine — just by listening — alerts you may want to look at immediately versus untimely alerts or even ones you typically ignore. But Apple has never given us complete control over notification s ...more
Apple just released its biggest update to iOS 17 yet, and there are 60 exciting new changes for your iPhone. With iOS 17.2, you get a brand new app, more Apple Music enhancements, upgrades in Messages, and a new security feature that was announced last year, as well as changes ...more
Perhaps the biggest new feature within Apple's iOS 17.2 update for iPhone is Journal, a new journaling app designed to help you take a moment to reflect each day using reflection prompts, recommendations via on-device intelligence, and suggestions for recent activities and eve ...more
When you want a helpful task manager on your iPhone or iPad, any of the nine apps in this guide should be at the top of your list. But we'll review each app's features to help you determine which one might be best for your workflow. Using a task manager on your iPhone or iPad ...more
Visual Voicemail revolutionized phone calls and the voicemail system when Apple introduced it with the original iPhone. Now, thanks to iOS 17, Apple has done it again with its newest calling feature, Live Voicemail. This feature uses speech-to-text technology to show you voice ...more
Apple Notes started with humble beginnings as a scratchpad of sorts, a place for us to stash some simple text for later. It's received many upgrades over the years, but Apple's latest iPhone software update is a game-changer. With all the new features for Apple Notes on iOS 1 ...more
Apple is finally adding profiles to Safari, so you can now keep your personal, work, and other topical browsing totally separate in their own instances, with their own history, cookies, website data, and active extensions. Creating profiles for different parts of your life ha ...more
Apple just released its iOS 16.6 update for iPhone on July 24. When you install the new software, it may look like there's not much to it since Apple doesn't include any features in the release notes beyond "important bug fixes and security updates," but a few new features are ...more
The volume buttons on the side of your iPhone can do more than just adjust the volume levels for media, ringers, alerts, Siri, and other sounds and voices. You can use them to perform different actions in certain apps and even create custom actions using the Shortcuts app. It' ...more
Apple offers many ways to customize the Home Screen on your iPhone, from adding widgets and scheduling rotating wallpapers to hiding apps and entire pages. But some of the best ways to customize your Home Screen are options Apple won't even tell you about, either because they ...more
Generative artificial intelligence has taken the tech world by storm, and Google's AI chatbot will give you a taste of what it offers. By learning patterns from existing data, generative AI can create new text, images, music, and other types of content from simple commands. W ...more
Apple's iOS 16.3 update for iPhone had impressive new features, but iOS 16.4 might impress you even more. The latest iPhone update was released on Monday, March 27 — a day earlier than Apple Music Classical, Apple's new classical music streaming service — has at least 30 more ...more
There's an iOS feature that benefits many users, but it's absolutely vital if you wear AirPods or other headphones models connected to your iPhone. A large number of iPhone users don't even know about it, especially since it's disabled by default and hidden deep in the system ...more
You see the status bar nearly everywhere on your iPhone, and it almost always looks the same. But you can use a few tricks to spice things up a bit — without jailbreaking your iPhone. The status bar's background on iOS is transparent, so you'll see different colors and gradie ...more
Widgets can display essential information from an app right on your iPhone's Lock Screen, but there's an even bigger reason you should be using them: fast access to your most-used apps. Thanks to iOS 16, you can add one widget above the time on the Lock Screen and up to four ...more
You're probably sharing a ton of information on your iPhone with other people, apps, and services without really realizing it. Now there's a new tool to show you just how much, and it can be an eye-opener as well as a fast way to manage sharing permissions and review your acco ...more
Android 12L and Android 13 have a taskbar just for tablets that lets you quickly open recent, suggested, or pinned apps and drag and drop apps into split-screen mode. While the taskbar is meant just for tablets and foldable devices, you can unlock this new feature for your And ...more
Google has a few hidden tools you might not have discovered yet, and they work in Google Search, in the Google app, and with Google Assistant — on both iPhone and Android phones. We all know smartphones do much more than make phone calls. They serve as cameras, GPS navigators ...more
Apple AirTags are super helpful for keeping track of your keys, backpack, and other frequently misplaced items, but there are some pretty clever things you can do with them beyond finding your stuff. Apple's $29 Bluetooth beacons definitely drew some inspiration from Tile's l ...more
While it's not usually the first thing everyone looks at after installing a new iOS software update, I'd give the new accessibility features on your iPhone priority attention because there are some highly valuable tools that even users without disabilities can enjoy. Of cours ...more
The Calculator app is probably one of Apple's most-used iPhone apps, yet I always meet people who don't know all the little tricks there are to using it more efficiently. You may know most of them, but there's a chance you don't or at least forget about some of them. What a " ...more
If you're doing the same tasks on your Android phone repeatedly each day — like playing a specific playlist at the gym, viewing work documents, or watching your favorite music video — you can save some time by automating your routine, turning each task into a one-tap gesture o ...more
Apple's latest big software update includes an entirely new Apple app, a controversial change in the TV app, better Siri control, an improved Shortcuts app, interesting Safari upgrades, Apple Music Sing, and more. Keep reading to see what iOS 16.2 has to offer your iPhone. Th ...more
You've probably already been using iOS 16 on your iPhone for months, but there's a good chance you haven't found or explored everything the new software has to offer. Health-related features are usually the first to be ignored or go unnoticed, but they're essential to know abo ...more
It hasn't been long since Apple released iOS 16.0 with over 350 new features, but iOS 16.1 just came out with even more cool updates for your iPhone. While some of the recent upgrades were expected, others are somewhat surprising — and there's even one that you may not even th ...more
If you're tired of the default yellow link colors in your Notes app, which I find hard to look at in light mode, there's a way to change them to another color on your iPhone, iPad, and/or Mac. It's not a perfect solution since you can't simply change the link colors specifica ...more
Apple's Contacts app just got its biggest update ever. Since the first iPhone in 2008, there have only been minor upgrades here and there to how you manage and interact with contacts. That changes with iOS 16. The last major feature Contacts received was emergency contacts th ...more