Name Period
EXCEL 2013 NAVIGATION WORKSHEET
Computer Technology
Directions: Open the Excel 2013 Navigation PowerPoint from the Shared drive. Use the presentation to help you answer the following questions. Save as: “Lastname Firstname Navigation Worksheet”. Close the file and copy it to the Teacher Folder.
Open a blank Excel workbook and use the following answers to fill in the blanks belowShift + Tab / Ctrl + Home / Arrow Keys / Ctrl + G / Home / Tab / Ctrl + End
EXCEL NAVIGATION KEYSTROKES
PRESS / TO MOVE CELL POINTER
Keys that move up, down, right, or left one cell
Move to and select the contents of the next cell
Move to and select the contents of the previous cell
Move to the first cell in the row
Move to cell A1 (1st cell in the spreadsheet)
Move to last cell in the spreadsheet (with typing in it)
Go To – move to specific cell in spreadsheet (also in Edit)
Use the following words to answer the questions below.
Groups / Plan / Key Tip Badge / Quick Access Toolbar
Tab / Mini Toolbar / Double-Click / Toggle
Dialog Launching Box / Page Layout / Ribbon / Fill Handle
F1 / Enhanced Screen Tip
1 A provides easy, central access to the tasks performed while creating a worksheet.
2. The provides easy access to frequently used commands.
3. Each surrounds a collection of groups.
4. contain related commands depending on which Tab is selected.
5. The contains commands related to changing the appearance of text.
6. The will appear when the Alt key is pressed.
7. When you move the mouse pointer over a button, an displays the name and a description of the button.
8. The will display a dialog box or task pane.
9. the sheet tab to give it a different name.
10. The bold button is a button, which means that if you click the bold button once, it turns on bold. Click again and it turns bold off.
11. Use the tab to change the margins or switch from portrait to landscape orientation.
12. Get help by pressing the key or by clicking on the question mark.
13. Point to the bottom right corner of the active cell to locate the .
The mouse pointer will change to a dark black plus sign.
14. An electronic spreadsheet can display information visually, calculate data accurately, recalculate updated information, but it can’t worksheet objectives.