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
combination chart
What is a predefined formula that adds all the numbers in a selected range?
=SUM(range) or
=SUBTOTAL(9,range)
What is two ways you can organize your data?
1)you can do scientific notation. 2)you can observe with different things.
How do you add two months if both or equal in excel 2007?
You can add the values of two cells that have dates or months, but adding dates doesn't serve any useful purpose.
Can a function assign the same output value to two different input values?
Yes. If you have a function that squares a number, the output will be the same for both positive and negative input of the number. e.g. 22 = (-2)2
Or if you use a boolean:
If test > 0
return True
test can be equal to 1 or 2 or anything else
What is meant by a spreadsheet model?
A spreadsheet model is the model (the type) of the spreadsheet.
- how it looks like.
Electronic spreadsheet was the very first microcomputer application ever invented?
No. There would have been other ones before it, like word processors.
How to read and write Excel Files with Perl?
http://search.cpan.org/~jdb/Win32-OLE-0.1709/lib/Win32/OLE.pm This link has a great example of accessing the Excel API using Perl.
Auditing is the process of checking formulas and the spreadsheet in general to find errors and correct errors. It enables you to do things like find out if a cell is being used by another formula or find out what cells a formula uses. This enables you to ensure that cells that should be included in a formula, like when you are totalling a range of cells, are included. It can also help identify cells that are in a spreadsheet with values that are not being used. This could enable you to correct formulas that should include a cell, or get rid of cells with values that are not needed. It also may help to define more efficient formulas and simplify a spreadsheet.
What does the ROW function do in Excel?
It gives you the row part of a cell reference.
=ROW(D3)
This will give the value 3, as that is the row part of the cell reference.
Well normally it depends on how much people buy them.
What does a Cholecystectomy treat?
A cholecystectomy is performed to treat cholelithiasis and cholecystitis
What is the term used to denote a film that was written and directed by one person?
You just named it. That is how they title it in a film.
How do you change date format?
go to the command prompt and give the date command
using the proper format and then restart the computer
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
What is the control center in a PowerPoint in Excel?
There is no PowerPoint control center in Excel. MS PowerPoint is a presentation application. MS Excel is a spreadsheet.
What formula in Microsoft excel would compute a total cost with tax?
=SUM(A1:A12)*.065 [assumes A1:A12 contains the purchased items and the tax rate is 6.5%]
How can you convert Excel to HTML without losing interactivity?
You can not. You can write a custom Web page using PHP, JAVA Script, or some other language to replicate a spreadhseet, but you can not import an Excel spreadsheet into an HTML document and retain interactivity.
What does a data series contain?
It is data that can be used in a chart. It can be values that are in cells in a worksheet.
