Types Function Search Results

How To: Grade test responses with formulas in Microsoft Excel

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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR functions.

How To: Count values between a lower & upper bound in MS Excel

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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.

How To: Use the MEDIAN IF function in Microsoft Excel

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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.

How To: Increment numbers in an Microsoft Excel formula

New to 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 Excel tutorial from ExcelIsFun, the 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.

How To: Create a dynamic equation system in Microsoft Excel

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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.

How To: Make a basic Jeopardy game in MS Powerpoint

This video demonstrates how to make a basic Jeopardy game in Microsoft PowerPoint. First, choose a background color by clicking Format on the top bar menu. Select Background and choose the color you wish to have. Click Apply To All to apply it to your entire PowerPoint presentation. Then, click Insert on the top bar menu and select Table. Fill in the number of columns or rows you wish to have for your table and then click OK. In this example, create a 2x2 table. Make a title for your game by ...

How To: Make a dynamic named range in Excel (left to right)

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

How To: Graph quadratic functions

This video walks you through the steps of graphing quadratic funtions. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.

How To: Program with Python

Welcome to Google's Python Class – a seven-segment, two-part free virtual class for people with a little bit of programming experience who want to learn Python. The class includes written materials, lecture videos, and lots of code exercises to practice Python coding. The first exercises work on basic Python concepts like strings and lists, building up to the later exercises which are full programs dealing with text files, processes, and http connections. The class is geared for people who ha...

How To: Unlock your AppleTV

Mike Agerbo explains the benefits from listening to one's music through AppleTV, however it seems that one cannot listen to any music or other audio files unless he/she is using iTunes media. Agerbo explains how you can use Apple TV with other types of media, using a program called ATV Flash. Agerbo believes ATV Flash to be an easy and inexpensive tool to upgrade one's Apple Television so it can use the USB port and download and use other media content. One can also create a Boxee account to ...

How To: Make two types of winter decorative wreaths

Make your holidays DIY and save yourself some money. Follow this video to learn how to make two types of holiday wreaths. Learn from Meg as she shows us how to make a mossy Christmas wreath, held together by little mushrooms for a personal touch. She also gives us some great tips on making a cinnamon stick covered wreath. Perk up the kitchen with the spicy aroma of cinnamon for the holidays.

How To: Use TypingRobot V1.0 (cheat Typing Maniac) (08/05/09)

http://www.texturemind.com/post463/ TypingRobot is an artificial intelligence studied to increase your points record with the Typing Maniac game on Facebook. It can recognize several labels because it uses a powerfull OCR system (tesseract) and some principle of word correction. With this program you can make millions of points without problems (my personal record is about 2.700.000 points).

How To: Apply eyeliner with MakeupGeek

This beauty video demonstrates how to apply eyeliner. If you are just beginning to wear makeup, you may be overwhelmed by the many types and brands of eyeliners out there. Depending on what look you want to achieve, you will want to use different eyeliners to get that desired result.

How To: Explore prosthetic options for the gym as an amputee

A below elbow arm amputee demonstrates the device he uses in the gym. He shows you how to use a prosthetic for working out at the gym when you've suffer a limb amputation. This video is very helpful in describing utilities available for enabling individuals with amputations to workout or get around and function in a gymnasium setting. This is a video that addresses adaptive equipment for handicapped or disabled people.

How To: Install towel hooks when remodeling your bathroom

Towel Hooks add function and a casual elegance to any style bathroom. AsktheDecorator.com host Meghan Carter demonstrates how to position all towel hooks and complete a towel hooks installation job. Why settle for messy towel bars when towel hooks keep a bathroom neat and tidy, while being stylish? Watch this how to video and learn how to install towel hooks when remodeling your bathroom.

How To: Trace Any IP Address

Using a simple trace trick, you can easily look up the IP address and its location for any website. This method uses a command line command to first find the IP address of a given website, and then uses a free online tool to get that IP's location.

How To: Restore audio devices on your computer

This video is a useful one to restore sound in our PC. If the audio or sound systems does not functions in your system this video will surely help. This video has many solution to the problem and any of these solutions will certainly help you to rectify the problem. First this video instructs us to check whether the service for sound is enabled or not. Then it describes about the drivers needed for the sound. Some of the drivers may be outdated so that type of drivers must be updated for the ...

How To: Perform a musculoskeletal exam on a patient

Whether your training to be a doctor or a nurse, there is no doubt that this video lesson will help you better understand the procedure for musculoskeletal examinations. Musculoskeletal exams rely exclusively on inspection and palpation and tests using a combination of those techniques. The main purpose of this exam is to identify in your patient any signs of musculoskeletal disease, by way of pain, redness, swelling, warmth, deformity, and loss of function. Watch this video to see the entire...

How To: Map Wardriving Data with Jupyter Notebook

With the Wigle WiFi app running on an Android phone, a hacker can discover and map any nearby network, including those created by printers and other insecure devices. The default tools to analyze the resulting data can fall short of what a hacker needs, but by importing wardriving data into Jupyter Notebook, we can map all Wi-Fi devices we encounter and slice through the data with ease.

How To: Type Curse Words with Apple's QuickPath Swipe-Typing Keyboard in iOS 13

The iPhone's autocorrect feature is wonderful and convenient, but it doesn't always work with informal language like profanity. If you've ever used the F-word, there's a good chance you've had your curse words "corrected" to other words that don't ducking make sense. And with the release of iOS 13, swearing in your messages and on social media could get a little harder.

How To: Use Websploit to Scan Websites for Hidden Directories

Websites are often misconfigured in ways that allow an attacker to view directories that are not ordinarily meant to be seen. These directories can contain sensitive information such as private credentials or configuration files that can be used to devise an attack against the server. With a tool called Websploit, hackers can scan targets for these hidden directories without difficulty.

How To: Automatically Answer Calls Just by Putting Your iPhone Up to Your Ear

Tapping on your iPhone's display to pick up an incoming call can be annoying when your hands are wet or dirty. It might even fail to register and cause you to miss your call. If you have a jailbroken iPhone, however, you can get rid of this problem entirely, thanks to a free tweak that lets you instantly pick up calls without having to interact with your phone's screen.

How To: Discover Open Ports Using Metasploit's Built-in Port Scanner

One of the first steps in reconnaissance is determining the open ports on a system. Nmap is widely considered the undisputed king of port scanning, but certain situations call for different tools. Metasploit makes it easy to conduct port scanning from directly inside the framework, and we'll show you three types of port scans: TCP, SYN, and XMAS.

Exploit Development: How to Learn Binary Exploitation with Protostar

Being able to write your own hacking tools is what separates the script kiddies from the legendary hackers. While this can take many forms, one of the most coveted skills in hacking is the ability to dig through the binary files of a program and identify vulnerabilities at the lowest level. This is referred to as binary exploitation, and today we're going to check out a tool known as Protostar.

News: How to Get Google's Gboard Keyboard on Your Android

Google released an amazing swipe keyboard a few months ago called Gboard that has Google Search built right into it; This makes adding pics, GIFs, videos, and links to articles, restaurants, and shops a breeze. It even helps you search for emojis! The only problem is that Gboard is for iOS devices only, meaning only an iPad, iPhone, or iPod touch can use its magical powers.

How To: Build a Directory Brute Forcing Tool in Python

While attempting to hack a web app, there may come a point where the attacker may have to escape the default directory in order to access unauthorized files. This is known as a directory traversal attack. Much as the name implies, this attack involved traversing the servers directories. But in order to move to an unauthorized directory, we need to know where those directories are. Today we'll be building a tool to brute force these directory locations based on HTTP response codes. Before we g...