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
No. The COUNT function counts only numeric values, including dates and times. It will not count cells with text or logical data or blank cells. COUNTA will count all kinds of data.
You can put borders around cells by pressing Ctrl - 1 and going to the border tab. You can also put an outline around an individual cell or around the area of a range, by pressing Ctrl - Shift - 7.
Where can one get free data download?
It would depend on the type of data needed. Stock data for example can be downloaded from chart oasis. Data on the Landsat program is available from NASA.
Where could one find a Scottrade Center seating chart?
There are a few places where one can find a Scottrade Center seating chart. This includes the site for the Scottrade Center, as well as ticket vendors such as TicketMaster.
How do you return within a cell in an Excel sheet?
Type the first part of what you want, then press the Alt-Enter key combination and you will be brought onto a new line and then you can continue typing.
Can Access and Excel be integrated?
They can be integrated and work together in many ways. Data can be copied between them, or imported and exported between them and links created between them. A lot of the functions found in one, can also be found in the other. There are lots of things that both can do.
What is the importance of Microsoft Excel in management information system?
Microsoft Excel is for numerical analysis and manipulation, so they are dealing with numbers all of the time. Numbers of all sorts are important in a Management Information System. It could be sales or wages or profits or a range of other things. Data can be presented in all sorts of ways, as tables of data or in a wide variety of charts. Different values can also be changed to see what the effect is, which is very useful within a Management Information System. It will give the managers the information they need to make decisions.
Does Open office include Word and Excel?
It does not include Word and Excel, but it has its own word processor and its own spreadsheet.
How do you use vlookup in spreadsheet?
VLOOKUP(Lookup Value,Lookup Table,Column Index)
It looks in the Lookup Table for a column whose first column contains the Lookup Value and then moves down the column according to Column Index and returns the value of the cell. The values in the first column of Lookup Table can be text, numbers, or logical values. They must be placed in ascending order: 0, 1, 2, ...; A-Z; FALSE, TRUE. If it can't find lookup value, it uses the largest value that is less than the lookup value.
The three parts of it are:
Lookup Value: A value to search for.
Lookup Table: The range of values to search through and return a value from.
Column Index: The number of the column of the value to be returned.
Set up a table as follows with the following values in the following cells:
C1: 0
D1: 10%
C2: 250
D2: 25%
C3: 1000
D3: 30%
C4: 5000
D4: 48%
For the VLOOKUP, in the the cell A6 put the following formula:
=A5*VLOOKUP(A5,C1:D5,2)
Lookup Value: A5 which contains the value 10
Lookup Table: C1:D5 Values in Column C are the values to be searched and those in D are returned.
Column Index: 2. The second Column in the range, in this case Column D.
It takes the value in A5 which is 10 and checks the values in column C for a match. In this case it does not find an exact match. The largest value lower than it is the 0 in cell C1. It then moves to the corresponding value in D1 which is 10%. This is then multiplied by A5 giving the value 1 in cell A6. If A5 is changed to contain 1150 it would multiply A5 by the 30% as 1000 in column C would be the highest value lower than 1150 and its corresponding value in Column D is 30% as 1000 is in C3 and 30% is in D3.
Should Excel functions be part of a developer's knowledge?
They would not need to know all functions, but they would need a good general knowledge of Excel's functions, beyond an ordinary user. Depending on the kind of developing they are doing, they may need to be particularly familiar with some categories of functions. For example, they may need a particular familiarisation with financial functions if they were developing for financial spreadsheets in Excel.
Where can flow charts be downloaded and printed out?
A flowchart is a tool that shows a sequence of steps within a process, one can download software from the internet on to a personal computer that will enable a person to download and printout their flow charts.
When you remove the boundary between two cells in a table or worksheet you are BLANK the cells?
merging
How do you input trigonometric functions in Microsoft Excel?
You can use the Insert Function button and choose the Math and Trigonometry category. From there you can pick the function you need and enter it in. All the main ones are there.
You can enter in the radians using the PI function. So to get the SINE for 45° you would enter it as follows:
=SIN(45*PI()/180)
You can also use the RADIANS function:
=SIN(RADIANS(45))
What is the key you use in Excel to group multiple worksheets?
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
The Ctrl key.
How can a spreadsheet be used to model data?
Yes because you can create pivot charts and pi charts as well
All the data should be put in a single worksheet and that worksheet can be specified when the mail merge is being made, so it doesn't matter if there are more worksheets.
What are other types of files that can be imported into Excel Can you list at least one or two more?
Microsoft Access files or text files.
What function is used to total table values that meet a specified criteria in Excel?
The SUMIF function.
What function do you use to calcutate the overall percentage of total in Excel?
There isn't a particular function that is used, but you could do it with a simple formula. Say the total was in cell A20 and the figure that you want to find as a percentage of the total was in A5, then you could enter the following formula into a cell and format the cell as percentage:
=A5/A20
What is a document or file in which information is permanently stored in Microsoft Excel?
A workbook.
What are fill patterns in Excel?
You can use Fill Patterns to fill in things like cells or parts of a chart etc. Instead of using a standard colour you can have the fill with patterns such as diagonal lines or dots or chequered patterns and so on. You can also mix the colours for these patterns.
Is it true that you need to be familiar with Excel to be able to create a chart?
You would need to know a little about it to create charts, but not a lot. It would depend on the kind of data you are working with and the kind of chart you want to create. You could use the chart wizard to quickly create a chart, once you have your data in.
What is ribbon used for and can it be purchased in bulk?
Ribbon which can be bought in bulk or regular lengths can be used for multiple purposes. The primary uses are as a decoration for small home craft style projects and decoration of presents.
What is an appropriate name for a macro in Excel?
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
You would base that on what the macro is doing. You should give it a name to indicate what it is for. Default names like Macro1 don't tell you what the macro will do. A macro called FormatCurrency is likely to be formatting some values to currency, so it is more obvious to a user when they see that name. A macro that underlines headings could be called something like UnderlineHeadings. So what is appropriate would depend on what the macro is doing and the name should give some indication of that.
