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
Which document is most efficiently created in spreadsheet software?
A balance sheet is very efficiently created in spreadsheet software. However, spreadsheet software has countless uses that make it very effective to use for a number of different projects.
How do I change the word to bold on excel?
Right click on the axis and choose the Format Axis option. In the dialog box that appears, in the Pattern tab you can adjust the weight of the line to make it thicker. Under the font tab you can set the text along the axis to be bold.
What happens when you hide a column in Microsoft Excel?
The column disappears from view so you cannot see it. You will notice its heading is missing, so if column H was hidden you would see column G and then column I. The values in column H can still be used in the worksheet by referencing them in the normal way. Hiding columns can be useful for hiding data that you do not want to be seen or that you do not want users to change or that does not need to be seen. It can be used to put in supporting data to a worksheet rather than having it cluttering up the screen by being visible.
What is the formula that multiples the contents of cell B4 by 18.5 in Excel?
=B4*18.5
This formula will also work in the OpenOffice and LibreOffice spreadsheets.
Does Microsoft Excel have auto column adjust?
When a referenced change the cell ,automatically updating the formulas
What is a matrix with the same number of rows as columns?
A matrix having the same number of rows and columns is a SQUARE MATRIX.
What is hyperlink and external hyperlink?
Theres not a big difference but a link is the URL of a website that you can click and a hyperlink can be put into a image or writing and clicked to take you to a website.
Hope I could help ;)
How would a scientist use a spreadsheet?
Organization believe it or not some of the smartest people in the world are not very organized.
What does point mode in Excel allow you to do?
When typing a formula in Excel, point mode lets you click on a cell or select a range of cells for use in a formula rather than typing their cell references in. This can be useful to make sure the correct cells are being selected or meaning you don't have to check the addresses of the cells to type in. So it can speed up creating formulas.
Example og upper and lower case password?
THIS IS UPPER CASE & this is lower case. So it is basically CAPITAL and small letters.
Shortcut key to jump to the last row in Excel?
To move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column, press and hold the Ctrl key and then press the End key. If you want to go to the actual last row of the entire worksheet, use the Goto command, which you can activate by pressing F5. Then you need to type in the address of the cell that you want to go to.
What is a name of a built in calculation such as sum and average called in excel?
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Excel is like a calculator, but far more powerful. You can use formulas to do calculations and you have functions which are like pre-written or built-in formulas, which is what you may be referring to.
Merge and center takes several cells that are beside each other and merges them into one large cell. The contents of this new cell will be centred. It can be used to put one large heading over a group of columns, to act as a main heading for those figures. So, for example, you could have 12 columns with sales for each of the 12 months for different products. In the cell above January you could put the heading Annual Sales. Then you could select it and the next 11 cells beside it, so that all 12 cells above the 12 monthly headings are selected. You could then do a merge and center and it would make one large cell with the heading in the middle of it.
What-if analysis.
The first step in creating a chart is to?
Normally the first thing that is done is that the data is selected. Then you would start the Chart Wizard. However, it is possible to start the Chart Wizard first and select the data later.
When does Excel assign the SUM function to cells next to numbers?
It you select the blank cell under a column of numbers or a blank cell at the end of a row of numbers and hit the Autosum button it will enter the SUM function and select the cells above in the column, or to the left in a row. Pressing Alt and the = key will also do the same thing. If you select the column or the row with the numbers and click the button or do Alt and the = key, then it will also do the same.
How do you delete rows and columns from am Microsoft Excel table?
many a time you may require to add a row of data or a coloumn of data which you forgot to enter earlier .excel proveides you the facility to insert rows or columns onto the sxisting worksheet very easily .it is that inserting a row of data will shift the rest of the rows down and cause the ladt row of the worksheet ,the rest of the columns shift right ,if there is any data in the last row or column of the worksheet that will be lost .
What is the extinction of PowerPoint and Excel?
You are referring to the the extension. For Powerpoint it is PPT and XLS is used by Excel.
How do you do a nested formula in Excel?
The short answer is that you can not, but there is a solution that will work for you. You are not able to automatically insert data into a cell from another cell; that would be a push of data, which Excel does not do. However, Excel can pull data from a cell.
- Put your formula in a cell. Use A1 for this example.
- Write another formula in the target cell to reference the value of A1. Use B1 for this example.
- In B1, put the formula, =A1 to show the value of A1 in B1.
****this is not going to work for my prob dude.. check out discussion tab for more about my question, please. Please, please... please. :) need more help..
How do you modify the selected cell so that the text automatically wraps around in Excel?
Press Ctrl - 1 to open the Format Cells dialog box. Click on the Alignment tab. Click the box beside Wrap Text so that it is ticked. The click OK. Whichever cells were selected will now have the Wrap Text formatting applied. Text that is too long will wrap around in the cell.
Why do you rotate text in Excel?
For style reasons. You might want the text in the corner cell of a table to be at an angle for example. You might want titles for columns to vertically. It could be done to enable you to narrow the width of a cell. Often it is purely for effect, maybe to enhance a set of data and distinguish the titles a bit more.
