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
When changing from a one column format to a two column format what does word insert?
1st answer: Active Cell
2nd answer: Section Break
What is a group of cell that form a rectangle called in excel?
The group of cell to farm a rectangular in ms excel is called list
If you need to count how many times an item is repeated in a spreadsheet what function do you use?
You could use the COUNTIF function and set the criteria to be the thing that you want to count. So say you wanted to count the amount of times the number 3 comes in a list of numbers from cells A2 to A50, you could type:
=COUNTIF(A2:A50,3)
Which dialog box enables you to specify the result cells for scenario summary report?
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
The Scenario Manager dialog box has a button called Summary which opens the Scenario Summary dialog box, in which you can specify the result cells.
What are the limitation of a break even chart?
it is not always possible to predict what will happen to revenues or costs as output increases.
It is only a forecast so in reality the figures can vary greatly. the business would need to take heed to the cost of financial accounting and the rate at which the value for money can change.
It also assumes that all products produced will have completed the whole production stage and be sold. Again, in reality, many businesses would still have stock in working progress and unsold stock; thus not showing a true representation of the data.
Sometimes it can be that the costs incurred by making and selling the product can vary so many managers find that classifying them as either fixed or variable can prove problematic.
What is the meaning and difference between Formating Cell and Conditional Formating Cell?
Formatting sets specific configurations for a cell (e.g. make the contents bold). Regular formatting is manually configured by the user for a cell or range. Conditional formatting is applied automatically, based on some predefined criteria (e.g. if the value of the cell is negative, then display in red; if positive, display in blue).
Chart paper is lines going vertically and horizontally so you can graph stuff.
What appeas when you start Excel?
At the very start you'll get the splash screen with the name of the version of Excel on it as it loads. Then you will get a blank worksheet, which will be Sheet1. You are then ready to start working on your spreadsheet.
What is are the shortcut commands for formatting toolbar?
Fonts and styles buttons
color choice buttons
How do you make a sentence in a cell come in more than one line in excel?
Right-click on the cell. Go to Format Cells>>>Click Alignment tab>>>>Click Wrap Text>>>OK
What is Actual symbol in Excel?
There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).
What happens when you use the Sum function and in the range of cells you find negative numbers?
It will still perform the calculation. The SUM function can deal with positive and negative numbers and it will deal with negative numbers correctly. So there will be no problems or errors if there are negative numbers amongst the numbers in the range of cells that it is calculating.
How do you ask questions in spanish using the preterite tense?
For the preterite form, you just need to learn the endings for -ar verbs, -er and -ir verbs.
for example: hablar: hablé hablaste habló hablamos hablasteis hablaron both -er and -ir verbs have the same endings in the preterite comer comí comiste comió comimos comisteis comieron abrir abrí abriste abrió abrimos abristeis abrieron
What is the deformity of column of bertin?
The columns of Bertin are normal structures of the kidney in the renal cortical tissue. A congenital enlargement of this area is called hypertrophy and is insignificant in most cases, but when X-rayed, this condition can be mistaken for a mass or tumor of the kidney. This presentation on the X-ray can also be called renal (means kidney) pseudotumor (pseudo means false). Other terms used to describe this congenital condition are Prominent Column of Bertin or Hypertrophied Column of Bertin.
What the print set area command is use to?
If you want to print just a part of a spreadsheet and not the whole lot of it, you can select the part you want to print and set the Print Area. It is a very useful feature if you only want to print an important part from what is a large spreadsheet, like some totals or some columns. When you have finished, you can use the setting to clear the print area which will set the setting back to normal and do a full print of the spreadsheet.
worksheet
Why would you use a line chart instead of a column chart?
You use a line chart to show changes over time, for the same value. The line goes up or down, depending on the change over time. A column chart is more commonly used to compare independent values.
Used to show the relationship of proportion of parts to a whole?
Percentages or fractions are two ways. You could also be referring to charts, particularly pie charts.
How do you copy the value in a single cell to adjacent cells on the right in Excel?
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
You can use the Fill Handle and drag to the right. You could select the cell you want to copy and a number of cells to the right and then press Ctrl - R. You could do an ordinary copy and then select the cells and do a paste.
