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
If a chart is clicked on when you go to print a spreadsheet what will happen?
If you click a chart before you print the worksheet, you will print only the chart. If you want to print the entire worksheet (including the chart), click in a cell that does not contain a chart (an empty cell is the best).
How many ways to paste in Excel?
Ctrl+V
Shift-Insert
Alt-E-P
Right click and select Paste
Press your shortcut key and select Paste
Click on the Paste icon
An Excel pane is part of the window. The worksheet itself can be split into panes using the Split option. You can also freeze panes, so that one is on the screen all of the time. You also have the task pane, which is outside the worksheet, but can show other things, such as help options.
What is a budget worksheet used for?
A budget worksheet is used for a way to sort out the funds you have against the costs. It allows one to have a educated guess to how much can be completed on a particular project against the total budget - the costs of materials and/or labour.
What is the intersection of row 1 and column A referred to?
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
A1 is the reference to that cell.
What exactly does Excel training mean?
Excel training refers to the instruction of use of the Microsoft Excel word and data processing program. Including all of its basic and andvanced functions, processes, applications, and requirements.
How do you convert Excel files to a different format?
It depends on the format you want. Excel can not be converted to every conceivable file type. However, you have many choices through the Excel "Save As" option.
What info goes on a budget worksheet?
It depends on what kind of budget you want to create. As a minimum, you need to list item categories and the amount you plan to spend in each category, then include a total amount for all the categories. See related links for a basic budget format.
Cells Command
What are values that are acceptable for a group of cells?
You can use whatever values you like. A group of cells is called a range.
Example of sum of 2 no's in predefined function?
You can use the Sum function. You can do it as a range of two cells, or list the two cells or put in two numbers literally, although that is not advisable.
=SUM(A11:A12)
=SUM(A11,A12)
=SUM(43,148)
What does one use a Copy Center for?
To make copies of documents that may be singularly or mass produced. Copy Centers are machines used to print out scanned or copied materials to compile or distribute. Some have bonus features that can be upgraded to if working in a law firm or office.
When utilizing a function what does a range of cells represent?
A range can be one of the arguments in a function. It can also be an array of values. It depends on the function and what it needs to work.
To add a column to the right of the last column of an existing Word table select table then?
to add a column to the right of the last column of an existing Word table select table then
A. insert Columns to the Right
B. insert Column
C. insert Cells Column Right
D. insert column 1
How do you use excel function for Modified Internal Rate of Return?
The MIRR function returns the modified internal rate of return for a series of cash flows. The internal rate of return is calculated by using both the cost of the investment and the interest received by reinvesting the cash. The cash flows must occur at regular intervals, but do not have to be the same amounts for each interval.
MIRR(range,finance_rate,reinvestment_rate)
range = range of cells that represent the series of cash flows
finance_rate = interest rate that you pay on the cash flow amounts
reinvestment_rate = interest rate that you receive on the cash flow amounts as they are reinvested
What Microsoft Excel charts will you have to use in the career of Allied Health Science?
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
In theory you could use any of the charts in a career, so there is no simple answer to the question. The most commonly used charts are bar, column, line and pie, so it is likely you would use a lot of those. Depending in specifically what you were doing, there is a possibility of using a lot of the others too.
With a regular formula you cannot change the value in another cell. So it is not possible to have a formula in one cell that changes a value in another cell. You can reference a value in another cell. You can type the address of a cell into another cell and then using a formula you can check a cell for the address of another cell and get the value from that other cell. The INDIRECT function can be used to do this. Say you put 10 in cell C1 and then type C1 into cell B1. Then if you put =INDIRECT(B1) into cell A1, it will look at cell B1, see C1 is in it and then look at cell C1, which will result in 10 being put into A1. Another function that may be useful is the ADDRESS function, which can be used to identify a cell by picking its row and column numbers.
How did changing value affects the other part of the worksheet in Excel?
Worksheets have lots of formulas and they use values in cells. So if you change a value in a cell, any formula that uses that cell directly or indirectly can be affected by the change. How many other parts of the worksheet it will affect will depend on the particular worksheet, as each will have different formulas. Changing a value in a cell could affect one cell or many cells.
Why is interfacing of Excel with AutoCAD needed?
AutoCAD may include tabular information that already exists in an Excel-based spreadsheet. It is often used to import tables such as wire schedules (electrical), metes and bounds (civil), etc.
