Trick Scores Search Results

How To: Make an Excel gradebook that drops the 2 lowest scores

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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.

How To: Make an Excel gradebook that removes the lowest score

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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

How To: Average rank scores given a tie in Excel 2010

New to Microsoft Excel 2010? Looking for a few good tips and tricks? In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel 2010 video tutorials, you'll learn how to use use the RANK.AVE function to average rank scores in the event of a tie. See the new Excel 2010 RANK.AVE and RANK.EQ functions.

How To: Make a gradebook based on percentage scores in Excel

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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Do a trick with 3 matchbooks

Need a new prank to play? Wait no more! In this video from Scam School, you'll learn how to do a simple trick with 3 matchbooks. You'll fool your mark into thinking you have magic psychic and weighing abilities. Just watch and follow the steps, and you could be on your way to scoring free drinks!

How To: Perform a self lighting candle trick

In this trick - which is perfect for any restaurant or bar - you will learn how to light a candle without actually ever touching a flame to the wick. Don't think it's possible? Think again! You will learn exactly how to do this illusion and amaze everyone around you. Score some free drinks or a couple bucks with this supernatural feeling goof.

How To: Create a grade book based on a total score 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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.

How To: Conditionally format a bar chart 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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed a given hurdle.

How To: Create a weighted gradebook 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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.

How To: Learn secret celebrations for Fifa 09 on XBOX 360

Learn how the do all of the Celebrations in Fifa 09. If you want to know the controls while playing, just go to the pause menu, then to Controls, and then to Celebrations Help. When you score make sure your celebration is that of a winner a la David Beckham. Check out the tricks to doing celebrations like 'Look at Me', 'Low Aeroplane', 'Fist Bump' and 'Acrobatics'.

How To: Average the last three values for an entity in 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Pull three great pranks on your friends: 1 computer, 1 string, 1 shower

One prank doesn't have a terribly long lifespan usually. You do it once to one of your friends, they tell everyone else, pretty soon your friends see that prank coming a mile away when you try to pull it again. Why not stock up? This video will show you how to pull three diverse, great pranks. First, the food-coloring-in-the-showerhead trick. Second, the living room string labyrinth. Third, the old broken PC desktop trick. Pull all three on someone in rapid succession for bonus score!

How To: Make a twist turn style card

In this video, we learn how to make a twist turn style card. The card will open with a neat pop out image on the front of the card! First, get an 8 1/2 x 5 1/2 piece of card stock and then score it 2 and 3/4 inches from the left edge and 4 inches over from the left edge. Then, turn the card the other way and find the center, then score from the right end to the very first score line. Then flip the card over and score the rest of the center line up to the first line. Now, make a score line fro...

How To: Improve any credit score with 3 steps

You should watch this video if you want to improve your credit score with just 3 steps. To improve your credit score: Check your credit report. It is where your score comes from. You can also get a free copy of your credit report once a year at Annual Credit Report. Check it for errors. Timing. If you're going to apply for a loan as the application month approaches, stop charging because if your balance happens to be reported while it's big, it will temporary lower your score. Don't close you...

How To: Get your official SAT score from College Board online

The SATs are a very valuable college entrance test and could determine if you're accepted or denied to your favorite university. So, once you've learned to ace the SATs and have already taken your test, get your scores as soon as they're out! Don't sit in dreaded anticipation— go to College Board and get your SAT test results now!

How To: Make a pop-up box card

Connie Brad teaches us how to make a pop-up box card in this tutorial. First, you need to take a scoring board and draw 1 cm increments down the center of it. Now, take a sheet of card stock and score the sheet 2 cm from one end, then continue down until you reach the bottom 3/4's of the paper. Now, fold your card along all of the score lines up until the last line. Next, line this up on a cutting mat and cut 3 cm on each side until the end of each score line. Now when you set this up, it wil...

How To: Make a holder for a card set

This video describes how to make a fancy-looking stationery card set holder. First, take a card and cut it down to 10*6.5 dimensions. On the 6.5 inch sides, score 1" each. On the 10 inch sides, score 1", 7" and 8". Using a pair of scissors, cut flaps on the 10" side on the scores upto 1". After cutting these slits, you can do any designs on the card in order to make the holder look beautiful. Now fold the card along all the scores to make creases. Now, using glue, stick the flaps together. Fo...

How To: Keep score in bowling

Bowling was at one time such a popular sport that it preempted such sports as college football, baseball and basketball on Saturday-morning sports broadcasts. So what's all the fuss about? And how do you keep score in bowling, anyway? With this helpful two-part pinhead's guide, you'll learn everything you need to know to tabulate your own bowling scores using just a pen and pad of paper.

Prev Page