SHG11 - EMPTECH - LESSON 2

In line with text

the image is part of the line of text which the image is inserted.

Square

the text surrounds the picture

Top and Bottom

the text appears at the top and bottom of the picture.

Tight

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

Through

it allows the text to cross between some part of the image.

Behind Text

the image is located behind the text

In front of text

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

Insert Shape

Shapes can be added to make documents look more interesting.

Shapes

are specially useful in creating flowcharts for tasks, diagrams, illustrations, and comics.

In Front of Text

default text wrapping for Shapes

Tables

are useful in organizing information using rows and columns.

Tables

the most efficient way in presenting large amount of data or information

Tables

easiest way to read and compare different data

Tables

readers can easily see what part of table to be compared with another

Header, Footer, Footnote, and Endnote

Are texts located in the topmost and bottommost part of every page in a document.

Header

is a placeholder for texts at the top margin of each page

Footer

is the placeholder for texts at the bottom margin of each page

Footnote and endnote

are used to place an author's comments or citations of reference documents that support the texts within a document

Footnotes

a short citations not to compromise the format of the document in that page

Endnotes

are used for long and more detailed citations since they are located at the end of the documents

Columns

are useful tools to make documents look easy to read.

page number

is essentially useful in arranging pages into their correct order.

page break

is used to force a computer application (i.e. Microsoft Word) to end the page.

page break

is usually inserted after the title to ensure that no texts or images can be inserted after

=SUM(sum_range)

SUM () FUNCTION formula

=SUM(sum_range)

Allows to sum numerical data in any number of columns or rows by selecting them or typing them in.

=SUMIF(range,criteria, sum_range)

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

=SUMIF(range,criteria, sum_range)

SUMIF() Function

=AVERAGE(range to be averaged)

AVERAGE() Function formula

=AVERAGE(range to be averaged)

Allows user to get the average of all the numbers in the chosen cells.

=COUNT(range to be counted)

used to count the number of chosen cells that have a number value in them.

Useful in determining if there are missing data or values

=COUNT(range to be counted)

COUNT() Function formula

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

IF() Function formula

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

Enables user to achieve a particular value if the condition has been satisfied or TRUE, or if the condition has been satisfied or FALSE

AND() Function

Checks if certain conditions or criteria are true or false.

AND() Function

This formula 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 met

=VLOOKUP(lookup_ value, table_range, column index number, range look)

VLOOKUP() Function formula

=VLOOKUP(lookup_ value, table_range, column index number, range look)

Enables user to find something on the leftmost column of the chosen range and return a value related to it.

Lookup_value

Found in the leftmost column of the table array. This can be a cell reference of an actual value.

Table_range

Found in the leftmost column of the table array. This can be a cell reference of an actual value.

Range_lookup

A logical value can be either “TRUE” or “FALSE”. If the left empty, the formula will consider it as “TRUE” and will look for the closest value In Column 1. If “FLASE”, the formula will look for an exact match.

Column_index_num

It is the column number in table array from which the value is to be retrieved.

=CONCATENATE(text1,text2,text3)

CONCATENATE() Function formula

=CONCATENATE(text1,text2,text3)

Combines two or more text strings. (combines the value from two or more cells into another cell)

MAX()

USED TO SEARCH THE HIGHEST VALUE IN AN ARRAY

MIN()

USED TO SEARCH THE LOWEST VALUE IN AN ARRAY

Conditional Formatting

Enables users to emphasize certain cells with the formatting they want

Text to Columns

Used to separate contents of one column to two or more columns.

Data validation

Limits what particular value can be entered in a cell.

This will make sure that the value entered in a specific cell is reasonable.

Graphs

Used to give users graphical representations of hat is in the spreadsheet

Graphs

Graphical representations make it easy for readers to visualize and understand data in the spreadsheet,