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

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