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 experience do you have in the use of Microsoft Office packages and other systems?
The applicant has used some applications on Microsoft Office more than others. The applicant is most familiar with Microsoft Word and Microsoft Excel.
Is there a database program similar to Microsoft Access for Linux?
They also have a developer version that you can create databases to give to anyone that will work without them having to purchase the full version. The version it creates to give away has some limitations, but it works great.
I use it for some pretty sophisticated stuff.
How do you create a documentation sheet in a workbook in Microsoft Excel?
That depends on what you mean by a documentation sheet. Excel can be used to lay out printed documents, though it is often better to use something like Microsoft Word. Although you can do tables in Word, sometimes Excel can be used to create structured document layouts in a simpler way.
In Excel how do I add a footer which is Page 1 to my current worksheet?
You can add it on the Insert tab. When you are setting it, there is an option to have a different first page for footers. So you can set it to be on the first page, and not on any other pages.
Excel inserts that show the boundaries of what will print on each page of the printed workbook.?
When you print a worksheet or use the Page Setup dialog box, Excel inserts_____ breaks that show the boundaries of what will print on each page
Tool bar icons are the various icons (small pictorial representations) that have a certain function and are located on the tool bar.
The tool bar is usually located under the menu bar. It contains various icons, that perform certain functions depending on the application being referred. These icons provide a pictorial representation of the function that is intended to be performed on clicking them.
for example : the 'back', 'forward' and 'home' icons in any commonly used web browser.
VBA is Visual BASIC for Applications. Code can be typed and it is stored in what are known as modules. So a VBA Module is just a file where code is stored that is associated with the workbook you are using. Code within the module can be run through Macros or other methods.
Is based on the relative position of the cell that contains the formula and the cells referred to?
This phrase (not a complete sentence or even a question) is so poorly worded, I can only guess at the answer of relative cell address.
What are other spreadsheet programs other than excel?
Try Star Office or Open Office, both of which are free. See the links below.
How do you copy and paste from one page to another?
To copy and paste you: 1.You highlight what you what to copy.
2.You right click and click on copy.
3.You go to where you what to copy it to.
4.You right click and click on paste.
5.And you can move it any where you what.
Or to copy the WHOLE page use:
1. Press 'Ctrl' and 'A'
2. Same as other instructions from here
columns
What function is used to calculate the future of value on an investment?
PV is used for present values and FV is used for future values.
Do you have to format a cell before you put data in it?
Not necessarily. If you are not sure how it will develop then it is better to do the formatting later as you are doing it. That way you can clearly see what cells contain data and know what way you want to format them. If you know exactly what way the sheet is going to be before starting, you could do the formatting first.
How many worksheets are present is Microsoft Excel?
Quote from the web: "According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it.) In my experience, even if you could generate a well-formed workbook with 650 sheets, it is unlikely that any Excel user would be able to open it without running into Excel's memory limit. I'm impressed that you could even get to 200 sheets without a problem, honestly. "
Can you give at least 5 non mathematical uses of Microsoft Excel?
It can be used to manipulate dates and text. It has some graphical capabilities, as you can draw things in it. You can create coloured images like flags by colouring cells. You can use it to make flowcharts and structured diagrams. It can be good for creating structured forms for printing out. It can be used to create grids. It can be used for databasing. It can be used for sorting data. It has a lot of other uses that you can come up with once you start using it.
How can you get a blocked cell number?
You go to your cellphone service provider and ask to have your number blocked. It will not show up on call display to other telephones.
This question is not clear. The answer could be a currency indicator, usually US dollars. Or, the answer could be it indicates the cell address includes an absolute address, rather than a relative address.
floating dollar sign
It is used to signify mixed or absolute cell addresses. See the related questions below.
How do you hide a column in a worksheet?
By default all cells are locked but they are still able to be edited until you choose the Tools... Protection... Protect Sheet (or Protect Workbook) menu. So what I do is to select all cells (Control + a) and switch off locking by clicking on the toolbar button that looks like a padlock. I then select the specific cells, rows and columns that I want to lock and lock them using the same toolbar button.
At this point you hide a column or range of columns (or rows) by dragging through the column headers or row labels (the grey boxes with the column letters or row numbers) with the mouse and then right clicking on the column header or row label and selecting 'Hide' from the menu that appears.
When you have done all your editing go to the Tools... Protection... Protect Sheet (or Protect Workbook) menu again. If anybody else is going to be using the workbook give a password at this point or else somebody will undo all of your hard work.
By default what is the active tab type?
which command should you use to quickly return text to the default format
How do you subtract 40 percent in Excel?
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:
=B2-B2*10%
=B2*90%
=B2-B2*0.1
=B2*0.9
=B2/10*9
