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

Where do saved files stored in Excel?

The files are saved on your hard drive or on whatever storage medium you select. Excel is very obedient and will put the files where ever you tell it (even if you don't remember where you told it to put the files).

Which columns are used to calculate TRIR rates?

days away from work, job transfer or restriction and other recordable cases

In a spreadsheet what is the formula for running totals?

There are a few ways of doing it. Say for example you have a list of numbers in the cells from A2 to A15, and you want to show a running total in column B. The formula in B2 will simply be:

=A2

In B3 you would want to add the total in B2 to the next value in A3, so you would have the following formula:

=B2+A3

That formula could then be copied down through all the cells to B15, giving you a running total.

Another way of doing it is using absolute references. You would put the following formula in B2 and copy it all the way down to B15:

=SUM(A$2:A2)

As it is copied down the A$2 will remain the same, but the A2 will change. So in each formula, you are summing always starting from A2 but down to the current row. This gives you a running total.

How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?

You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.

What is the shortcut key to highlight the entire column in Microsoft Excel?

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Ctrl and the Spacebar.

Which view allos you to create or modify a worksheet?

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Normal View.

Does an Excel complex formula use more than one arithmetic operation?

A complex formula in Excel could have many arithmetic operators in it. There are many things that make a formula complex, so a formula with just one arithmetic operator or even no arithmentic operators could be complex too, depending on what it does.

Is a cell reference in Excel like a note book?

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

A cell reference uses the column letter and row number to identify it, like cell C5 or K123 etc. That is not like a notebook.

How is a group of selected cells named?

A group of selected cells is a range. If you want to give them an actual name, there are a few ways of doing it. You can use the Name Manager on the Formulas tab. With the Name Manager you can choose Define Name to pick a name. On older versions of Excel, use the Insert menu and pick Name and then Define. If you have cells selected, you can type a name directly into the Name box on the Formula Bar.

Is Excel a cloud computing application?

If using it through Office 365, then yes, but normally it is on the local computer, in which case it is not.

What did corinthian columns have at the top?

Corinthian columns were the most elaborate column type. They had a sort of leafy ornament at the top of it. It was suggested as an imitation of the slenderness of a maiden; for the outlines and limbs of maidens, being more slender on account of their tender years, admit of prettier effects in the way of adornment.

Why might manager want to stimulate conflict in a group or team?

Human relations view of conflict states that conflict is unavoidable and creates a potential for individuals as groups to evolve and grow and is an opportunity for organizational transformation. Interactionist’s view of conflict encourages conflict, as it is positive and necessary for a group to perform to their optimum abilities. Conflict can result in new and different ideas as it encourages feedback and stimulates creativity and innovation. Members question and challenge the status quo and become innovative, as they are force to search for new approaches. A peaceful, harmonious group can be prone to remaining stagnant and unresponsive. A group or team in conflict becomes stimulated and interests and curiosities are piqued. Conflict can create competition among groups or teams. It makes people communicate with great precision, thereby avoiding ambiguous messages. People are forced to clarify their views. Conflict lends participants to become more accommodative, competitive, compromising and collaborative and teaches them how to negotiate

Why does a shopkeeper use a spreadsheet?

He could use it to tally up his weekly stock or weekly total

How many worksheets can you have in any one excel document I understand a spreadsheet can have 1048576 rows and 16384 columns does this mean total rows for all worksheets in the one document?

Those numbers are for each worksheet. You can have as many worksheets in an Excel 2007 workbook as the memory in your computer will allow. Excel 2003 and earlier are limited to 255 worksheets per workbook.

The xls extension indicates an Excel template?

.XLS files are standard Microsoft Excel spreadsheet files. .XLT extension is used for the Excel template files.

- Neeraj Sharma

What Excel interface item is not displayed until you start typing in a cell?

One Excel interface item that is not displayed until you start typing in a cell goes by several names: insertion point, insertion point indicator, cursor, "that flashing vertical bar." Also when you start typing or editing a cell, beside the formula bar the x and tick will appear, allowing you to abandon or accept what you are doing in the cell.

What is the shortcut in putting dollar sign in an excel formula?

For making mixed and absolute cells in formulas, press the F4 key while typing the cell reference to add dollar signs. Pressing F4 several times will cycle through the various forms of mixed, absolute and relative referencing.

How do you remove hash tags in cells Microsoft Excel?

The hash tags appear because the cells are not wide enough to show their contents. You just need to widen the cells to show the values.

How do you convert a Excel file to an ASCII file with fixed length fields?

You want to SaveAs Formatted Text (Space delimited)(*.prn). You can export only one worksheet at a time, so if you have multiple worksheets you will need to combine them into a single worksheet or export each worksheet separately.

PROCEDURE:

  1. Highlight the content you want to export from Excel.
  2. Change the font to Courier (you need to have a fixed length font for this to work).
  3. Change the column widths to display all cell content on one line, or to the width you want.
  4. Align all cells to right justify (this will insert spaces to pad the length of each field).
  5. Select SaveAs and choose Other Formats. From the Other Formats choices, select Formatted Text (Space delimited)(*.prn).
  6. Choose a location for the file and click SAVE.

What are the elements of a formula in excel?

A simple formula could be something like multiplying cells by each other, or summing a range of cells using a simple function:

=C10*D10

=SUM(A2:A20)

Excel is capable of doing much longer and more complex formulas which would take more time to work out accurately. See the related question below.

What is a command tab?

It is a tab on the ribbon that allows you to access various commands. The specific commands depend on the tab you select. Look at the ribbon to see the names of the tabs, then click on the tab to see the commands that are displayed there.

How many levels of undo exist in Excel?

Default number of undo actions:

Excel 2007 = 100 undo actions

Excel 2003 = 16 undo actions