Midterm 1st Sem Exam Etech Reviewer

PRODUCTIVITY TOOLS

Tools also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more

WORD PROCESSOR

is an electronic device or computer software application

MICROSOFT WORD

is a word processor developed by Microsoft.

OCTOBER 25, 1983

microsoft word was first released on?

AUTO CORRECT

corrects common spelling errors as well as capitalization mistakes

AUTO FORMAT

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

GRAMMAR CHECKER

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

TEMPLATE

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

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

TEXT WRAP

adjusts how the image behaves around other objects or text

Ctrl + A

select all

Ctrl + B

bold text

Ctrl + C

Copy text

Ctrl + D

Show Font Dialog Box

Ctrl + E

Align Text to Center

Ctrl + F

Display Find Dialog Box

Ctrl + G

Display Go To Dialog 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 Left

Ctrl + M

Indent the paragraph/Tab

Ctrl + N

Create a new document

Ctrl + O

open a document

Ctrl + P

Display Print dialog box

Ctrl + R

Align Text to Right

Ctrl + S

save a document

Ctrl + U

underline 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

HOME TAB

allows you to change document settings, such as the font properties, adding bullets 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.

8.5” by 11”

Short (Letter)

8.5" by 13"

Long (Folio)

8.27" by 11.69"

A4

IMAGE PLACEMENT

This is the default setting for images that are inserted or integrated in a document.

TIGHT

almost the same as the square setting, but here the text "hugs" to the general shape of the image.

THROUGH

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

TOP AND BOTTOM

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

BEHIND TEXT

this allows your image to be dragged and placed anywhere on your document but with all the texts floating in front of it

IN FRONT OF TEXT

this setting allows your image to be placed right on top of the text as if your image was dropped right on it

STYLE

is a predefined combination of font style, color, and size that can be applied to any text in your document.

SMARTART

allows you to communicate information with graphics instead of just using text.

PICTURES

these are electronic, "soft copy", or digital pictures you have saved in any local storage device.

JPG (JOINT PHOTOGRAPHIC EXPERTS GROUP)

This type of image file can support 16.7 million colors. Suitable for use when working with full color photographic images

GIF (GRAPHICS INTERCHANGE FORMAT)

This type of image file is capable of displaying transparencies and animation. It only supports Only supports 256 colors

PNG (PORTABLE NETWORK GRAPHICS)

It is capable of displaying transparencies but not animation. It supports only 16 million colors.

CLIPART

This is generally a GIF type; line art drawings or images used as generic representation for ideas and objects that you might want to integrate in your document.

SHAPES

These are printable objects or materials that you can integrate in your document to enhance its appearance or to allow you to have some tools to use for composing and representing ideas or messages.

SMARTART

These are predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature.

CHART

Allows you to represent data characteristics and trends.

SCREENSHOTS

Sometimes, creating reports or manuals for training or procedure will require the integration of a more realistic image of what you are discussing on your report or manual.

PRESENTATION SOFTWARE

is an application software that allows users to create visual aids for presentations to communicate ideas, messages and other info.

MICROSOFT POWERPOINT

is a presentation program, created by Robert Gaskins and Dennis Austin at a software company named Forethought, Inc. It was released on April 20, 1987, initially for Macintosh computers only.

ROBERT GASKINS AND DENNIS AUSTIN

Who created MS PowerPoint?

APRIL 20, 1987

When was MS Powerpoint released?

SLIDE

is a single page of a presentation.

SLIDE DECK

a group of slides

DESIGN TEMPLATE

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

SLIDE SHOW

a collection of pages arranged in sequence that contain text and images for presenting to an audience.

ANIMATION

is a set of effects which can be applied to text or graphics within a slide.

TRANSITION

are motion effects that when in Slide Show view add movement to your slides as you advance from one slide to another.

HYPERLINK

allows you to jump to another location.

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 for each slide in the notes pane on the bottom of the pane.

OUTLINE VIEW

displays all of the text in a PowerPoint slide show in outline form regardless of the design, objects and animations.

ENTRANCE

These controls how the object enters the slide.

EMPHASIS

These animations occur while the object is on the slide, often triggered by a mouse click.

EXIT

These controls how the object exits the slide.

MOTION PATHS

These are similar to Emphasis effects, except the object moves within the slide along a predetermined path, like a circle.

HYPERLINK

(also known as links) to navigate from one webpage to another.

MICROSOFT EXCEL

is a spreadsheet application. It uses grids of cells within columns and rows to manipulate, organize, and perform calculations with data.

WORKBOOK

is what you actually use when you open Excel. it also contains the spreadsheets.

CELL

are made up of rectangular blocks. It contains the data you enter; from numbers to words to images to formulas, cells hold that information.

COLUMNS

run left to right along the top of the Worksheet/Tab and are labelled according to the alphabet.

COLUMNS

a vertical series of cells

ROWS

are labelled along the left side of the Worksheet/Tab numerically and run down from top to bottom.

ROWS

a horizontal series of cells.

WORKSHEETS/TABS

are made up of Columns, Rows and Cells and are essentially pages of your Excel workbook.

CHARTS AND GRAPHS

can be really useful to visualize data and give a clearer picture of what the data can tell you.

FORMULA

is an expression that operates on values in a range of cells or a cell.

FUNCTIONS

are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names.

VLOOKUP

is an Excel function to look up data in a table organized

vertically.

SUMIF FUNCTION

sum the values in a range that meet criteria that you specify.

SYNTAX

a function must be written a specific way, which is called the?

ARGUMENTS

refer to both individual cells and cell ranges and must be enclosed within parentheses.

SUM

This function adds all of the values of the cells in the argument.

AVERAGE

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.

COUNT

This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.

MAX

This function determines the highest cell value included in the argument.

MIN

This function determines the lowest cell value included in the argument.

INSERT FUNCTION

allows you to search for functions

QUICK ACCESS TOOLBAR

lets you access common commands

RIBBON

contains all of the commands you'll need