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

芳華老師的電腦小教室
569 followers
230 Video Views·Jul 13, 2024
快速解題~電腦軟體應用乙級術科題組四附件二excel操作步驟Office2016
Computer Software Application and Mathematics Topic Group IV Annex II Excel Operation
What this topic needs to do is the education statistics of the important customers of the company in the 90 years of the Republic of China.
Let's go to the data worksheet.
Let's go and press insert to analyze the table.
Then press OK
Press the right key above to analyze the table options
Show Classical Tick OK
In the first place, what he wants is customer protection.
So our customers are guaranteed to tick here.
Then again, the transaction amount.
The transaction amount is his achievement here.
After reaching the mark here
There is one that accounts for the company's turnover.
What he meant was that
What is the percentage of this customer in the total turnover of all companies
So here we are again to achieve business
Press and hold the left mouse button
Drag him below.
Let it go.
His way of showing.
He wants a percentage.
Therefore, the right-hand value is displayed.
Total percentage
This will show the percentage.
Then comes the original name of the business.
Check the original name of the business here.
Let's take a look at the requirements here.
if required.
An important customer means
More than 3% of the company's total turnover
And his words here.
To sort by transaction amount
Let's go back to this excel.
He doesn't need this total of customers here.
So let's go press the right key
Put the small chicken customer number on this tick and light it off.
Let's sort it out first.
Sort by right key here
More sorting options
Here it is to be used.
words of shame.
Here is a summary of this achievement.
Or get 2.
Both are the same.
So let's just pick one of them.
确定
After sure.
Let's take a look.
More than three percent of his talk.
So the information just came here.
And he didn't repeat it.
Because he's talking about it.
If the transaction is the same.
Sort by way of customer guarantee increase
That's the amount of this transaction here.
It's just not the same.
So we chose here.
More than three percent of information.
Pick it up here.
Reproduction
Then add a new worksheet.
Stick on
After pasting
Because he has a bottom with this net bottom.
So let's take these and cancel it.
Then press the paint bucket at the bottom of the net.
Not filled.
Then the oil mark is in the upper left corner here.
Go between blue and blue.
Let him take his place.
After the opening?
Let's revise his position.
His words here.
The name of the employee he came to the back.
So let's click here in B here
After the whole thing.
Oil labels to the blue and blue
He will show the sign of this arrow.
Then hold down this Shift key.
Then move to the side
So the name of the sub-clerk moved in.
Then come here again.
Change it to this transaction amount.
Then come here again to account for the company's turnover.
Good to come to this company again.
He has two businesses here.
of those two businesses.
Their turnover is not the same.
Then this Lin Xixiang
He did not reach this business.
The standard required by this project.
So this information cannot be kept
Let's take this one below.
Guoxiong this information ah
Pick it up and show the arrow sign.
Then hold down and move one up.
Okay, let it go.
This can directly replace certainty.
Okay, here's another blank column.
We removed it.
After getting rid of it?
His deal here.
He wants the transaction amount unit.
It's the new NT $10,000
Then we have to turn it into a million yuan way to show it.
So here we are on the sidelines
blank place
You go into ten thousand
After entering 10,000
Copy it here.
Ctrl C
Then put the number of these transactions.
Pick it up.
Then go to paste
Here's an optional post.
Okay, so here's one except
Well, what he means is that
I have all this information.
Divide by the meaning of this grid.
Okay, sure.
This way, his unit becomes a million.
Well, he's a little here.
want two
So let's adjust
His little place.
Let him be two.
Okay, so this one.
Can not
Cancel
Then come again.
His customers here.
He has spoken here.
Here he is.
The customer's number here is on the left.
The rest of the words should be put in the right place.
So our customers put their numbers on the left side.
the rest of the place.
It is to be centered on the left.
Then we'll point the tour here in the upper left corner.
Double-click here between the bar and the bar.
Let him adjust the width of the position.
Okay, let's take a look again.
His answer here.
Between every one of his clients
He has a blank column.
We don't have that here.
And then his customers got more information.
So we can be here.
Next to the first customer.
Enter 1 and 3 here.
Then pick these two.
We press the control point in the lower right corner
Hold and drag down
Let him fill this value automatically.
And then in the empty column below
Enter 2 4.
Then we picked both up.
Hold down the control below.
Drag Down
Give him that value.
To be bigger than this.
The last piece of information is worth this.
And then our tour point is here.
Take one of the squares
Go by information.
Here we go in order of increase.
Press down
that kind of word.
He can take every client.
Just one more blank column
Okay, that number.
We can remove it.
After the removal
He has one below.
Transaction Amount Unit Colon NT $10,000
So we have to supplement it here.
And then his colon is to the whole line.
Then he both.
Because he has more words.
So we picked these two cards.
We made him fit.
Then move to the right.
Okay, well, when this is done
This is the second sheet in Annex 2.
So we put it in 2-2.
We are all in line now.
Change it back to half
That just this worksheet is the first
So we changed it to 2-1.
Then we put these two worksheets
Pick it up together.
Then move it back
After that.
When we do it in Word.
Let's go find the last one.
Last sheet for each attachment
That's his information.
It is more convenient to do the arrangement of this action later.
Ok, the above is group t 4 annex 2
Excel operation explanation
