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 do you use mixed reference in Excel?
In most cases where people use an absolute reference, a mixed reference will do. A mixed reference will lock a column or row, but not both. Most formulas are copied either down or across, but rarely both. If a cell needs to be locked in a formula, then we lock the row when copying down or lock the column when copying across. See the related question below for more details on the different kinds of cell references.
Does text that is left-aligned have a ragged left edge?
No the left edge is even, if the left edge is ragged then it is either centered or right aligned.
What is a mail merge toolbar used to display the values of the previous record?
Previous Record Button
How do you insert equals sign without making formula?
To get the equals sign to show in a cell you put the apostrophe before it. Anything after the apostrophe is taken literally and put into a cell. So to get the equals sign to show you put:
'=
The equals sign will then be displayed in the cell, without the apostrophe showing. You can use it to put in a full formula without the formula actually calculating. This is good if you want to see the formula and the result beside each other in two cells. Into one you put your formula starting with the equals and in the other the same formula with an apostrophe before it. In one it will do the calculation and in the other it will show the formula including the equals sign.
What is the general format of an SQL query?
In general, SQL "statements" have a Select "clause," a From "clause," and a Where "clause."
Can you run multiple instances in Excel?
Yes. You can run as many instances of Excel as the memory in your computer will allow.
What is the primary insert command and the row command on the insert menu?
Insert command which u get wen u right click in excel shift have options like u can add rows,columns,shift cells right and shift cells down but in row command on insert menu will allow u to insert one row.
Which number format would you apply to a cell to show the total sales for the month?
The answer depends on the whether you are measuring the value of sales of the quantity of sales. In the latter case, it depends on whether it is a discrete variable of continuous.
Value of sales: Currency format.
Discrete quantity (eg number of cars sold): Integer number.
Continuous quanity (eg amount of fabric sold): Decimal Number.
In all three cases you will need to use a sensible number significant figures. There is not much sense in presenting sales worth millions to 2 decimal places!
What does the comma in Excel mean?
The comma button will apply comma formatting to cells, so a value like 10000 will become 10,000. Commas are also used in functions to separate the different arguments used in a function.
Does Copying a formula with an absolute reference does not change the cell reference?
An absolute cell reference will not change when it is copied.
How can you keep a excel cell not to fall below a set number in a formula?
You need to use the IF function. Something like:
=IF(C12*D12<100,100,C12*D12)
Where can I receive information about SBA programs?
More information is available from the U.S. Small Business Administration Office of Marketing and Customer Service, 409 Third Street SW, Suite 600, Washington, DC 20414; 202-205-6744 or 1-800-8ASK-SBA; or, http://www.sba.gov.
Why would you use the Excel web query tool?
You might want to read data from the web and use it in formulas. It would be particularly when it is values that are likely to change quickly, like stock prices or currency exchange rates.
What is a formula which would add A1 A2 and A3 and divide by 3?
To add the 3 cells and divide the total by 3, you could do it several ways:
=(A1+A2+A3)/3
=SUM(A1:A3)/3
=SUM(A1,A2,A3)/3
If True or False Question. The answer is T
Column is the term used to describe a vertical line of cells. Columns are identified by letters at the top of the worksheet page.
How do you enter data from several different worksheets at the same time on excel?
This question is not clear. Unless you have multiple keyboards and lots of extra hands, you probably can enter data only one sheet at a time. However, if you are asking how to combine data from several sheets on a single worksheet, use the worksheet names in your formula.
=(Sheet1!A1+Sheet2!A1+Sheet3!A1)
If this did not answer your question, think about what you want to know and ask another question that is more specific.
