 |
Select Columns A to G
as shown. |
|
|
|
|
|
|
|
While still selected,
right-click and choose Column Width... and type a column
width of 15. |
|
|
 |
Select Rows from 1 to 13
and Right-Click.
|
|
|
 |
Choose a Row Height of
32. |
|
|
|
 |
Select Column H as shown then
hold down the Ctrl
+ Shift keys. While
depressing the keys hit the Right
Arrow key. This will select
all the columns from letter I all the way to the
right. |
|
|
|
 |
With the
columns still selected, Right-click and choose
Hide from the popup window to hide all the
columns that you won't be using for this
project. |
|
|
|
 |
Select Row
14.
Hold down Ctrl
+ Shift
then hit the Down
arrow key. This will select all the rows from 14
to 1048576.
Right-click
and select Hide from the popup window. |
|
|
|
 |
Click and
drag to select all the cells.
Select the
Paint Bucket tool
in the Home menu ribbon bar and choose a color
for the background of your calculator.
|
|
|
|
 |
Select the
following cells and change the fill color to
white or another light color. These will be your
data entry cells:
B4, D4, F4
B6, D6, F6
B8, D8, F8
B10, D10, F10
B12, F12
Hold down the
Shift
Key to
select multiple cells. |
|
|
|
 |
Click and
drag to select Cells
B2
to F2.
Right-Click and
select Format Cells. |
|
|
|
 |
In the window
that opens choose
Alignment.
Check
Merge Cells
and change the Horizontal and Vertical
Alignments to
Center. |
|
|
|
 |
In the merged
cells give your calculator a name as shown.
In the following
cells type these mathematical operands:
-
in C4 type +
-
in C6 type -
-
in C8 type x
-
in C10 type ÷ (go to Insert Symbol)
-
in C12 type x2 (right-click,
Format Cells, and choose superscript)
Choose a larger Font size for these symbols. |
|
|
 |
Select each
of the following cells and type the following
into the Formula Bar:
-
in F4 type
=B4+D4
-
in F6 type
=B6-D6
-
in F8 type
=B8*D8
-
in F10 type
=B10 / D10
-
in F12 type
=B12*B12
It is important
to hit Enter after entering formula in
each cell. If you just click on another
cell, that cell's name will be added to your
formula. |
|
|
 |
|
Add the
equals signs for a finishing touch.
You should
now have a working formula. Type the numbers into the
white cells then hit the
Enter Key to
calculate. |
