Multiplication publicity application and primary function application

1) Because (a +b) = a -2ab + b so a +b = (a -b) +2ab = 4 + 30 = 342) A factory Xiao Wang's one-month worksheet is as follows.

Information 2: The production of two kinds of products A and B, and the production of not less than 60 A in accordance with the regulations.

A brief description of the production of the product also takes the time relationship as shown in the following table:

Number of pieces of product A Number of pieces of product B Production time taken.

10 10 350 points.

30 20 850 points.

Information 3: Remuneration by piece, each production of a commodity A can get yuan, a piece of B can get yuan.

1.How many minutes does it take for Xiao Wang to produce each product A and each product B?

2.What is the maximum amount of money that Xiao Wang can have in that month? How many pieces of A and B are produced at this time?

2)1.Solution: Let each production of a commodity A take x,y minutes for each production of a commodity B.

According to the problem: 10x+10y=350 30x+20y=850 solution: x=15 y=20

A: It takes 15 and 20 minutes to produce each product A and each product B is produced.

2.Because it is stipulated that the production of A is not less than 60, so A produces 60. The time taken is 60*15=900 minutes.

Because the daily work is 8 hours for a total of 25 days, 25 * 8 * 60 = 120,000 minutes, so the time taken to produce B is 120,000-900 = 119,100 minutes, and the production of B 119,110 20 = 5,955, a total of 60 * yuan was earned).

Answer: Xiao Wang can get the most yuan that month, and at this time, the production of two kinds of A and B is 60,5955 pieces respectively.

3.Set the production of product A as X tons. And the total profit obtained from the sale of these two products is y million yuan.

If the production of product A is x tons, then the production of product B is 8-x tons. A is needed, B y= is needed

Where: 0 0 0 x

Therefore, the value of x can be in the following range:

y=when x takes the minimum value, that is, when x=, the profit is the largest, and the maximum profit is: 10,000 yuan).

1. Assuming that the unit price is written in cell A1 and the quantity is written in cell B1, the total amount can be obtained by formula in cell C1

a1*b1 or =product(a1:b1).

2. Definition of product function.

Multiply all the numbers given in the form of parameters and return the product value.

Syntax product(number1,number2,..

number1, number2, .are 1 to 30 numeric parameters that need to be multiplied.

Indicates that parameters can be evaluated when they are numbers, logical values, or literal expressions of numbers. An error occurs when the parameter is an error or cannot be converted to numeric text.

If the parameter is an array or a reference, only the numbers in it will be evaluated. Blank cells, logical values, text, or erroneous values in arrays or references are ignored.

3. Excel four operations.

Taking the range of cells A1 to A5 and cell B6 as examples, A1 to A5 are 1, 2, 3, 4, 5, and B6 is 6, respectively

Addition = sum(a1:a5,b6).

a1+a2+a3+a4+a5+b6

A1 to A5 and B6 add up to 21

Subtraction = sum(a1:a5)-b6

a1+a2+a3+a4+a5-b6

The addition of A1 to A5 minus B6 is 9

Multiplication = product(A1:A5,B6).

a1*a2*a3*a4*a5*b6

The multiplication of A1 to A5 and B6 is 720

Division = product(a1:a5) b6

a1*a2*a3*a4*a5/b6

Multiply a1 to a5 and subtract b6 to 20

The cells written to the formula cannot be the cells that have been referenced in the formula, so as not to form a circular calculation.

** is topped by a row of letters a, b, c, ,..This is the label;

To the left is a vertical column of numbers 1, 2, 3 ,..This is the line number;

The column label plus the row number is the name of the cell, and the cell name is also called the cell address, such as the third row of column A, which is cell A3, the 18th row of column C is cell C18, and the seventh row of column C is cell E7, so that the coordinates are formed one by one, indicating the position of each cell.

Assuming that the unit price is A1 and the quantity is B1, the formula is:

a1*b1

Click fx - search for the function and enter product - click go - select and press OK - jump out of the function parameter dialog box - put the cursor in number1 - drag the data range you want to multiply (for example, a1 e1) in the excel sheet - OK. This way the function has been calculated once, and you can just pull down the rest and you'll have it.

Horizontal evaluation method: = a1*b1*c1....

There are 3 ways to set a full column formula,1Set up a formula and fill it down to all columns. 2.

If you have a certain grasp of the formula, select a column, enter a formula, press Ctrl+Enter, and the full column of formulas is completed. 3.In the case of ** with data, set the first formula, move the cursor to the lower right corner of the grid, double-click the "small black dot", and all the rows with data will automatically generate formulas.

Displays the results of the calculation.

What are you based on and what kind of calculations do you use to get the results?

1.Click cell E1.

2.Enter "=c1*d1" in the formula bar, and then press enter.

3.In the lower right corner of the E1 single pants Chahong Yuan grid, stop at the mouse no mark, when ten characters appear, push to the E20 cell, the content of the other cells will be automatically filled.

Time is actually saved in the form of a numerical value in **, and multiplication is the same as a regular value, but the answer is very weird.

For example, if you just want to double one or each of these values at 20:00 on March 1, 2012*3=2236 at 12:00 on July 5, 2012, the method is different.

For example, if you want to make 20:00 on March 1, 2012*3 just a year*3, the result will be 20:00 on March 1, 2026.

Or: If you want to make all *3 at 20:00 on March 1, 2012, the result will be 12:00 on September 5, 2026.

What effect do you want?

#include

include *malloc function header, if this function header does not work, you can try.

int main(void)

for(i=0;ifree(a);

a=null;

free(result);

result=null;

for(i=0;ifree(b);

b=null;

return 0;}

I'm a master at this. Yes, there is a function that can be multiplied by values, which is the product function. The product worksheet function multiplies all the numbers given as parameters and returns the product value.

How to use: product(Parameter 1, parameter 2, parameter 3,..Parameter 30).

For example, product(b3:b5)=1670284, which is equivalent to 121*119*116=1670284, and product(b3:b5,5)=8351420, which is equivalent to product(b3:

b5)*5=1670284*5, after opening excel, click insert, then click on the function, select all in the selection category, there is this function below, it is arranged in alphabetical order, I don't believe you try it.

Yes!

Write the function in the cell"=a1*a2"It is the product of the first column of cells and the second column of cells.