Forum pracy nad projektem wskrzeszenia The Forge

[fasfsdas]

L
1, editing skills -
-
-
-
(2) matrix of the basic calculations -
5) error value: # N / A -
-
(2) add description text in the input digital data to be automatically added after the text, using a custom format: \content. \@ Symbol on the position of the Excel input data relative to the number of added text. -
Sometimes we need to delete Excel workbook in the blank line, the general practice is to identify one by one blank line, then remove. If the number of rows in the table a lot of work, this is very inconvenient. We can use the \Approach: first in the table insert a new blank line, then press Ctrl + A keys to select the entire worksheet, right-click \Then in the top of each column, are a drop-down list box, in a typical drop-down list box, select the column \-
-
-
-
-
Excel offers 14 standard chart types, each with a variety of combinations and transformations. Among the many chart types, select a chart that better? According to the data and the use of the different requirements of the different, you can choose different types of charts. The choice of the chart with the data in the form of relevant, then we consider the effectiveness and sense of aesthetics. Here are some common rules. -
-
(5) multiple sheets, enter the same content -
; ; 9. Batch Remove blank lines -
-
If you enter = if (A2 <60, \level. -
select a cell, hold down the Ctrl key, right click the other cells, these cells will be all selected. Enter data in the edit area, then hold down the Ctrl key while you tap Enter, in all the selected cells have emerged in the data. -
1. editing skills -
-
Meaning: Enter the data into a cell or cell formula is too long the result is too large, so that the results show no less than in the cell. Date and time format, or the cell subtraction, there has been negative. -
; ; 6. Since defined functions -
a cell is a variable, a unit can also be seen as a set of domain variables. For convenience of calculation, a set of variables to an array of the best names. For example, A = {A1: C3}, B = {E1: G3} and so on. Step is to set the name of the array: an array of field selected, click \Simpler approach to naming: Choose an array of fields, click the Name box, type the name directly on the line. -
-
-
* frequently or repeatedly enter some fixed content, such as a good format for exclusive business address, personnel lists, etc.; -
-
-
-
Figure 3 Figure 4 -
-
-
If you want to join in the workbook beautiful horizontal stripes, can use the alignment of the filled function. First filled in a cell of \\-
-
5, drawing FUNCTIONS -
-
solution: Cancel the space between two ranges. The above equation can be changed \
-
If the direct input \-
-
-
-
Figure 8 -
-
-
; ; 11. macro use -
-
-
-
(1) fraction of the input -
* create a formatted table; -
-
1) error values :#### -
-
to draw the y = | lg (6 + x ^ 3) | of the curve, for example, the method is as follows: in a blank worksheet, enter the function arguments: A column in the cell A1 type \X = \value, given the number of variables and the number from the step between, and then select the two cells A2 and A3, so that the two into a rectangle with a black border, and then point to the lower right corner of the black rectangles small box \-

12, the chart application skills -
-
-
Figure 1 -
(7) to display the formula in cell -
-

-
Although already a large number of built-in Excel function, but sometimes may also encounter some computational functions can be used without the case. If a company uses a special mathematical formula products, discount buyers, if there is a function to calculate how much more convenient? Said the following about how to create such a custom function. -
-
then close the editor, as long as we enter in the appropriate column rrr (F2, B2), then the amount of money even after the kick off out (Figure 10). -
-
(9) quickly remove the contents of the cell -
-
9, bulk delete blank lines -
-
-
(2) Select the columns to input Chinese characters in the \button. Thus, when the cursor is the first one, you can write in English, the next column, you can directly enter the Chinese and English in order to achieve the automatic switching between input methods. -
Note: How to determine the initial value of the independent variables,[link widoczny dla zalogowanych], the step between data points is the number, this is according to the specific characteristics to determine the function, which is the ability of users to test. If you want to quickly find the function of the extreme or see its development trend, given the data point does not necessarily have to be arithmetic, can be arbitrarily given. -
; ; 2. unit merge cell contents -
-
-
bar: horizontal bar formed by the series. Makes a point on the timeline, two or more items of relatively comparable size. For example: it can compare each quarter, the three products in the sales of any kind. Bar in each worksheet is a single data point or more. Because of its rows and columns with the column happens to be transferred over, so are sometimes used interchangeably. -
all the data are selected in the case, click the \At this time all of the blank lines have been removed, and then click the \Insert a blank line is to avoid deleting the first row of data. -
-
7) error value: # NUM! meaning: to provide an invalid argument to the worksheet function, or the result of the formula is too large or too small to be expressed in the worksheet. -
-
-
-
needed, and sometimes want to B and C list the contents of the column to merge, if the number of rows less, can directly use the \do. -
-
-
-
If you want to delete the contents of the cell content and its format and comments, can not simply be applied to the cell selected, then press the Delete key methods. To completely remove the cells, using the following method: you want to remove the selected cell or range of cells; click the \-
-
-
If you want to delete only one empty cell in the column, while the other columns of data and blank cells are not affected, you can copy the first column, paste it to a blank worksheet will be empty by the above method delete all rows, then copy this column and paste it into the original location on the corresponding worksheet. -
-
-
-
matrix is not a number, but an array. In Excel, the array of domain occupied by a unit, the unit field with large brackets, such as {A1: C3}, and the general unit for the domain A1: C3-phase difference. Setting, first select the unit field, press Shift + Ctrl + Enter key to automatically generate large parentheses, an array of fields to be confirmed. -
-
-
(1) the definition of arrays and matrices -
6, custom function -
The following is an example: select one, and then click the \Custom \\Then if we enter \0 \If you change the custom format content, \\If you enter \-
we know, the use of If the function can be achieved in accordance with the conditions of display. A common example is when the teachers in student achievement statistics, want to enter scores below 60, can appear as \This effect, the use of IF functions can be easily achieved. Assumption results in the A2 cell, determine the results in cell A3. Then in cell A3 enter the formula: = if (A2 <60, \-
(2) sequence \
-
1 editing skills -
The following is a \With AutoCAD drawing, some people like the coordinate point is stored in EXCEL, called when drawing curves in these parameters. Stored data format is \merged into C column, enter in C1: = A1 &\All contents of the combined (see Figure 3-4). -
11, macro applications -
-
from simple to complex logarithmic trigonometric functions, exponential functions, can draw the curve with EXCEL. If available, you can also use EXCEL to complete the determinant, the matrix of the various calculations, a simple integral operation, the use of iteration of a function value (such as x ^ 2 = x ^ 7 +4, can be iterative method for solving x value), and so on, all things related to computing, to find EXCEL to help, it will give you a satisfactory answer. -
meaning: the formula used in Excel can not recognize the text,[link widoczny dla zalogowanych], such as the name might be the wrong, or enter a name deleted, if not the literal string enclosed in double quotes, will also have the error value -
-
-
-
meaning: delete the formula referenced by the range of cells. -
(1) use of color in a custom format to a paragraph set the color, simply add the paragraph in square brackets the color name or color number. Excel color name recognition: [black], [Red], [White], [Blue], [Green], [blue] and [magenta]. Excel also identified by [color X] specified color, where X is a number between 1-56, representing 56 kinds of colors (Figure 5). -
another example, assume that the ongoing settlement of accounts, you want to use the blue account balances in excess of $ 50,000, negative values shown in brackets in red, the rest of the value of the color displayed by default, you can create the following format: \conditional operator can be used as a powerful auxiliary scaling values, for example, if the unit production of several products, as long as a few grams of each product of a compound, while the production of several thousand a day this product, then used in the preparation of the budget need to switch from grams kilograms, tons, then you can define the following format: \# _k \
-
-
-
-
-
3) error value: # VALUE! -
Figure 7 -
-
-
enter the formula in Excel, sometimes the results can not be calculated correctly, and in the cell displays an error message, the production of these errors, some due to the formula itself, and some are not. Here to tell us about some common error messages, and proposed ways to avoid mistakes. -
-
pie chart: comparison of several data used for the formation of the sum of its percentage of the value of the most useful. Representative of the whole sum of bread, each with a wedge or slice the number of representatives. For example: sales of different products that the percentage of total sales, the units of the total funding for the proportion of funding, collection of books, how many of each type and so on. While the pie chart can only express a data column, but because the expression was clear and easy to use and easy to learn, so in practice more than used. If you want multiple series of data, you can use the ring diagram. -
-
-
There are other types of charts, such as Cylinder, Cone, Pyramid, just a variation of bar and column charts, with no outstanding features, but with a relatively small, there is not a a repeat. To note here is: This is only general application of the chart, sometimes a set of data can be used to express a variety of charts, then we should be selected according to specific circumstances. For some charts, if a data sequence drawn into the cylinder, while the other is drawn into a line chart or area chart, the chart will look better. -
for tea[link widoczny dla zalogowanych]ng friends will experience painting function curve question! If you want to quickly and accurately draw a function curve, a chart can make use of EXCEL functions, it can make you draw the curve of both standard and pretty. You must ask, is not difficult to learn it? In fact, this not difficult, can be very simple, do not believe you told me to try. -
(3) create a conditional format of six logic symbols can be used to design a conditional format: \equal), = (equal ),( not equal), bad if you think these symbols in mind, simply use the \-
-
-
; ; 3. Conditions Show -
In addition, we can use a custom format to achieve the purpose of hiding the input data, such as the format \Hide all the input values. Custom format only changes the appearance of the display of the data,Add friend referred today to get goods to live a t, the data does not change the value, that does not affect the calculation of data. Flexible use of a good custom format function to the actual work will bring great convenience. -
solution: when should confirm that the formula or function or parameters required for the correct operator, and the formula refers to cells that contain valid values. For example, cell C4 has a numeric or logical values, cell D4 contains the text, the formula = C4 + D4, the system can not convert the text to the correct data type, which returns the error value # VALUE!. -
If the direct input of \-
(1) Select the column to type in English, click \tab, in the \-
-
; ; 7. matrix Calculation -
* set the cell has its own style into a form; -
2, the combined cell content -
be pointed out that, EXCEL and WORD macros in the macro some differences, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so when it comes to and location of the operation, to be extra attention. If the phase by using relative references, can be Offset by means of methods, such as the following statement: ActiveCell.Offset (1,0). Range (\If used together, you will find it to have more content and more flexible application methods. -
solution: Modify the cell references, or used as a divisor input cell value is not zero. -
Figure 10 -
-
10, how to avoid the error message -
several worksheets the same data filled in the same location, you can select a worksheet, and then hold down the Ctrl key, then click the window to the bottom left corner of the Sheet1, Sheet2 ...... to directly select Enter the same content multiple sheets, then in any one of a worksheet, enter the same data, then the data will automatically appear in the table selected among other work. After input finished, press the Ctrl key on the keyboard, then use the left mouse button click on the selected multiple worksheets, work table to remove these links, or in a form input data will then appear in the election the other work table. -
-
on a work table, often both the data, there are text, so that input back and forth on the need to repeatedly switch between the English and Chinese input method is very troublesome. If you want to enter something great regularity, such as this column is all words, all Chinese to explain the next column, you can use the following method for automatic switching. Is: -
-
-
-
-
-
; ; 10. how to avoid the error message - ;
-
-
-
meaning: no information available for the calculation to be performed. In the modeling, the user can enter in a cell # N / A, to show that is waiting for data. Contain any references to # N / A value of the cell will return # N / A. -
custom format
; ; 8. Automatic Switch input method -
solution: restore the referenced cell range, or re-set the reference range. -
* set a table for each job requires a fixed form of the header; -
-
macro is a set of instructions that tell EXCEL to complete the action specified by the user. Macro is similar to a computer program, but it is being fully operational in EXCEL, we can use a macro to complete the tedious, often repetitive work. Macro to complete the action do the speed is much faster than the user. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We can also create a macro, in the \-
Excel's powerful computing capabilities, not only simple arithmetic, it can be an array, matrix calculations. -
[link widoczny dla zalogowanych] -
general model is equivalent to the following formula: [>; 0] is the number of formats; [<; 0] negative format; zero format; text format. -
data in the table if the majority of work is generated by a formula and want to quickly know the formula for each cell in the form of, for editing, you can do: Use the left mouse button click on \Options \At this time the division of labor in each cell that come. If you want to restore the display of calculated results to re-set \-
-
-
-
; ; 12. the icon of the application of skills - ;
in EXCE in combination allows the creation of such charts, but if you want to create an EXCEL chart type combination is not allowed, such as a two-dimensional map can not be the same mix with a three-dimensional chart, this combination is not possible , the system will display an error message. How to build mixed-chart it? Click the \If you are within the definition of these forms are still not satisfied to click the \-
-
-
-
-
array of computing and computing with very different matrix, such as the following example, A and B are defined array, as the two arrays are 3 × 3, the output is 3 × 3 units grid. Matrix calculation results when the first output of the selected domain, the range of cells for the 3 × 3, then enter the formula. If you enter \array B. If you want to matrix calculation, we must use the corresponding matrix function. Matrix addition, subtraction and addition and subtraction array is the same expression, but also \inverse matrix of A by B, so the formula is \Formula input, and press Shift + Ctrl + Enter key to get results. For more complex matrix calculation can be used step by step calculation. -
macro given below applications, as long as the \If you want the recorded macro and then edit it, we should have some knowledge of VBA. -
-
area chart: shows the magnitude of change over time. When there are changes in several parts, and the sum of those parts you are interested, they are particularly useful. Area chart so you see changes in the various parts separately, but also see the overall changes. -
-
( Select the text using Ctrl + * -
-
-
solution: wait for the data in the cell is filled with data. -
-
-
4, the custom format -
* insert sheet or thin and so on. -
-
another example, the formula: = if (SUM (A1: A5> 0, SUM (A1: A5), 0) this style on the use of a nested function, meaning that when the A1 to A5 and greater than 0 , returns this value if less than 0, it returns 0. Another point to draw your attention: The above symbols are half-angle, and the IF with no spaces between brackets. -
-
-
For example, if you enter: = if (A2 <60, \-
-
solution: increase the width of the column so that the results can be fully displayed. If it is subtracted from the date or time had caused negative, can change the format of the cell, such as to text format, the result is a negative amount of time. -
Excel by default a lot of useful data formats, and can basically meet the requirements of use, but for some special requirements, such as the emphasis on some important data or information display, set the display conditions, we must use the custom format feature to complete. Excel custom format using the following general model: a positive number format, negative format, zero format, text format, in this general model, contains three digital section and a section of text: use of data greater than zero positive number format; less than zero data using a negative format; zero data using a zero format; enter the body cells to use text format. We can also use the test, add descriptive text and color to expand the use of a universal model custom application form. -
-
-
XY scatter: show pairs of numbers and the trends they represent the relationship between. For each number on a number is drawn in the X axis, while the other was drawn in the Y axis. Had two points in the vertical axis, intersecting at a mark on the chart. When a large number of such numbers being drawn, the emergence of a graph. The important role of scatter can be used to draw the function curve, from simple trigonometric, exponential functions, logarithmic functions to more complex hybrid function, can use it to quickly and accurately draw the curves, so in teaching, scientific often used in the calculation. -
-

2) error value: # DIV / 0! -
-
-
7, Matrix -
-
solution is: In the C line, insert a blank line (if the D column is not content to operate directly in the D column), in D1, enter \column and a. Select cell D1, the cell with the mouse to point the bottom right corner of the small box \B series and C series combined. Then do not just put the first B and C column remove column, the first column of the results of D should copy it, and then \Time you delete B, C, D columns. -
(3) the date input -
-
-
Figure 6 -
the custom number format, up to only 3 field, Excel provides a maximum number of segments in the first two conditions, including 2 tests, meet with a number of test conditions specified in the corresponding section of the format, and the remaining figures with paragraph 3 of the format. If the test contains only one condition, they have different situations according to specific analysis. -
-
8, automatic switching input method -
Radar: How to display data or other data changes at the center. The coordinates of each category from the center of radiation. The data from the same sequence with the lines connected. You can use radar to map the sequence of several interrelated,[link widoczny dla zalogowanych], it is easy to make a visual contrast. For example: You have three parts with five identical machines, the radar can draw on each machine for each component wear. -
-
-
Figure 9 -
-
-
matrix function is Excel for matrix calculations of the specific module. Use the \determinant of the matrix; MINVERSE calculate a matrix of; MMULT calculate the product of two matrices; SUMPRODUCT calculate all the matrix elements corresponding to the product of and. -
Figure 11 -
-
-
* each time you print the page settings are fixed; -
error value: # NULL! Meaning: The formula to insert a space between the two areas to represent the intersection of these two, there is no public cell. For example enter: \-
merge the contents of different cells, there is a way is to use CONCATENATE function, the function of certain text string into a string, the specific operation for the \For example, assume that the investigation in a river ecosystem in the table, B2 contains \, \-
-
; ; 5 . Draw Function Image -
-
drawn curve: Click on the toolbar, the \point smoothing line scatter \At this time in front of us a curve (Figure . -
Figure 12 -
-
-
6) error value: # NAME? -
-
-
custom function, also called user-defined functions, Excel is the most innovative and attractive features, one of the following Visual Basic module, we create a function. In the following example, we give each person the amount by a factor, if it is working meals at work, and beat the tickets; if it is working overtime meal time, and beat half of the amount; if it is a rest day to dinner, hit Jiuzhe. First, open the \\\-
4) error value: # REF! -
Line: is used to show trends over time. For example: the data over time is an increasing trend, and the other in a downward trend over time, we can line chart, to predict the future. For example: speed - time curve, thrust - fuel consumption curve, lift coefficient - Mach number curve, the pressure - temperature curve, the fatigue strength - rotation curve, the power costs of transfusion - transmission distance curve, can be expressed using a line chart generally used more in engineering, if one of the data in several ways, a line chart where there are several different lines, such as five athletes in the process of change in velocity meters, there are five line, compared to each other , can also add a trend line to predict the speed. -
3, conditions shows -
If a worksheet has a lot of data form, you can select a cell in the table, and then press Ctrl + * key to select the entire table. Ctrl + * the selected region: According to the selected cell to the surrounding radiation data involved are the largest regional cell. So that we can easily and accurately select the data table, and effective method to avoid dragging large range of cells selected screen Luangun phenomenon. -
the impact of macro viruses and the fear of mental programming, many people dare not use the \In fact, you may rest assured bold to use, if only with the \put the operation and run it again. -
meaning: trying to divide by 0. This error is usually associated with the following situations: the divisor is 0, the divisor used in the formula or the empty cells contain a zero value cell cell reference. -
-
-
-
-
(6) cells do not continuously fill the same data -
Figure 2 -
stock figure: the three data series is a line chart is used to display a given time period of the underlying shares of high, low and close. Through the highest, lowest drawing lines between data points forming vertical lines, while the axis of the closing price on behalf of a small scale. Stock chart used for finance, commerce and other industries, used to describe commodity prices, currency exchange rates and the temperature, pressure measurement, etc., of course, describe the stock price is the most adept. -
-

Figure 13 -
meaning: the text-input mathematical formula item. If you are using an incorrect parameter or operator, or when performing an automatic correction function can not correct the formula for the formula, will produce an error message # VALUE!. -
-
(4) fill streak -
solution: If the name does not exist using this type of error generated, should be sure to use the name does exist; if the name, function name, spelling mistakes should be corrected; the text string enclosed in double quotes; sure all areas used in the formula are used in reference to a colon (. For example: SUM (C1: C10). Note that the formula in the text enclosed in double quotes. -
input function type: B1 cells in column B enter the general functional form of written expression, y = | lg (6 + x ^ 3) |; in cell B2 enter the \)) \At this time, and then select cell B2, so that the cursor point to the lower right corner of the rectangle B2 \-
Figure 5 -
If you want to enter the \If you want to enter the current date, click \-
-
-
solution: Make sure the function parameter type used is correct. If it is too big or too small formula results, it is necessary to modify the formula so that it results in -1 × 10307 and between 1 × 10307. -
Column: composed by a series of vertical bars, usually a period of time to compare two or more items in the relative size. For example: quarterly or annual sales of different products compare several projects in different sectors in the funding allocation, the number of various types of information every year and so on. Bar chart type is used widely, many people are using the chart from its beginning. -
-
-
; ; 4. Since Definition Format -
-