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 keys do you press to start a new line of text within a cell?
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
Press Alt-Enter and you can do it. You can also set wrap text on.
What is the formula that divides the value of the cell A1?
You can divide by anything except zero. So you can use a number or a cell with a number in it. You use the / symbol for division. So your formula to divide something in cell A1, which must go into a cell other than A1, could be like either of the following:
=A1/10
=A1/B2
How many no of alignment in MS Excel?
There are 13, including both Horizontal and Vertical types:
Horizontal: General, Center, Left, Right, Fill, Justify, Centre Across Selection and Distributed.
Vertical: Bottom, Top, Center, Justified and Distributed.
You can also set the amount of indent required.
Pasting.
Similarities and dissimilarities of Microsoft Word and MS Excel?
simililarities between ms word and ms excel screen feature
What are the different types of columns?
Major types of Absorption columns are
liquid-liquid absorption columns,
Gas-liquid absorption columns.
How do you rearrange worksheets?
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Click and drag on the Sheet tab to re-order the worksheets.
Which button removes the italic font style from selected cells?
The B button on the formatting toolbar. Using the keyboard you can press and hold the Ctrl key and then press B. Also, if you hold the Ctrl key and press the 2 key, it will bold things or remove bolding.
What is each column in the data source called?
They are called 'fields'. For example, the primary key is always a field in the table. If you're looking at a database table in datasheet view (so that it looks like Excel) then each column is a 'field' and each row is a "record". Therefore a field called "Date of Birth" would be part of a record stating all specific "Employee Details" etc.
Format that inserts a comma every three positions to the left of the decimal point?
It is known as Comma Style. The same effect is caused by using the Currency or Accounting styles.
For a single cell: with the cell selected, Format menu > Cells > Number tab > Category: Number [By default the Decimal places is set to 2] > OK.
To apply this format to a whole column: position the mouse icon over the column heading (such as B); the icon becomes a black arrow pointing down. Click to select the column, then use the Format menu as above.
To apply this format to a range of cells: select the range, then use the Format menu as above.
You can also adjust the horizontal position of figures within a cell: select the cell(s), then Format menu > Cells > Alignment tab > explore the options under Horizontal, especially Right (Indent) with Indent set at 1 or 2.
When one cell has just the right format, you can apply its format to one or more other cells using the Format Painter. Select the "perfect" cell, then click the paintbrush icon in the Formatting toolbar, then click another cell to apply the format without changing the value in the cell. If you double-click the Format Painter, you can go on "painting" cells as long as you like. To exit, press Esc on your keyboard or click the Painter icon again.
What is the formatting that is automatically updated if you change data in the worksheet?
No, not necessarily. A lot of formatting will stay the same. There are instances when formatting will change, like when using Conditional Formatting. Typing data in a particular way into a cell that clearly identifies its data format can also change the formatting, like if you type a time into a cell.
You use the OR criteria when you want to be able to give a choice of options. Say you have a list of people working in different departments and you want to list people working in the Accounts department or the Sales department, then you would use the OR statement. You could be looking for people who are widowed or divorced from your marital status field as another example. So when you have 2 or more allowable criteria on the one field, you can use the OR criteria. It can also be used across different fields. It depends on what you want to do. If you use it carefully, it is very powerful.
A style is a pre-defined combination of formats. For a cell, this can include the colour of the cell, the number formatting, the text alignment, the font formats, borders etc. You can modify existing styles to suit your needs.
Is it true that data can only be sorted by a single column (In Excel)?
If you only have a small amount of data, then it could be stored in a single column if appropriate.
What is the address of cell in Microsoft Excel?
Most commonly, you address cells by their column and row intersection. For example, the cell with the address B4 is in the second (B) column and 4 rows down from the top of the sheet.
You can also address a cell by R1C1 format. In R1C1 cell B4 would be 4,2. A third way to address a cell is by giving that cell (or even a range of cells) a name.
Cell addresses can be Absolute, Relative or Mixed. The address $B$4 refers to only (absolute) cell B4 even when you drag or copy the formula that contains that address. There is a quick tutorial on this topic at http://cbt.brainstorminc.com/microsoft/help.php?file=excel9.
You will enter the formula by chosing summation and then clicking the cells, while on cell d3, click enter.
The column part of the reference will increase by 1 for every 1 column to the right you paste to (or decrease if pasting to the left). As long as this results in a valid reference then there will be no error.
So if you have =A1 in cell A2 and copy A2 to C2 it will read =C1.
Tab will move to the next cell and Shift-Tab will move to the previous cell. You can also use the arrow keys to move from one cell to another.
What are the two kinds of sheets in Excel?
Initially there are 3 sheets when you open Excel. They are called Sheet1, Sheet2 and Sheet3. More sheets can be added and any sheet can be renamed.
How do you add V.A.T on excel 2007?
choose where you want to show the vat
type =
click on the cell you want to add vat to
type +0.175*
then click on the cell you want to add vat to
example - =Z1+0.175*Z1
hope this helps
(its a formula by the way!)
