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
Which end of a mattress is the header or footer?
The head of the mattress is the end where the side panel ends are sewn together, and this is where the "law tag" is sewn in. The side panels and foot end of the mattress should show no vertical seams. Unless of course the mattress is a very low quality piece.
What Excel function would be used to find the lowest score on a series of student test scores?
You would use the MIN function. Say your list of scores were in the cells B2 to B40, then in a cell you would type:
=MIN(B2:B40)
You could also use the SMALL function as follows, but it is more for finding things like the second lowest or third lowest etc. In this case the 1 specifies to find the lowest:
=SMALL(B2:B40,1)
Can you use the Go To command to preview a worksheet before you print it?
No. Go To allows you to go to different parts of worksheet or workbook. It is not for previewing it. You would use Print Preview for that purpose.
Can you retrieve information from a file in Excel?
Yes. There are all sorts of ways of retrieving information from Excel files, so it depends on what kind of information you want to get.
What is the purpose of the Compatibility Checker and saving in a backwards-compatible file format?
It has to do with who will be using your files and what versions of the software they have. Virtually all major software packages, including Microsoft Office, are backward-compatible, which means that you can work with files that were saved in older versions of the software. However, you often cannot open files saved in newer software versions if you are using an older version. For example, in Excel 2007, in addition to the normal Save function, you also have the option of saving your workbook as an Excel 97-2003 file. Both the normal save and the 97-2003 save have their drawbacks. If you save your file normally, you are limiting the range of your audience, because people using older versions of Excel won't be able to open it. If you save it as a 97-2003 version, you are limiting what functions you can use to make the file look and behave the way you want. Obviously, every new software version has more "bells and whistles" than the previous version. By saving as a 97-2003 version, you are limiting yourself to only the functions that were available in those older software versions. When using a newer Excel version and saving your workbook as an older format, the Compatibility Checker will let you know what characteristics of your workbook, if any, are not compatible with the version in which you are trying to save it. Of course, if your file is only for your personal use, you need not concern yourself with the 97-2003 save option. BTW, you can tell which Excel files are compatible with Excel 97 etc. by the file extension. Files saved in newer Excel versions and that are not compatible with the older versions have four-letter extensions instead of three-letter. For example, for regular Excel files (not templates, no macros, etc.), older versions have the extension .xls, and newer versions have the extension .xlsx.
yes
What is the difference between simple formula and complex formula in Excel?
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
How do you select a large range without dragging in Microsoft Excel?
By clicking on one corner of the range and then clicking on the other corner while holding down the shift key.
Where does AutoCorrect in Microsoft Excel 2007 store the corrections?
i m also search the auto correct option in Microsoft Excel 2007 Pleas help
What is auto complete in excel?
Autocomplete is a feature in Excel spreadsheets that is meant to make data entry faster. Autocomplete is done by typing in one cell, clicking on the cell and dragging it downwards. The remaining cells fill with serial numbers and/or letters.
How would you recommend Excel spreadsheet?
The question is not clear. I would just say, "I recommend Excel."
2 Column Proof: If a transversal intersects two parellel lines, then alternate interior angles are congruent.
Can a check box selector in Microsoft Excel be created that can dynamically hide and unhide fields?
This is an elaboration of the question presented:
Our company has a spreadsheet that is derived from a database application. The application downloads records that have almost 50 fields (A-Z) and (AA-ZZ), making for a cumbersome display. I would like to add a front end in Excel that allows fields to easiy be hidden for unhidden. In this control, a default set of fields would be displayed (checked) and others could be added creating a customized display of data to work w/. The unwanted data would still be in the spreadsheet, but would not display.
How would you display a shortcut menu for cell B15?
Right click on the cell and a shortcut menu will appear.
Say the mark is in cell B3, then the function would be as follows:
=IF(B3>=50,"Pass","Fail")
range finder
What is any number you enter into a spreadsheet is called?
A value. IN a spreadsheet, it's either a value or a formula.
What helps you display portions of your data in a table?
Pivot Tables, Filters, Dashboards and Data Tables are some of the ways you can do it.
On Excel What Part of the IF function that the conditions are stated in?
The conditions are always set out in the first of the 3 parts of an IF function:
=IF( Condition, True action, False action)
For example, if you have an exam score in cell A5 and want to say if it a pass or fail, based on the pass mark of 40%, then you would use the IF function like this:
IF( A5>=40%, "Pass", "Fail")
Which feature automatically adjust the width and height of cells in Excel?
You can use AutoFit to do it. You can also double click on the boundary between headers of columns or rows to re-adjust the column width or row height to fit the current content.
What are the Functions of the family?
the family is the social unit for bringing the children into the world. all societies-primitive,developing and industrialization's have some from of marriage among men and women.marriage is the approved setting for bearing children. children born to the couple are expected to be raised within that family setting
The very basic functions that family perform as an institution are :-
a) Socialization,
b)Reproductive and Sexual Functions,
c)Economic functions,
d)Identity and Social Status, and
e)Emotional Security.
f)Productive function
How can one convert an Excel spreadsheet to an iif file?
One can convert an Excel spreadsheet to an IIF file using the Microsoft Office 2010 software suite. Also one can convert such files using online services like Spreadsheet Converter and Accountant Pro.
