Then, locate and click on percentage 6. Steps in inserting rows and column: 1. Keep your cursor where you want the row or column 2. On the submenu displayed, click on either row or column depending on your choice. Steps in apply text alignment: 1. On the submenu displayed, click on cells 4. Locate and click on alignment on the dialogue box displayed 5. Locate degree under orientation, click on the degree type in the rotating angle you want e.
Click on OK. Steps in shading the cells: 1. Select the cells to be shaded 2. Click on cells on the submenu displayed 4. On another dialogue box displayed, click on patterns 5. Then, click on the color you want 6. Locate the arrow in front of pattern and click on it, where you will choose the pattern 7. When ascending it implies that the data will be arrange alphabetically while descending start with the last alphabet coming first.
Steps in sorting: 1. Select all the data to be sorted 2. Click on start on the menu bar 3. Click on sort on the submenu displayed 4.
On another dialogue box that appears, select the heading field you want to sort from the available one under sort by 5. Select either ascending or descending depending on your operation 6.
Steps to auto fill: 1. Keep your cursor on the cell numbering will start 2. Click on edit on the main menu 3. Select fill from the submenu displayed 4.
On another submenu that appear, click on series 5. On another dialogue box that appears, click inside the step value box to type where numbering should start 6. Click inside the stop value box, type where the numbering should stop 7.
Select where it should be filled in row or columns under series in box 8. Click on OK to complete the process. The first advantage acquire during my industrial training programme was that i was taught computer component i. Finally, my perception about office profession has been greatly widely broaden.
It gives me the opportunity to gain first experience of the profession even though it was not easy. But when formatting for currency, a dollar symbol will display and the cell will only show the hundredths place 2 decimal points , even if the actual data in the cell has is more exact and has more decimal points. The way to understand what the actual data is in a cell is to look at the formula bar. This will sometimes show you the raw data. The cell format is generally used to make thing more human-readable.
But sometimes this can be the cause of consternation, especially when using formulas. This could especially be tricky when using dates. This next section will describe how to calculate a percent change between two numbers. A percent change is calculated by finding the difference between the two numbers, and comparing that difference by the first number.
In our spreadsheet on murder weapons, we can calculate how much each weapon increased or decreased between to This formula tells the spreadsheet to find the difference of homicides by subtracting the total homicides in from After that, divides the results to the original value.
Note: The parentheses in this formula are also important to define the correct order of operations. The total number of homicides by all types of weapons declined by 9. But to make it into a more human-readable format, we can change the data format of the cell to a percentage. Click on cell:. Pass your mouse over the bottom right corner of the cell until the cursor changes to thin crosshairs. Click and drag the mouse cursor down over the rest of the cells in the H column.
Release your mouse button when you get to cell:. The percent changes for all the different types of weapons used in homicides will appear on your screen. In the formula for percent change we used in the previous section, parentheses were included in the formula:.
The parentheses in this formula are very important. These tell the spreadsheet to subtract the number of homicides in B5 from the number of homicides in F5 first , and then divide that amount by the number of homicides in B5. Finally it would subtract the result from F5, resulting in an incorrect number. So if you are doing a calculation involving several steps, it is important to include parentheses so you can group the numbers properly and the spreadsheet thus knows the order in which to do the calculations.
In our spreadsheet, for example, we might want to know what percentage of homicides involved each different type of weapon compared to a specific year. This formula tells the spreadsheet to divide the number of homicides involving firearms in F6 by the total number of homicides that year F5. So firearm related homicides were about two thirds of the total number of homicides in Good… so far. But, you might then try to apply this same formula to the cells for the other types of weapons by dragging the crosshairs, as we did in the previous example.
The problem is that when the spreadsheet copies a formula using this method, it shifts the letters for both cells in the original formula F6 and F5 as it applies that formula to other cells resulting in F7 divided by F6 in the next cell down.
To fix this, we need to force the spreadsheet to always divide the numbers for each type of weapon used by a constant number — the total number of homicides in cell F5. This is called anchoring the cell in our formula, and force the spreadsheet always to use one cell each time.
The dollar signs tell Excel to always keep anchored on cell F5 and the data in it when applying this formula to other cells. For example, in our example spreadsheet on weapons used in homicides, what if you wanted to know the total number of homicides in which did not include a firearm? To calculate that, you could add up the numbers in rows 12 to 21 for each year using the SUM formula. To use the SUM formula to calculate the number of non-firearm-related homicides in rows 12 to 21, first click on cell:.
A range has two cell references separated by a colon. Ranges can even span multiple row or multiple columns, and can be used in numerous formulas. You also can add up select numbers in a column, rather than a span of them, using the SUM formula. To do that, in the SUM formula you replace the colon with commas to separate the specific cells you want to total up. Thus if you wanted to total up only the number of homicides in in which either poison cell B15 or narcotics cell B18 was involved, you would type this formula.
This would mean adding cells B6 through F6. Now you can click the cells you want to be referenced, and they will be auto-populated into the formula. You can click-and-drag to specify a range, or click and hold down the shift key and click another cell. Monday, November 8. Adobe Spark now available to students, faculty, and staff. The Office of Information Technology has expanded its licensing with Adobe so that Adobe Spark is now available to all Ohio University students, faculty and staff at no charge.
Friday, November 5. Supervising teams across remote environments using flexspace allows for productive work and communication. Amid the transition to remote work and finding a good location to work in, employees have continued to produce good work and collaborate as a team. Thursday, November 4. Digital accessibility gains visibility in technology review process. Example is Windows server For example a Symantec antivirus, Partition Magic etc.
For example Executable files usually end in. Discuss the history and evolution of computers. Computers are used more extensively than ever for tasks such as banking, investing, shopping and communicating. Do you see this trend as having a positive or a negative impact on our society and economy?
Give reasons to support your answer.
0コメント