answersLogoWhite

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

Why you use mollier chart in mechanical engeeniring?

the Mollier chart gives the values of a property say enthalpy by defining any other two properties i.e. dryness fraction,pressure like this any two fixed values can provide the other values.

In Excel is Goal Seek usually a faster approach to reach desired data results than a what-if analysis?

They are not really for the same thing. Goal Seek is used to find a specific value that makes a formula give a particular result. It gives just one single result. If you have a formula that you need to give a particular result and a value for another cell used by that formula needs to be changed to get that result, then you use Goal Seek to obtain that value. Goal Seek is used to look for a single result rather than to give many results.

What-If Analysis has a much broader purpose. It is designed to see what results you get when you use different values for the same set of formulas. It could be doing things like seeing how much profit you can make by paying different pay rates and using different amounts of staff and selling different amounts of products at different prices. So it can be used with many values and many formulas. Goal Seek can be used as part of What-If Analysis.

What does Excel use to keep a cell reference constant?

a $ sign before the letter and/or number for example to always keep the cell reference F45 use $F$45. If you only want to keep the Column the you use $f45 and for the Row F$45

How do you multiply the contents of the cells in a column by the tax rate in a cell?

  1. In cell A1, enter the label TAX RATE.
  2. In cell B1, enter the label AMOUNT.
  3. In cell C1, enter the label TAX.
  4. In cell D1, enter the label TOTAL.
  5. In cell A2, enter the tax rate (numbers). Format the cell as a percent.
  6. In cell B2, enter the amount you want to calculate.
  7. In cell C2, enter the formula =A$2$*B2.
  8. In cell D2, enter the formula =B2+C2.
  9. Copy cells C2 and D2 as far as you like down the columns (for this example, to row 10).
  10. Enter the rest of your amounts in column B.
  11. In cell B11 enter the formula =SUM(B2:B10).
  12. Copy cell B11 to cells C11 and D11.

What are step to calculate the average of a cell range using the autosum tool?

Select the cells you want to get an average of. Go to the Autosum tool and click the little arrow beside it and pick Average from the list of options. It will automatically insert the formula into an adjacent cell, usually the cell below the figures you would have selected. You could also go to the cell where you want the result to be first and then click on the Autosum tool and pick Average. It will start the function and at that point you can select the range you want to get the average of, or type it in.

What is an example of a formula with a 3-D reference?

A 3d reference refers to a worksheet, a column and a row, to identify a particular cell in a workbook. The following is a simple example, where the worksheet name is in the reference and is followed by an exclamation mark before the cell address:

=Sheet1!A3 * 10

Point out the step to edit formula in cell.?

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

Click on the cell and then press the F2 key. You could also double click the cell. Using F2 has the advantage of always bringing the cursor to the end of the formula.

How can you set the home key in Excel to go to A1?

Go to Advanced Options and click the "transition navigation keys" check box under "Lotus Compatability"

Why have you lost Excel shortcut menus?

They probably were turned off for some unknown reason. If by shortcut menus, you mean, "Mini Toolbar" in Excel 2007, you do the following to display the Mini Toolbar:

  • Click on the MS Office symbol (circle in top left corner).
  • Click on Excel Options (bottom, toward the right side).
  • Click on Popular (top of left-side menu).
  • Click in the box to place a checkmark in front of "Show Mini Toolbar on selection."
  • Click OK.

In what row with the active cell B1 be after you insert a new row?

If you insert a new row above B1, the cell contents will move to B2 in the second row. If you insert a new row below B1, the cell contents will not move.

How would you calculate percentages for students marks on Microsoft Excel i?

Set up a formula that divides their actual score by the maximum score available. Then format that result as a percentage. So say they had a maximum score of 60 and they scored 45. If the 45 is in cell B3 you could put a formula in cell C3 as follows:

=B3/60

In this case it would give you 0.75 which if formatted as a percentage will give you 75%. So put all the scores of students in one column and in the first cell of the column beside it, put the formula that divides their score by the maximum. Copy the formula down for all others and format them as a percentage.