Microsoft Excel

You can click and drag from one cell along a row, down a column, or to the opposite corner of a rectangle to select with a mouse. When doing a formula you can select cells in that way after you start typing a formula. So to add all the values in the cells from A2 to A15, you could type:

=SUM(

Then you could either type the cell range, or select the range with the mouse. The completed formula would be as follows no matter which way you do it:

=SUM(A2:A15)

blank worksheets

The VLOOKUP function works on the same principle as HLOOKUP, but instead of searching horizontally, VLOOKUP searches vertically. VLOOKUP searches for a specified value vertically down the first column of an array. When the value is found, VLOOKUP searches across to a specified column and enters the value of the cell. The syntax for the VLOOKUP function follows the same pattern as HLOOKUP, except that instead of specifying a row index number, you would specify a column index number to instruct VLOOKUP to move across to a specific column in the array where the required value is to be found. =VLOOKUP( lookup_value , table_array , col_index_number ) In the case of VLOOKUP, data in the first column of the array should be in ascending order, as VLOOKUP searches down this column for the lookup_value.

The xlsx file extensions are from Excel 2007 whereas xls is used in the earlier versions of Excel.
Thanks

YES

split windows

There are many ways a formula can go wrong. There can be an error that won't let the formula be accepted by Excel due to an error in the way you type it, like leaving out a bracket, which results in an error and you will get an error message.

A formula may be accepted but the calculation results in a problem, like trying to divide by zero, which is mathematically impossible. That will result in an error message.

A formula may give a result which is not what you want, and you may not even notice. For example you might have the plus instead of a minus in the formula by accident. This kind of mistake will not give an error message. The formula is not what you want and is wrong from your perspective, but it is a perfectly valid formula so it will give a result. These kinds of errors can go unnoticed for a long time. This is why it is very important to check all your formulas carefully and to test them to see that they give the results you want.

This would be the MAX function.

=MAX(A1:A12)

You can also use the LARGE function, with 1 specified as the position to find. 1 specifies the largest, 2 the second largest, 3 the third largest and so on. LARGE is best used when it is not the highest value you are looking for, but it still can be used to find the largest. It can be done like this:

=LARGE(A1:A12,1)

No. It appears in the title bar at the top of the screen.

Click on the row or column header you want to delete. Then right click and pick Delete.

You could start by building up some essential basic equations / algorithms

with data input boxes to change variable values.

eg

build equation for area of a circle (a = pi * r2), but refer to seperate cell for value of radius

cell a1, type in: 0

cell a2, type in: = 3.141592654 * (a1)^2

cell a1 contains the radius, install any value, then a2 reveals the area

typing in a new value in a1 automatically overides the previous value.

cell reference or cell address

A spreadsheet software is a program or application that is used to organize, analyze and store information in a digital worksheet. This type of application is commonly used in financial computations and documentations.

high responsibility

In Access, a row from a spreadsheet is normally a record.

You multiply it by 0.75, exactly as we used to do it before

anyone had ever heard of Excel, or of Microsoft.

_______________

If you have a value, say in cell A1, then you can put the following formula in cell B1 to do this:

=A1 * 0.75

In many. Failed in many too

There are many things you can do. Try not to duplicate figures and formulas that are getting the same thing. Use one set of data to generate all your data. Sometimes people will put the same data on two sheets, and do different sets of formulas for them. They should just put the data once and use that for any calculations to do it. Some complex spreadsheets would seem to be easier if data is duplicated, but it is best to only have the data once. There are lots of potential problems, like errors when copying the data, or if the data has to be changed, that it is only changed in one place and not another. The Scenario Manager can be used to reduce the amount of duplication needed.

To make spreadsheets more efficient you could also look at your formulas. Some formulas could be combined. Some could be done in a simpler fashion. It is good to show lots of figures that have been calculated at each stage, but sometimes it is better to combine formulas. Look at different ways of getting information from your data, like using pivot tables. Using named data sets, through the Name Manager, can make formulas easier to create and understand and that can help efficiency.

One of the most important things to do is to plan your spreadsheet before you even start it. Then you will know how it is going to be done and you can avoid some of the inefficiencies that creep in through not having thought out how it can be done. There are many other things you can do too. A lot will depend on the specific spreadsheet itself.

You may see an error box telling you you have not entered the correct arguements. You also could receive a variety of error displays. Some are: #DIV/0!, #NAME?, #VALUE!, #SYNTAX?

the h stands for horizontal lookup and the v stands for vertical. assume you have two columns and you want to know if there are any names in them that are the same. You can use v look up to tell you how many repeats there are. You can also do that with rows, but you use h lookup. ALso this function can be used to find a certain aspect about a item iin a table.

active cell

This question needs more context in order to be answered; it contains a question referring to a multiple choice list which is not included in the question. Try re-phrasing the question.

Highlight the cells you are interested in merging .. make sure you are on the "home" tab (found at the top of the excel program), and choose the down arrow beside merge & center in the "alignment box". there you will find the option to merge & center, merge across, merge cells, and unmerge cells ..