Closet Organizer Slanted Wall

electronic notebook

David Holland Martínez

8 º 04

TECHNOLOGY E INFORMATICA

Héctor Cuartas

Professor

SAN LUIS GONZAGA EDUCATIONAL INSTITUTION

SECTION 1

Santafe de Antioquia

2010

ELEMENTS OF EXCEL

• Excel Operations
• Formulas and Functions in Excel
• Excel Charts
• Layout view in Excel
• Tables in Excel
• function of the elements of the toolbars
• pie charts and bar graphs in Excel
• Data Tables

OPERATIONS IN EXCEL

ADD

directory To add multiple numbers:

selected a cell and begin typing the equal sign "= " to indicate the program is a mathematical operation.

• Sumamos using the +
• We press Enter or confirm . Be sure to press Enter or confirm before changing cell.

MULTIPLY, DIVIDE AND POWERS

· Multiply . We can multiply using the sign * . For example to multiply two by two wrote in a cell = 2 * 2 and press Enter on the keyboard.

· Divide. divide the symbol /. For example if we divide 4 by 2 write in a cell = 4 / 2 and press Enter .

· Powers . Raise a number to a power is to multiply that number by itself a number of times. For example, two to the four equals 2 * 2 * 2 * 2, resulting in 16. To raise a number to a number to a certain power we can use the symbol ^ . For example, 2 raised to 4 we write in a cell = 2 ^ 4. Pressing Enter in the cell is the result of 16.

THE ORDER IN WHICH THEY ARE PERFORMED mathematical operations

In mathematics, the order of operations can affect the outcome.

Excel program calculates in a certain order:

• First the operations in parentheses.
• powers
• Multiplication and division
• Addition and subtraction
• Etc.

EXCEL FORMULAS AND FUNCTIONS OF

A function is a predefined formula for Excel operating with one or more values \u200b\u200band returns a result that appear directly in the cell or be used to calculate the formula contains it.

A function like any information you can write directly to the cell if you know its syntax, but Excel has a help or assistance in using, so it was easier to work with them. The syntax of any function is:

Name - Role - (Argument 1, Argument 2, ..., Plot N)

If we introduce a function is a cell:

• Situate in the cell where you want to enter the function.
• Click the Formulas tab .
• Choose the option Insert Function .
• Or, click on the button (fx) in the formula bar.

Excel 2007 allows find the function we need writing a short description function needed in the box Find a function: and then click on the button (Go), so it is not necessary to know each of the functions and features that Excel will show in the list box Select a function: functions must do with the written description.

For the list of functions can not be as extensive pre-select a category from the combo box Or select a category: this will make in the list box to show only the functions of the chosen category and thus reduce the list. If we're not sure we can choose the category All .

list box Select a function: have to choose the function you want by clicking on it.

Notice how as we select a function, at the bottom appear to us the various arguments and a brief description thereof. We also have a link Help on this function for a fuller description of that function.

A final click on the OK button .

CHARTS IN EXCEL

Microsoft Excel supports many types of charts to help you display data to the most significant hearing . When using the Wizard graphics to create a chart, or graph type command to modify an existing chart, you can easily select the type of chart you want from a list of types of standard or custom graphics.

Each standard chart type has several subtypes. For a preview of a chart, select any chart subtype, and then click to see sample Press. For more information on the standard chart types and their use, click on any of the following rates or at all.

E l Chart Wizard is one of the most attractive features of Excel. With it you can easily create various kinds of graphs based on data from your spreadsheet. The wizard guides you step by step, to make your numbers in an attractive and colorful graphics.

The most common terms used in the graphs are:

· Rows : refers to the way you see the graph, if elected as the graph lines appear horizontally.

· Columns: refers to the way you see the graph, choosing as columns appear on the chart vertically.

· Bar is a type of graph type or horizontal rows.

· Data Range: refers to the set of values \u200b\u200bor data that constitute the graph, which is usually a set of cells.

· Series: the data sets are in rows or columns that have values \u200b\u200bfor the same item or category Therefore, if more than one series should be named by placing a meaningful name to represent values \u200b\u200bin the graph.

· Legend: the series or series that were shown in the chart, or otherwise is a table that can be placed up, down, left or right of the chart plot area, it will represent each of the items or categories of values \u200b\u200bplotted.

· Plot Area: the plot area of \u200b\u200ba graph is the infield of the graph where objects are displayed or figures representing the values \u200b\u200bthat were chosen for plotting.

VIEW DIAGRAMS IN EXCEL

A schema can be defined as an accurate summary reflecting the most important concepts or higher relevance of the document outlined.

Thus, a scheme may well be an index of a book, where we see all the points raised in the book, we can see an example of the rate schedule of this course, which contains the most important points try it and it is structured by levels of depth on a topic specifically, we deploy the schema of the points contained in the subject.

The best option to create schemes is that it does Excel automatically, since it takes much less time than doing it manually.

There are some prerequisites for Excel2003 can automatically create the schema:

- The summary row should be above or below the data, never mixed.

- The summary columns must be to the right or left of the data, never mixed.

If the available data does not correspond with these features we will have to define the schema manually,

We can see that there are subtotals in cells B6, C6, D6, B11, C11, D11, B20, C20, D20 and column E is filled subtotals rows where found. In cells B21, C21, D21 and E21 are totals of the subtotals.

In this example we can make a sketch of both rows and columns, has been organized since the subtotals of each region (rows) and calculated the subtotals for each quarter (columns).

Therefore, as we already have the data we will make the outline.

To do this we stand on any cell and access the menu data - Group and Outline, and select the option self schema.

to compress and expand the scheme only have to click on the symbols - and + on each level.

For example, in the example table, clicking on the - over the first quarter, compress that quarter, if we do the same on each level of autonomy, the scheme would remain as we can see in the image .