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
No. In Excel you would use the COUNT function to do it, or possibly the COUNTA or COUNTIF, depending on exactly what you were trying to do.
What does set cell mean in goal seek?
Set Cell is used to specify a cell in the worksheet that you want to have a particular value in when the process is finished, by changing a value in another cell. The cell specified in Set Cell will always have a formula in it.
How do you convert Excel file to a translation support file?
You most likely would need to start with the application that uses the file format and try to import the Excel file. Excel does not directly support .TRN files.
A translation support file (.TRN) is used by many applications, including:
.trn - Quattro Pro
.trn - Clarion database
.trn - MKS Source Integrity project usage log
.trn - Translation file
.trn - Medlin Payroll Software related file
.trn - MegaHAL conversation simulator training file
.trn - NSME Trains screensaver file
.trn - Medlin Accounting current year transactions
.trn - Adobe PageMaker file
.trn - Payroll Mate 2008 current year transactions file
.trn - Microsoft SQL Server transaction backup file
.trn - STN Express transcript text file
.trn - TextBridge training data
.trn - VGA Planets game turn file
.trn - Nova Logic game mission terrain file
What are the arithmetic instructions that calculate in the spreadsheet called?
They usually are called operators. You can use addition, subtraction, multiplication, division, and exponents as operators. You can combine operators with functions.
How do you select a cell without deselecting another cell in excel 2003?
Hold down Ctrl as you click on all the cells you want to select.
What button do you press to manually calculate a worksheet in Excel?
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
The F9 key.
How do you sort a few columns based on one column's values from low to high?
What you need to do is select all the data. Normally when doing this, the first column of the data you selected acts as the key to sorting it. So what you need to do next is to go to a Custom Sort and select the column to base your sort on. Then you can do it on a different column. That will work. When values change in Excel it does not automatically sort them again like in a database, so you will need to redo the sort occasionally. You could set a macro up to do that for you.
What is the easiest way to understand the cursive writing worksheets?
The difference between a cursive writing worksheet and a conventional worksheet would be that the cursive sheet is used to teach students how to write the alphabet and words in cursive writing instead of printing the alphabets or words. The cursive worksheets that are the best are the ones that have the alphabet letters printed for you to match up with the letter that it is teaching you how to write in cursive.
What is the formula in Excel that will subtract cell H15 from the sum of cell i7 through i12?
=SUM(I7:I12)-H15
How does Excel recognize that you are entering a formula into a cell?
All formulas must begin with the equals sign. That is how Excel knows it is a formula.
Does Microsoft Excel consider names to be relative references?
Named cells are normally used to reference specific cells, so they would be absolute references.
How do you combine first and last names in Excel cells?
If one cell contains a first name and another contains a last name, you can bring the two together into one cell in two ways. You can use the & operator or the CONCATENATE function. So if the first name was in A2 and the last name in B2, then in C2 you could have either of these formulas, which also put a space between the two elements:
=A2 & " " & B2
=CONCATENATE(A2, " ", B2)
Arrange tab button that creates a layout similar to a spreadsheet?
The arrange tab is in access. Save a form and it will appear on the menu.
What are the five tools word provides for creating polished documents?
correctness, conciseness, clarity, emphasis, diction
How many font types should you use in a Excel worksheet?
There is no real answer to that, in that you can use as many as you want. It is a good idea not to use too many. You might use some different ones for some main headings, but things like the data would probably all be the same. Having too many fonts could be distracting. The most important thing on a worksheet is the data itself, so it essential that the emphasis is put on the accuracy of the data first, before what fonts are used. After ensuring everything is correct you can then look at changing some fonts.
Can I create conditional sheet within a workbook based on a pick-list?
Yes you can. The value you select from your pick list can be put into a cell, with the linked cell value. Then you can use that cell as part of your conditional action. That could be part of Conditional Formatting, using the "Formula Is" setting, or for use in an IF function for a regular formula. It may take a little work to lay it out and get it to work the way you want, but it can be done.
How do you enter criteria for date in an advanced filter?
You need to have your table set up and then headings for your criteria. Say you want to show birthdays for people born after the 1st of January 1970, then in your criteria line under the date field you would have:
>01/01/1970
How do you format a cell in Excel that converts feet to meters?
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
You would format it as Number with 2 decimal places.
What is the black line around an active cell?
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
