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

What is the path to the copy and paste buttons in excel?

home tab- clipboard group is the path to the copy and paste buttons

What are excel formulas?

An Excel formula starts with an equal sign (=), and does some calculation. It may be something as simple as copying the value of another cell (=A5), of doing some simple math (=1+2), or it may involve more complicated calculations, including Excel functions.

What is the Trace Error button in Excel?

Trace Error shows you the cells that are referenced by a formula that has an error. With a cell with an error highlighted, clicking on the Trace Error button will show arrows indicating links between cells which can help you trace the error. You can then check what cells are referenced and see can you find which one may be causing your error.

Each value in a cell selected for a chart is called a?

The individual values that are on the chart itself are known as points or data points. A group of related values together make up a series.

What button allows you to erase recent cell entries?

The Delete key will do it, once you have those cells selected. You can also use the Undo button on the screen, or Ctrl - Z.

What do you call a reference cell on another sheet?

There is no particular name in full, except we do talk about part of it being a sheet reference. So you have a sheet reference and a cell reference together. To do the reference you need the sheet name, followed by an exclamation mark, followed by the cell. The following refers to cell C3 on Sheet2:

=Sheet2!C3

Does the formula bar in Excel display the value or formula of an active cell?

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.

What does merge mean in excel?

It brings the contents of two or more cells into one cell, or allows you to spread a single cell across several rows or columns. You select the cells you want to merge, which must be together, and then apply the merge through the menus or icon.

How do you print a selection or range of a worksheet?

As with most such questions there is likely more than one answer, but I have always:

1. Selected the area (i.e. range) that I wanted to print.

2. Chosen the 'Set print area' option.

3. Set page breaks and any other such required options.

4. Printed.

See the related help article within Excel for further information.

When Excel follows the order of operation the formula 8 3 2 equals?

48

8 times 3 = 24, 24 times 2 = 48

I don't know why you would need excel to solve this formula when you can easily do it mentally.

What is copy area and source area in Excel?

The copy area and source area can both to refer to the cells that you are making a copy of. Another use of source area, is the cells used in the process of consolidation of data.

How do you calculate bonus in Excel?

It depends how the bonus will be allocated - is it a fix amount, is it a percentage of their weekly/monthly salary

Assuming its a % of weekly salary

In cell a1 place the salary for the employee i.e. 250

In cell b1 place =C1*A1

In cell c1 - format it to Percentage using CTRL +1 or through the menu FORMAT

once done add in 25 in to the c1 cell

The figure in B1 will be 25% of whats in a1 - change c1 to change the allocated percentage of bonus.

Change cell a1 for the salary amount.

If you want to have a final total of wage plus bonus then in cell D1 place

=A1+b1

What Excel number format inserts thousand comma separators fixed dollar sign leaves small space for negative numbers?

You have the comma style that will do it from the toolbar, or you can do it by using the numeric format called Number and ticking the "Use 1000 Separator" tick box.

Why do you use formulas on spreadsheets?

Formulas are used to carry out either repetitive or complex calculations. A simple example would be someone typing in a figure for degrees Celsius - and the spreadsheet returning a value in degrees Fahrenheit. It saves the user doing the manual calculation (multiply by 1.8 then add 32).

What are the steps to set the text wrap in a cell?

  1. Open cell format. (One option is to right-click on the cell and select "Format Cells.")
  2. Click on the Alignment Tab in the Format Cells window.
  3. In the Text control section, click on the Wrap text option.

How do you calculate frequency percentage in excel formula?

FREQUENCY(data_array, bins_array).

See related links for details and examples.

Are Microsoft Word and Microsoft Excel system softwares?

MS Word and MS Excel are examples of application software, because they allow the user to accomplish specific tasks.

System software is software that runs in the background to make the system resources available to application software. An example of something system software does to assist applicatin software is allowing the computer to talk to the printer.

Does excel have a grammar checker?

Excel has a spell checker. If you go into the Tools menu there is a Spellchecker option there. You also can just press the F7 key to start it.

What key do you use to erase an entire entry in a cell and then reenter the data from the beginning with Excel?

You can use the Delete key and then type the new entry in. If you have the cell already opened for editing, you can use the Backspace to delete everything back to the start of the cell and then start your new entry.

Is it TRUE that Excel opens with a new blank workbook displayed?

Yes, when you start Excel in the normal way, you will be presented with a blank workbook. However, you can choose an Excel file from your folders before opening Excel, and if you double click on it, it will start Excel and have that file open when it starts, instead of a blank workbook.

What is a column with an ornate decorative top called?

The decorative top of a column is called the capital.

What do people use spreadsheets for?

spreadsheets are used by accountants and people who are mathematician