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 setting an Excel formula what is the word used when subtracting one column from another?

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

You would use the minus symbol.

Can You can add additional worksheets to a workbook if needed?

Yes.

At the bottom of the screen you should have 3 worksheets showing by default. To the right of the third is a tab that you can click to insert a new worksheet.

Click on the help icon and search for 'insert worksheet' for additional information.

How to know the numbers of worksheet of a workbook?

They are on the Sheet tabs, starting with Sheet1, then Sheet2 and Sheet3. Normally there are just 3 sheets to start with, but you can add more, in which case the next would be Sheet4. You can also rename them to anything you want, by right-clicking on them.

The best tool to use to copy bold and Times New Roman 12pt is it format painter button?

Yes. The Format Painter can take the formatting from one thing and paste it onto another.

What approaches does an internal auditor use to perform the job?

The internal auditor uses a variety of approaches, including observation of current activities, examination of past transactions, and simulation--often using sample or fictitious transactions--to test the accuracy and reliability of the system.

What software did Excel outsell when it was first released?

After about 3 years it overtook Lotus 123 to become the most popular spreadsheet application.

What is a cell reference that contains an absolute value for the column or row but not both called?

Mixed reference is a cell reference that contains an absolute value for the column or row, but not both.

What do you do to edit existing data in a cell without having to retype it all?

This question is not clear. You can copy and paste from somewhere else. You can edit only the part of the data you want to change.

What is the function of a press junket?

A press junket is designed to promote, and usually unveil, a new product or service to the media. The "junket" may also refer to the actual documents and items associated with such a presentation.

What is the purpose of a chore chart?

Chore charts are often used in many families in order to provide organized directions for who will perform chores. They can be used as tools to improve motivation and responsibility.

What does a blank cell in Excel?

A blank cell has nothing in it. It has no text. For numeric purposes it is treated as having the value zero, but it is not counted when using the COUNT function as it does not literally have a value in it.

Which of these is not a valid Excel analysis tool or function what if goal seek now function if statement?

Goal Seek is not a function or an analysis tool. It is a tool that is used to establish a value to be used for a formula. What If and the IF function can be used for analysis. The NOW function is a function but it is not an analysis tool.

What should the Save As file type be if saving Excel?

That will depend on what you want to do. If you are in Excel saving as a standard Excel file, you don't need to change the file type. It is only if you want to save into a different format, that you would change the File Type. What you change it to, would depend on what you need. You might want to change to a different version of Excel or maybe into a completely different format, such as a text file. If you are working in a different application, saving something to be used in Excel, then again it will depend on what format you actually need.

Is 5 a valid entry into a cell that requires numbers for Excel?

As 5 is a number, then it should be accepted, unless there are some additional validation criteria, like it having to be between a low and high value. So, for example, obviously if it is set to only accept numbers between 10 and 100, then 5 will not be accepted.

How do you drag sum in Excel?

drag the little square on lower right

so that the arrow cursor changes to a + cross.

Who wrote lightly row?

From what my music teacher told me years ago, it was a German folk song.

What is the difference between IF function VLOOKUP function?

The IF function checks a condition to determine a task to do. It is a logical function. VLOOKUP is a lookup function. It can search through a list to find a value or a position in a range, and then find a corresponding value. There are situations where both could be used. Sometimes a VLOOKUP is good for using in place of a nested IF that is having to search through a lot of options. See the related questions below.

How many file formats does Excel offer for saving a workbook?

Microsoft Excel offers more than 30 file formats for saving a workbook. Iif you go to Save As and bring up the list in the "Save as Type" field, it will show you all the available options for your version of Excel.

Why can't I open Microsoft Excel 2003?

There are many possible reasons that your copy of Excel is not behaving as expected. For example, these could include:

A corrupt file or hard disk.

A virus.

A software bug.

User error.

There are other possible causes and the above list is a sample and is not intended to cover them all.

To identify a resolution to the specific problem you are having would require you to provide more information as there isn't a simple answer that fits all possibilities.