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
Select Contacts in the To book drop-down list box
Ensure the worksheet is located before Sheet2
In the Employees workbook, open the Move or Copy dialog box
Open the Employees workbook
What was the Excel multiplication bug?
It caused some multiplications to return erroneous results. The multiplications included 77.1*850, 5.1*12850, and 10.2*6425. They should return results of either 65,535 or 65,536 but in Excel 2007 they returned a result of 100,000 instead.
Which happens when you enter the formula equals B 11 into a cell?
B11 is not a formula. It needs to have an equals sign before it like this:
=B11
If you do that, then the value in cell B11 will be assigned to this new cell. For example, if the cell B11 shows a number 34.5, then the new cell will show the same number. The formula itself cannot be put into cell B11.
The Merge Cells option.
Sum is the main one, but you can also use Count, Average, Max, Min, Product, Count Numbers, StdDev, StdDevp, Var and Varp.
What does filling mean in Excel?
It is a way of quickly putting in a series of values rather than having to type them in individually. If you type the name of the day of the week into a cell, and then start to drag down, Excel will automatically start to put the following days in. The same will work for months. You can do similar things with other kinds of values and even set up special lists yourself.
Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
Can an Excel file be locked so it cannot be printed?
The only thing you can do is hide the relevant sheet (from the design menu choose - sheet - hid) and then lock the entire workbook.
Otherwise - whatever you can see on the screen can be printed.
For more excel tips got to excel-tip.com
What are Some of the ways to format numbers is to use?
Under the Home tab in 2007/2010 Excel you have Number. Clicking on the lower right selector arrow under that shows the various ways:
Number (decimal places and + and - numbers)
Currency (Including symbols besides US currency, decimal places and + and - notation style)
Accounting
Date (various forms)
Time (How you want it notated and 12 or 24 hour clock)
Percentage
Fraction
Scientific
Special and Custom
How do you copy a cell to a range of cells. For example copy a value in A1 from A2 - A2000?
By Copy and Paste
If you highlight the cells which need the same value, copy from Cell (A1) and then highlight all the cells which need the same value and Click paste
Voila!
Why would you use round up and surflan together?
Surflan is a pre-emergent herbicide and will not control emerged weeds. Round-up is a post-emergent herbicide and will not control weeds that have not emerged. The use of the two together controls weeds that are already present and weeds that have not yet emerged, at least for a period of time dependent upon the rate of application.
What is angshudhi in reference to the Bharatanatyam?
It is the overall co-ordination of the body movements in reference to the established (correct) trajectories. The "cleanliness" of moves, or how perfect your moves are.
How do you associate an xls file extention to Excel?
When you are saving a workbook in versions of Excel up to 2003, it will automatically assign that as the extension. If you specifically want it in versions 2007 or 2010, which normally use xlsx, then you need to use the Save As option. Dong so may possibly lose you some features of your spreadsheet as you will be saving it in an older version. So that is something you need to be aware of, though for most standard ones it will not have any major effect.
How do you calculate deduction in Excel?
There are various ways, depending on the type of deduction, or if you want to get the actual deduction or the total remaining after. You can get a percentage and take it away from the amount. For a 10% deduction you could do this to get the deduction, where the initial value is in A2:
=A2*10%
To get the total remaining after the deduction:
=A2-A2*10%
Or you could do it this way:
=A2*90%
If you know the fixed amount to be taken off, say 150, then you could do this:
=A2-150
You could calculate all the deductions and then use the SUM function to add them up, if you are looking for total deduction.
If it is individual deductions like tax, insurance, pension etc., they can be individually calculated and then added together to get the total deduction for the person.
What does an arrow at the bottom of a group header of the Ribbon tell you?
There are more options for that menu group.
How do you control the appearance of data in a Excel worksheet?
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
By using the many formatting options that are available within Excel. There are basic formats such as size and colour; particular data formats such as currency, percentage, date, time; autoformatting and conditional formatting.
Can you use a period character in the file name of an Excel file?
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
You can, but it is better to avoid doing so if at all possible.
What usually starts with equals signs and what the calculations for each cell?
A formula starts with an equals sign. A formula can be a function or contain functions with other aspects of the calculation.
=B10+B15
=SUM(A2:A20)
=MAX(A2:A20)+100
=MAX(A2:A20)-MIN(A2:A20)
