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 is the difference between a cell height and a cell width in excel?
Cell height is how high the cell is from bottom to top. Cell width is how wide the cell is from side to side.
What shortcut key do you press to unfreeze column and row titles?
There is no shortcut key to do this, but you can press Alt + W + F + F in Excel 2007 to access menu options to toggle between freeze and unfreeze panes. (I do not remember if this same sequence works with Excel 2003; you might just have to press F one time in Excel 2003.)
In relation to spreadsheets what does SOAP stand for?
It does not really have anything directly to do with Excel. SOAP stands for Simple Object Access Protocol. It is a protocol specification for exchanging structured information related to Web Services in computer networks (usually used with the Internet). It uses eXtensible Markup Language (XML) as the primary messaging format.
Since Excel 2007 uses XML-based files, I suppose it would be easy for a SOAP programmer to uncompress and extract data from the Excel file. I am not aware of any major applications that do this, but it should be possible.
What is called Spreadsheet software; the features you mention in your question are a function of the applications macros being organized to complete a particular task and Lotus 1-2-3 will not do such goal seeking without the End-User (you) writing and/or designing such a macro.
You need an application like SmartDraw or SmartDraw Viewer.
See related links for information about SmartDraw.
How do you multiply cells with text and numbers in excel?
Normally, you do not. I recommend you put text and numbers in separate cells. You can modify the width of columns and join cells to format almost unlimited layouts on a spreadsheet, so there is no reason why you need to combine text and numbers in the same cell. Another option, is to enter the numbers as a separate entry in another column. You can hide the column, so the numbers do not show in the view or a printed report.
If you have an absolute requirement to combine text and numbers in a cell, you can extract the numbers with a custom macro. The algorithm would be to cycle through all the characters of the cell and save only those characters that are numbers, then copy the numbers to a separate cell where you can perform calculations.
What are different types of worksheets?
There are as many different types of worksheets as you can imagine. Please ask another question that is more specific.
How do you get cheque print with Excel?
This question is not clear. If you are trying to use Excel to print cheques, you may be using the wrong application. However, you can format Excel to print in almost any format you need. I suppose you could put the data for each cheque on a separate page, then configure the page and the print options to match what you want to output. A more specific question will get you a more specific answer.
How do you create a conditional format that will indent the data in a cell?
You do not. Text alignment is not an option available for conditional formatting.
table
Use the freeze panes option.
less than (<) and greater than (>)
If data is collected that is way different than other data collected what is it called?
You may be thinking of 'anomaly'.
How do you apply a thick bottom border to a worksheet?
Format the appropriate cells with a thick line along the bottom or top of the cell (your choice).
What Excel function calculates the future value an investment based periodic payments?
FV( interest_rate, number_payments, payment, PV, Type )
How do you insert rows in Excel 2007 past IV?
Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.
