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
How do you calculate the median using Excel?
The median can be calculated using the Median function. Assuming the values you wanted the median of were in cells B2 to B20, you could use the function like this:
=MEDIAN(B2:B20)
How can worksheet be connected with database?
Before proceeding with the following steps, name each range of data that you want to use as a table, and then make sure you then close the workbook in Excel. For information about naming ranges, ask the Office Assistant in Excel aboutdefining names for ranges.
- In theData Link Propertiesdialog box, click theProvidertab, and then clickMicrosoft OLE DB Provider for ODBC Drivers.
- Click theConnectiontab, and underSpecify the source of data, clickUse connection string.
- ClickBuild, and then do one of the following:
If you already have a data source set up for the database you want to connect to, double-click the name of this data source, and then skip ahead to step 9.
If you don't have a data source set up, click theFile Data Sourcetab in theSelect Data Sourcedialog box, and then clickNew. - In theCreate New Data Sourcedialog box, clickMicrosoft Excel Driver, and then clickNext.
- Type an identifying name for the data source, clickNext, and then clickFinish.
- In theODBC Microsoft ExcelSetupdialog box, in theVersionbox, select the version of Excel that was used to create your workbook file.
- ClickSelect Workbook, and use theSelect Workbookdialog box to locate and select the .xls file.
You now have a data source set up on your computer to connect to your Excel database. In the future when you connect new PivotTable® lists to this database, you won't have to repeat the setup steps. - ClickOK, and in theSelect Data Sourcedialog box, double-click the name of the new data source you just created.
- ClickOKto return to theData Link Propertiesdialog box.
- On theConnectiontab, underEnter information to log on to the server, do one of the following:
If you want users to enter a login name and password to access the data in the PivotTable list when they open your Web page, type the login name in theUser namebox and type the password in thePasswordbox.
If you don't want users to have to enter a password, type the login name in theUser namebox, type the password in thePasswordbox, and select theAllow saving passwordcheck box.
If your workbook does not require a password for access and you don't want users to have to log in, select theBlank passwordcheck box, and then select theAllow saving passwordcheck box. Leave theUser namebox blank. - If you want to verify that the connection you've set up works, clickTest Connection.
- ClickOKin theData Link Propertiesdialog box, and if prompted about saving the password, clickYes.
- In theProperty Toolbox, underUse data from, clickData member, and then select the named range that contains the data you want to display in the PivotTable list.
How to Remove a range of cells after selecting it?
To remove the contents, just press the delete key. You can also drag the fill handle back up over the selected cells and it will also remove the contents. To remove the cells completely, go to the Edit menu and pick the Delete option and pick the option you want on the dialogue box that appears. The Delete option will also appear on the shortcut menu if you click the right mouse button.
Why do accountants use spreadsheet?
they use spreadsheets because they like to eat jam and stick it up their bum. their bum becomes all jammy and they prefer peanut butter in their testicles but what they don't realise is peanut is infectious and makes dinosaurs come back to life to eat your testicles.
How do you use bold button in Excel 2003?
Select the cell you want to have bolded. Then click on the Bold button. The content of the cell will be bolded. If it is empty, when you do put something into it, it will be bolded. To turn bold off, click on the Bold button again. You will be able to see if it has been pressed or not. You can also use the Ctrl - B shortcut key combination to turn it on and off.
What does the f8 function do in Microsoft Excel?
It is a way of allowing you to select cells with the keyboard. If you press F8 and then start pressing the arrow keys, you will find it starts to extend the selection. Shift F8 can be used to help you to select non-contiguous cells. Alt-F8 can be used to run Macros.
The Ribbon.
In Microsoft Excel addition and subtraction are considered to be on the same level of?
They are on the same level as each other. Mathematically, addition and subtraction have equal precedence and are done in a left to right order. Microsoft Excel is designed to follow the rules of mathematics, so they have equal precedence.
Switch rows and columns in Excel?
Columns and rows can be swapped by transposing them. You can copy a row of cells and using Paste Special and the Transpose option the data can be put into columns. You can do the same with data in columns and transpose them into rows. There is also a Transpose function in Excel.
There is no "Calculation" tab in Inernet Explorer.
What is an input form in Excel?
When data is in a table a form can be used to enter the data and it will add a new record to the table. This can be accessed from the Data menu or tabs.
What type of graph is excellent for showing the percentage of the sources of income for a family?
pie graph
How do you convert a scanned image of numbers into an Excel file?
If it is an image, then it cannot be converted. As far as the computer is concerned it is a picture, not individual digits. You would have to have something scanned as text in order to be able to use the text and digits that are in it. Try scanning the document in text mode. That is not a guarantee that it will pick up the numbers, as it depends on their clarity. If it does scan them in, they may not be laid out as you want them. However once you have them as a text document, then you can try to open them in Excel. Even then it may not work out right. You may have to comma separate the original text document, to indicate the break between the numbers in order to put them into the right cells, So if you have 23,14 the 23 will go into one cell and the 14 into the one beside it. As you can see all of this can be messy and may not come out as you like, so if there aren't too many numbers in the original image, you could be better off and quicker to just type them in.
What are normative reference group?
žNormative Reference group refers to groups that influence broadly and define values or behavior (Schiffman & Kanuk, 2010).
How do you create a gantt chart in Excel?
See related links for templates and an instructional video related to using Excel to create a gantt chart.
Is the zoom function in Excel same as Word?
They allow you to zoom in or out of a worksheet or document, so they are essentially the same.
How do you change xlsx to xls if YOU dont have xlsx?
Google 'Compatibility Pack' and Download and install FileFormatConverters.exe from Microsoft Homepage.
Is it ms-Excel is a caculator?
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Microsoft Excel can be used as a calculator, but it can do far more than that. It can do anything a calculator can do, so it can be used for that purpose. It does a huge amount of things that a calculator cannot do. So it is far better than any calculator.
Where is the scroll bar located on an Excel worksheet?
There are two of them. The vertical scrollbar is up the right side of the worksheet. The horizontal scrollbar is across the bottom of the worksheet.
