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 overlay a chart legend?
If you click on a chart legend you can drag it to wherever you want around or on the chart.
How do you work out averages on excel?
Mathematically, the average is the sum of all values, divided by the number of values there are. This is known as the arithmetic mean. You can get it by using the Average function, which is the simplest way. Another way would be to the spreadsheet to total the values and count the amount of values and divide the total by the amount of values. If you were trying to get the average of the cells from A1 to A100, you could either do:
=Average(A1:A100)
or
=Sum(A1:A100)/Count(A1:A100)
Using the Average function is the best way. There are also two other forms of average, other than the arithmetic mean. They are the Mode and Median. The Mode is the most common value in a list and the Median is the middle value when all are arranged in numerical order, although you don't have to do the sorting yourself as the function is able to work it out. They are done as follows:
=Mode(A1:A100)
=Median(A1:A100)
This is not a question; it is not even a complete sentance. Please ask again using words that indicate what you want to know. Also, ensure you put it in the correct category, so you can get a meaningful answer.
Does an argument take a value or values and perform an operation in excel 2007?
Yes, arguments combine values, but since this test question is not a very good one, the correct answer probably is no. The "approved" answer most likely relates to functions. Some arguments are optional, depending on the function and how you are using it. Others will put in default values if you don't specify one.
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
What are the functions of the hindlimbs?
The hindlimbs primarily serve several key functions, including locomotion, support, and balance. They enable animals to walk, run, jump, and swim, depending on the species. Additionally, hindlimbs play a role in various behaviors such as grooming and climbing, while also providing stability and strength during activities like standing and turning. In some species, they may also assist in reproductive activities or territorial displays.
As you drag the fill handle you will see?
The fill handle is a tool used in Microsoft Excel. It has various uses in terms of the way it can copy things, so you may see different things on different instances of you using it. As you drag the fill handle, you will see an outline of the area that is to be filled. You may also see values in tip text form beside the fill handle. When you stop dragging, the cells will be filled and you may then see the Autofill icon beside the fill handle.
How do you use Autoformat-copying data columns and rows?
Create your table first. Then select the table, including headings and formulas and Autoformat can be applied from a variety of styles. Newer versions of Excel have much wider choice and will also give you a preview of how it will look before applying it. You can paste formatting from the table to other columns and rows subsequently if you are extending the table. Use the Format Painter tool to do this or Copy and Paste Special and pick Formats.
Does a conditional format in Excel make negative numbers red and positive numbers black?
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
Not necessarily. You can use one of the standard formatting options to that. There would be no need to use Conditional Formatting. You can get Conditional Formatting to do it, but you can use it do change positive and negative numbers to whatever colours you want or apply other formatting to them.
How do you change the shape of the edges of a 3-D chart in Excel?
After starting up Excel you should load up the file required, highlight the whole of the chart, click on the format tab at the top of the screen to find the formatting options. After this you should select the 3-D format option, then select the options to select the size, depth and color. Then use the close button to close the formatting area and return to your 3-D chart.
Use conditional formatting
Can data allow you to change the way data appears?
You can have what is known as Conditional Formatting, which can change the format, depending on the value.
What would be a good way to change the color of a bar or pie chart?
Right click on a slice and pick Format Data Series. From there you can choose the colours you want.
On Excel can you insert more than one table in the same worksheet to manage several groups of data?
Yes. You can link to multiple sources at the same time.
In excel 2007 how do you decrease by 2 percent?
Multiply your value by 0.98 or by 98%, which in effect reduces it by 2%. So if the value was in cell A3, in another cell you could have either of these two formulas:
=A3*0.98
=A3*98%
If you have a lot of cells to do, there is another way. Put 0.98 into a blank cell. Then copy it and select the cells that you want to convert into 98% of their original values. Right click on the mouse and on the shortcut menu that appears, pick Paste Special. It will bring up a large dialog box. In the middle section of it, under Operation, click the radio button beside Multiply and then click OK. All the values will be multiplied by 98.
See the Related Question below for other ways of using percent formulas.
How is access better than Excel?
You can't really compare them, as they are for doing two different jobs. Access is for creating databases. Excel is for creating spreadsheets. It is possible to do simple databases in Excel, but Access is better at doing databases, so that is one way you would say Access is better. However, Excel is better for doing calculations and though you can do a lot of calculations in Access, Excel is better in that area. So you pick which one is suited to whatever you need to do.
What does minimum mean in Excel?
It refers to the lowest value. You can get it in a formula using the MIN function. To get the lowest number in the cells from A2 to A10, you would do this:
=MIN(A2:A10)
Minimum can also be used in specifying the scale on a chart. Normally it is zero, but it can be set to any number that may be appropriate for the values you are charting.
A business worksheet is a tool used to organize and analyze financial data, project plans, or business strategies. It typically includes sections for income, expenses, forecasts, and key performance indicators. By consolidating important information, a worksheet helps business owners make informed decisions, track progress, and identify areas for improvement. Overall, it serves as a valuable resource for planning and managing various aspects of a business.
Does anyone have an AFL tipping Excel spreadsheet?
Yes I have just made a AFL Spreadsheet. You can try it here.
http://members.iinet.net.au/~cstranger/AFL/AFL-Tips.xlsm
Cath
PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule.
PMT(interest_rate,number_payments,PV,FV,Type)
interest_rate = interest rate for the loan
number_payments = number of payments for the loan
PV = present value or principal of the loan (amount to be financed)
FV (optional) = future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.
Type (optional) = indicates when payments are due. Type can be one of the following values:
0 = payments due at the end of the period (default or if value is left out)
1 = payments due at the beginning of the period
