快速解題~電腦軟體應用乙級術科題組一附件一excel操作步驟Office2016

芳華老師的電腦小教室
569 followers
173 Video Views·Jul 18, 2024
快速解題~電腦軟體應用乙級術科題組一附件一excel操作步驟Office2016
Computer software application and a few sub-suggestions for Excel operations.
This question is about the new student review.
Let's take a look at the question here.
It requires seven new students to be printed every month.
The order of printing data should be printed in the order of school number from small to large.
So let's go to our information table first.
It is necessary to click on any place in this column of the school number.
Let's go to the data.
Arrange
Let's arrange it from small to large.
Then we just need to find the data of 14 students.
So we start from the first column, from the blue place.
Select to the 14th place, 911014.
Okay, let's copy these files.
Let's add a blank workbook.
Paste
Let's name this workbook 1-1.
Let's pull it to the back.
After going to the back, let's change the name of the blue one.
The name of the blue one, the first one, it has to be a special code.
So we have to enter it here as a special code.
Okay, the second one is the special name.
Okay, the next one is the school name.
For gender, we use the ID number to judge.
So let's click on the ID number column here.
Click the OK button to insert.
Enter gender here.
For gender, we use the ID number column.
For gender, we go to the equal sign here.
Use the IF function.
For the IF function, we go to press F of X.
Logical test is its conditional value.
For the conditional value, we use a function called MID.
Because the second digit of the ID number here.
If it's 1, it's a man.
If it's 2, it's a woman.
So let's click on this ID number here.
Then press the DOT number.
We start with the second digit.
Every time we take a digit out.
Then if it's this digit.
Because the value it takes out.
The format it takes out is a digital format.
So we have to add a binomial.
If it's 1, it means it's a man.
So we have to enter a man here.
Otherwise, it's 2.
Because it's not 1, it's 2.
So it's a girl.
It's not a boy, it's a girl.
OK, press OK.
Then we press twice at the bottom right control point.
Let it copy the formula.
OK, next we're going to do the birthday part.
For the birthday, it's going to take these files.
Cut it up.
OK, so we have a column here.
So we're going to add five more columns to it later.
So press the right button to insert.
Then we select this column.
After selecting this column.
There's a gap in the information here.
Press down.
We're going to press the fixed width.
Then press the next step.
After the next step.
We're going to click between every number.
It's going to create a line.
OK, then press the next step.
Next step.
OK, done.
Then you can see that it automatically.
OK, next we're going to do this.
The admission qualification part.
For the admission qualification.
It's going to have three lines in front of it.
So we're going to select the three columns in the back.
Press the right button to insert.
And the first two lines are all zero.
OK, so what's next?
It's going to be judged by the one in the back.
The one in the back, the graduate school.
If it's a graduate, it's one.
If it's a leave of absence, it's four.
So we're going to do the same thing here.
Go to the next one.
The function of the clothes.
What about the function of the clothes?
Let's open it up here.
Go to f of x.
And then here.
Graduation and leave of absence are all in the back.
The back of this column.
The right side.
That's the right side of this column.
So we're going to add the right function.
Let's click on this storage box.
Take the last two words.
If the last two words.
It's graduation.
That's his code.
It's one.
Otherwise, it's a leave of absence.
Because the data here is only graduation and leave of absence.
So it's not one, it's four.
Okay, sure.
And then we can pick up these three storage boxes.
We're going to click on the right-hand corner to control the point twice.
So the code for the admission qualification is ready.
And then the rest of the data.
He's going to do this.
So we're going to delete these files first.
I don't need it.
Okay, so far, we've got all the data for the admission qualification.
And then we're going to add a new work table.
We're going to pick up these columns first.
Copy and paste over.
So that we can reduce the input of some data.
And then we're going to stick it over.
We're going to arrange it according to the panel requirements of this topic.
The first one is the special code.
The special name is under the special code.
So we're going to pull it over.
And then it's the school number.
The school number is the two above.
It's going to merge into a storage.
So we're going to choose the middle of the cross.
And then the name is going to be here.
And then the gender.
And then the number of identities.
He's going to merge the top and the bottom into a storage.
So we're going to pick it up.
Top and bottom merge into a storage.
We're going to let him be neutral.
And then the blue frame, adjust it.
And then the date of birth.
Here, the following.
What you need to add is the year.
And then the month.
Year, then there are two horses to be merged together.
So we're going to pick up these two storage boxes.
And then the month.
The same thing, these two boxes are going to be merged.
And then the date.
And then the top six are going to be chosen.
Merge up.
This is the birth.
Okay, so next to it.
Except for the following codes,
In addition to these three horses,
And this graduate school.
So there are four storage boxes in total.
And then there are two lists.
So what we're going to do here is we're going to choose two lists.
But it's four.
This height.
Merge into a storage box.
Make sure.
And then what we're going to do here is we're going to enter the admission qualification.
And then the name of the document.
And then he's got this word.
It's a little bit lower.
So we're going to press this word.
And then the rest of the data in this graduate school is not needed.
You can delete it.
And then he's going to merge into a storage box.
He's going to add a backup.
We'll wait for all the data.
We'll go to the top left corner.
We'll go to the middle here.
That's it.
That's faster.
Once set up like this.
Okay.
All right.
And then the title column above.
We're going to do the same thing between blue and blue.
Click twice here.
So that his title column can also be fully displayed here.
All right.
And the following information is the same as above.
There's a place to merge.
To merge.
So we're going to merge here.
So we're going to press the merge storage box again.
The ID number is going to be merged up and down.
And then we're going to stick it up and down.
Here.
And here, you can pick it up and press F4 to repeat the previous action.
It's going to be faster.
Okay, so here's the merge part.
And then we can name this work table 1-2.
Okay, and then we're going to click on the display.
Happy window.
And then after the happy window, we're going to click on the sidebar display.
Sidebar display.
We're going to make it horizontal sidebar.
Okay, sure.
Okay, so here's the horizontal sidebar.
And then we're going to click here.
And then we're going to click on the place where the original data came from.
And then we're going to use this method.
It's a window.
You can see the layout that we're going to arrange at the same time.
And then the following is the source of the data.
In this case, we don't have to say two windows.
Keep switching left and right like this.
It takes a lot of time.
Okay, and then we're going to leave it on the second 1-2 work table.
And then we're going to leave it on the 1-1 work table.
And then we're going to click on the place below the special code.
Click here.
We're going to click on the equal sign.
We're going to make it equal to the special code here.
The special code of 1-1 below.
This storage box.
Okay, after you click on it, it will automatically bring it over.
This 1-1.
The exclamation mark.
The exclamation mark means that it's in this A2 storage box.
Okay, he's going to bring it over.
Then we'll press the Enter key.
That's it.
Okay, and then the special name.
Same as the equal sign.
Click on the special name next to it.
Okay, let's learn again.
Okay, and then the name below.
Okay, and then the gender next to it.
Okay, and then the ID number.
And then the date of birth here.
And this code.
The information about going to high school is all connected.
So we can just do this.
Right-click and drag it over to the side.
That's it.
Okay, and then we're going to do the same thing.
Click here in the upper left corner.
We're going to press this.
Between blue and blue.
Go and let him adjust the blue width automatically.
Okay, so you can see that we're here.
This kind of information is ready.
Then we can do it like this.
Put it in here.
Back up and down like this.
Okay, when you push it down.
You'll find out.
My information becomes the first one.
The blood number is one.
Then it becomes three.
Then it becomes five.
The middle one here, number two, number four.
If it's a number, it's gone.
Because he's here.
We have the original information here.
It's one piece of information.
There's only one piece.
The title requires us to do one piece of information.
There are two pieces.
So our information here.
It's going to be a case of jumping numbers.
So we can go here.
One to one, this work table.
Here.
Okay, so we're up here.
This place.
This one.
This place in the title bar.
We're going to enter zero here.
And then we're going to enter one.
And then we're going to enter three.
We're going to pick up this one and three.
Press the control point in the lower right corner and drag it down.
Okay, to the last piece of information.
Let go of it.
The last number is 27.
Okay, and then the following words.
Enter two and four.
Pick up this 24.
Drag it down the same way.
We're going to drag it down to 27.
Just as big as it is.
Okay, let go of it.
And then when you let go of it.
The title is in any place in here.
Go to the information.
Here's the earthquake sequence.
Okay, so you can see that.
It automatically puts one piece of information.
There's a blank space between the information.
So one piece of information is two.
We can see that.
He's a工作表的话
You can see that his school number has become a順號下来了
Then we can do the same thing again.
Pick up all this information.
Let's pick up the last one.
And then hold it down and drag it down like this.
We're going to do a total of 14 students.
Each student has two lists.
And then the title list is also two lists.
So what about the last number of the list?
It's going to be a total of 30.
Like this.
So we're going to hold down the control point in the lower right corner.
我们拉到这个旁边是30的这个地方
好这样子就到14笔了
好那一样
我们左上角这边再点一下
我们去按常用
因为题目这边的资料全部都要置中对齐的
所以我们选一下置中
然后这个垂直的话也是要置中
好上下左右都要置中
好那以上是
提足1附件1excel操作说明
