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 are the steps required to name a range using the name box?
- Highlight the range you want to name.
- Click in the name box.
- Type the name you want to call the range.
- Press Enter.
What criteria is used in the BCG analysis use?
The BCG analysis emphasizes two main criteria in evaluating the firm's product mix: the market growth rate and the product's relative market share. BCG uses these two criteria because they are closely related to profitability.
What displays a dollar sign in the far left of the cell?
It is a currency indicator. US dollars display $, EURO displays the € character, British pounds display the £ chacter, etc.
Placing the "$" at the beginning of the formatting expression will place a dollar sign immediately to the left of the output.
The expression "$#0.00" guarantees that numbers will be presented for dollars and cents, including the dollar sign.
Why is value coming up in excel?
The #Value! error comes up when you try to use an inappropriate value in a formula. It will depend on what exactly you are doing as to why it is particularly coming up. You need to know the function you are using, what it requires and what values you are using in it.
What is true program for DLL files?
C++ editor and a dll compiler, but I wouyld go with codeblocks because it has a built in dll compiler with the dll tags
hope it helps :)
Which dialog box specifies elements to be included in the function formula?
Function Arguments dialog box
Does A sheet tab display the name of a cell within a worksheet?
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
No. It can only display the name of the sheet.
How can I assign a numerical value to a text in Excel?
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
It is not possible to type in words like "twenty" or "one million two hundred and eighty two thousand nine hundred and four" and get Excel to automatically convert any of them into their numeric equivalents. It could be done on a limited basis for a set range of numbers by using something like one of the lookup functions, but not for absolutely any number.
What is horizontal axis title in Excel?
The macro recorder is giving the same code for adding the title for the X and Y axis. On the Y-axis I want 'Age' and on the X-axis 'Year', but after going through the recorder it gives this:
ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Age"
ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Year"
When the program is run, there is nothing in the X-axis title, and 'Year' in the Y-axis. How do I diversity the codes so that the correct title goes to the correct axis?
~G.
Why key performance areas and strategic control points are important to designing control system?
When designing a control system you have to focus on access. You want to limit access to information based on job titles and the need for information.
In word processing why is inserting comments feature important?
Comments can give more information about a document. They can be used for things that may not be clear and need some explanation. They can be attached to the text, assisting people who are reading it, but without being directly in the text.
Why do I need to refresh linked tables in Access?
To ensure that the data being linked to is up to date.
How do you find even and odd in Excel?
If you are referring to the Even and Odd functions, you can just start typing then or find them through the Math and Trig functions category. You can use the Insert Function button on the Formula Bar to do that. You can also do it through menus or tabs, depending on the version of Excel you have.
To find out if an actual value is odd or even you could use the MOD function, which finds a remainder. If you divide by 2 and the remainder is 1 it is obviously odd, and if it is 0 then it is even. You use the MOD function like this, where the 2 is dividing into the first value, in this case 10:
=MOD(10,2)
It could also be used with a cell reference, like this, where it is using A15 as an example:
=MOD(A15,2)
What are the advantages of spreadsheet?
A spreadsheet is, in it's most basic form, a large calculator. It's purpose is to perform both simple & complex mathematical calculations. Spreadsheets are extremely powerful and are used for 'number crunching' - (calculations on lots of figures) and also allow mathematical formulae to be applied. A good example of spreadsheet use would be to calculate sales profits for the current year which need to be presented in a graph. The range of formulae that can be applied is vast and ranging from the most basic (adding two numbers together) to complex calculations such as applying 'what if' scenarios. The spreadsheet should not be confused with a database (although it has limited database functionality) and should not be used to store mailing lists or other data records - this is a common mistake (see above the reference to somebody using a spreadsheet to create a resume). The sheet itself is comprised of columns (vertical) and rows (horizontal) which are in turn, made up of cells. It can be used for keeping small business accounting records if the company does not generate enough revenue to warrant the cost of accounting software. In short: the main advantage of a spreadsheet is when complex mathematical calculations need to be carried out on large amounts of numerical data. It's a powerful, complex calculator.
What is the basic difference between structured chart and flow chart?
the structure chart differs from flow chart in these principle ways:
1- It is difficult to identify different modules
of the software from its flow chart representation.
2- Data interchange among different modules is not represented in a flow chart.
3- sequential ordering of tasks inherited in a flow chart is suppressed in structure chart.
When would you use flow chart?
when you are sequencing actions or getting ready to write a story, letter, etc... but remember: beginning ---------------------------------------------------------------------------------------> body 1 ---------------------------------------------------------------------------------------------> body 2 -----------------------------------------------------------------------------------------------> body 3 -------------------------------------------------------------------------------------------------> closing
