FINAL TERM REVIEWER - 1st Sem ETECH

SUM() Function

This function allows the numerical data in any number columns or rows by selecting them or typing them.

=SUM(sum_range)

State the basic format of the SUM() Function:

SUMIF() Function

This function is used to summate the values of cells in a range that meet the criteria that have been specified.

Range

These are the cells that contain values and from which values will be checked against the criteria.

Criteria

The value which will define which cells will be summed up.

Sum_range

This is the range of cells to be summed up.

=SUMIF(range,criteria,sum_range)

State the basic format of the SUMIF() Function:

AVERAGE() Function

This function allows the user to get the average of all the numbers in the chosen cells.

=AVERAGE(range to be averaged)

State the basic format of the AVERAGE() Function:

AVERAGEIF() Function

A function that calculates the average of values in a range that match criteria you specify.

=AVERAGEIF(range,criteria,average_range)

State the basic format of the AVERAGEIF() Function:

COUNT() Function

This function is used to count the number chosen cells that have a number value in them.

=COUNT(range to be counted)

State the basic format of the COUNT() Function:

IF() Function

This function allows users to achieve a particular value if the condition has been satisfied or TRUE, or if the condition has not been satisfied or FALSE.

e.g., =__(B5>74.99,"PASSED","FAILED")

=IF(CONDITION,RESULT if TRUE,RESULT if FALSE)

State the basic format of the IF() Function:

AND() Function

This function will test all the conditions set and will return a "TRUE" value if ALL the conditions are met and "FALSE" even if only one condition is not.

e.g., =__(B5="PASSED",C5="PASSED",D5="PASSED")

=AND(CONDITION to be met)

State the basic format of the AND() Function:

=AND(CONDITION to be met)(Nested to IF function)

State the basic format of the AND() Function nested to the IF function, which may be used if he or she wants to have a customized result for the AND function instead of just TRUE or FALSE:

VLOOKUP() Function

This function enables users to find something on the leftmost column of the chosen range and return a value related to it.

e.g., =__(A4,A10:C16,3,FALSE)

Look_up value

This is the value to be found in the leftmost column of the table array. This can be cell reference or an actual value.

Table_range

It is the table from which the data is retrieved. This is the table being searched.

Table_array

Another term for "Table_range".

Column_index_number

It is the column number in table array from which the value is to be retrieved. The first column in the table is Column 1.

Range_lookup

It is logical value that can be either "TRUE" or "FALSE". If left empty, the formula will consider it as "TRUE" and will look for the closest value in Column 1. If "FALSE" the formula will look for the exact match.

=VLOOKUP(lookup_value,table_range,column index number,range lookup)

State the basic format of the VLOOKUP() Function:

CONCATENATE() Function

This function combines two or more text strings. It combines the values from two or more cells into another cell.

e.g., =__(a4," ",b4)

=CONCATENATE(text1,text2,text3)

State the basic format of the CONCATENATE() Function:

Quick Access

1

Ribbon

2

Name Box

3

Formula Bar

4

Cell

5

Row

6

Column

7

Worksheet

8

Worksheet View Options

9

Zoom Control

10

Pictures

A kind of material that are electronic or digital photographs you have saved in any local stored device.

JPG/jpeg

This can support 16.7 million colors and suitable for full color photographic images.

JPG/jpeg

Relatively small in file size.

JPG/jpeg

Does not support transparency.

Joint Photographic Experts Group

JPEG stands for _____.

GIF

Capable of displaying transparency which makes it good for blending with other material or element in the document.

GIF

Displays simple animation.

GIF

Impressive only in sending documents electronically or posting into a website.

GIF

It only supports 256 colors (logos, art decors, drawings, small text, B&W images).

Graphic Interchange Format

GIF stands for _____.

PNG

Said out loud as "ping."

PNG

Built around the capabilities of .GIF.

PNG

Purpose for transporting images on internet at faster rates.

PNG

It supports transparency but it does not support animation.

PNG

It can display 16 million colors.

PNG

It allows the control of the transparency level or opacity of images.

Portable Network Graphics

PNG stands for _____.

Clip Art

A kind of material that is a .GIF type that involves line art drawings or images used as generic representation for ideas and objects.

Shapes

A kind of material that is printable objects or materials that enhance the appearance.

Smart Art

A kind of material that is predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature.

Chart

A kind of material that is a type of material that represent data characteristics and trends.

Screenshots

A kind of material that is a realistic image that you can capture while discussing any report.

In Line with Text

Image is located in the line where the text is located.

Square

Text surrounds the image.

Tight

Text surrounds the image, but the margin or space between the image and text is smaller.

Through

Allows the text to cross between some part of the image.

Top and Bottom

Pushes the text away vertically to the top and/or the bottom.

Behind Text

Image can be dragged anywhere but the texts floating in front of it.

In front of Text

Image is located in front of the text or hovers above the text which obscures it.

Mail Merge

This feature 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

A component of mail merge that is generally the document that contains the main body of the message we want to convey or send.

Place Holder/Data fields, Merge fields

<< >>

List or Data File

A component of mail merge that is where the individual information or data that needs to be plugged in (merged) to the form document is placed and maintained.

Label Generation

Microsoft will print individual addresses to a standard form that it has already pre-formatted. It creates a blank form document that simulates either a blank label or envelope of pre-defined size and will use the data file that you selected to print the information or individual address.

FALSE

Excel can be used so that one does not need to double check all the data entered in the file since it ensures that no incorrect data can be entered in it if programmed properly.

FALSE

The SUM function of Excel can be used to determine the total of all cells that satisfy a given criteria.

TRUE

Graphs make the presentation of data easily understood than presenting it using plain tables.

FALSE

The text to columns feature of Excel functions the same way as the Concatenate function does.

TRUE

In the use of AND function, all conditions included in the formula must be satisfied in order for the formula to show a "TRUE" result.

Data Validation

It ensures that only correct information is entered in the spreadsheet.

Text to columns

This is used to separate contents of one column to two or more columns.

Conditional formatting

This enables one to emphasize certain cells with the formatting required.

Graphs

It is used to give graphical representation of what is in the spreadsheet that makes data easy to visualize and understand.

Max

This function is used to search for the highest value in a range.

Min

This function is used to search for the lowest value in a range.

Range

It refers to a group or collection of cells which can be a group of cells within a row, column, or combinations of both.

Balance

The visual weight of objects, texture, colors, and space is evenly distributed on the screen.

Emphasis

Giving more weight or focus to some elements on the screen. It is used to give attention to the most important part or content

Proximity and Unity

Closely related elements should be placed together to be perceived as one unit of design.

Pattern, Repetition, and Rhythm

These are the repeating visual element on an image or layout to create unity in the layout or image. Rhythm is achieved when visual elements create a sense of organized movement.

Proportion

Refers to relative sizes and scales of the different element of the design in connection to the overall design.

Variety

This uses several design elements to draw a viewer's attention.

Information graphics or infographics

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

Visual Elements

Includes color coding, graphics, and reference icons.

Content Elements

Includes time frames, statistics and references.

Knowledge Elements

Consists of facts.

Color coding; Graphics; Reference icons

Enumerate three (3) elements under visual:

Time Frames; Statistics; References

Enumerate three (3) elements under content:

Facts

State one (1) element under knowledge:

Cause and Effect Infographics

Infograpics that show the cause and effects of certain topics.

Chronological Infographics

Usually used to show a topic in a chronological or a step-by-step sequence.

Quantitative Infographics

Used to show statistics like charts, bar graphs, etc.

Directional Infographics

Similar to chronological infographics where you use arrows to direct the viewers attention to another aspect of the infographic.