Excel Date, Time, Currenty and Percent
- Open Excel.
- Make sure you are in cell a1.
- Type your name.
- Tap enter.
- Press and hold down the control key and tap the semi-colon key to insert the date.
- Tap enter one time.
- Press and hold down the control and shift keys and tap the semi-colon key one time to insert the time.
- Tap enter two times to go to cell a5.
- Press and hold down the control and shift keys and tap the number 4 key (above the alphabet keys).
- Release all keys.
- Type the number 4.
- Tap enter.
- Up arrow one time.
- You should see or hear $4.00; you have used the currency command.
- Press control g.
- Type a6
- Tap enter one time and you are in cell a6, just below the cell containing “$4.00”.
- Press and hold down the control and shift keys and tap the number 5 key (just above the alphabet keys).
- Release all keys.
- Type the number 4.
- Tap enter one time.
- Up arrow one time and you should see or hear “4%”.
- Press control g.
- Release both keys.
- Type c10.
- Tap enter.
- Press control shift 4.
- Release all keys.
- Type the number 5.
- Tap enter one time.
- Press control shift 4.
- Type the number 6.
- Tap enter.
- Press control shift 4.
- Type the number 7.
- Tap enter.
- Press control g.
- Type d10.
- Tap enter.
- Press control shift 5.
- Type the number 5.
- Tap enter one time.
- Press control shift 5.
- Type the number 6.
- Tap enter one time.
- Press control shift 5.
- Type the number 7.
- Tap enter.
- Press control home to go to cell a1.
- Save the file as Excel Handout Lesson Two
- Print two copies of the file; give one to the teacher, and keep one for yourself.
Assignment: Open Excel. Type your name in cell a1,
the date in cell a2, and the time in cell a3. Type $27.50 in cell a5;
$39.48 in cell a6; $50.19 in cell a7; $14.37 in cell a8; and $101.99
in cell a9. Goto cell b5 and type 5%; type 17% in cell b6; type 50%
in cell b7; type 79% in cell b8; and type 100% in cell b9. Save the
file as Small Step Assignment Two. Print two copies. Give one copy to
the teacher and keep one copy for yourself.
BACK