0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
What Formula do you use for excel to see how many characters are in a cell?
The LEN function counts the amount of characters in a cell. For example:
=LEN(A3)
How do you centre worksheet titles across a range of cells?
Select the cell (or cells) where you want to centre (uk english) the title, right click and select format>alignment and select centre under horizontal (or you can use the menu at the top by selecting format>cells to access the same options). If you have a group of cells (eg with a number of columns below them) and you want a word centred above all of them, type the word you want in the first cell on the left, then repeat the above process and make sure you tick the checkbox where it says "merge cells"
What is the destination area or paste area in Excel?
It is called the Destination Area, and is where data is pasted after it has been copied or cut.
What is Lotus and Microsoft Excel?
Once upon a time Lotus 1-2-3 was far and away the best spreadsheet application available to PCs. A lack of development has left it a long way behind Excel in most respects, although as far as I know Excel still doesn't have 1-2-3's ability to base a chart on three dimensional data.
When can you format cells in Excel?
You format them whenever you need to. You can do it before putting data in, so that it is immediately formatted when it is put in, or you can put all your data in and do the formatting when you are finished, or you could format it as you are working. The options are always there, so you can use them at any time.
What does FV stand for in Excel?
It is a financial function. It returns the future value of an investment based on an interest rate and a constant payment schedule. So if you are paying in a set amount on a regular basis, like every month, and there is a fixed interest rate, it can work out how much your investment will be worth. See the link below for more details.
How do you get lines through your text when you type on word?
i believe that you can go onto shapes under insert and click on a line.
hope this helps :)
How are individual rows identified on a worksheet?
One answer to that is that you can have labels or headings at the top of columns or start of rows or beside particular figures as a way of identifying them. You could also mean the cell references that identify where the data is.
5 areas of learning where you can use spreadsheet?
any,you can even write and save text documents,save as .html,.txt insert pictures,links,connect to database
How do you make a cost table of the money you have to pay with Microsoft Excel?
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
What are MS Excel advantages over MS Access?
If you work on a huge number of sets of data, which you have to sort, filter, group, and create subgroups on which to calculate or extract values such as averages, medians, or/and maximums, you are better off with Access. The process of creating groups within groups and then performing calculations on those is way more cumbersome in Excel. Excel on the other hand will be better for analyzing up to a few hundred records of data. The number of records, however, cannot exceed 65536 records (Excel 2003) or 1,048,576 (Excel 2007) . This is the maximum number of records Excel can handle. It also depends on the way you want to analyse the data. Databases are good for finding relationships in data. Spreadsheets are good for crunching numbers and doing "what if" analysis (e.g. scenario models). Because of a spreadsheets two dimensional design (rows and columns), the way users use spreadsheets as combined input/storage/output systems, and a spreadsheets inability to easily establish enforceable relationship rules between rows (or columns) on the same or different spreadsheets, the true multi dimensional nature of data can be hidden from the user and/or violated by incorrect data edits. This can make analysis of data difficult if the data is stored in a spreadsheet. It is easy to extract data from a database into a spreadsheet to take advantage of a spreadsheets unique data manipulation features (e.g. pivot tables, charts etc). The real questions should be "Where do I store the data I want to analyse?" The answer to that is definitely "In a database". You can make it safe there. Then choose the appropriate tool for the analysis you want to do.
How do you title a spreadsheet excel?
Under File (upper left) drop down menu to Page Setup
Open Header/Footer Tab
Create header
Click OK
What are the standard operators in Excel?
The logical operators in Excel are as follows. < is less than, > is greater than, = is equals. <= is less than or equals and >= is greater than or equals. Not equal to is written as <>.
What is the use and purpose of the function which is average and sum in Ms Excel spreadsheets?
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
The SUM function can total up ranges of cells, or individual cells or values. For example, to sum the values in all the cells from A2 to A20, you could do it like this:
=SUM(A2:A20)
The AVERAGE function gets an average that is known as the arithmetic mean. It adds up all the values and divides by the number of values it finds. It can be used in the same way as SUM can be, like this:
=AVERAGE(A2:A20)
What does The split double arrow mouse pointer in Excel?
It is the result of moving the mouse pointer to the boundary between column heading A and column heading B, or between any neighbouring column headings. Once it is visible, it is possible to change the column widths. The column to the left is always the one that will have its width changed.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
It allows you to zoom in and out, making a sheet look bigger or smaller. You can drag the slider with the mouse to do the zoom.
What key do you press to cancel a moving border and clear a selection from the office clipboard?
Esc key
What is the difference between a spreadsheet app and a word processing app?
A spreadsheet app has rows and columns. Word processing just goes down the page.
