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
I would use the left and right functions to split up the address into 2 separate columns and then sort on column 2
What is the difference of Microsoft Excel from lotus 123?
One is a spreadsheet program made by Lotus the other is a spreadsheet program made by Microsoft. The main difference is the way in which formulas are entered - in Excel they are preceded by the = symbol and in 1-2-3 they are preceded by the + symbol.
Has anyone had issues converting macros or pivot tables from Microsoft Excel 2000 to Microsoft xp?
4740830 call 4 gay sex
What arithmetic operator directs excel to perform multiplication?
The asterisk * character is used to multiply two values. For example =3*4 entered into a cell will display the product 12. If you use cell references (like =2*a1) then the cell will display 2 times the value in cell A1.
What symbol in Excel refers to cells not wide enough to display the entire entry?
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
The # symbol.
How do you copy a column of numbers from Excel that are calculated with a formula?
Highlight the column of numbers. Copy with either the menu selection or ctrl-c. Go to where you want to paste the column. Go to the menu selection Paste Special. A box will pop up, select Values.
Why would a bookshop use spreadsheet?
For all sorts of reasons. Spreadsheets are used for numeric calculations and analysis. This is what businesses have to do a lot, and a bookshop is a business. So they could use a spreadsheet to do things like:
Keep a track of their sales.
Keep a track of how many books they have.
Produce charts of their sales.
Calculate their best selling book by seeing what one sells the most.
Categorise the books, to see how many they have of certain types of book.
Work out the costs of running the bookshop.
That is just a tiny amount of the things a spreadsheet can do for a bookshop.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
First put the values you want multiplied into cells. Then put 2 into a cell. The select and copy the cell with the 2. Then select all the values you want multiplied. Go to Paste Special and choose Multiply on the list of options and click OK. All the values will be multiplied by 2.
If you have given the data a name, there is no point in referencing them by the row and column. You could but, why would you want to?
How do make a smiley face on Excel?
Go to Insert and Symbol and you will find the smiley face in the Winddigs character set.
How do you select a group of cells in Excel with keyboard commands?
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
There are various ways. Pressing any of the direction keys while holding down the Shift key will do it. So pressing the right arrow and the Shift key will start selecting cells to the right for example.
The End key can be used in a similar way, to select a block of cells that already have values. So for example, click on a cell in the middle of cells with values. Press the End key. Then press and hold the Shift key and press one of the arrow keys to select from the current cell to the last of that block of cells with values.
Pressing the F8 key will change to a select mode and then pressing the arrow keys will start selecting cells. Press F8 again to turn off that mode.
What is the function of the cell format controls in Microsoft Excel?
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
The cell formatting allows you to change a large amount of formatting options, such as number formats, text formats, alignment, size, colours, borders etc.
How can you eliminate excess row height in a spreadsheet?
You can double click on the border of the headings of the row, to set the row height to a best fit. You can also manually drag it to narrow it.
What does SHIFT 4 do in Excel?
IT GIVES YOU $ BUT WHAT DOES IT DO IN EXCEL? The dollar signs $ can make the cell reference absolute =$A$1 is absolute reference, if you dragged the formula it will always be A1 =A1 is relative reference if you drag the formula the reference will change accordingly
Programming with Vba for Microsoft Excel?
Microsoft Excel has an option to program the repitative task.
What is the purpose of the Compatibility Checker and saving in a backwards-compatible file format?
It has to do with who will be using your files and what versions of the software they have. Virtually all major software packages, including Microsoft Office, are backward-compatible, which means that you can work with files that were saved in older versions of the software. However, you often cannot open files saved in newer software versions if you are using an older version. For example, in Excel 2007, in addition to the normal Save function, you also have the option of saving your workbook as an Excel 97-2003 file. Both the normal save and the 97-2003 save have their drawbacks. If you save your file normally, you are limiting the range of your audience, because people using older versions of Excel won't be able to open it. If you save it as a 97-2003 version, you are limiting what functions you can use to make the file look and behave the way you want. Obviously, every new software version has more "bells and whistles" than the previous version. By saving as a 97-2003 version, you are limiting yourself to only the functions that were available in those older software versions. When using a newer Excel version and saving your workbook as an older format, the Compatibility Checker will let you know what characteristics of your workbook, if any, are not compatible with the version in which you are trying to save it. Of course, if your file is only for your personal use, you need not concern yourself with the 97-2003 save option. BTW, you can tell which Excel files are compatible with Excel 97 etc. by the file extension. Files saved in newer Excel versions and that are not compatible with the older versions have four-letter extensions instead of three-letter. For example, for regular Excel files (not templates, no macros, etc.), older versions have the extension .xls, and newer versions have the extension .xlsx.
yes
What symbol would you use to multiply two numbers on a spreadsheet?
On a spreadsheet you use the * symbol rather than x as used normally in mathematics.
Which end of a mattress is the header or footer?
The head of the mattress is the end where the side panel ends are sewn together, and this is where the "law tag" is sewn in. The side panels and foot end of the mattress should show no vertical seams. Unless of course the mattress is a very low quality piece.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
That is correct.
What identifies the cell by row number and column?
Cell address or cell reference. Example: B12 is a cell in row 12, column B.
