際際滷

際際滷Share a Scribd company logo

Creating If Statements In Excel

Download as DOC, PDF
A
ahopkins

This document provides instructions for creating a multiplication practice worksheet in Microsoft Excel using IF statements to provide feedback on answers. The worksheet contains 10 multiplication problems with space for answers. An IF statement in each answer cell will display "Wow! Great Job!" for correct answers and "Sorry! Try Again!" for incorrect answers. The instructions guide the user to enter the problems and answers, then add the IF statements to each answer cell to display the feedback. Extra credit is offered for creating a more extensive multiplication review worksheet.

1 of 1
Download to read offline
Creating IF Statements in Microsoft Excel 息 2009 iClipart.com Problem: You have a little brother or sister struggling to learn his/her multiplication facts. You will create a spreadsheet using Excel of 10 multiplication problems. Leave a space for them to type their answer and for an IF statement for feedback on their answer (ex. Wow! Great Job or Sorry! Try again!) Follow the steps below to create your multiplication table. It should look similar to the one below when completed. 1. Begin by opening Excel. 2. Type Multiplication Facts in cell A1. 3. Type Problem in cell A2 and Answer in cell B2. 4. Type out 10 multiplication facts of your choice in cells A3 through A12. 5. Click in cell C3. Select the AutoSum button on the formula bar. 6. Select under More Functions the IF option and click on OK. Type B3= (the number following B3 should be the answer to the multiplication problem in A3, which in this case is 1 (1 x 1). So it should read B3=1. 7. In the Value_if_true box type Wow! Great Job! 8. In the Value_if_false box type Sorry! Try Again! 9. Select OK and then type a wrong answer in B3. In cell C3 the words Sorry! Try Again! should appear. Try typing the correct answer now. The words Wow! Great Job! should appear. 10. Now complete the project by following the same steps for the other 9 problems. To show me you understand how this works, leave some answer right and enter some of the answers as wrong. 11. As always, make it look as nice as possible, adding borders, clipart, etc. 12. Put a heading (View, Header/Footer) and turn it in. EXTRA CREDIT: You may create a multiplication review for elementary students that I could pass on to our elementary teachers. (ex. Make a table for 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, 10s, 11s, 12s). How many should be done for a free 100? See me and well decide.

More Related Content

Creating If Statements In Excel

  • 1. Creating IF Statements in Microsoft Excel 息 2009 iClipart.com Problem: You have a little brother or sister struggling to learn his/her multiplication facts. You will create a spreadsheet using Excel of 10 multiplication problems. Leave a space for them to type their answer and for an IF statement for feedback on their answer (ex. Wow! Great Job or Sorry! Try again!) Follow the steps below to create your multiplication table. It should look similar to the one below when completed. 1. Begin by opening Excel. 2. Type Multiplication Facts in cell A1. 3. Type Problem in cell A2 and Answer in cell B2. 4. Type out 10 multiplication facts of your choice in cells A3 through A12. 5. Click in cell C3. Select the AutoSum button on the formula bar. 6. Select under More Functions the IF option and click on OK. Type B3= (the number following B3 should be the answer to the multiplication problem in A3, which in this case is 1 (1 x 1). So it should read B3=1. 7. In the Value_if_true box type Wow! Great Job! 8. In the Value_if_false box type Sorry! Try Again! 9. Select OK and then type a wrong answer in B3. In cell C3 the words Sorry! Try Again! should appear. Try typing the correct answer now. The words Wow! Great Job! should appear. 10. Now complete the project by following the same steps for the other 9 problems. To show me you understand how this works, leave some answer right and enter some of the answers as wrong. 11. As always, make it look as nice as possible, adding borders, clipart, etc. 12. Put a heading (View, Header/Footer) and turn it in. EXTRA CREDIT: You may create a multiplication review for elementary students that I could pass on to our elementary teachers. (ex. Make a table for 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, 10s, 11s, 12s). How many should be done for a free 100? See me and well decide.