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
Can you insert images into Excel worksheets?
Yes. It will sit on the worksheet, like a text box or other graphic does, not in a cell. You can use the Insert options or just a cut and paste of the image.
Fill destination area with contents without formatting?
Copy the range you would like to use. Move to the new location. Instead of just using paste, select Past Values. This will fill the destonation area with the values of the original cells, without also filling with the origin formats.
What is the difference in cell references and cell values in excel?
A cell reference is the address of the cell like A1 or B20 or C45. A cell value is what is actually in the cell. So in cell A1 you could have 23, in B20 you could have 190 and in C45 you could have 3461.
How do you delete a sheet in word?
Right click on its tab, and there are several options, including one to delete the sheet.
What is the default file format of Excel 2003 and 2007?
Default file format for Excel 2003: .xls
Default file format for Excel 2007: .xlsx
Note: You can't open lower version file format in upper version. If you want to do this then you will have to download the compatibility pack.
What are the uses of spreedsheet?
A spreadsheet is a collection of rows and columns, which are used to organize data in such a way that the arithmetic operation can be carried out on whole rows of columns extremely quickly.
- to use spreadsheets as modeling tools
- plan, design and create a database
- The benefits of a spread sheet include the fact that you can make formulas and work out complex sums easily.
How do you edit items in entire column in Excel?
To make changes to an entire column in excel, click on the column heading (letter at the top of the column) and make your desired changes.
EXAMPLE (Make all text in column C align center):
- Click on the column "C" at the top of Column C. [This will highlight the entire column.]
- Click on the BOLD text formatting option. [You might need to click two or three times, if some text is bold and some is not.]
- Observe that all all text in Column C is bold.
What are the two components that functions generally consist of in Excel?
All functions have a name and have brackets just after them. So they could be said to be the two main components. For some functions it is mandatory to have something inside the brackets. These are usually known as arguments. For functions that do have them, there are some arguments that are mandatory.
HOW TO CALCULATE variance EXCEL?
Coefficient of Variance (CoV) is a non-dimensional value calculated by dividing the Standard Deviation of a data set by the algebraic mean (or Average) of the same dataset. Thus CoV = STDEV/AVERAGE. So, in Excel, at the bottom of a column of numbers representing your data set, say in cells B39 to B58, make cell B60 = AVERAGE(B39:B58), B61 = STDEV(B39:B58) and B62 = B61/B60. CoV is frequently expressed as a percentage, so B62 could be = 100*B61/B60
How would you write this formula in Excel?
*Note: You have probably forgotten or got an answer for this years, ago. The reason your question has taken so long to answer is that you put the description into the Answer area, meaning the question was deemed to have an answer in it. A description should go into the discussion area. Your original question and an answer are below.
[Extra Information -
I have an excel problem and I need a formula to perform the task. Here is the situation: I have two tables in excel; a table full of dates and a table showing the week numbers. I have been given some dates in this format "28/01/2010". I need excel to work out which week number (in the year) this date falls into and then put a "1" in that week row.
For example: if I get given the date "28/01/2010", excel will look at that date and put a "1" in the week 4 row because that date is found in week 4 of the year. If then I get given another date: "25/01/2010", excel will add another 1 to the week 4 row, meaning week 4 row will display "2". All together, I have been given lots of different dates and I want excel to sort all the dates into their corresponding week numbers within the year. This is ultimately to create an automatic system where the dates can be typed into a excel table, and then they can be turned into week number type form in the other table.
I hope this is clear enough. :)]
You could take a different approach. Use the WEEKNUM function to work out which week a date is in. So if the date you wanted to find the week for was in cell A2, beside the date you could have =WEEKNUM( A2 )
Then you could use the FREQUENCY function to help set up a frequency table to show how many dates are in each week. This would have to be done with an array function. Without seeing your actual set of data, it is impossible to give specific cell references. You would set up a column with the week numbers, having just the number, so 1 for Week 1, 2 for Week 2 etc. In a column beside that, you would have your FREQUENCY function to calculate the amount for each week, based on the source data from the set of week numbers that you have calculate. You will need to do a little research on the FREQUENCY function and also on array formuals.
What is a developer tab in Excel?
The developer tab allows you to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. It is a relatively advanced tab which you would likely benefit from reading up on before using.
See the Excel help file for further information (click the help icon and search for "developer tab").
When you insert a worksheet in the active worksheet in the active tab it appears where exactly?
The new worksheet will go in before or in other words to the left of the current worksheet.
What is the use of showing grid lines in Excel?
It makes it easier to see where things are and to pick out cells and their references. It is also easier to see the widths of columns and heights of rows, especially when they have been changed.
Go to View Tab; Then go to Windows Group; Click " Freeze Panes"
What keyboard shortcut is used to show formulas in a worksheet?
Press and hold the Ctrl key and then press the `key. Make sure it is the `key and not the ' key. It is on the key in the top left corner of the main part of your keyboard.
Excel is a spreadsheet developed by Microsoft but is by no means the first spreadsheet. The very first spreadsheet was developed (or invented) by Dan Bricklin and Bob Frankston called VisiCalc. VisiCalc was a spreadsheet written to operate on the Apple II computer and was released in 1979. The program was sold to Lotus who developed Lotus 123 from the VisiCalc principle. Lotus 123 was released in 1983. Excel, first released in 1987, is a development of the early spreadsheets and therefore cannot strictly be classified as an invention. Excel is far more powerful than VisiCalc but that is also a result of development over the years that Microsoft have been working on the product, and the increase in computing power. Dan Bricklin and Bob Frankston never patented the product because software patents were almost unheard of in the 70s.
What is the function AutoComplete list in Excel?
Autofill allows you to identify a series of data and automatically fill cells with the appropriate text.
For further information about how to use autofil in Excel please see the related links.
It is a style.
What copies a formula in excel?
If you need to do the same task repetitively, you copy a formula to do it. When working on a spreadsheet you commonly need to do this. You may be calculating wages for one person, and when their wage is calculated, you would copy the formulas used to do the calculations for other people. You could have a list of sales in a particular month. You may want to add all of them or get an average, and then do the same for other months. Once you have the first formula done, it can be copied to do the same for all of the other months, saving you having to do each month individually.
Why do you use IF functions in Excel?
One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If the value does meet the condition, one result will happen, if false, a different action will occur. Some people shy away from using this versatile function because of its apparent complexity. By doing this, they are missing out on one of the most useful functions available in Excel.
=IF(logical_test, value_if_true, value_if_false)
=IF(D1 < 26, 100, 200) Breaking the example down into its three parts we have: logical test: D1 < 26, ("<" means less than)
value if true: 100
value if false: 200
Breaking it down further, it basically says:
If Cell D1 is Less Than 26, Enter 100 in this cell, otherwise enter 200.
What does the Control key allow you to do in Excel?
Pressing the Control key itself does not do anything in Excel. It is when you combine it with other keys that you can do a wide range of things. Some of the most common are Control - C to copy, Control - X to cut, Control - V to paste, Control - B to bold. Combinations with other letters do things too. You can also used Control in combination with other keys, not just letters. Control - 1 will open the Format Cells dialog box. Control - Home brings you back to cell A1. There are lots of others.
Using keyboard shortcuts is very useful and once you get used to them you will find that you can use them a lot and that they are often quicker than using the mouse, even though people think it is slower and more awkward. So if you want to get good at using Excel, learning about using shortcut keys is one thing that is very useful to do. The Control key is just one of the keys that you can use with others for shortcuts.
How do you change chart style on Microsoft Excel?
When a chart is active or selected, in the menu or on the ribbon, you can choose one of the other types of charts and convert it to that type. Not all charts are compatible with each other, as some need certain combinations of data or a set amount of series, so the charts won't always change as expected.
When copying or moving formulas in an Excel worksheet the default type of cell reference is called?
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
A relative reference.
How do you spell out numeric value of currency in English words using Excel?
I have written step-by-step instructions on how to spell out numeric value in words using MS Excel macro in the below blog:
http://grvishal.webs.com/apps/blog/show/7424633-how-to-spell-out-numeric-value-of-currency-in-english-words-using-excel-add-in-
