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 using spreadsheet software a function does what?
Function can be used for calculations in a spreadsheet. A simple example of a function is for adding a column of numbers.
EXAMPLE: You have a column of 23 numbers in column B, from row 1 to row 23. To add all of those numbers, and display the results in cell B24, enter =SUM(B1:B23) in cell B24.
See related links for more Excel functions.
How do you minimize the ribbon in spreadsheets?
Right click on the Ribbon and choose the option "Minimize the Ribbon". To show the ribbon again right click on one of the tabs (for example "Home") and uncheck the "Minimize Ribbon" option.
How do you change the worksheet order in Microsoft Excel?
Right-click on the tab at the bottom of the worksheet and name it to whatever you like. After you have named the worksheets, click the tab and drag to a location on the tab row to whatever position you like. There is no method (except for writing a custom visual basic for applications program) to automatically rearrange the worksheet names on the tab row.
What is the purpose of page layout view and normal view?
Normal view shows the actual document body. Page layout view show the document as it would appear on a page, so you also see the page, its margins and edges as well as the body of the document.
Which key do you press to copy while dragging and droping selected cells?
The Ctrl key will enable you to copy while dragging and dropping.
How do you change charts in Excel?
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
Charts in Excel are very easy to change. Click on any part of a chart, such as the axis or a bar or legend or title etc., and then right click and you will get options to change that element.
What is the default font type and size in excel?
The default font and size for Word 2007 is Calibri on 12.
Why is it important to use formatting?
If the question is why, not how, the answer is tricky.
You usually do it to change some parameters of your text, e. g. size, color, you make it bold or underlined.
The same applies to paragraphs - you change spacing, margins, etc.
hope I helped :-)
Mike
Relative reference
What is the use of if sumif and countif functions in Excel?
It allows you to sum only certain figures from a set of numbers. A regular sum will sum all values in the range. Sometimes you will not want to sum all the values, just ones that meet certain conditions. For example you could have a list of numbers in the cells from A1 to A20 and only want to add ones that are over 50. Your function would be:
=Sumif(A1:A20,">50")
The first part is the range and the second part is the condition. It must be enclosed in quotation marks.
An inspection or viewing of something before it is bought or becomes generally known and available.
Display (a product, movie, play, et. ) before it officially goes on sale or opens to the public
The text will appear to overflow into the next cell. It is only a visual effect. All of the data is still in the initial cell, which you will see if you put the cursor on the initial cell and look at the formula bar. In the same way, if you put the cursor on the next cell that the text appears to flow over, you will see that the formula bar shows it as being empty, which it actually is. As soon as other data is put into that cell, then what is in the initial cell cannot be shown in full, and appears to be truncated. The full content is still in the initial cell. You can either widen the column, or set the text to be wrapped, by using the format menu, going to cells and then alignment and tick the wrap text tick box.
How do you add a drop shadow in excel 2007?
It depends on what you are trying to add it to. You are not able to add a drop shadow effect to a cell, but you can add add a drop shadow to charts and some other objects. It just depends on what you are trying to do. If the object allows drop shadow effects, you will get to the option through the object's format options. Right-click on the object and select the format option (will be in different locations on the drop-down menu, depending on the object) and follow the directions in the format window.
How do you insert a column to the left of a column?
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
Select the second column, the one on the right. Then go to the insert column option, through the menus or icons. The second column will be pushed to the right and the new column inserted between the two.
The name box shows the address of the current cell selected or the name of that cell if a special name has been given to it. It can also show the name of a range. You can type in a cell reference or a range name in the name box and it will bring you to that location. The name box appears to the left of the formula bar.
What data validation rule is cautionary?
Data validation is all about what can be entered into a spreadsheet cell or database cell, you can choose an error message aswell as restricting what values can be entered, reducing human error and improving accuracy.
What is a file extension for Microsoft Excel?
For a standard Excel document, prior to Excel 2007, it is xls and xlsx is used in 2007. There are other kinds of files created by Excel, like templates which can be xlt or macros which can be xlm and xla for Add-ins, and there are other extenions. For 2007, you add x to the end of them.
What are three parts of a function in Excel?
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.
=NAME()
=NAME(arguments)
The TODAY function has no arguments so it can be entered like this:
=TODAY()
The SUM function must have arguments, so it could be something like this:
=SUM(A2:A20)
Is percent a valid Excel arithmetic operator?
No. Percent is not an operator, it is a symbol or cell format style.
What are the vertical columns called and how are the elements of each row relate?
The verticals are called , just as you questioned, columns; they are designated by letters. the relation between cells is according to formula that apply to values in the cells.
Can you look at 2 Excel spreadsheets at the same time?
If you are using Excel - you just need to use either the "Split" menu option and then click on whatever sheets you want to see in each "pane" or in older versions you can use the "Arrange" menu option to get sheets to show either side by side or one above the other.
What is A grid of columns and rows that you can fill with text and graphics?
It can be a table or a spreadsheet. They can also be called datasheets or worksheets.
