1 / 14

Excel Navigation

Excel Navigation. Instructions. Use this PowerPoint presentation as you answer the Excel Navigation worksheet questions. Have Excel open also and use ALT Tab and then tab back and forth between the two documents while you fill in the answers for the worksheet.

jenna
Download Presentation

Excel Navigation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Navigation

  2. Instructions • Use this PowerPoint presentation as you answer the Excel Navigation worksheet questions. • Have Excel open also and use ALT Tab and then tab back and forth between the two documents while you fill in the answers for the worksheet. • NOTE: Many of the features discussed in this presentation are consistent in all Microsoft products.

  3. Excel Navigation Keystrokes • Open a blank document in Excel. • Type your name in Cell D5. • Try the various keystrokes to see where they move the cell pointer: • Shift + Tab • Ctrl + Home • Arrow Keys • Ctrl G • Home • Tab • Ctrl + End

  4. Ribbon The Ribbon is the control center in Excel. It provides easy, central access to the tasks you perform while creating a worksheet.

  5. Tabs Quick Access Toolbar This toolbar is above the Ribbon and provides easy access to frequently used commands. Each Tab surrounds a collection of groups, and each group contains related commands.

  6. Groups Groups Groups are found on the Ribbon and contain related commands depending on which Tab is selected.

  7. Mini Toolbar The Mini Toolbar will appear automatically based on tasks you perform and contains commands related to changing the appearance of text in a worksheet.

  8. Other Features Key Tip Badge • Press the Alt key and a Key Tip Badge will appear. Press the corresponding number or letter to complete the task. • When you move the mouse pointer over a button, an Enhanced Screen Tip displays the name and description of the button. • The Dialog Box Launcher is a small arrow in the lower-right corner of some groups. When clicked, a dialog box or task pane appears. Enhanced Screen Tip Dialog Box Launcher

  9. Double click the sheet tab and then type in a different name (i.e. January, February, etc.) Default number of sheets is three, but you can add additional sheets by clicking the Home tab, and then Insert, Insert Sheet in the Cells group. Click and drag to move the sheet in a different order. Sheet Tab

  10. Toggle Button • On the Ribbon there are several toggle buttons. • If you click the button once, it turns on. Click it again and it turns off. • Bold is an example of a toggle button. • A toggle button is like a light switch. It turns on and off with the same switch.

  11. Page Layout Tab (common features) • Margins, Custom Margins, Margins • Center vertically and horizontally • Orientation • Portrait or Landscape • Gridlines • View • Print

  12. HELP! • Press the key OR • Press F1 Type in the keyword and click on Search

  13. Fill Handle Fill data within a row or column Select the cells you want to copy. Drag the fill handle (The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a dark black plus sign.) across the cells you want to fill, and then release the mouse button. The fill handle is a great tool that can save lots of time by copying formulas rather than having to type them in each time.

  14. Spreadsheet • Displays information visually • Calculates data accurately • Recalculates updated information • Cannot plan worksheet objectives. That is what a human does when working with spreadsheets.

More Related