Excel Date, Time, Currenty and Percent

  1. Open Excel.
  2. Make sure you are in cell a1.
  3. Type your name.
  4. Tap enter.
  5. Press and hold down the control key and tap the semi-colon key to insert the date.
  6. Tap enter one time.
  7. Press and hold down the control and shift keys and tap the semi-colon key one time to insert the time.
  8. Tap enter two times to go to cell a5.
  9. Press and hold down the control and shift keys and tap the number 4 key (above the alphabet keys).
  10. Release all keys.
  11. Type the number 4.
  12. Tap enter.
  13. Up arrow one time.
  14. You should see or hear $4.00; you have used the currency command.
  15. Press control g.
  16. Type a6
  17. Tap enter one time and you are in cell a6, just below the cell containing “$4.00”.
  18. Press and hold down the control and shift keys and tap the number 5 key (just above the alphabet keys).
  19. Release all keys.
  20. Type the number 4.
  21. Tap enter one time.
  22. Up arrow one time and you should see or hear “4%”.
  23. Press control g.
  24. Release both keys.
  25. Type c10.
  26. Tap enter.
  27. Press control shift 4.
  28. Release all keys.
  29. Type the number 5.
  30. Tap enter one time.
  31. Press control shift 4.
  32. Type the number 6.
  33. Tap enter.
  34. Press control shift 4.
  35. Type the number 7.
  36. Tap enter.
  37. Press control g.
  38. Type d10.
  39. Tap enter.
  40. Press control shift 5.
  41. Type the number 5.
  42. Tap enter one time.
  43. Press control shift 5.
  44. Type the number 6.
  45. Tap enter one time.
  46. Press control shift 5.
  47. Type the number 7.
  48. Tap enter.
  49. Press control home to go to cell a1.
  50. Save the file as Excel Handout Lesson Two
  51. 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