Unanswered | Answered

Microsoft Excel

Parent Category: Microsoft Office
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.
Quickest way is to click the red "X" in the top right corner of window. If the worksheet needs to be saved, you will be prompted to save, if you like. Answer: The actual quickest way is to press alt and f4 at the same time on your keyboard, it will also prompt you to save.
There are two different ways to turn your laptop off. For you, thebest method would probably be to hit the power button on yourlaptop rather than to hit the shut down option in your start menu.Unless there is an update or you need to sync files to a server,there is no real need for the complete...
The data source is located in Excel. The main letter is in Word and the addresses for each custom letter come from Excel.
Double click the y-axis, then from the Scale tab select  'Logarithmic scale'    To create custom "gridlines" see    Flexible Log Scale
hopefully your answer can be found here    Excel Tips and Tricks - How to Automatically Download Index Data  from NSE - Part One  
Generally, a financial model consists of one or more input  parameters along with data and formulas that are used to perform  calculations or make predictions. By changing the values of the  input parameters, you can do "what-if" studies to see what happens  when the inputs change.
   The  default pointer shape; appears in most Excel workspace  contexts  Moves  cell pointer or selects a range of cells      Appears  when the pointer is on the border of a window  Adjusts  window size      Appears  when the pointer is between a row or column...
Multiplying Two or More Numbers in a Cell   =2*12      Multiply Different Cells     =A1*A4(after entering data in A1,A2,A3,A4)   
SUM adds a range of numbers. EXAMPLE: Find the sum of the contents of cells B1 through B32. =SUM(B1:B21)You also can combine several ranges to get a single sum.=SUM(B1:B12,B34:B42,D13:D43)
LEFT - Align all text even at the left margin, while letting it remain ragged on the right. RIGHT - Align all text even at the right margin, while letting it remain ragged on the left. CENTER - Align all text to center between the left and right margins, while letting it remain ragged on the...
There is no clear answer of your question, but as per my knowledge excel represent calculation thats why this software named MS excel.
They are short for "Excel Spreadsheet."
An Easter Egg is a term used for a hidden item in a computer programme. Up to version 2000 of Excel, there were hidden games in them. From Excel 2003 onwards they are no longer there. To find them there is usually a long-winded process to be gone through.
You can save Excel in many different formats. To save as HTML you select File|Save As. When the Save As window opens, look toward the bottom of the window for the "Save as type:" drop down. From the drop down selection click on "Web Page (*.htm; *.html). Navigate to the location in the Documents...
The number symbol (#) indicates that the content of the cell is wider than the cell can display. Increase the column width and you will see the cell contents, instead of ##########.
MS Excel icons just search on google for answers
An I-beam is a cursor on the mouse that makes it look like a  capital "I". It happens when the mouse goes over highlightable  text. When you mouseover text, the cursor changes its look, the new  'I' look is called an I-beam pointer.
There are many types of people that we would be likely to associate with using Microsoft Excel. Lots of people in the areas of business, that are dealing with numbers every day, would use them a lot. Scientists, mathematicians, students, teachers, accountants, investment managers, shopkeepers, small...
Go to the Format Menu and pick Cells. Then pick Alignment. Then go to the Orientation section. From there you can adjust the orientation of a word to whatever you need.
In Find and Replace, use the Replace All option.
Beecause your "CAPS LOCK" key is depressed. Tell it a funny story & it will cheer right up!
The name is "merge and center", which combines all highlightedcells. For newer versions of Excel this is on the "Home" tab.
Functions basically establish relationships between expressions.Many common Algebraic functions are expressed as functions of x: f(x) = x2 + 4 Which could also be written as y = x2 + 4 However, this just scratches the tip of the universe. Not only domathematical functions vary in complexity and...
Models are simplified representations of real things and situations. They can help you picture in your mind what the real things look like and how they act. Toy aeroplanes, for example, might be used to show how real planes might fly in formation. A working model of a steam engine might show how...
They can contain anything an ordinary document in Excel can. So cells may be pre-formatted. There may be text or dates or numbers etc. already in some cells. There may be some formulas there. Cells may have borders and shading. Basically the template is done in such a way that the user can open it...
As you type, Excel displays the entry in the FORMULA BAR, and also displays the active cell reference int he Name box on the left.
The most common reason for doing it would be to be able to fit larger text, like a big heading into a cell in the row.
The simplest way is to press the F1 key. You can also access it through the Help menu. If you have the Office Assistant visible, you can also click on it.
GOAL SEEKING -- You can use the Goal Seek facility.
While holding down SHIFT, press END (near home, insert, delete, etc.). Then press DELETE or BACKSPACE.
The file formats natively used in any spreadsheet program is .xsl  or .xslx
Assuming you are talking about the cell address F5, it means the cell is located at the intersection of column F and row 5.
Set the column to an exact new width you specify as a number of charactersClick the right border of the column heading and drag it to increase the widthUse the AutoFit feature to change the column width automatically
Altough one can use Chart in excel to do this one but the main problem is the scale of the drawing produced. So CAD section drawing is the best. For some sample program for this one see related links.
Electronic spreadsheets are used almost in every office these days.
Use absolute referencing, but following the column letter or row number with the dollar sign. EXAMPLE: The relative cell address D23 can change relative to other cells when you insert or delete rows or columns. The absolue cell address D$23$ always remains the same.
An effective use of conditional formatting is to automatically highlight a cell if the total drops below a specified limit, such as stock price.
Because it makes showing a chart or graph much easier. Also, if you know how to use it correctly, you won't have to do any math on your own.
Yes. Try the Microsoft Website.
You can use MAX to evaluate a list of thousands of sales transactions to determine quickly which day had the largest single transaction. You can use the MIN function to compare hundreds of wholesale costs to determine the lowest cost for a particular item.
There are many things you can do. Try not to duplicate figures andformulas that are getting the same thing. Use one set of data togenerate all your data. Sometimes people will put the same data ontwo sheets, and do different sets of formulas for them. They shouldjust put the data once and use that...
All charts need titles. It helps others to work out what is going on.
It depends on what you mean by 'display nuberic data.' The simplest way would be to type numbers in a cell, so you can see them on the screen.
You do not. Background images can not be printed. However, you can add a background image to a header and play around with the positioning to accomplish the same task.
Normally, you should not experience too much of a delay. Sometimes exiting all applications and rebooting your computer, then going back into the application after the computer has started again will solve the delayed-response problem experienced by some Windows computers. Some other causes for a...
Might updating relative references when formulas are copied ever produce the wrong result
Relative cell references will change automatically to refer to the relative location of the original cell in relation to the destination cells. Strictly speaking there will be no change if you are using full relative addressing, meaning having the row reference and the column reference locked by...
It is an inbuilt function and it stands for vertical lookup. Suppose you have two worksheets with information on for the same person. On each worksheet you have an identifying reference number for each person. Now suppose you wanted to use some of the information stored on worksheet 1 in worksheet...
It is at the top of the page below the line where it says  reproducible page.
Documentation sheet describes the content of each worksheet within the workbook. Summary worksheet shows the total amount sold, consolidates the data from each worksheet.
Use the ROMAN function.In cell C2, enter the formula =ROMAN(B2)In B2, type the number you would like to convert.In Cell C2, observe the roman numeral.
There are at many types of entries you can make in a spreadsheet: text, numbers, dates, times, logical data(TRUE & FALSE) and formulas.
Highlight what you want, then without lifting your mouse, move it to where you want. Click on my name below for the subject, I'm a computer whiz.
I pulled up a map on Google, but couldn't find "row" street, or  "Column" avenue, did you maybe misspell the streets? Best regards.
The default format that Excel applies is normal text (no bold, etc.) with no color in the background of the cell. Numerals are formatted as Integers and justified right. Letters and special characters are formatted as text and justified left.
A cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) refers to a cell or a range of cells on a worksheet and can be used in a formula (formula: A sequence of...
1. Touch typing. 2. Sustainable rhythm3. Thinking about what you're typing.4. Proper posture5. Ergonomically correct typing/computer station6. Keyboard shortcuts7. Practice, practice, practice
This is a very complicated function that assumes you have reliable data to input. Recommend you use the Solver Add-In. See related links for specific details about Solver and an example of how to use it with test data (including the formula to use in Excel). If the Solver is not installed on your...
I don't think you can because what if your looking for an spicfic one and that's why you need many hyperlinks
If you only want to print the current screen you see on your monitor, press the Prt Scr button, open MS Word, and paste the image to word. Play around with the page orientation and margins in your Word document to configure it to accomodate the image (recommend Landscape orientation with .5" margins...
It is normally on the right side of the window.
Format the cell(s) as currency and ensure the currency is set to dollars The currency format can do that. As there are many currencies in the world, in different countries where the dollar is not used, a computer can be set to use a different currency symbol and it can also be done directly in...
Not really. Just copy and paste or just paste formulas.
No. There are many ways of doing it. You can use the fill handle to drag formulas. You can use the Ctrl - C and Ctrl - V keys to cut and paste. Alt - E - C and Alt - E - P can also do it. You can right click on a cell and pick Copy from the shortcut menu to copy and do the same to paste. You...
See the related links for a good source for questions and answers about MS Excel.
There is no ruler bar in MS Excel. That is an MS Word function.
Go to page setup and select the Sheet tab. . In the Print section, click in the box in front of Gridlines. . Click OK, then print as you normally would.
In MS Excel you would use the cell format feature.
Initially it is just Book1 and it will have Sheet1 opened in it first. It only uses those names because no other names have been given. It is the same in other applications, like having Document1 in Word for example. When you go to save the Excel Workbook it will give you a chance to give it the...
All cell references are unique, that is the purpose of a cell reference (the intersection of a column and row). EXAMPLE: A1 is unique. There is only one cell that is at the intersection of column A and row 1.
There are a lot of different steps in a financial modelling build up, starting with laying out the structure of your model in Excel and building in some assumptions. See the related links (further down this page) for the detailed steps to take.
There are two ways to express exponents in Excel. . =6^3 . =POWER(6,3)
to move the insertion point to the beginning of data in a cell what do you press?
You can not enter a number starting with zero, since Excel will  automatically discard any leading zeros as insignificant digits in  a number. However, you can enter a string of numbers starting with  zero if you format the cell as text.    You can format a cell as text two ways: 1) use the...
I'm not going to be able to list all the pros and cons of Excel but I'll have a go. Advantages of Excel include automatic calculations of values, graphs, macros, simple tables, and can be used to make simple checking systems if you know the program. The biggest problem with Excel is that there is so...
  the Order of operation is:    divide    multiply    subtract    adding
Microsoft excel is used in Banks for filing accounts and storing data involving numerical data. Its very useful for banks..........
It can have various affects, depending on how you to do it. Excel will decrement the series if you also press the Ctrl key. It can also create a normal incrementing series. If there are values already in the cells, it will erase them.