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

Are the keyboard commands the same in Word and Excel?

Some of the keyboard shortcut commands are the same, but most are different.

See related links for keyboard shortcuts for MS Word and MS Excel.

What does form do in Excel?

If you have a database in Excel, then you can use a form to enter the data instead of typing directly into the cells. The data will still go into the cells, but you will have a form with labels telling you what you are to enter and also allowing you to skip values that are formulas, so you don't need to worry about them.

What are the differences between trace precedents in Excel 2003 and Excel 2007?

It works basicly the same way in both versions, but the commands are in different locations. The command is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003.

See related links for an animated tutor of how to use trace precedents.

Is there a Microsoft office function to divide one cell by another?

There is no dedicated function to divide one cell by another. You can use a simple division like:=A2/A3

What laptop computers come with Microsoft 2007 Excel or Word?

None do. They do not come automatically with any computer. If you want any Microsoft Office products, then you have to ask for them and pay for them.

What are the different icons of Microsoft Excel?

Actually, I don't know.

Just search in Google that will be easy

How do you enter the formula that will calculate the total revenue of the year 2006?

You would use the SUM function, specifying the cells that have the various revenues for the year. It will depend on what cells you are using. If you have one for each month in the cells from C2 to C13, the function would be as follows:

=SUM(C2:C13)

When you format a cell to display percentages Excel assumes that whatever you enter into that cell in the future will be a percentage?

Yes. Cells can have formatting applied before data is entered so that when data is entered it can be in the approrpiate format. This is handy in the case of percentages as it allows people to start typing whole numbers in and for those to be made into percentages. So for example, if it is formatted to percentage and you type 5, Excel will automatically put the percentage symbol in after it and treat it as 5%. However if you type 5 into a cell and then format it to percentage, it will become 500%, which is correct, so people have to remember to type 0.05 if they want it to be 5% after it is then formatted.

What is a non embedded chart?

It is a chart that is on a chart sheet, not embedded on a worksheet. There will be a separate tab for it, like each worksheet has.

Which tab contains the command to insert a watermark in a document?

If you are talking about background, go to 'page layout' menu and select 'background'. On newer versions it is in the Page Background group in the Design tab on the Ribbon.

Where can you get answers to buckle down workbooks?

what is one difference between arch

ne and camilla?use two details to support your response.

Where does the file name appear when you open an Excel file?

The File name will usually appear at the top of the excel file. It should look something like this: file name - Microsoft Excel...

True or false each worksheet in a workbook must have the same header and footer?

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

False. You can have different ones, like having the different sheet names on a page or having different odd and even page header/footers, or different ones for first pages.

How can I change the column letter on an Excel spreadsheet?

You cannot do that. What you need is a row of headers within the spreadsheet cells. You would usually supply these on row 1. although try this Tools > Options > GeneralTab > check the box marked "R1C1 reference

style".........that will change columns A, B, C, etc to columns 1, 2, 3,

etc..... other than that, I know of no other way to change them to be

"words" or anything else. for more guides http://allaboutoffice.blogspot.com

Tables have records which are columns and fields which are rows?

No. In a database table the records are in rows and the fields are in columns.

Merge two Excel files in DOS?

yes convert to csv

then at command promt type copy *.csv all.txt

rename all.txt all.csv

open all.csv with xls

and there you go

Can a worksheet have too much formatting?

It depends on your purpose. Sometimes too much formatting (e.g. too many different colors) is distracting to the viewers. Deciding on how much formatting you use is the artistic and functional part of designing a worksheet.

In Excel a cell reference of B17 is it an invalid cell reference?

No it is not invalid. It is the cell address of the cell where column B meets row 17. It is a relative cell address.

What function adds all the numbers in a range of cells?

SUM(1st range, [optional 2nd range], [optional 3rd range], [& so on])

What variables are used in solving a time value of money problems without a periodic payment?

Present Value (PV)Future Value (FV)

Number of periods (n)

Interest Rate (i)

Payment Amount (PMT)