Q: Like this: =SUM Like this: =Sum(A2:A4). Excel will add up the numbers in cells A2 to A4
A: Decide what column of numbers or words you would like to add up  Select the cell where you'd like the answer to populate  Type the equals sign then SUM. Type out the first cell reference, then a colon, then the last cell reference. Press enter.

Q: Certain talents are common in pageants—like dancing and playing instruments. It’s great if you’re a talented dancer or musician, but if you’re not, don’t try to force your talent. Choose a talent that you’d feel confident performing. For example, the talent could be something fairly unusual like ventriloquism or karate. The talent shouldn’t be something you learn right before the competition. Choose something that you’ve been practicing for at least a year. your talent. Practice makes perfect is a common phrase, and that’s because it’s true. Don’t wait until the pageant is just days away to practice your talent. Develop your routine and then spend time working on it every day. You should be able to go through your routine effortlessly so that you can focus on the performance aspect of the talent.  If possible, get help from a coach to help you perfect your routine. If you’re doing a tap dance to upbeat music, you may want to choose a brightly colored costume. If you’re singing an emotional song, a long, black dress may be ideal. No matter what you’re performing, consider how you want the audience to perceive your performance when choosing a costume. Make sure your costume fits properly and doesn’t have any rips or tears before going onstage. You may feel nervous before going onstage, but that’s completely normal. Take a few breaths and visualize the routine you’ve worked so hard on before going performing. Go on stage with a smile and keep your head up. Even if you make a mistake, continue on and do not stop until the routine is over.
A: Choose a talent you feel confident performing. Practice Pick a costume that displays the mood of your performance. Perform with confidence.

Q: Get started on the questions that are worth the most points first, all other things being equal. This will ensure that you are able to answer all the higher point value questions that matter more, rather than wasting time on the questions that count for fewer points. If you finish early, look through all your answers again. Give special attention to questions with underlined words. Don't stop working until the final bell. If you finish early, maybe you missed answering all the questions. Go back and make sure there are other questions (like on the back side of a sheet), up on the blackboard, on sheets you dropped on the floor, etc. You may only be getting half your answers right, but, that could be a passing mark, even a top mark depending on the curve.  Tests can be daunting, but you almost always know more than you think you do. Once you get in there and start taking the test, you will remember a lot more. If you struggle with a section, simply move on and come back to it later. Wasting time on something that you don’t remember at the moment might mean that you run out of time before you can answer questions that you definitely know the answers to. Also, sometimes there will be hints for the question that you are stuck on later on in the test that will jog your memory. Keep moving through the test and come back to the parts that gave you trouble at the end. You could get caught, and get a zero. Or worse. Don't write notes to yourself on your body, where it can be found (instead, use the strategy in #2, above). If you copy wrong answers from a neighbor, teachers are quick to notice this. And forever after teachers will know you as "The Cheat." Spend the effort you might devote to cheating on doing the best possible job you can honestly. If you fail, use the experience to motivate yourself for the next test. This might mean that you will not concentrate and you will not get the grade that you were expecting to get. Also, if the teacher catches you talking, s/he might give you a failing grade and you will not be able to retake your test.  Taking a test is not the time to talk to your friends. You need to dedicate all of your brain space to the test in front of you. This will help you be more successful. Many teachers consider talking during a test as an attempt at cheating, even if you were not discussing the test. So don’t do it.
A: Pay attention to point values of the questions. Be thorough. Don't panic and don't give up. Don't ever cheat. Never talk to your friends during test conditions.

Q: Let your friends and family know that you really want something by mentioning the item casually. Bring up the item you want several times over a period of days or weeks before Christmas.  ”I saw a new bike at the store and thought it would be really fun to ride.” ”My friend got a new bike and wants me to ride with him; I wish I had one to join him” ”Did you know that bikes were on sale this week at the sporting goods store? Maybe this is a good time to get one.” Make sure that your parents know exactly what you want by telling them the specific thing you want. Tell them that you’d be happy if that was the only item you got this year. Chances are you will still get other presents, but let them know that this one thing means a lot to you. Leave a note with a nice message for your parents that includes the item you want for Christmas. Make sure that you compliment or thank your parents in the note and aren’t just demanding a new toy. ”I’m really glad I have the best parents in the world! I hope I can get an XBox for Christmas!” Volunteer to help out around the house to show your parents how responsible you can be. Try to pitch in with extra chores so your parents want to reward your help with a special present. The more you are able to do, the more likely your parents will be willing to get you the things you want.  Offer to do the dishes. Clean your room really well. Offer to wash the windows. Clean the bathrooms. Take out the trash.
A:
Hint at what you want. Tell your family you only want one specific item. Leave a note saying what you want. Do extra chores.