Opening and looking at blank Excel worksheets in an Excel workbook.
- Press and hold down the Windows key and tap the letter r, or just hit the Windows (Start) key one time.
- Release both keys if you used the Windows key r (run command).
- Type excel
- Tap enter one time.
- You are in an excel workbook, that has three worksheets (Excel 2013 opens up with just one worksheet). Go
from worksheet one to worksheet two by pressing and holding down
the control key and tapping the page down key one time. Go to
worksheet three by pressing and holding down the control key and
tapping the page down key one time. Go back to worksheet one
by pressing and holding down the control key and tapping the page up
key two times.
- On each Excel worksheet, there are columns and rows:
Columns go up and down the page, and are labeled by alphabet
letters. For example, there is column A, column B, and so on.
Rows go left to right, and are labeled by numbers. For example,
there is row 1, below that is row 2, and so on.
- Press control home and you will be in cell a1.
- Tap the enter key one time and you will be in cell a2; notice that when you tap enter you go down the page.
- Press control home to go to cell a1.
- Tap the tab key one time and you will be in cell b1; notice that when you tap the tab key you move to the right.
- Press and hold down the shift key and tap the tab key one
time and you will be back in cell a1; notice that shift tab moves
you to the left or backwards.
- Press control home to make sure you are in cell a1.
- Tap the down arrow key one time and you will be in cell a2.
- Tap the up arrow key one time and you will be back in cell a1.
- Tap the right arrow key one time and you will be in cell b1.
- Tap the left arrow key one time and you will be in cell a1.
- Press and hold down the control key and tap the letter g one time.
- Release both keys.
- Type c5
- Tap enter.
- You have just used the “goto” command to go to cell c5.
- Type dog
- Press control home to go back to cell a1.
- Press and hold down the control key and tap the letter f.
- Release both keys.
- Type dog.
- Tap enter.
- Tap escape.
- You have just used the “find” command sequence to find the word “dog,” which is in cell c5.
- Press control g.
- Type a1
- Tap enter and you will be back in cell a1.
- Press control g.
- Type f5
- Tap enter.
- You are in cell f5.
- Tap the Home key (all by itself).
- You are now in cell f1; when you tap just the home key, you are taken to the beginning of the row you are on.
- Press control home to go back to cell a1.
Assignment: Open Excel. In cell a1 write your
name. In cell a2 write the date. In cell a4 write Candy. In cell a5
write Chips. In cell a6 write Pop. In cell b4 write $1.00. In cell b5
write $.75. In cell b6 write $1.25. Save the Excel file as Small Step
Assignment One. Print out 2 copies and give one to the teacher, and
keep the other one.
Did you notice: Your words/text was left aligned,
and your numbers were right aligned? Words or text are considered as
labels by Excel, and are automatically left aligned, unless you specify
differently. Numbers are considered data by Excel, and are right
aligned for the purpose of place value.
BACK