| Creating the Worksheet |
- Go to Start>Programs>Teachers>Microsoft
Excel.
- In cell A1 type the title of your cell. Use the term Questions
or Problems.
- You may change the width of the column by placing your mouse on the
line just between the column headers A and B and double clicking to automatically make
text fit.
- In cell B1 type the word Answers. This will be the column for
the students to record their answers.
- In column C you will enter the If-Then formulas. Click in cell
C1. Select the function wizard icon on the toolbar:
- Choose IF in the second column of the function
wizard box. Click Next.
- A gray dialog box will appear in which you must fill in the correct
infomation as shown in the example below:
- Click finish.
- Now use the absolute reference feature. Highlight cell and drag
a copy of cell C2 to the end of your exercise. You will get a + sign on the bottom
right corner of the cell which you wish to drag and copy. This will copy the if-then
formula into all the cells. You will need to go back to each individual cell and
insert your cursor to delete and change the answer to reflect the question on each row.
Refer to the activity sheet to input information.
- Double click between column C and D on the gray row to widen the
column.
|
| |
| Hiding Answer Column |
- Click to highlight the column you would like to hide.(C)
Click on the gray cell with the letter C at the top of the column.
- Choose Format on the menubar and select Column.
- Choose Hide from the pop up menu.
- Notice the column is now hidden. A darker black line appears
where the column is hidden.
|
| |
| Unhiding Answer Column |
- Highlight the column before and after
hidden column. (B and D)
- Choose Format on the menubar and select Column.
- Choose Unhide from the pop-up menu.
- The column should reappear.
|