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

芳華老師的電腦小教室
569 followers
259 Video Views·Jul 13, 2024
快速解題~電腦軟體應用乙級術科題組四附件一excel操作步驟Office2016
Computer software application and math problem group 4 attachment 1 Excel operation
First of all, let's change this name.
Then the name of his business here should be changed to the name of an employee.
Then came the career goal. He didn't have 90
So remember to remove this 90 first
Then after the change is good
Let's do this for Annex 1.
We first go to the analysis table by inserting
Okay, sure.
Then press the right button above to analyze the table options.
Show Classical Tick OK
If you want a position on this topic, there is the name of the first department.
So the department name ticked
Again, the name of the supervisor, the name of the operator, the name of the business performance target
He's a performance target because he's a number.
So he's going to run to the Gadget himself.
What we say here is the goal of the year.
So there's no need to add up
We pulled him aside here and here.
So he won't do the whole thing.
Then comes the achievement.
Tick the mark here.
In terms of performance success rate, we will do it later.
Let's do the following gross profit first.
Well, after this is used well
Let's take a look.
He doesn't need to count the names of the business people here.
So here we press the right key
Tick the name of Xiao Ji, an operator, and light it off.
Again, we can look at the name of the supervisor here.
He has a total of the names of the supervisors here.
Then there is also this total account of this business department.
The subject here.
The total of his supervisor's name here
The department's total.
Business doesn't need that either.
The sum of every class here in the business department does not need to be
And you can see the total value of these two.
is the same
So let's count the business department here.
The total number of the department name ticks it off.
After dropping it.
Come again.
We can get that information.
Reproduce it.
We picked it up here.
Ctrl C to add another worksheet
Here we use optional ways to attach values.
There would be no such net bottom.
with the problem
After pasting it.
Let's go here and circle in the upper left corner.
Then two in the blue land.
So that his seat can blow it away
After the break.
Let's change the name here.
The goal here is to achieve success.
So add Dash to remove it.
Here gross profit plus Dash here also want to remove it
Well, we have achieved success here.
With Maori
This F in the middle
Click here.
He will appear to bow down
You go and click the right key
insert insert words
We are here to enter this business achievement rate.
He has a talk about the achievement rate here.
His algorithm.
The algorithm for the achievement rate is the achievement rate divided by the performance target.
Then use the percentage display to calculate to the first decimal place.
Then the second place should be four or five in.
So we're here to make a career here to click on it.
As long as it's a formula.
Here go and press an equal sign
That means it's a formula.
Then he achieved his career.
So let's take a look at Dacheng Performance Removal
And then here is his career goal.
That's OK.
Then tick
Well, check it. That's a good thing.
The percentage they show is this.
Then he comes back to count to a small number first.
So let's increase the number of decimal places.
Even if this
He only needs one.
Good.
Then after using the formula here well
Let's go here.
Then press the control point in the lower right corner to quickly press two
So he did all that.
Then it's good.
You can see there's a false sign.
That's because he hasn't been here yet.
So put these numbers together.
Go to him.
Press Ctrl
Then go and choose.
The same goes for the bottom one.
Then pick up these here.
There is a total above.
In this summation this sigma symbol
After pressing it down
He'll be able to help you out.
And this one he is very bright
He will sum up the above ones.
Just add it up.
After that, it's always good.
Then we'll do it again.
Change of this name.
the words here.
He didn't want the total of the supervisor's name.
He wants the chief
So here you can press replace
If it is replaced, this is a total.
And then below
Remember that total.
Because we have something different here.
Total of names of supervisors
So ahead of us.
To add a universal source of this signal
Then the following words go into the Ministry and
Then replace them all.
Well, then, after this one is used well
You can see him here.
his bottom
What he wants is the company's annual total.
We are now total.
So we just need to modify this.
Then we put him in these two boxes.
Turn it into a grid.
Because we'll go to Word and make changes later.
Better to modify.
Then press the left arrow.
And then when it's done
As long as the text of the place to the left
Then the number of words is to the right
Because he's in this position.
Many, many positions.
And then there is a smaller
Some are narrower.
So let's take a look at the one on the left.
Two times at the end of the line.
Let him make the best of him.
Then come back here and take a look.
He's every class.
He has spaces in between.
And ah, the department has to move up.
The supervisor should bring it up
So this is the first class.
To lift up two columns
Ah, after the second class
There is a blank column between classes.
So after the second class
He wants to have three empty columns here
This is enough to add a blank column.
Then the department goes up
Supervisor up
Good last company annual total here
With this department and ah.
Yes, there are two blank columns
So we can choose here.
The first lesson is two empty columns
After that, press and hold the control key.
Here to add three new columns of blank columns
Then the company's annual total is two.
Ok, after selecting, press the right key to insert
After inserting well
You can see him right here to help you put this blank column
Insert it in.
Then we can move up
Take the first business lesson.
And then after the sign of this cursor with this arrow
Hold to lift
This can move up.
All right, everyone is the same.
That reminds him that there is still a blank column between class and class.
So remember to keep it here.
Okay, that kind of thing.
He's this worksheet.
So far, so far.
Annex I is ready.
Then let's name this worksheet and modify it.
This is the second sheet in Annex 1.
This is the first sheet in Annex 1.
So we changed it to 1-1.
Let's take this data and move it up.
This move forward
This is Annex II.
That's the value of that.
You will see that this is 33660.
Then his ratio was 76.
This is good.
The above is the Excel operation in Annex 1 of Topic 4
