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

When you plot data series in Excel how do you show the legend for only some of the series?

To show the legend for selected series in excel you can do in the following steps

Click on the chart icon then

Step-1 Chart type (select the multiple xy plots)

Step-2 Chart source data

Select series in rows

Step-3 Chart options

tick show legend and select the placement for legend (right or left..)

Step-4 Chart location

After the chart is created click on the legend box and again click on the legend of the series 4 and press delete to delete the series 4. Same thing can be done for sereis 5

Can you make Excel 2007 look like the old Excel?

There are some downloadable tools on the web which recreate the old or 'classic' Excel toolbar in Excel 2007. One such example you might want to take a look at can be found at

http://www.download.com/Classic-Menu-for-Excel-2007/3000-2077_4-10637173.html

Regards, Jake Courtesy of

www.Excel-Expert.co.uk

How to resize the row and column in Microsoft Excel?

Highlight the row or column you want to resize by clicking on the top or left column, then click on format either row or column, then click on either heighth or width. A task box will appear, just enter the highth or width you want. Another option is to autofit.

How do you get Excel to stop calculating an IF function and lock in the value once a certain value has been met or after a certain number of calculations?

An IF function can only return one value. Once it finds a value that fits its criteria it does not continue. It is important that you construct a IF function correctly, particularly if it is a nested IF function, so that you get the correct result. If you do that, then issues around where it stops calculating are not a problem. It is simple to construct a nested IF function in the wrong way and it is a mistake a lot of people make.

How to calculate liquor cost?

Beginning inventory minus ending inventory plus purchases (cost of goods sold) divided by liquor sales equals liquor cost, which should be between 22% and 28%, if you want to be a profitable business.

If two Microsoft Excel sheets are opened together then how can I close one of the windows of the Excel sheet with the keyboard i.e. without using the mouse?

Depending on if you have them open in separate windows of Excel.

If they are in the same window: * Ctrl + F4 = Closes the active workbook. If they're in separate windows: * Alt + Tab = Changes your active window * Ctrl +F4 = Closes the active workbook. OR * Alt + F4 = Closes Excel; closes the program. * Ctrl + W = Also closes the active workbook (It doesn't matter if you have extra sheets in Microsoft Excel, unless if someone tells you it does matter.)

How do you restore the undo command in Excel when the undoredo symbols are greyed out in the toolbar and the edit menu shows can't undo in greyed out state and customize or reset have no effect?

AnswerOne way:

go to:

tools--- (in the menu bar), then select "Customise"

then scroll thru until you see it

then drag to the tool bar

finished

Try this:

For each version of Excel, use Regedit to go to:

(For Excel 2007):

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

(For Excel 2003):

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

(For Excel 2002):

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

Edit "UndoHistory" and change the value to between 1 - 100

What's the difference between a field and a record using Microsoft Excel?

Field and Record are database terms.

If you look at it from the top-down, a database consists of records--a collection of data, all of which belongs to one person or account or business or other unique entity; and each record consists of a collection of fields, each of which contains a chunk of data. .

The way simple databases have historically been set up, a row corresponds to a record, and the individual cells within that row correspond to the particular data or expression in the various fields which make up that record. Records are represented by particular rows, and fields identify the type of information in each particular column. Where the rows and columns intersect is a cell, which corresponds to the particular field (type of information) for a particular record.

What is a strip chart?

A strip chart is a graphical representation of data plotted over time, where individual data points are displayed as small marks or lines along a horizontal axis. It is often used to visualize trends, patterns, or variations in data over a continuous period. Unlike traditional line graphs, strip charts can show multiple data series simultaneously, making it easier to compare different sets of data. They are commonly used in fields like engineering, environmental monitoring, and quality control.

If you press f4 will it repeatedly keep inserting rows?

If you have just inserted a row, then pressing F4 will continue to insert new rows.

What are three things you must keep in mind when writing a formula?

There are many things to keep in mind when using a spreadsheet to write a formula. You should know what you want to do in the formula, what its purpose is. You should start the formula with the equals sign. You should know how to correctly reference cells. You should know how to use relative, mixed and absolute cell references. You should know how to use any particular functions you intend using, like what arguments they need. You should know where to put the formula. There are other things you should know too. For simple formulas, those things are easy, but some formulas are more complicated and need a lot more work to get right, so it is a good idea to plan them and test them. For a long formula, sometimes it is good to break it down into separate parts, get them working and then put them together.

List three arithmetic operators that might be used in a formula?

A plus sign, a minus sign and a star, which is used for multiplication.

How is relative inequality related to the extent of absolute poverty?

Relative inequality relates to absolute poverty because both people will attempt to change their situation. They may also have the similar feelings for people who are rich.

What is the Excel function that is used for business?

There is no real answer to that. Excel has hundreds of functions, any of which can be used for business in one way or another. There are a group of financial functions that you would more specifically associate with business, but many other functions can be used by businesses too. Excel is such a versatile application with so many different things it can do, that many functions can be used by business people or others, to do what they require.

What are sheet tab scroll buttons in Microsoft Excel?

When you have a lot of Sheet tabs you can scroll through them or quickly go to the first or last one using the scroll buttons.

What is Merge Styles button in Excel?

It allows you to combine elements of different styles together.