EMPOWERMENT TECHNOLOGY REVIEWER  Ctrl + C – Copy Text

 Ctrl + D – Show Font Dialog Box

ADVANCE WORD PROCESSING SKILL  Ctrl + E – Align Text to Center
 Word Processor – is an electronic device or  Ctrl + F – Display Find Dialog Box
computer software application that performs the  Ctrl + G – Display Go to Dialog Box
task of composing, editing, formatting, and  Ctrl + H – Display Replace Dialog Box
printing of documents  Ctrl + I – Italicize Text
 Ctrl + J – Justify Text
EXAMPLES OF WORD PROCESSORS  Ctrl + K – Create a hyperlink
 Ctrl + L – Align Text to the Left
 OPENOFFICE WRITER
 Ctrl + M – Tab
 LIBREOFFICE WRITER
 Ctrl + N – Create a new document
 POLARIS OFFICE
 Ctrl + O – Open a document
 KINGSOFT WRITER
 Ctrl + P – Display Print Dialog box
 WORDPERFECT
 Ctrl + R – Align text to the Right
 WORDPAD
 Ctrl + S – Save a document
 MICROSOFT WORD
 Ctrl + U – Underline Text
 Ctrl + V – Paste a copied text
 Ctrl + X – Cut a selected Text
 Microsoft Word – is a word processor
 Ctrl + Y – Redo the last undone action
developed by Microsoft. It is also known as MS
 Ctrl + Z – Undo the last action
Word.
CUSTOMIZING A WORD DOCUMENT
FEATURES
 Home Tab – allows you to change document
 AutoCorrect – corrects common spelling errors settings, such as the font properties, adding
as well as capitalization mistakes. bullets or a numbered list, adjusting styles, and
 AutoFormat – applies formatting to text, e.g. other common features.
number listing, bullet, hyperlinks  Text Alignment – Left, Center, Right, Justified.
 Grammar Checker – proofreads documents for  Page Layout Tab – refers to the arrangement of
grammar, writing style, sentence structure errors text, images, and other objects on a page.
 Page Sizes – Short (letter) – 8.5” by 11” –
and reading statistics.
Long (Folio) – 8.5” by 13” – A4 – 8.27 by
 Template – a document that contains the 11.69”
formatting necessary for a specific document  Page Orientation – Portrait and Landscape
type.
 Thesaurus – provides synonyms for a word in a Image Placement – This is the default setting
document for images that are inserted or integrated in a
document.
 Tables – organize information into rows and
Square – This setting allows the image you
columns inserted to be placed anywhere within the
 Mail Merge – a feature that allows you to create paragraph with the text going around the image
a document and merge them with another in a square pattern like a frame.
document or data file. Tight – This is almost the same as the square
 Text Wrap – adjusts how the image behaves setting, but here the text “hugs” to the general
shape of the image.
around other objects or text.
Through – This setting allows the text on your
document to flow even tighter, taking the
KEYBOARD SHORTCUTS
contour and shape of the image.
Top and Bottom – This setting pushes the text
 Ctrl + A – Select All
away vertically to the top and/or the bottom of
 Ctrl + B – Bold Text
 the image so that the image occupies a whole  Design Template – pre-designed graphic styles
text line on its own. that you can apply to your slides.
Behind Text – This allows your image to be  Slides Show – a collection of pages arranged in
dragged and placed anywhere on your document sequence that contain text and images for
but with all text floating in front of it. presenting to an audience.
In Front of Text – This setting allows your  Press “F5” – to display slide show
image to be placed right on top of the text as if  Press Shift + F5 – to this play the current slide
your image was dropped right on it. (e.g. 4th slide)
 Animation – is a set of effects which can be
DEFAULT applied to text or graphics within a slide.
 Transition – are motion effects that when in
 Font – Calibri Slide Show view add movement to your slides
 Font Size – 11 as you advance from one slide to another.
 Color – Black  Hyperlink – allows you to jump to another
 Alignment – Left location.
 Column – One
 Size – Short(Letter) 8.5 by 11 TYPES OF VIEWS
 Orientation – Portrait
 Margin – Normal  Normal View – simplified layout of the page so
you can quickly key, edit, and format the test.
 Notes Page View – displays your slides on the
top portion of the page, with the speaker notes
ADVANCED PRESENTATION SKILLS for each slide in the notes pan on the bottom of
the pane.
 Presentation Software – is an application  Outline View – displays all of the text in a
software that allows user to create visual aids for PowerPoint slide show in outline form
presentations to communicate ideas, messages regardless of the design, objects and animation.
and other info.
FILE INSERTION
EXAMPLES OF PRESENTATION SOFTWARE
 File Insertion: Image, Illustrations, Links, Text
 MagicPoint & Media.
 [Link] Impress  Image Insertion: Click the insert tab then
 LibreOffice Impress choose among the following: Picture, Online
 Powerdot Pictures, Screenshot & Photo Album.
 Microsoft Powerpoint  Inserting an illustration: Click the insert tab
then choose among the following: Shapes,
SmartArt & Chart.
 Inserting a Link: Click the Insert Tab then
choose among the following: Link & Action.
 Microsoft Powerpoint –is a presentation
 Inserting a Symbols: Click the Insert Tab then
program, created by Robert Gaskins and Dennis
choose among the following: Equation &
Austin at a software company named
Symbol.
Forethought, Inc. It was released on April 20,
 Inserting a Media (Audio/Video): Click the
1987, initially for Macintosh computers only.
insert tab then choose between the following:
Microsoft acquired PowerPoint for $14 million
Video, Audio & Screen Recording.
three months after it appeared.
TIPS IN CREATING AN EFFECTIVE
KEY TERMS PRESENTATION

 Slide – is a single page of a presentation.  Minimize

Collectively, a group of slides may be known as  Clarity
a slide deck.  Simplicity
 Visuals
  Consistency  =x+y – returns the sum of x and y
 Contrast  =x*y – returns the product of x and y
 =x/y – returns the quotient of x divided by y
ADVANCE SPREADSHEET SKILLS
OTHER FUNCTIONS
 Spreadsheet Software – allows users to
organize data in rows and columns and perform  =ABS(x) – returns the absolute value of x
calculations on the data. These rows and  =AVERAGE(x,y) – returns the average of x and
columns collectively are called worksheet. y
 =CONCATENATE(x,y) – joins x and y
EXAMPLES OF SPREADSHEET SOFTWARE:  =IF(Condition,x,y) – returns x if the condition
is true, else it returns y
 LibreOffice Calc  =ISEVEN(x) – returns true if x as an even
 [Link] Calc number
 Google Sheets  =ISODD(x) – returns true if x is an odd number
 Apple iWork Numbers  =COUNT(range) – counts the number of cell
 Kingsoft Office Spreadsheets containing a number within a range
 StarOffice Calc  =COUNTIF(range,criteria) – count the
 Microsoft Excel number of cell that fits with the criteria within
the range
 =ISNUMBER(x) – returns true if x is a number
 =ISTEXT(x) – returns true if x is a text
 Microsoft Excel – is a spreadsheet developed by  =LEN(x) – returns the length of characters in x
Microsoft for Windows, macOS, Android and  =PROPER(x) – returns the proper casing of x
IOS. It features calculation, graphing tools, pivot  =LEFT(x,y) – returns the characters of x
tables, and a macro programming language specified by y (from the left)
called Visual Basic for Applications.  =RIGHT(x,y) – returns the characters of x
specified by y (from the right)
 =PI() – returns the value of pi
KEY TERMS  =MIN(x,y) – returns the smallest number
between x and y
 Active Cell – the selected cell  =MAX(x,y) – returns the largest number
 Column Heading – the box at the top of each between x and y
column containing a letter.  =MIN(range) – returns the smallest number
 Row Heading – the row number within the range
 Cell Reference – the cell address of the cell  =MAX(range) – returns the largest number
usually combine letter and number (ex. within the range
A1,B4,C2)  =POWER(x,y) – returns the value of x raised to
 Merge – combining or joining two or more the power of y
cells.  =ROUND(x,y) – rounds x to a specified number
 Functions – are predefined formulas and are of digits (y)
already available in Excel  =COLUMN(x) – returns the column number of
 Formula Bar – the bar that displays the contents x
of a cell.  =ROW(x) – returns the row number of x
 =SQRT(x) – returns the square root of x
FUNCTIONS – BASIC MATH OPERATION  =TRIM(x) – removes extra spaces in x
 =UPPER(x) – returns x in all capital form
 =SUM(x,y) or =SUM(range) – returns the sum  =LOWER(x) – returns x in non-capital form
of x and y or (all the numbers within the range)  =TODAY() – returns the current date
 =PRODUCT(x,y) – returns the product of x and  =NOW() – returns the current date and time
y Workbook – collection of single-page
 =QUOTIENT(x,y) – returns the quotient of x spreadsheets (2 or many sheets)
divided by y Worksheet – is a standalone workbook (one)
 =x-y – returns the difference of x subtracted by y