excel navigation n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Excel Navigation PowerPoint Presentation
Download Presentation
Excel Navigation

Loading in 2 Seconds...

play fullscreen
1 / 15

Excel Navigation - PowerPoint PPT Presentation


  • 120 Views
  • Uploaded on

Excel Navigation. Instructions. Open Word and find the Excel 2013 Navigation Worksheet on the S hared drive. Use this PowerPoint presentation as you answer the questions.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Excel Navigation' - adora


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
instructions
Instructions
  • Open Word and find the Excel 2013 Navigation Worksheet on the Shared drive. Use this PowerPoint presentation as you answer the 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.
excel navigation keystrokes
Excel Navigation Keystrokes
  • Open a blank workbook 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
ribbon
Ribbon

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

slide5
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.
groups
Groups

Groups

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

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.
slide8

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

sheet tab
Double click the sheet tab and then type in a different name (i.e. January, February, etc.)

Default number of sheets is one, but you can add additional sheets by clicking the New sheet key .

Click and drag to move the sheet in a different order.

Sheet Tab
toggle button
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, Italic, and Underline are examples of toggle buttons.
  • A toggle button is like a light switch. It turns on and off with the same switch.
page layout tab common features
Page Layout Tab(common features)
  • Margins, Custom Margins, Margins
    • Change vertically and horizontally
  • Orientation
    • Portrait or Landscape
  • Gridlines
    • View
    • Print
slide12
HELP!
  • Press the key

OR

  • Press F1

Type in the keyword and hit Enter or click on the magnifying glass.

fill handle
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.

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