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

studied byStudied by 41 people
5.0(1)
get a hint
hint
  1. Have a question in mind

  2. Narrow it down

  3. Advanced search

  4. Look for a credible source

  5. Give credit

1 / 42

Tags & Description

Studying Progress

0%
New cards
43
Still learning
0
Almost done
0
Mastered
0
43 Terms
1
New cards
  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

New cards
2
New cards

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

New cards
3
New cards

Form Document

  • component of mail merge

  • it contains the message and it remains the same no matter who you send it to

New cards
4
New cards

List or Data File

  • component of mail merge

  • individual information or data that needs to be merged

New cards
5
New cards

Accounting Formats

  • a number format that is used for accounting

  • values with Php or Philippine peso sign use the Accounting Number Format

New cards
6
New cards

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

• how do you change the value to any other currency

New cards
7
New cards

Ctrl + 1

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

New cards
8
New cards

Count

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

New cards
9
New cards

• COUNT Function • COUNTA • COUNTIF

  • to count numbers only

  • to count numbers and text

  • to count based on one criteria

New cards
10
New cards

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

New cards
11
New cards

SUM

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

New cards
12
New cards

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

New cards
13
New cards

AVERAGE

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

New cards
14
New cards

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

New cards
15
New cards

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

New cards
16
New cards

Go to Inster>Hyperlinks or Ctrl + K

• how do you insert a hyperlink

New cards
17
New cards

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

New cards
18
New cards

Place in this document

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

New cards
19
New cards

Create a New Document

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

New cards
20
New cards

E-mail Address

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

New cards
21
New cards

Embedding

  • the act of placing objects within the presentation

New cards
22
New cards

Insert, Text Group, Object, Insert Object dialog box

• how to embed a file to your slide presentation

New cards
23
New cards

Creates New

  • creates a new file from scratch

  • you can select on a wide variety of files listed

New cards
24
New cards

Create from File

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

New cards
25
New cards

Balance

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

New cards
26
New cards

Emphasis

  • attract the viewer's attention

New cards
27
New cards

Movement

  • guide the viewer's eyes around the screen

New cards
28
New cards

Patter, Repetition & Rhythm

  • repeating visual element

  • the sense of organized movement

New cards
29
New cards

Proportion

  • the sense of unity where they relate well

New cards
30
New cards

Variety

  • several design element to draw a viewer's attention

New cards
31
New cards

Infographics

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

New cards
32
New cards

Raster-Based

  • the basic type of online format for images

  • bitmapped images

  • cannot be scaled without distortion

New cards
33
New cards

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

New cards
34
New cards

Tagged Image File Format(TIFF)

  • usable

  • high-quality master image

  • file size can be huge

  • gained popularity as a scanning format

New cards
35
New cards

Graphics Interchange Format(GIF)

  • supports transparency & animation

  • graphics and logos with areas of solid color

  • smaller file size

  • limited number of colors

  • transparent background

New cards
36
New cards

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

New cards
37
New cards

Bitmap(BMP)

  • low-quality files

  • word processing application

New cards
38
New cards

Photoshop Document(PSD)

  • native file format for Adobe Photoshop

  • layered images

New cards
39
New cards

Vector-Based

  • the basic type of online format for images

  • mathematical formulas

  • scale the image without distortion

New cards
40
New cards

Drawing Interchange Format(DXF)

  • used in computer-aided design

  • used by engineers and architects

New cards
41
New cards

Encapsulated Postscript(BPS)

  • desktop publishing

New cards
42
New cards

Computer Graphic Metafile(CGM)

  • image oriented software programs

  • high degree of durability

New cards
43
New cards

Shapefiles(SHP)

  • ESRI GIS(geographic information system) applications

New cards

Explore top notes

note Note
studied byStudied by 38 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 14 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 75 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 4 people
Updated ... ago
4.0 Stars(1)
note Note
studied byStudied by 3 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 11 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 10 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 1591 people
Updated ... ago
4.7 Stars(14)

Explore top flashcards

flashcards Flashcard36 terms
studied byStudied by 15 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard75 terms
studied byStudied by 6 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard56 terms
studied byStudied by 12 people
Updated ... ago
5.0 Stars(3)
flashcards Flashcard37 terms
studied byStudied by 3 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard67 terms
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard71 terms
studied byStudied by 99 people
Updated ... ago
5.0 Stars(2)
flashcards Flashcard47 terms
studied byStudied by 22 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard66 terms
studied byStudied by 208 people
Updated ... ago
5.0 Stars(2)