EMPTECH

• PARTS OF MS EXCEL

  Title bar

  Formula bar

  Active cell

  Column heading

  Row heading

  Column

  Cell

  Reference cell

  Row

  Sheet tab
• ROW


  Horizontal line in a table
• COLUMN


  Vertical line in a table
• CELL


  the place where the info is
• ACTIVE CELL


  selected c3ll
• COLUMN HEADING


  The box at the top containing letters
• ROW HEADING


  The number row
• SUM-Adds all the values


  =SUM(number 1, number 2)
• AVERAGE-Calculates the sum then divides the value


  =AVERAGE(number 1, number 2)
• COUNT - counts all cells in a given range

  =COUNT(value 1, value 2)
• MAX

  • The highest value
  • =MIN(number 1, number 2)
• MIN

  • Lowest value
  • =MIN(number 1, number 2)
• FUNCTIONS 


  Predefined formulas and are already available in Excel.
• • Ctrl+A - Select All
• • Ctrl+B - Bold Text
• • Ctrl+C - Copy Text
• Ctrl+D - Show Font Dialog Box
• Ctrl+E - Align Text to Center
• • Ctrl+F - Display Find Dialog Box
• • Ctrl+G - Display Go To Dialog Box
• • Ctrl+H - Display Replace Dialog Box
• Ctrl+I

  Italicize text
• Ctrl+J

  Justify text
• Ctrl+k

  Create hyperlink
• Ctrl+L

  Alight text to the left
• Ctrl+M


  Tab
• Ctrl+N

  Create new document
• Ctrl+O

  Open new document
• Ctrl+P

  Display print dialogue box
• Ctrl+R

  Align text to the right
• Ctrl+S

  Save a document
• Ctrl+U

  Underline text
• Ctrl+V

  Paste copied text
• Ctrl+X


  Cut a selected text
• Ctrl+Y


  Redo the last undone section
• Ctrl+Z


  Undo the last action
• Uses of Interactive

  • Education
  • Training
  • Games
  • Simulation
  • Info presentation
  • Corporate Presentation
• MULTIMEDIA CONTENTS


  • Videos - through video host hosting sites
  • Sounds / Music or Audio - you can record sounds & share it to the world
  • Online Games- developers now create Browser based game"
  • Online test - Online Survey that automatically display the results
  • Course ware- online courses that stimulates the classroon outline
• Podcast - Episode series of audio and textiles strecimed outline


  DATE
• Designing Interactive multimedia

  • Determine the needs and goals- set up schedule
  • Learn the content- learn about the content yourself
  • Generate ideas- brainstorm
  • Storyboard- textual and pictorial displays
  • Flowchart the program- series of diagrams showing the flow
  • Detailed design- detailed info about the project.
  • Program it- translate the Storyboard into instructions.
  • Produce support materials- user manuals, worksheets, etc...
  • Evaluate & revise- get feedback, fix bugs, final production