PowerPoint & Excel

• Microsoft PowerPoint


  A powerful presentation software developed by Microsoft that provides users with an interface to design multimedia slides to be displayed on a projection system or personal computer
• Slides


  • An individual screen in a slide show
• Presentation File


  • The file saved to disk that contains all the slides, speaker's notes, handouts, etc. that make up a presentation
• Slide Show


  • The presentation of PowerPoint slides
• Object


  • Any element that appears on a PowerPoint slide such as clip art, text, drawings, charts, sounds, Flash objects, WordArt, SmartArt, photo albums, and video clips
• Transitions


  • The effect that takes place when advancing from one slide to the next
• Animations


  • Special visual and sound effects applied to text or content
• Placeholders


  • Boxes that display when creating a new slide
• Slide Master


  • The top slide that controls information about the theme
• Ribbon


  • Contains commands organized into tabs
• File tab


  • The first tab on the Ribbon
• Quick Access toolbar


  • A small, customizable toolbar that exposes a set of commands specified by the application or selected by the user
• Slides and Outline tab


  • The Slides tab shows thumbnail icons of slides, and the Outline tab shows the presentation arranged as an outline
• Status bar


  • Tells the currently displayed slide (e.g., Slide 5 of 20)
• Notes pane


  • Located beneath the slide, used to add notes to slides
• Hyperlinks


  • A connection from one slide to a webpage, email address, slide, or file; text or objects can be formatted as hyperlinks
• Ways to Insert Hyperlinks

  Select an object or highlight text, then select Hyperlinks and choose from options like Existing File or Web Page, Place in This Document, Create a New Document, E-mail Address
• Embedding Objects in Microsoft PowerPoint

  Go to Insert tab, select Object, and choose between creating a new object or creating from an existing file
• Minimize slide counts to maintain a clear message and audience attention
• Avoid using fancy font styles; use easy-to-read fonts
• Use bullets or short sentences; limit content to 6x7 (six lines, seven words per line)
• Use graphics to help in the presentation but avoid too many to distract the audience
• Make the design uniform; avoid different font styles and backgrounds
• Use contrast with light font on a dark background or vice versa
• Microsoft Excel


  Allows users to organize, format and calculate data with formulas
• Projects that can be done in a spreadsheet

  • Budgeting displays
  • Checkbook registers
  • Enrollment records
  • Inventories
  • Surveys
  • Field and laboratory research data
  • Financial and accounting applications
• Cell


  Intersection between a row and a column
• Cell Address


  A combination of a letter and a number that specifies the column and row
• Cell Pointer


  Heavy border around the selected cell
• Row


  A series of data banks laid out in a horizontal fashion in a spreadsheet
• Column


  A vertical series of cells in a spreadsheet
• Row numbers range from 1 to 1048576 and Columns range from A to XFD, in total 16384 columns
• Workbook


  An Excel file that contains one or more worksheets
• Worksheet


  A collection of cells on a single "sheet"
• Values


  The data in a spreadsheet
• Quick Access Toolbar


  • A customizable toolbar that contains or holds frequently used commands
• Ribbon


  • Depicts all the features of Excel
• Formula Bar


  • Displays the contents of the active cell
• Sheet Tab


  • The current worksheet that is being displayed
• Name Box


  • Shows the address of the current selection or active cell