Microsoft Excel

A relative reference in a formula will change when it is copied.

There are 10000 litre/hectare in 1 litres per (square meter). So you would divide by 10000.

So if the value was in B2, the formula would be:

=B2/10000

You can't do that. What you do is use borders. Put borders around the cells you want. Then print the document with no gridlines, and the borders you have will be printed.

It really depends on what you want to do when you say you want to remove characters at the end. Factors like how many characters you want to remove would be important to know. There are various functions that would be of use such as LEN, LEFT, RIGHT and MID, amongst others. As a random example, say you have text in E9 that you want to trim and then remove just the last character from, you could do this:

=LEFT(TRIM(E9),LEN(TRIM(E9))-1)

It gets the trimmed version of the text, finds its length and starting from the left takes the amount of characters that is one less than the length, and so leaves out the last character. Whatever text you put into cell E9, regardless of its length and how many spaces are around it, it will achieve its purpose. So by using some of the Text functions available in Excel, you could do something like what you are saying. You just need to experiment with the functions and then combine them, as in the example.

The MOD function finds a modulus. That is the remainder when you divide one number into another. So if you divide 10 by 3, you would get a remainder of 1. To do that with the MOD function, you enter it as:

=MOD(10,3)

When a pivot table is active, you can show its toolbar in older version of Excel and in the new versions the Pivot Table tools will be on the ribbon. Standard formatting, such as fonts, can be applied with the normal formatting options available in Excel.

=COUNT(cells)

Cells can be the reference to the cell range you want to count. Say you want to count values in the cells from A2 to V20, then you would do it this way:

=COUNT(A2:V20)

They are very usable because users can quickly click on the icons they want to do a particular task. Toolbars normally group related items together in a logical manner so that you have different toolbars specifically for different kinds of work. It is also possible for a user to customise a toolbar to have the particular icons on them that they need. Toolbars can be turned on or off as needed, enabling most of the screen to be for the worksheet, instead of being cluttered with all the toolbars that Excel provides.

Yes, whatever row or rows are selected are where the new row or rows will appear. The existing row or rows will be pushed down.

First select the table or cells. You can then choose the Format options or Autoformat options or style options. These will enable you to change whatever you need to change in your worksheet.

For any function, what is inside the parentheses are known arguments. For the SUM function it is normally a range, you can have more one range in a SUM function, and also individual cells and values. So you could have something like this:

=SUM(A2,10,A14:B20,C66)

Ideally have the names in the first column of your data. Then select the column that has the names in it and the other columns. The active cell should be in the first column. Then go up to "Data" on the toolbar or the Sort and Filter options. You can select to sort alphabetically. If the Names are not in the first column you can use the Advanced sort option and choose it as the column you want to sort on when all of the columns of data are selected.

Validation is the feature that can limit what is entered into cells in Excel.

Sum gets the total of a list of values, Average gets the arithmetic mean, Min the lowest value and Max the highest value. All functions work on list of cells or ranges. So they are all implemented in a similar way. Given a range from A2 to A20, you could use them as follows:

=SUM(A2:A20)

=AVERAGE(A2:A20)

=MIN(A2:A20)

=MAX(A2:A20)

1. Select the top cell of the column.
2. Go to Insert/Symbol.
3. Select Wingdings from the Font drop down list.
4. Double click on the arrow you want.
5. Close the Symbol window.
6. Change the character color to green at Home/Font.
7. Select the position within the cell that you want the arrow at Home/Alignment (Left/Center/Right and Top/Middle/Bottom).
8. Select the entire column by clicking the box above the top cell.
9. Fill down (Ctrl+D).

Decorating a spreadsheet could be formatting it, like setting colours for some cells or putting in borders on some cells. You can also change the size of text or bold it. You could add in some simple graphics. While doing these things can make a spreadsheet look nice, it should not be overdone. Also, the most important thing about a spreadsheet is that all the formulas work and the results are accurate, not how it looks.

You have to format the cell(s) in order to convert military time automatically over to standard time. In Excel, click on Format on the toolbar, then select what you want to format, then under the number tab find time and select how you want it to show up.

You can delete the actual row by selecting it and using the Delete rows option. That will also delete the data. If you just want to get rid of the actual banding and keep the data, you can select the rows and change the formatting, and set it to be the same as the other rows.

A spreadsheet that you create and save with Excel is an example of a file.

There is no definitive answer to that. Normally text labels are aligned to the left, particularly at the start of rows. Over columns they may be centred. However, there are no set rules, so you can align them the way you want as long as it is clear and consistent.

Go to the Format Cells option and to the Number option. Press Ctrl - 1 to access Format Cells. You can use Ctrl-Shift-1 to apply the thousands formatting too. Another option is to click on the comma icon.

There are many sorts of financial records, but Excel is designed to deal with numbers. It has many specialised financial functions along with the normal functions that would be used with numbers. If you know what you want to store you can create worksheets to store the data that you want in the way that you want. It will depend on the specific data you want to keep as to what way you would store it and lay it out.

The Glycemic Index Chart provides a measure of how quickly blood sugar levels rise after eating a particular type of food. The effects that different foods have sugar levels are huge.

You could use the ABS function which takes a number and ignores its sign, so it can turn negative numbers into positive ones. So for example, the following will result in 5:

=ABS(-5)

You can also put a minus before a minus number to make it positive:

--5

You need to have a good understanding of it and if you don't there are errors that can arise. If you need multiple IF functions you may have to nest them and this can get very complicated and you may not get all the correct results, though some parts will work. You need to thoroughly test it. In some cases using an alternative, like VLOOKUP of CHOOSE will work better, though it depends on the nature of the particular problem you have.