1.explain the term 'formula 'in MS excel?
2.explain the method of entering numbers as text in MS excel?
3.what is a cell?what does it contain /hold?
4.how can we change the portion of data in a cell using mouse in MS excel?
5.explain the difference between a worksheet and a work book?
ples freands give answers fast and don't give sili answers
Answers
Answer:
1) A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.
2)
On the worksheet, click a cell.
Type the numbers or text that you want to enter, and then press ENTER or TAB. To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER.
3)A Cell is an intersection of a column and a row in a worksheet. It is rectangular in shape. Each cell is identified by its columns letter, and row number, which is known as Cell address. A cell is used to store data, such as text, numbers, formulas, functions etc. A cell can contain up to 32,767 characters
4)When the pointer becomes a move pointer move pointer , drag the cell or range of cells to another location. Select a cell or a cell range. Select Home > Cut Cut or press Ctrl + X. Select a cell where you want to move the data.
5)The workbook is the entire book, while the worksheet is a single page within that book. A workbook can contain, at minimum, one worksheet, and up to a very large number of worksheets that is only limited by the available memory on your computer. Worksheets can be added, deleted or renamed within the workbook.