e-tech mod 2

• Common productivity tools

  1.    Microsoft word

  2.    Microsoft excels

  3.    Microsoft PowerPoint 

  4.    LibreOffice 
• Mail Merge

  • It is a Word’s way of generating mass mailings.
• Mail Merge

  • It involves combining a list of names and addresses to individually address to each person / receiver on the list.
• You can use Mail Merge to create envelopes or address labels, as well as form letters.  
• Main document – this document contains text and graphics. Example body of the letter.  
• Mailing list – this is your data source that is used to populate information in the letter. It contains names and address of the recipients.  

   
• Merged document - this document the combination of the main document

   
• Animation - is a simulation of movement created by displaying a series of pictures, or frames.
• Animation on computers is one of the chief ingredients of multimedia presentations.
• A hyperlink is a reference data that the reader can directly follow either by clicking or tapping.
• Hyperlinks are found in nearly all Web pages, allowing users to click their way from one page to another.
• In text hyperlinks are often color blue and underlined.
• When you move the cursor over a hyperlink, whether it is text, button or an image, the arrow cursor should be change to a small hand pointing to the link
• two basic parts of hyperlink

  1. address
  2. display
• 1.    The Address – can be webpage, email address, or other location they are linking. 
• 2.    The Display – can be picture or shape. 
• Word processing refers to an application program for manipulating text-based documents; the electronic equivalent of paper, pen, typewriter, eraser, and most likely, dictionary and thesaurus.
• According to emerald.com, an electronic spreadsheet is probably the most useful general-purpose for the microcomputer user.   Almost all spreadsheets are now packaged in combination with other applications, such as database systems and graphic capabilities.
• electronic spreadsheet refers to a collection of text and numbers laid out in a rectangular grid.
• electronic spreadsheet - It is an application program commonly used for budgeting, inventory management, decision making, forecasting and other finance-related tasks. 
• Formula – is an equation that performs operation on worksheet data.
• A formula in Microsoft Excel always begins with an equal sign (=). 
• #DIV/0! - appears when entering a formula that performs explicit division by zero (0),
• • ##### - appears when the column is not wide enough to display the content and/or dates and times are negative numbers.
• #NAME? - Appears when the formula refers to a range name that doesn't exist in the worksheet.
• #N/A - an inappropriate value was given for the lookup value argument in the HLOOKUP
• #NULL! - Appears most often when you insert a space (where you should have used a comma) to separate cell references used as arguments for functions.  
• #NUM! - Appears when Excel encounters a problem with a number in the formula, such as the wrong type of argument in an Excel function or a calculation that produces a number too large or too small to be represented in the worksheet.  
• #REF! - Appears when Excel encounters an invalid cell reference, such as when you delete a cell referred to in a formula or paste cells over the cells referred to in a formula.  
• #VALUE! - Appears when you use the wrong type of argument or operator in a function, or when you call for a mathematical operation that refers to cells that contain text entries
• Solution is optionally, if error checking is turned on in Excel, click the button that appears next to the cell that displays the error, click Show Calculation Steps if it appears, and then click the resolution that is appropriate for your data.