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 effect does the insertion of rows at the top of a spreadsheet have in excel?
It will push down all rows below it, renumbering them and changing the formulas as necessary.
HLOOKUP
Where is the enter box in Excel?
The Enter box is the green tick that appears beside the formula bar when you are entering or editing a cell.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
Subscripts are when values in text are put below the normal text, like when specifying bases in mathematics. It is the opposite to superscripting, where values are above the regular text, like st following 1 to specify first. The st is normally smaller and higher than the 1.
What button copies multiple formats from selected cells to other cells?
The button that you can use to apply multiple formatting style to selected cell is called format painter (the icon is a little brush on the "standard" toolbar). The way it works is as follows:
1/ select an area of the spreadsheet that already have the formatting that you want to use.
2/ click on the format painter button on the standard toolbar.
3/ select the area of the spreadsheet where you want to copy the formatting.
That's all.
Note that if you want to apply the same formatting in several places, you can double click on the format painter button in step 2/ instead of a single click. Then you can do step 3/ several times. When you are finished, click again on the format painter button to deactivate it.
What will Excel do if printing a broken chart graphic?
It will just print it, possibly blank if no data is available.
What do you put on your inventory spreadsheet?
You should put the amount of each product on the spreadsheet. You should also list the item number, so that you can order items that are low.
By using reverse calculation method one can calculate the missing figures with the help of provided figures by starting from known cost of good sold and moving towards upward and with the help of know or given amounts unknown amounts can be calculated.
An alignment chart is another name for a nomogram, a mathematical diagram in which the relationship between three variables is represented by a straight line or curve for each variable.
What function do I use to get percentage in most items in spreadsheet?
You can get the percentage of something in relation to another thing without using a function. You can do it with a simple division formula. If you have two numbers and you want to find what percentage the smaller one is of the larger one, then divide the larger one into the smaller one. You are basically finding how much of the larger number goes into the smaller one. So if you wanted to find what percentage 458 was of 1030, you would divide the 458 by 1030, and format the result as a percentage. You can do it directly or use cell references. So directly, it would be:
=458/1030
If 458 and 1030 were in the cells B3 and D3 respectively, the formula using cells would be:
=B3/D3
What are the styles of cell referencing?
There were two styles of cell referencing.
A1 reference style where the columns are labeled using the alphabets and the rows are labeled using numbers.
R1C1 reference style both the rows and columns are labeled using numbers.
Note: try to search on ask.com or google.com for more info... :)
How do you format a cell in Excel to currency with two decimal places?
Press Ctrl-F1 to open the Format Cells dialog box. The Number tab should be open. Click on Currency on the left and in the right set it to 2 decimal places and then click OK.
What pair of brackets can be used to override the precedence of the operators in Excel?
Parentheses or round brackets ( and ) override operator precedence.
What factor determines how the labels and values look in Excel?
Their formatting. You can set many different formats for cells, like different number types or different fonts or different colours for the cell or the contents.
What is the formula to calculate 149.99 minus 30 percent in Excel?
There are lots of ways of taking 30% of 149.99 away from 149.99. It is also the equivalent of getting 70% of it. Assuming the 149.99 is in cell A2, then any of these formulas will do it:
=A2 - A2 * 30%
=A2 - A2 * 0.3
=A2 * 70%
=A2 * 0.7
