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

芳華老師的電腦小教室
569 followers
252 Video Views·Jul 13, 2024
快速解題~電腦軟體應用乙級術科題組四附件三excel操作步驟Office2016
Computer Application and Numerical Modules 4.3.0 Excel
This topic is about the chart.
The chart needs the information about the department's name,
the target of the business, the achievement of the business, and the profit.
We can use the data from the sub-suggestion just now.
So we choose the department's name from the sub-suggestion file.
The department's name is Business Class 1.
Next is Business Class 2.
It's in a different place.
It's not continuous.
So we press the CTRL key and select Department 2, 3, 4.
Then copy it and add a blank work table.
Then paste it.
And here, it needs the target of the business, the achievement of the business, and the profit.
There is an achievement in the middle.
It's okay. Let's choose it together.
Then press the CTRL key again.
Select the information of the department here.
Then press CTRL C and come back here.
Paste it here.
After pasting it, delete the achievement.
After deleting it, you can see that the information here is added one by one.
Because the column is not wide enough, it will be like this.
Let's click twice between the column and the column.
Okay, then you can see the information.
This one is a three-dimensional straight line chart.
So we need to click on the information to insert the chart here.
Select this three-dimensional straight line chart.
After clicking, we move this chart to a new work table.
Let's take a look at the new work table first.
The chart has a title, axis, and chart.
So let's click on the quick chart configuration first.
This chart configuration 9 is in line with the title requirements.
After clicking it, let's design it again.
You can see that the title requirements here require a lot of data to be 10-point size.
A lot of data is 10-point size.
If it is 10-point size, we can make some settings at the beginning.
This is more convenient.
In English, this is Times New Roman.
In Chinese, this is a new title or a new title.
The size is 10-point.
Okay, confirm.
After confirming, let's change the title of the chart here.
The title of the chart requires a 90-year company business department performance target.
The target is a full-length.
Achieve performance.
And毛利比較圖
Let's select these words.
The title requires 16-point diagonal.
And then we need to add a single line and a bottom line.
In this chart, the prediction is already medium.
And then it's 16-point.
And then we need to add a diagonal.
And then add a bottom line.
Remember, as long as it is a chart, its font must be Times New Roman or Times New Roman.
As long as it is the title of the chart.
Okay, let's take a look at the coordinates here.
The coordinates here, the coordinates on the left are gold.
And then use a vertical one.
Let's pick this one up.
If it's vertical here, let's click here.
Let's take a look at the size of the coordinates here.
The coordinates here are gold.
It's going to be 14-point.
So let's change it to 14.
And then this level, the information it wants is the department name.
Here, this is the department name.
If it's the department name, the size here is also 14-point.
So let's take a look here.
Let's go to this horizontal coordinate system.
The name of this coordinate axis is also changed to the department name.
And then pick it up here.
If it's the size, change it to 14.
And then if it's a chart.
The mark of the chart here, the size here is also 10-point.
And then it's going to be built at the bottom right of the outline.
It's going to look like this.
So remember to do the outline here first.
Add this outline and pull it down.
After pulling it down, let's take a look here.
The coordinate axis here is going to be 10,000.
So let's click twice on this coordinate axis.
After clicking twice, there's a display unit here.
Let's choose 10,000 here.
You can see it.
And then there's a label that shows the coordinate axis on the chart.
We don't need it here.
We'll add it later.
After it becomes 10,000, let's take a look.
There's an angle here.
So let's show it the angle here.
The angle is on the inside like this.
And then we're going to show it this color.
Because the color is green now.
So we're going to show it black.
And then this block below.
And then there's the coordinate axis here.
It says here that the coordinate axis here is 0 to 40,000.
And then the font size is 10-point.
So we're going to check here.
It's going to be 10-point here.
And then it's down here.
The horizontal below is vertical.
And then it's the same size as 10-point.
So we're going to change it to 10 here.
And then it's going to be vertical.
Like this.
You can look at the reference sheet.
It's going to be vertical here.
And then it's the same here.
It has a bottom here.
So we're going to add this bottom part here.
And then you can see that it's also angular.
So let's click this place.
After clicking the coordinate axis here.
We're going to select the angle.
And then this angle is the same as the inside.
So you can see here.
It's not very obvious, but it's still there.
And then the outer frame here.
It has an outer frame.
And then it says here.
It's going to have a rough outer frame on the outside.
Here's the topic.
It says here that it's going to have a rough outer frame.
So we're going to be here.
On the outside here.
The outer frame is black.
And then the thickness of the outer frame here.
We're going to select three points.
In this case, it's going to be rougher.
Okay, so let's take a look at the reference answer.
The reference answer is here.
So we just had this coordinate axis.
After the horizontal part becomes vertical.
It's going to run down a little bit.
So you have to remember to pull it up a little bit here.
So it's not too low here.
The coordinate axis here.
This part of the chart.
It also has unit languages and dates on top of it.
This is too high.
If you choose this one here.
There's no way to adjust the size.
You have to click on the blank space next to it.
This is how these circles appear.
This is how you can adjust its size.
We can pull it down a little bit.
If we pull it down a little bit.
We can insert this information here.
We're going to insert it here.
Here's the text block.
What we're going to insert here is unit languages.
Remember, he's going to add a full-length symbol.
The font size here is 14.
Okay, so after we're done.
We're going to adjust the font here.
The position of the font here.
It's going to be here.
If you say it's too flat here.
It's not very easy to adjust.
You go to the side and click on it.
Pull it in a little bit.
And then this is how it works.
It's easier to adjust the position.
It's not so borderline.
And then there's a date here.
So we can hold down the control key here.
Select this text block and press the control key.
You'll see that it's a copy.
It's presented in a copy.
And then we're going to put it here.
And then we're going to enter today's date.
This is your hard test date.
So today's date is July 6th.
So we're going to enter the English word here.
This is 2024.
In English, July is J-U-L.
And then here, the date format here.
Remember to make some adjustments.
The English word here is Times New Roman.
And then the Chinese word is Xīng Xīng Míng Tí or Xīng Xīng Míng Tí.
As for the date here,
Let's take a look at the topic.
The topic here says that the date is as long as it's 12 o'clock.
So we're going to change it to 12 here.
And then 10,000 yuan is 14.
10,000 yuan is 14.
So this part here is 14.
And then here, as long as it's a date.
And if you have a purchase rating software,
The font here,
You have to make some adjustments here.
Although what you see is Xīng Xīng Míng Tí,
But if you add a text,
There's going to be a problem with the rating.
And then what we're going to do is,
Let's take a look at the reference sheet.
Every one of them has this information label.
This word up here.
And the size of the word here,
The size of the information label here is 10 points.
So we're here.
Click on this picture.
You'll see this plus sign here.
Click here.
There's a information label here.
And this label, you hook it up.
You can see it.
And then after you hook it up,
Let's go over here and do a little bit of setting.
Here you click on it.
What we're clicking on now is the blue one.
The part of this bar chart.
If you click on it,
Select all the information from each department.
And then we're going to change it to 40 here.
After 40,
Let's press it again to get rid of it.
In this part of the value,
Each one has two decimal points.
So we're going to choose the value here.
And then two decimal points.
It doesn't have to be a decimal point here.
So we're going to click on the hook for the decimal point.
And then the same thing.
The following action is also here.
Select the value here.
And then remember the size here.
You have to adjust it first.
It's 10.
And then click on the decimal point.
And then there's this one down here.
This size is 10.
And then the same thing here.
And then click on the hook for the decimal point.
And then after you click it off,
You can see that there are some words.
It's going to be in this one.
It's going to hold this part of the bar chart.
And when you're in the lab,
Because it's a black and white printout.
So if you do this, you won't be able to see it.
And if you can't see it,
We're going to do some translation.
Let it be this value.
It's not going to be on this bar chart.
So here we are.
After you click it,
You'll see that it's selected here.
And then press it again.
And then move it up a little bit.
Like this.
Click first.
And then do the translation.
There's no way to do it.
You have to move it right after you click it.
Because there's no way to do it this way.
So you have to click first.
It means you've selected it.
And then do the translation.
And this one, remember.
You're going to have a line.
And try not to press the line.
In case your value is blocked by the line.
And then we're going to do it again.
Let's do that check.
The title of the title here.
And then here's the unit.
It's going to be a full title.
This is 14.
The Chinese language is XIN XIN name.
Or name.
The English word is Times New Roman.
And then here's the date of the test.
It's in English here.
And the size is 12 points.
And then it's the coordinate axis.
The vertical coordinate axis
is this place.
剛剛的這刻度這裡是10然後再來水平的這個座標軸名稱是部門名稱然後它大小是14然後那每一個這個長條圖啊都有這個資料標籤每一個的資料標籤的話不能壓到這個長條圖
的話它大小是14的然後再來這邊是有刻度是0到這裡4萬然後呢它這刻度的話是向內的刻度然後下面的話這裡部門名稱的話它是垂直的這是10
然後大小都是10然後再來是旁邊的這個圖例圖例的話是有框框圖例的大小是10如果它跑掉的話記得趕快再去做一下調整它的位置的話在這邊它的旁邊所以去記得要去做一下它的調整的這個位置把它調到剛好這樣子然後在這個圖的外面它是有這個框線的最外面要一個粗的框線那這樣子的話才表示說你復健3這圖表已經是完成了
好那以上是T組式復健3的Excel操作步驟解說
