Hello everyone! I would like to ask you about the use of Excel

Send the table to, deal with it and help you send it back, other excel problems can also be used, master.

I'm also a newbie, I have a good place to learn office, share it with you, it should be useful to you, ** as follows.

Good to solve! Why don't there be 13 columns? The first 12 columns are each a month, and the 13th column is set to the adult cumulative number.

In this case, there is also the number of each month, so it is clear. Specifically: first select the first box of column 13, then dot the = sign in the formula bar, and then click the first box of each column in turn, note:

After clicking on the first box of each column, don't forget to add a plus sign. Point all the way to column 12. Then click OK in the formula bar above.

If it's not just one row, point to the bottom right foot of the first box in column 13 until the black cross appears, and then drag all the way down to the row you want.

Isn't there a function in excel?

Your problem can be solved with the simplest summation function.

recommend

There are many masters, so it is recommended that you ask.

I also want to solve this problem, please let me know when you solve it.

First, let's talk about the functions we use.

vlookup

vlookup is a function that determines the referenced data, and it has a total of four parameters, in order:

1. Conditions for judgment.

2. The area where the data is tracked.

3. Return the data in the first column.

4. Whether it is accurately matched.

Depending on the needs of the question, this formula should be:

vlookup(a2,sheet1!$a$2:$f$100,6,true)

Let's elaborate on the use of each parameter in this vlookup function example

1. A2 is the judgment condition, that is to say, if the data corresponding to column A in the Sheet2 table is the same as the data in the Sheet1 table, it can be referenced;

2、sheet1!$a$2:$f$100

is the region of data tracking, because the data that needs to be referenced is in column f, so the area tracked is at least in column f, and $ is the absolute reference.

This is the number of columns that return what number, as shown in the figure above the physics is column 6, so it should be 6, if the English value is requested, then it should be 5 here

4. Whether it is absolutely cited, if so, enter it.

true, if it is approximate, the condition is satisfied.

Then enter false

Approximations are mainly used for financial, arithmetic, etc. with decimal points).

5. Vlookup is a judgment in the vertical direction, if it is a judgment in the horizontal direction, you can use the hlookup function.

Put the amounts in the first table and the second table in the first column, and then use vlookup, provided that the amounts cannot be duplicated, otherwise the match will be wrong.

There will be a lot of problems in the use of excel**, it may be more troublesome for novices, and I don't know how to solve them, today I will share with you 6 common problems and solutions, you must have encountered such problems.

1. The number 0 is missing

Why doesn't the number 0 entered at the beginning of the cell show up?

Solution: Method 1 is to enter single quotation marks in English on the cell before entering the number; Method 2: Select the cell and set the cell format - text.

2. The contents of the cell become

Why is it displayed after entering data in a cell

Solution: This is actually caused by the cell is too small, the data display is incomplete, select the cell, double-click the column width to adjust it according to the content.

3. The number becomes e+

What should I do if a lot of data is entered into a cell and it becomes e+?

Solution: Select the cell range, right-click - Format Cells - Custom, enter 0 to OK. If it is a number with more than 15 digits, the following number will become 0, and when there are more numbers, the cell format will be set to text in advance.

4. The formula is not calculated, and the formula is displayed

Why is the formula still displayed after entering the formula without calculation?

Solution: This problem may be that the cell is set to text formatting, you only need to modify the cell formatting to regular, and then double-click the formula cell, and press enter to calculate.

5. The excel function is gone

What should I do if the function on the excel menu bar is missing?

Solution: The ribbon is hidden, click the arrow in the upper right corner and select Show tabs and commands. You can also double-click the menu bar to hide functions and show functions.

6. The blank cell formula is displayed incorrectly

Filling a formula on a cell with no data, why does it show an error, is there any way to hide it?

Solution: Add another function to the formula, use the formula [iferror(original formula,"" and then fill in the formula, the error will not be displayed, and the blank cells will be displayed.

The above are the common problems shared with you, the must-have tips for newbies!

Follow the following example story to implement your application using random functions:

Recently, a math teacher asked me if there was an easy way to get a computer to automatically generate an exercise, and it turned out that she had to give her students a lot of calculation exercises recently, and the training content was very simple. Before that, she had wasted a lot of time typing and typesetting in Word, and racking her brains to come up with a bunch of different numbers. Why not use Excel's powerful functions to help?

It's easy to do it with functions like rand, so come with me.

For example, if you want to practice adding 10 four-digit natural numbers, analyze that four-digit numbers are between 1000 and 9999.

Any random number, only insert rand() in the cell is obviously not good, because it can only produce random decimal places between 0 and 1, so you must multiply it by 9000 to amplify it, use the int function to round, add 1000 to get the random number in this range, and then use the drag copy of excel, it only takes a few seconds, a full page, dozens of questions will come out, and it is a real random effect. Once saved, you can use it again next time, and the questions are all new! This is because the cell in which each number is located holds the formula that produces the random number, not the number you see.

In addition, to generate a random number between n and m, you can use the formula "int(rand()*m-n+1))+n", interested friends can give it a try.

Random letters are attached.

Uppercase English letters are randomly generated.

char(int(rand()*24)+65)

Lowercase English letters are randomly generated.

char(int(rand()*24)+97)

Randomly generate uppercase and lowercase English letters.

char(int(rand()*24)+if(int(rand()*2)=0,65,97))

Randomly generate an 8-digit password.

concatenate(char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)),char(int(rand()*93+33)))

If you want to change after random generation, please use VBA to do it.

You can input the nested function =round(rand(),1)*10+1 of random function and rounding function

1.You check that the file you open is not shared on the server.

2.Check to see if you have an invalid printer connected.

3.Have you ever set it up or something?

4.Either reinstall or repair Office.

The first question is that you check whether all excel files are like this, if it is just a specific file, then there is no problem, sometimes the formula function used is recalculated every time you open it, so there will be no operation after opening, but the report file has been modified;

The second problem is estimated to be that your office program is not good (the 2007 version of Word is very unstable on some computers), and it is recommended to use 2010 to feel much more stable.