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
What is 'comma delimited format'?
Also referred to as comma-separated format (CSV), this format is a way to store data by separating each field with a comma.
EXAMPLE: first item, second item, third item, fourth item, fifth item, etc.
Other delimited formats can use other characters as a delimiter to identify the difference between each field in a collection of data (database).
OTHER EXAMPLES:
"first item" "second item" "third item" "fourth item" "fifth item", etc.
first item; second item; third item; fourth item; fifth item; etc.
first_item second_item third_item fourth_item fifth_item, etc.
How do I run a macro that will delete columns eg A E F J N Z and will always be the same columns?
Sub Clear_Columns()
'
' Select columns from which to clear contents of all cells in the columns
Range("A:A,E:E,F:F,J:J,N:N,Z:Z").Select
' Clear contents of all columns in selected range
Selection.ClearContents
' Return cursor to cell A1 (optional)
Range("A1").Select
End Sub
Pick a zoom amount at View/Zoom, or turn the mouse roller while holding down the Ctrl key.
How do to keep Excel from changing the form of the date put in?
Apply formatting to the cell that you want. There does not have to be anything in the cell when you apply the formatting. Then when you type a date in, it will show in the format you want.
1. Right click the particular cell
2. choose "Format Cells"
3. On the "Number" tab under "Category" left click on "Currency"
4. Set how many decimal places to show (you probably want to leave this as "2"), the symbol for the currency (e.g. £ or $ etc...) and how you wish negative values to be displayed.
5. Finally, left click on "Ok".
A time series chart is good for showing data that occurs over a time interval, but the intervals between data points are not consistent.
See related links for how to make a time series chart with Excel.
How to insert a cell and shift remaining cells down?
Select the cell where you want the new cell to be. Right click and pick insert, and there will be a shift cells down option which will do it for you.
Do you have experience in Excel such as VLOOKUP and other more advanced features?
This is a question that could be asked at an interview. To answer yes, you would need to have a good knowledge of Excel. There are a lot of specialised functions, such as VLOOKUP, that more advanced users can work with. For a job that has a lot of Excel involved it would be a good idea to look at the more advanced features, such a VLOOKUP and many other functions that a lot of ordinary users know little about. Excel has hundreds of functions and most people only know a small amount of them.
What alignment buttons are in the Alignment group?
Top, Middle, Bottom, Left, Right, Center, Orientation, Decrease Indent, Increase Indent, Wrap Text and Merge & Center.
What are the functions and effects of postinol2?
Postinol 2 is an emergency contraceptive pill that primarily functions by delaying or inhibiting ovulation, thereby preventing fertilization. It may also alter the uterine lining to prevent implantation of a fertilized egg. The effectiveness of Postinol 2 is highest when taken within 72 hours after unprotected intercourse. Common side effects can include nausea, fatigue, and changes in menstrual bleeding patterns.
How do you create 3-D reference in selected cell that will sum up cell B2 for Q1 through Q4?
You reference the sheets with a colon in between them, follow it with an exclamation mark and the cell reference. So your formula would be like this:
=SUM(Q1:Q4!B2)
If I get this right you know the volume of sales for this year and know the percentage that it changed since last year and need to know the volume of last year?
First, you need to know what percent of last years volume that this years volume is, if not ...
let's say it increased by x% then this year the volume is 100+x% of last year or
if it decreased by x% then this years volume is (100-x)% of last year
Second,
volume this year = percentage change* last years volume
percentage means per 100 and "of" means multiply
so for example if this year the volume is 150 and it increased by 50%
then your percentage of last year is 150
150 = 150/100 * last years volume
150 = 1.5 * last years volume
150/1.5 = last years volume
100 = last years volume
Hope this helps..
How would you start typing a formula into a cell?
You must start all formulas with an equal (=) sign. This symbol will tell Excel that you want to write a flormula.
How can you prepare a report in Word that contains a chart you created in Excel?
Teere should be an option to import the chart, or to paste it.
Can text or a word be used as an if value for a function in excel?
Yes. IF functions can work by checking things like dates or text. If you were doing an exam function you could have a function to display Pass or Fail, based on an exam score. If the score was in cell A1 and you want to display Pass or Fail in B1, then you'd put the formula in B1. You must enclose the text in quotation marks, or else it will think it is a cell reference and give an error. The formula in B1, based on a pass mark of 40, would be:
=IF(A1>=40,"Pass","Fail")
You can also check what is in a cell to see if it matches a piece of text. Again in the formula you need to enclose it in text. So in C1 you could have a formula like this, to display a message based on the result from the IF formula in B1:
=IF(B1="Pass","Congratulations","Hard luck")
Can Worksheet cells only contain numbers?
No. A worksheet can hold all sorts of data, like text, dates, number, logical values and formulas.
It is a border between columns. Columns and rows are formed by gridlines. To make these lines heavier, you can put gridlines in to emphasise the borders. Borders can be different colours and styles and thickness. It is up to the user to specify what they want.
What will appear in the upper right conner of a cell if a comment has been inserted?
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
A small red triangle.
What is the address of the cell at 32nd column and 49th row?
The address would be cell AF49 because AF is the 32nd column.
What do you insert when you want to insert notes into a worksheet?
You can type notes directly onto the worksheet, you could type them into a text box on the worksheet, or you can add comments, which are attached to a cell. Pressing Shift - F2 will enter a comment into the selected cell. A small red triangle in the top right corner will indicate that a cell has a comment and it can be seen by putting the cursor over the cell.
Is docx files can be converted as xlsx files?
No. A docx file is a Word document and a xlsx file is an Excel document. It is possible to copy data from one to the other, like copying a table from Word into Excel, but the files as a whole cannot be understood by the other application.
