How can you change the alignment of the text?
In Microsoft products, especially Microsoft Word, you can do it in several ways. First either select the text you want to align, or even just have the cursor in it.
Using key commands you can press and hold the CTRL key and then press one other letter as follows:
Ctrl L for Left Align.
Ctrl E for Centre Align.
Ctrl R for Right Align.
Ctrl J for Justified text.
You can also align by going to the Format menu, then to the Paragraph option and under Indents and Spacing you will find the options for different alignments.
The increase indent button indents the contents of a cell to the right by how many spaces?
three (3) spaces each time you click it.
What identifies a worksheet in a workbook?
It is a sheet tab. The names of the sheets appear on sheet tabs.
Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.
Types of documents created using spreadsheets?
two types of spread sheets are multi dimensional and online spread sheet.
What does the undo icon do in excel?
The function of the undo button is to revert back to the last immediate state. Using the button several times will revert changes for equivalent number of times.
How do you open templates in Excel?
First design what layout you want for your template. Then do a SAVE AS and pick a template rather than a normal workbook.
They could use it for anything from very simple calculations to more complicated formulas using functions of special categories like Engineering, Maths, Logical, Trigonometry, Statistics etc. There are many ways a scientist could use these. Mathematics is a crucial part of many scientific areas. Excel has also got capabilities for doing things like charts and many other things which can be of use to a scientist.
What causes adjacent rows to have different formatting?
Initially all rows have the same formatting. As users enter data they can set different formatting for other cells, columns or rows. They can use Autoformatting, which is capable of picking up on regular data and formulas and apply different formatting to them. You can also use conditional formatting to change the format based on values in the cells or other conditions.
All formulas in Excel begin with?
Are you looking for the one with just = H O and like + and stuff like that?
What is the shortcut key for cut?
Cntrl + C = Copy (Will copy Text, but not erase it from the spot you are copying from.)
Cntrl + X = Cut (Will cut the text out of the document you are editing.)
Cntrl + V = Paste (Pastes materials that have been copied or cut.)
Which function will you use to enter current date and time in a excel worksheet cell?
The TODAY function can enter today's date in Excel. The DATE function can be used to build a date from the day, month and year elements.
What is a tab scrolling button in Excel?
button that appears just to the left of the sheet tabs, which allows you to scroll hidden tabs into view.
Can you create formulas in the Excel cells?
Create a formual in excel by beginning your entry with the equal sign.
EXAMPLE: =A12+B12 adds the content of cell A12 and B12
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
Yes, you can do that.
The function you are looking for is Freeze Pane, to accomlish this, simply do the following.
Excel 2003
Go To: Window > Freeze Pane
Excel 2007
Go To: View > Freeze Pane
What is say comment in cell on Microsoft Excel?
A comment can be added to any cell. It can be used to give additional information about the cell and its contents. To enter a comment, press the Shift-F2 key combination or right click on the cell and choose Insert Comment. After a comment has been put in, you will see a red triangle in the top right corner of the cell. To see a comment, just put the cursor over the cell.
It is the position of text in a cell, whether it is to the left of the cell, the centre of the cell or the right of the cell. If you have a cell that is higher than normal, text can be aligned to the bottom, centre or top. Text can also be written from top to bottom, instead of left to right and it can also be slanted.
What is the data in a cell called in Excel?
They are the cells in a spreadsheet that hold data, as opposed to ones that hold formulas or labels. A data cell contains numbers usually, but it could be other kinds of data like dates or times.
Cells that have any kind of data in them, such as text or numbers, as opposed to cells with formulas.
What is an example of an absolute cell reference?
Relative cell reference: A2
Absolute cell reference: $A$2
When you decrease the row height to blank the row is hidden?
It is considered to have 0 height, at least temporarily.
However, there is no need to decrease the row height to 0 for a hidden row. If you do, when the row is unhidden it will unhide to the default height (generally 15).
For example, you could hide a row of height 50, and when you unhide it it will still be of height 50, not the default.
What does the increase indent button do in excel?
An indent pushes in text to start further in than it would normally do. So if you indent text in a cell, the text won't begin at the left edge of the cell, but a bit further in, depending on the size of the indent.