LESSON 4

• Spreadsheet


  Electronic version of the columnar pad
• MS Excel


  Spreadsheet program that allows you to store, organize, and analyze information
• Formulas


  Tools with which you can manipulate, analyze and draw calculations about your worksheet data
• How to enter a formula

  1. Click on the cell where you want to enter a formula and type = (equal sign) as the first character

  2. Enter a value or select the cell that includes the value you want in the formula

  3. Add the necessary operators or functions. Use parentheses, if applicable

  4. When the formula is complete, click on the ✓ button or press enter on the end of the formula at the formula bar
• Cell referencing


  Using cell references, you can control how formulas in a cell display when you paste or drag them to a new location
• Relative referencing


  By default, Excel records new formula entries are relative reference formulas. When you copy or move a relative reference formula, Excel changes the cell references in the copies of the formulas to reflect the relative location of the formula from the cell references in the formula
• Absolute referencing


  You use an absolute reference formula when you want to anchor cell references in a formula. In absolute referencing, the cell references always point to a specific location regardless of where the formula is moved or copied
• How to use an absolute reference


  1. Click on the cell where you want to enter a formula

  2. Type the equal sign (=) to begin the formula

  3. Select the cell to be computed then enter an arithmetic operator

  4. Select another cell then press the F4 key on the keyboard to make the cell reference absolute. Observe the $ signs added to the cell reference
• Calculating cost using MS Excel

  1. Type in your data to MS Excel

  2. Use the SUM formula to get the summation of the values from C4 to C7

  3. Check if out estimated price will earn us profit. Type the additional information shown below then apply the arithmetic formula for subtraction

  4. Include the information below and deduct the Total from the New Sale price
• AVERAGE function


  Used to determine the average rating of Quality, Taste, Presentation, and Product
• COUNTIF function


  Used to determine how many people said YES or NO if they were satisfied with the product or if they would recommend it to their friend
• AVERAGEIF function


  Used to average a range if the cell beside it equals to "teacher" and/ or "student"
• Microsoft PowerPoint


  • Powerful presentation software that helps you produce an effective presentation in the form of onscreen slides
  • Provides hyperlinks and several animation styles such as Entrance, Emphasis, Exit, and Motion Paths
  • Animation and hyperlinks are great tools for making a presentation more dynamic
• Canva


  • Online multimedia platform offering multiple functionalities and features including creating visual contents, graphics, presentations, advertising materials, and more
• Apple Keynote


  • Presentation software application developed as part of the iWork productivity suite by Apple Inc. Began as a computer program for Apple's former CEO Steve Jobs to use in creating the presentations for the Macworld Conference and Expo and other Apple keynote events
• Haiku Deck


  • Online app that makes presentations simple, beautiful, and fun. It is a powerful new application that uses artificial intelligence to instantly transform your ideas into beautiful presentations
• PhotoSnack


  • Probably, this is the best free slideshow maker and an interactively easy app you can use to make slideshows with music. Use it to share important moments in your life with friends and family
• Slide


  A single page of a presentation collectively, a group of slides may be known as a slide deck
• Design templates


  Pre-designed graphic styles that you can apply to your slides
• Transitions


  Motion effects that when in Slide Show view add movement to your slides as you advance from one slide to another
• Animation


  A set of effects which can be applied to text or graphic within a slide
• Slide show button


  A collection of pages arranged in sequence that contain text and images for presenting to an audience
• Presentation views


  Buttons that you use to change views into normal, outline, slide sorter, notes page, and reading views
• Normal view


  A simplified layout of the page so you can quickly key, edit, and format the text
• Outline view


  Displays all of the text in a PowerPoint slide show in outline form regardless of the design, objects, and animations
• Notes page view


  Displays your slides on the top portion of the page, with the speaker notes for each slide in the notes page on the bottom of the pane
• Slide sorter view


  Allows you to see thumbnails of all the slides in your presentation to easily rearrange them
• Using hyperlinks in Microsoft PowerPoint


  1. Select an object or highlight a text

  2. Go to insert > Hyperlink (under the links category) or use the shortcut key Ctrl+ K

  3. Link to options: Existing File or Web Page, Place in This Document, Create New Document, E-mail Address

  4. When done, click Ok, to apply the hyperlink
• Embedding objects in Microsoft PowerPoint


  1. Go to the Insert tab

  2. On the Text group, click Object

  3. Options: Creates New, Create from File

  4. Once you are done, click Ok