Computer Examination Preparation Guide: Windows, Word, Excel, and PowerPoint

Image


COMPUTER EXAMINATION PREPARATION GUIDE


WINDOWS
What is Windows and its features?
Windows: A family of graphical operating systems developed by the company Microsoft.
Features
Multitasking, multiuser operating system supports more than 255 graphic characters automatically adapts to the system in which failures are installing controls efficiently supports plug and play technology.


What is Windows Explorer? Operating System indispensable tool with them to organize and control the files and folders from different storage system, such as the hard disk, CD, etc.administrador files.


What is Recycle Bin and to serve: A hard disk space reserved to store the deleted information, so that in case of removing a file or folder by mistake be able to retrieve it.

WORD
Word Definition and characteristics

Definition: Microsoft Word is a word that lets you do many more things than in a normal word processor http://www.monografias.com/trabajos5/sisope/sisope.shtml>.
Characteristics: In the text we do http://www.monografias.com/trabajos13/libapren/libapren.shtml> decorated with the Word Art tool, can do simple tables, complicated or until the computer http://www .monografias.com/trabajos15/computadoras/computadoras.shtml> make difficult calculations for one, and some things that word processors http://www.monografias.com/trabajos15/historia-computador/historia-computador.shtml> can also cartazes tasks such as simple text.


Format Menu Options
The following bar displayed is the bar format as the name suggests allows you to format text http://www.monografias.com/trabajos13/libapren/libapren.shtml>. We can choose font, color, letter shape, center, justify subrallar, highlight text
Image


Objectives and what they formats; Font, Paragraph, Alignments, Columns, Tables, Text Boxes,
Source: Used to select font type and size (you can fuenteAdemás effects and animations as N Bold, K italics, borders, lights, etc..
Paragraph: (http://www.monografias.com/trabajos13/libapren/libapren.shtml> text alignment, line spacing, indentation, etc.).
Lineups: Using the alignments, configure how you want to sort the text of a paragraph on the left side and the right margin of the document. Left alignment Example: Microsoft Word assumes by default this alignment. In this case, all lines of a paragraph in accordance with the left margin of the page, or not being able to get the right margin. Alignment centered: Microsoft Word 2007 set an imaginary line halfway between the left and right margin. The text of each line in the paragraph is distributed evenly to the left and right of this imaginary line.Alignment justified: this type of alignment introduces the space needed for all lines of paragraph conform perfectly to the left and right margin of the document, except the last line of the paragraph which makes a left alignment.

Columns: used to sort the information

Tables: Tables allow http://www.monografias.com/trabajos7/sisinf/sisinf.shtml> organize information into rows and columns, so you can perform operations and treatments on the rows and columns. For example, obtaining the average value of the data http://www.monografias.com/trabajos11/basda/basda.shtml> a column or to sort a list of names.

Text Box: This option is useful for example when the drawing in Word and want to add text somewhere in the drawing or near http://www.monografias.com/trabajos13/histarte/histarte.shtml> because if you want to do with the cursor in Word in the usual way, is complicated because the area of the design does not allow entry to write.
Header and Footer, Insert, Page Number: This option belongs to “see” is used to add a legend http://ads.us.e-planning.net/ei/3/29e9/cfa010f10016a577?rnd=0.16684726984891884 ac3a026c1446c795 & pb = & fi = & kw = d46ac648e71e5a40 legend> at the top (top margin) of the sheet named header and another at the bottom (bottom margin) called footer.
Both legends http://www.monografias.com/trabajos15/leyendas-coloniales/leyendas-coloniales.shtml> appear on all sheets of paper and can be seen when we activate the “Print Preview”
Insert number of page: If you want the page numbers appear in our paper when we print it to insert from the Insert tab, displaying the page number option and choosing where we want to display the number.

Features of the Tables, as defined: we can sort data or information in columns, rows or cells

Definition: the ability to order data by columns, rows or cells are located in the insert menu

Elements Bar Format: source include, paragraph, numbering and bullet, border and shading, columns, background, theme, etc. framework.


Word provides tools that: provides spelling and grammar, language, auto sum, count words, macro and more.

Paragraphs can be aligned left, center, right and justified. To get the cursor anywhere in the paragraph and click Image , Image , Image and Image . You can also set the alignment with the Format menu and click Paragraph.

Format / Paragraph (Display) you can choose various display options paragraphs.

EXCEL
Definition of Excel and its features (book and spreadsheets)
Excel is a program used to makehttp://www.monografias.com/trabajos15/lotus-excell/lotus-excell.shtml> spreadsheets and that can take much advantage, because not only is to make leaves, but to calculate, convert, express , graphing and much more.
· The main features of Excel are:
· Is a spreadsheet http://www.monografias.com/trabajos7/caes/caes.shtml>
· Can do lengthy calculations
· Has limitations incredibly small
• A table is not a challenge even Excel
· Templates and very explicit examples

  • Fill and cell formatting

Format Menu Options

Definition; cell, column and row, as are routed

Cell:

Intersection of a column and a row is identified with the column name to which it belongs and the number of its row.

Column: A group of selected cells vertically, are named by letters A to Z.

Rank: set of selected cells horizontally, numbered from 1 to 65536.

Formulas and Functions, similarities and differences, as used

Formulas should appear in the formula bar and always preceded by the sign =. They contain a mathematical operation. Are used to relate constant values and extract results.

Features: A special type of formulas that are predefined by Excel.


The formulas are just as or more useful functions because the computer does not know what a company http://www.monografias.com/trabajos11/empre/empre.shtml>, business, or you will face
The formulas can “replace” the functions, for example:
Instead of = average (a1: a3) can put = a1 + a2 + a3 / 3, clear that the functions are more useful than the formulas, but seeing it from another point of view, it is useful


Excel provides tools that
Microsoft Excel Tools
The basic tools of Microsoft Word much as those of Microsoft Excel are the same as those of copy, paste, cut, highlight and type of font size, these are included on page 4 and 5 only show the new Excel.
Image
http://www.monografias.com/trabajos7/mafu/mafu.shtml> Bar Functions: This is one of the main things Excel for being so efficient and showing all formulas, formulas and functions are going see below.
Image AutoSum: The AutoSum I used to add 2 or more cells that contain numbers and obviously gives the result in another cell
Image Ascending order: This button is for the text in a cell instead of text go in order from left to right, go up and down
Image http://www.monografias.com/trabajos11/estadi/estadi.shtml> Graphics: This button is to insert a graph in the spreadsheet http://www.monografias.com/trabajos16/sepa-excel/ know-excel.shtml>, there are many types of graphics, but that we will see later.
Image Format Painter: Copies the formatting of a cell that was selected, ashttp://www.monografias.com/trabajos16/marx-y-dinero/marx-y-dinero.shtml> money, http://www.monografias.com/Administracion_y_Finanzas/Contabilidad/> accounting, etc..
Image Styles: These are the styles, serve to identify which type of currency, percentages or decimals wants one. The first is for money, just put a number and deselect the cell appears http://www.monografias.com/trabajos5/selpe/selpe.shtml> the dollar sign and .00, the following is percentage , does the same just not put a dollar sign but of percentages, and the last is to appear next to the decimal number
Image Add or decrease decimals: These buttons are used to decrease or increase decimal numbers with many decimal
Image Merge Cells: This button is very useful, is to join 2 or more cells and mainly serves to hold

POWER POINT
Definition of PowerPoint and its features
Power Point:
It is a program specifically for graphic http://www.monografias.com/Computacion/Programacion/> creating effective business presentations http://www.monografias.com/trabajos15/plan-negocio/plan-negocio.shtml> and versatile by combining text, images, colors http://www.monografias.com/trabajos5/colarq/colarq.shtml> forms, drawings http://www.monografias.com/trabajos13/histarte/histarte. shtml>, animation effects and sounds.
What is Presentation?
Is an ordered sequence of slides that let you expose synthetic and structured manner, the essential points, or aims of a particular project http://www.monografias.com/trabajos12/pmbok/pmbok.shtml>.
What is Slide?:
These are images that are displayed sequentially on the screen and are the basic element of a presentation. Each slide can contain text, graphics, drawings, clip art, animations, sounds and graphics created by other programs http://www.monografias.com/Computacion/Programacion/>.
Steps to start Power Point:
To start a session with Power Point 2000 perform the following steps:
Display the Start menu on the Taskbar, select Programs, and then clip in Microsoft PowerPoint http://www.monografias.com/trabajos13/quienbill/quienbill.shtml>.

Tools and options provide Power Point
http://www.monografias.com/trabajos11/contrest/contrest.shtml> Toolbar:
This tab displays a sub menu which contains all options and settings that you can make to the toolbars. In this sub menu options appear art such as:
· Standard: Demonstrates the basic tools used in the program http://www.monografias.com/Computacion/Programacion/>, such as save, print, open, new, zoom, etc..
· Format: sample tools to use on everything related to the selected text as font types, font sizes, font options (bold, underline, italics), options in paragraphs (justified, centered, aligned right, left aligned.) etc..
· Control Toolbox: displays the tools to be used on check boxes, command buttons, option buttons, buttons
alternator, among others. It even has options to view the properties, the code and insert http://www.monografias.com/trabajos12/eticaplic/eticaplic.shtml> other subprogrammes.
· Animation effects: outlines the types of tools you have to create and configure animations.
· http://www.monografias.com/trabajos7/imco/imco.shtml> Image: give us all the options you can use an image of the presentation.
· Review: shows the options to insert comments, hide or show up comments, create an Outlook task, mail recipient.
· Common tasks: it gives us options to re-create http://www.monografias.com/trabajos35/el-poder/el-poder.shtml> another slide or apply a design to the slide.
· Visual Basic http://www.monografias.com/trabajos10/visual/visual.shtml>: Contains the options to create or change a program in Visual Basic http://www.monografias.com/trabajos10/visual/ visual.shtml> in the presentation.
· Wep: Appears all about having to do with Internet pages.
· Word http://www.monografias.com/trabajos12/guiaword/guiaword.shtml> Art: There are tools to use to create and edit text with different styles.
Customize: By giving you click a window like this.
This window contains 3 tabs:
· Toolbar: Here are the options that you can use clip art.
· http://www.monografias.com/trabajos7/coman/coman.shtml> Commands: This has the possibility of placing all existing commands individually.
· Options: Contains other alternatives that can be applied to tasks such as bars, large icons, menu animation and more.
Rule: Toggle display of measurement guidelines http://www.monografias.com/trabajos15/la-estadistica/la-estadistica.shtml> both horizontally and vertically.
Guide: Sample dotted lines do not appear on the display, dividing the page width as well as long as it helps to locate the center of the slide.
Header and Footer: This window contains all options related to creating and modifying headers and footers.
Comments: Show or hide the comments are in the presentation.
Zoom: With options for adjusting the size of the view in the presentation.