# How to create an interactive spread sheet in Excel

Document Sample

```					How to create an interactive
 Type
   Problem in cell A1
   Right? In A3
    Points in A4
    and Expected in A5
 Then write a problem in cell A2 and
the correct answer in cell B2 and E2.
 In cell C2 copy and past the formula
=IF(B2="","",IF(B2=E2,"Good","Uh-Oh")).
With this formula C2 will say good if the
answer column (B2) is correct and uh-oh
if it is incorrect, if B2 is left blank C2 is
blank.
 Press enter and if this is correctly
done it should say good in cell C2.
 Using this same procedure, add nine
Copy the formulas by using "Fill" >
"Down" from the Edit menu or by
using the "plus sign" curser symbol in
the lower right hand corner of the
formula cell and dragging in down.
 Now we can enter the points into the
points column.
 Enter the following formula
=IF(B2="","",IF(B2=E2,10,0))
 Copy the formula into the remaining
points column.
 Now we can add a total points by
putting in the cell D12 the formula
=Sum(D2:D11)
 Then write Total Points in cell A12
 This will add all of the points in cells
D2 through D11
 Next we need to hide column E
 Select the column
 Click Format > Column> Hide
 To make your worksheet a little bit
easier to read and colorful, change
the color of every other row.
 Select the rows by highlighting them
while holding down Ctrl
 Then choose Format > Patterns >
and choose a color
 Repeat again for other rows if desired
 Now we must protect our worksheet
so students cannot make changes.
 However, we must keep the answer
column unlocked so students can
 First we need to select the cells you
want to unlock, choose Format >
Cells > Protection > deselect
Locked.
 To make the cells larger simply click
on the line between A and B and drag
it left or right to make it longer or
shorter.
 Change the font style and size if
desired.
 Center all the cells.
 To make it look more like a sheet of paper we need
to
 Surround our spreadsheet with white space
 Insert a column before column A by highlighting column
A (put mouse on A and click),
 Choose Insert > Column.
 Insert several rows above row 1 by highlighting row 1
(put mouse on 1 and click), choose Insert > Row.
 Give directions to students
 Merge several horizontal cells together by highlighting
the cells and then choose Format > Cells > Alignment.
Place a check mark in Wrap Text and Merge Cells.
 Type directions into the merged cells
 Insert rows above and below the directions to create a
balanced appearance for the worksheet.
Finally…
 Choose Tools > Options > View.
 Deselect Formula Bar, Status Bar, Windows
in Taskbar, Page breaks, Gridlines, Row &
 Change tab to Edit (instead of View) and
deselect the checkbox for Enable Auto
Complete for cell values
 Tools > Protection > Protect sheet
 If you choose a password you must remember
it to make any changes to your worksheet
 State Capitals

 Multiplication Problems

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 4 posted: 1/14/2010 language: English pages: 22