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
Can you use cell background color in a COUNTIF statement in Excel?
Not directly. You could set a list of cells that indicate the colours of other cells and then could count them. So for example, in the cell beside each cell that is red, put the word red, and then use the COUNTIF to count the cells that have the word red in them.
If the original cells have been coloured based on conditional formatting, you may be able to use the condition to count the cells too.
What icon is found in toolbar?
Several icons that represent various functions. The specific icons depend on what toolbar you select.
How do you move straight away from cell A1 to cell B320?
Press the F5 key, which opens the "Goto" dialog box. Then Enter "b320" where it says "reference". Click OK. You are now in the B320 cell. Press F5 key again to go back to A1.
What is the insert tabs purpose in Excel?
The Insert Tab allows you to insert various things. These include charts, various shapes and graphics, tables, pivot tables, sparklines, headers and footers, filters and symbols. The only things not on it are the facilities to insert cells, rows and columns, all of which are on the Home Tab.
Which bar displays the name of workbook?
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
It appears in the Title bar at the top of the window and can also appear on the Taskbar.
Why should the Microsoft Excel be properly organized?
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
If data is properly organised it is a lot easier to deal with the data. Part of the reason for using computers, and particularly spreadsheets and databases, is to help to organise data. Data that is organised is much more useful to us and helps us to do things. A spreadsheet that is completely disorganised is difficult to work with and not very productive. By putting things into columns and rows we can create simple formulas and copy them to help us get the results and information we want.
when we use computerised database it really makes our calculation easier and quick rather using pencil and paper. it reduce the time that takes to use in paper and it makes our work easier and comfortable so we can easily make calculations in microsoft spreadsheet.
What shows the date a workbook report or other document was created or the period it represents?
file date
They can be in the same row, but sometimes there are multiple criteria, so they could be in more than one row. Say you had a list of department and there were two different departments that you wanted to list data from, the criteria would have each of the two departments you wanted on a different row in one column under the department field heading.
Does a workbook contain 5 worksheets by default and is limited to 256 worksheets?
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
The default is 3 worksheets and this can be increased, with the limit usually depending on the amount of memory available in your computer.
Can you print just a selected section of an Excel document if you would like?
Yes you can. You can use what is known as a Print Area. You select it, specify it as a print area in the print settings and then you can print just that area.
The IF function.
How do you reset General default format?
Use the Format Number tab, with the cells that you want to change the format for selected. Then choose General and it will set that formatting for those cells.
What are the advantages of spread sheet?
. Very accuraly result can be updated
. Any part of the work sheet can be edited
. Formating of the data in several ways can be carried out very easly
. Sorting can be perfomed on nuemeric and non-nuemeric data
. With an electronic spread sheet we can easly produce reports and gets answers to what if
. Prepration of chart and graphs is very easy
.
Where can you enter a sum in excel?
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.
When inserting a column if you select column D where will the new column be inserted?
The inserted column will push column D to the right and become the new column D. The original column D will become column E, and so forth.
What ensures that users do not change values inadvertentently that are critical to the worksheet?
cell protection
What press to move to the next line within the same cell?
Pressing the Alt - Enter key combination will start a new line in the same cell.
Which sort order sorts text from the end to the beginning?
Descending would do that, going from Z to A as it were.
