EMPTECH: Excel Terms, Principle of Design, Online Format for Images and Texts

1. Have a question in mind
2. Narrow it down
3. Advanced search
4. Look for a credible source
5. Give credit

• Tips in Conducting Online Research

Mail Merge

- allows you to create documents and combine or merge them with another document or data file
- it is commonly used when sending out advertising materials to various recipients

Form Document

- component of mail merge
- it contains the message and it remains the same no matter who you send it to

List or Data File

- component of mail merge
- individual information or data that needs to be merged

Accounting Formats

- a number format that is used for accounting
- values with Php or Philippine peso sign use the Accounting Number Format

click the drop-down arrow at the currency button then select More Accounting Format

• how do you change the value to any other currency

Ctrl + 1

• what do you press to change the orientation of a text

Count

- a function used to count the cells with content in a range

• COUNT Function
• COUNTA
• COUNTIF

- to count numbers only
- to count numbers and text
- to count based on one criteria

COUNTIF(range,criteria)
• Range
•Criteria

- format of COUNTIF function
? the cells where the counting will take place
? the label or value that determines if it is to be counted

SUM

- function used to compute the summation of the number of a range

SUMIF(range, criteria)
• Range
• Criteria

- format of SUMIF function
? the cells you want to apply the criteria against
? used to determine which cells to add

AVERAGE

- a function used to compute for the average of the number of a range

AVERAGEIF(range, criteria, [average_range])
• Range
• Criteria
• Average Range

- format of AVERAGEIF function
? One or more cells, including numbers or names, arrays or references
? A number, expression, cell reference, or text
? The cells to average. When omitted range is used

Hyperlinks

- a text or object that contains a link to another file, web page, a place in a document, a link to a new document, or an email address

Go to Inster>Hyperlinks or Ctrl + K

• how do you insert a hyperlink

Existing File or Web Page

- creates hyperlink to a website or a local file saved in your hard drive
- just browse your file in the dialog box or type the web address

Place in this document

- creates a hyperlink that allows you to jump to a specific slide in your presentation

Create a New Document

- creates a hyperlink that once clicked, creates a new document on your specified location

E-mail Address

- creates a hyperlink that opens MS Outlook that automatically adds your specified recipient on a new email

Embedding

- the act of placing objects within the presentation

Insert, Text Group, Object, Insert Object dialog box

• how to embed a file to your slide presentation

Creates New

- creates a new file from scratch
- you can select on a wide variety of files listed

Create from File

- creates a file from an existing file saved on your hard drive

Balance

- the visual weight of objects, textures, colors, and space is evenly distributed

Emphasis

- attract the viewer's attention

Movement

- guide the viewer's eyes around the screen

Patter, Repetition & Rhythm

- repeating visual element
- the sense of organized movement

Proportion

- the sense of unity where they relate well

Variety

- several design element to draw a viewer's attention

Infographics

- represent information statistical data or knowledge in a graphical manner usually done in a creative way to attract the viewer's attention

Raster-Based

- the basic type of online format for images
- bitmapped images
- cannot be scaled without distortion

Joint Photographic Experts Group(JPEG)

- doesn't support transparency & animation
- supports a wide range of colors
- used in Internet delivery and photo sharing compressed
- great for maximizing

Tagged Image File Format(TIFF)

- usable
- high-quality master image
- file size can be huge
- gained popularity as a scanning format

Graphics Interchange Format(GIF)

- supports transparency & animation
- graphics and logos with areas of solid color
- smaller file size
- limited number of colors
- transparent background

Portable Network Graphics(PNG)

- used for screenshots, high compatibility
- supports transparency but not animation
- higher quality files than GIF
- preferred for images that contain text or line art

Bitmap(BMP)

- low-quality files
- word processing application

Photoshop Document(PSD)

- native file format for Adobe Photoshop
- layered images

Vector-Based

- the basic type of online format for images
- mathematical formulas
- scale the image without distortion

Drawing Interchange Format(DXF)

- used in computer-aided design
- used by engineers and architects

Encapsulated Postscript(BPS)

- desktop publishing

Computer Graphic Metafile(CGM)

- image oriented software programs
- high degree of durability

Shapefiles(SHP)

- ESRI GIS(geographic information system) applications