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
color coding
If a cell shows, then you will see it. Please ask another question using words that make it clear what you want to know.
How do you create a summary report from many spreadsheets in excel?
Use the sheet name of the other sheets in your calculations.
EXAMPLE:
- You have data on Sheet1 in cell A2.
- You have data on Sheet2 in cell A2.
- You want add the data from Sheet1 and Sheet2 and put it on Sheet 3 in cell A2.
- On Sheet3, in cell A2, put the following formula:
- =(Sheet1!A2+Sheet!2A2)
Why does Microsoft Excel not have rows and columns in rounded figures?
It is because the numbers they do use are related to powers of 2. If you start at 1 and keep doubling up, you will find many numbers that are commonly used in computers. These are used because they are associated with binary, which computers use at the most fundamental levels. Here are the first block of those numbers:
1, 2, 4, 8, 16, 32, 64, 128, 256, 512,1024,2048, 4096, 8192, 16384, 32678, 65536, 131072, 262144, 524288, 1048576.
Amongst those you will see some of the numbers for the amount of rows and columns in different versions of Excel.
What do you call an unchanging value in a formula in excel?
It can be called a constant or fixed value. If it is not a value but a cell reference then it can be called an absolute reference.
How do you combine two MID functions in an Excel String Formula?
You could use the CONCATENATE function or the & operator. The following two formulas will do the exact same thing. They both use the MID function to extract two pieces of text and then combine them into one piece of text.
=CONCATENATE( MID( A2, 2, 3 ), MID( A3, 2, 4 ) )
=MID( A2, 2, 3 ) & MID( A3, 2, 4 )
What would you select if you wanted to complete a formula without leaving the active cell?
Press and hold the Ctrl key when pressing Enter. Your formula will be entered, and the cell it is in will remain the active cell. It also has another use in that if you select a range of cells and type a formula into one and then press Ctrl-Enter, it will fill all selected cells with the formula or whatever else you have typed in, saving you having to copy it to them. The active cell will also stay the same.
Data can only be stored in ascending order?
Data can be stored in ascending order, descending order or no particular order.
What are possible limitations using macros within Microsof Excel?
What are possible limitations using macros within Microsoft® Excel
How graphical representation of spreadsheets data can be helpful in business?
Charts can be a quick way of comparing data and showing changes over a period of time, rather than having to read through lots of figures. A business can then see things like what products are selling well or whether their profits are going up or down or how big a share of the market they have for their products, and many other things. Seeing it on a chart is much faster to see those kinds of trends without having to look at the actual figures behind the charts.
Does Excel allow symbols in sheet names?
Yes, you can use characters other than letters and numbers in sheet names.
Why IZ10 is invalid cell address?
IZ10 would be an invalid address in version 2003 of Excel and earlier versions. The last column in Excel 2003 is column IV, so there is no column IZ. In versions from Excel 2007 onwards, IZ10 would be a valid cell address.
It is a comment. A comment allows you to enter some information about a cell that you are looking at. It might be something to explain the value in the cell. Placing the cursor over the cell will cause the comment to show.
C7 in an Excel spreadsheet is located in column?
It is in the third column, which is Column C. It is also in the seventh row.
What is the formula for calculating maximum in Excel?
MAX. If you had a series of numbers in the range B1:B84 the following formula would show the largest of them:
=MAX(B1:B84).
How do you import CSV file into toad?
Go to "DATABASE", select "IMPORT" then IMPORT TABLE DATA. This open a wizard so you must to select the correct information about your schema, object type and object name (table's name). After setup this, clic in NEXT button (right-lower corner).
- Now select TEXT FILE(*.txt)
- select the file clicking in the buttom ...
- NEXT
- Select DELIMITED
- select delimited= COMMA(,)
- NEXT in all the screens (according to yours parameters)
and EXECUTE at the end!
That´s all =)
Assuming that you mean the 'Insert' key on the keyboard, normally found somewhere up in the top right area of the keyboard.
This is used to switch back and forth between what are called 'Insert Mode' and 'Replace Mode'. Each time this key is pressed the computer switches from the mode it is in to the other one.
If you are typing a document and click in the middle of a word then type letters - in Insert mode the letters you type are inserted between the existing letters of the word - making the word longer - in Replace mode each letter you type will replace the letter to the right of the cursor keeping the word the same length.
The exact function may change depending on the software you are using, normal text editing software such as Microsoft Word, Word Perfect, Notepad etc all work as described - but the answers.com answer editor (used for this) does not - it always works in Insert Mode, I suspect that all Internet based text editors work like this.
How do you undo web layout on Microsoft word 2003?
If it's being pasted from a website, a small icon with a drop down arrow should show up at the bottom of the selection once it is pasted in Microsoft Word. There are a few options: Keep Source Formatting, Match Destination Formatting, and Keep Text only. If your document already has a style layout, then select the Match Destination Formatting box. If you just want the text from the page, choose Text only.
