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
In excel a number can contain the characters...?
A minus sign, full stops and commas for normal numbers, and also currency symbols.
Spreadsheets are one of the most versatile of all applications, so there is a huge amount you can do, far too many to list here. Mainly they are used for numerical analysis and manipulation, which covers almost anything you can think of that you want to do with numbers. They can also do many other things too though. They can deal with dates and text and do a huge amount with them. They can be used for diagrams and graphics. You can use them for integrating with other applications or websites. People generally only use a very small amount of the full capabilities of what a spreadsheet can do. Even experts would not use the full range of its capabilities. They can be used by so many people who have different requirements and their own areas of speciality. With good imagination and creativity and a good knowledge of the application they are using, people can come up with all sorts of things to do.
Distinguish between power point and Excel 2007?
PowerPoint is a presentation application and Excel is an electronic spreadsheet.
Each box on the worksheet grid is called a tab?
This is a false statement. Each box on a worksheet grid is called a cell.
operators (although, there is no specific percentage operation, only the percent symbol to show the number is a percent)
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
Exponent (^)
operators
Arithmetic operators are the symbols used in formulas to calculate values, such as addition (+), subtraction (-), multiplication (*), division (/), and exponentiation (^).
All charts need titles. It helps others to work out what is going on.
What test for specific conditions?
It depends on the conditions. Please ask the question again using words that make it more clear what you want to know.
What is paste special in Excel 2007?
Paste Special lets you copy cell contents and copy selected cell contents to another cell. The paste special command has a number of useful tools built into it. Besides allowing you to paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
How do you apply conditional formatting in excel 2003 based on number of characters in a cell?
Use the LEN function to count how many characters are in the cell. If you want to evaluate cell C23, use LEN(C23)=6.
What function is available in the Consolidate dialog box in Excel?
SUM is the most commonly used one, but you also have Count, Average, Min, Max, Product, Count Numbers, StdDev, StdDevP, Var and VarP.
A predefined formula that allows us to do complicated calculations easily is known?
...as a function.
What is the importance of being able to produce a spreadsheet to display data correctly?
One of the most important things in a spreadsheet is to have the data laid out correctly and displayed in a structured and organised way. If the data is displayed correctly, it will be much easier to understand and work with. Creating formulas will be easier. Seeing totals and other important information will be easier too. It will make it easier to create charts. It will help reduce errors and provide consistency. It will make it easier to find errors when they do occur.
What rectangular range of cells with headings to describe the cells content is referred to as a?
It can be referred to as a table.
What function should be used to quickly convert the times from minutes to seconds in Excel?
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
If your time was in A2, then you could use the following formula:
=(HOUR(A2)*60+MINUTE(A2))*60
What does a cell address as it applies to Excel 2010 do?
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
A cell address identifies a particular cell. It can be used in formulas to help in calculations. By using the cell address you can access the value in the cell.
Can part of data in excel be saved as a file?
If you only want part of a worksheet to be saved, then copy the section you would like to save, open a new workbook, paste the section into a worksheet, and save the new file.
