EMTECH: MS WORD-MS PPT

microsoft word

• A word processor developed by Microsoft. 

• First released on October 25, 1983.

• Also known as MS Word

• Press “Windows Logo” + R, then type “winword”, then enter

autocorrect

corrects common spelling errors as well as capitalization mistakes

autoformat

1. applies formatting to text, e.g., number listing, bullet, hyperlinks

grammar check

1. proofreads documents for grammar, writing style, sentence structure errors, and reading statistics

template

1. a document that contains the formatting necessary for a specific document type

thesaurus

provides synonyms for a word in a document

tables

organize information into rows and columns

mail merge

1. a feature that allows you to create a document and merge it with another document or data file

text wrap

1. adjusts how the image behaves around other objects or text

1. autocorrevt

2. autoformat

3. grammar check

4. template

5. thesaurus

6. tables

7. mail merge

8. text wrap

MS Word features:

Ctrl + A

sellect all

Ctrl + B

bold text

Ctrl + C

copy text

Ctrl + D

show font dialog box

Ctrl + E

align text to the center

Ctrl + F

display find box

Ctrl + G

display go to dialogu box

Ctrl + H

display replace dialog box

Ctrl + I

italicize text

Ctrl + J

justify text

Ctrl + K

create a hyperlink

Ctrl + L

align text to the left

Ctrl + M

tab

Ctrl + N

create a new document

Ctrl + O

open a document

Ctrl + P

display print box

Ctrl + R

alighn text to the right

Ctrl + S

save a document

Ctrl + U

underline a text

Ctrl + V

paste a copied text

Ctrl + X

cut a selected text

Ctrl + Y

redo the last undone action

Ctrl + Z

undo the last action

• Ctrl + A

• Ctrl + B

• Ctrl + C

• Ctrl + D

• Ctrl + E

• Ctrl + F

• Ctrl + G

• Ctrl + H

• Ctrl + I

• Ctrl + J

• Ctrl + K

• Ctrl + L

• Ctrl + M

• Ctrl + N

• Ctrl + O

• Ctrl + P

• Ctrl + R

• Ctrl + S

• Ctrl + U

• Ctrl + V

• Ctrl + X

• Ctrl + Y

• Ctrl + Z

MS Word Shortcuts

home tab

• allows you to change document settings, such as the font properties, add a bullet or a numbered list, adjust styles, and other common features

text alignment

•  left, center, right, justified

page layout tab

refers to the arrangement of text, images, and other objects on a page

page sizes

• Short (letter) - 8.5” by 11”

• Long (folio) - 8.5” by 13

• A4 - 8.27” by 11.69

page orientation

• Portrait 

• Landscape

image placement

• the default setting for images that are inserted or integrated in a document

square

• allows the image you inserted to be placed anywhere within the paragraph with the text going around the image in a square pattern like a frame

tight

• is almost the same as the square setting, but here the text “hugs” to the general shape of the image

through

• allows the text on your document to flow even tighter, taking the contour and shape of the image

tap and bottom

• pushes the text away vertically to top and/or the bottom of the image so that the image occupies a whole text line on its own

behind text

• allows your image to be dragged and places anywhere on your document but with all text floating in front of it

in front of text

• allows your image to be placed right on top of the text as if your image were dropped right on it. 

spreadsheet software

allows users to organize data in rows and columns and perform calculations on the data. These rows and columns collectively are called a worksheet.

microsoft excel

• Developed by Microsoft for Windows, macOS, Android, and iOS. 

• Features calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications

row

• horizontal line

column

vertical line

cell

• the place where info is held in a spreadsheet

active cell

• the selected cell

column heading

• the box at the top of each column containing a letter 

row heading

the row number

cell reference

• the cell address of the cell usually combines a letter and a number (ex., A1, B4, C2)

merge

• combining or joining two or more cells

functions

predefined formulas are already available in Excel

formula bar

• the bar that displays the contents of the cell

• row

• column

• cell

• active cell

• column heading

• row heading

• cell reference

• merge

• functions

• formula bar

Key terms in MS Excel

=SUM(X,Y) or =SUM(range)

• returns the sum of x and y or all the number within the range

=PRODUCT(x,y)

• return the product of x and y

=QUOTIENT(x,y)

returns the quotient of x divided by y

=x-y

• returns the difference of x subtracted by y

=x+y

• returns the sum of x and y

=x*y

• return the product of x and y

=x/y

• returns the quotient of x divided by y

=SUM(x,y)

=PRODUCT(x,y)

=QUOTIENT(x,y)

=x-y

=x+y

=x*y

=x/y

Basic Math operations

=ABS(x)

• returns the absolute value of x

=AVERAGE(x)

• returns the average of x and y

=CONCATENATE(x,y)

• joins x and y

=IF(Condition, x,y)

• - returns x if the condition is true, else it returns y

=ISEVEN(x)

• returns true if x is an even number

=ISODD(x)

• returns true if x is an odd number

=COUNT(range)

• counts the number of cell containing a number within a range

=COUNTIF(range, criteria)

• count the number of cell that fits the criteria within the range

=ISNUMBER(x)

• returns true if x is a number

=ISTEXT(x)

• returns true if x is a text

=LEN(x)

• returns the length of characters in x

=PROPER(x)

• returns the proper casing of x

=LEFT(x,y)

• returns the characters of x specified by y (from the left)

=RIGHT(x,y)

• returns the characters of x specified by y (from the right)

=PI()

• returns the value of pi

=MIN(x,y)

• returns the smallest number between x and y

=MAX(x,y)

• returns the largest number between x and y

=MIN(range)

• returns the smallest  number within the range

=MAX(range)

• returns the largest number within the range

=POWER(x,y)

• returns the value of x raised to the power of y.

=ROUND(x,y)

• rounds x to a specified number of digits (y)

=COLUMN(x)

• returns the column number of x

=ROW(x)

• returns the row number x

=SQRT(x)

• returns the square root x

=TRIM(x)

• removes extra spaces in x

=UPPER(x)

• returns x in all capital form

=LOWER(x)

• returns x in non-capital form

=TODAY()

• returns the current date

=NOW()

• returns the current date and time

presentation software

allows users to create visual aids for presentations to communicate ideas, messages, and other info.

microsoft powerpoint

• Created by Robert Gaskins and Dennis Austin at a software company named Forethought, Inc.

• Released on April 20, 1987, initially for Macintosh computers only

• Microsoft acquired PowerPoint for $14 million three months after it appeared.

slide

• a single page of a presentation. Collectively, a group of slides may be known as a slide deck.

design template

• pre-designed graphic styles that you can apply to your slides