These following terms you will be find in Microsoft Office Excel :
Microsoft Office Excel Cells are the basic building blocks of a worksheet. Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. In other words, it is where a row and column meet.
Microsoft Office Excel Columns are identified by letters (A, B, C).
Microsoft Office Excel Rows are identified by numbers (1, 2, 3).
Microsoft Office Excel Cell Address is based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
Microsoft Office Excel Cell Range is a larger group of cells. Microsoft Office Excel Range is a block of two or more cells.
Microsoft Office Excel Range Reference or Address is represented by the address of the upper left cell and the lower right cell separated with a colon. For example, the range A1:C2 includes 6 cells from A1 through C2. A cell range that included cells A1, A2, B1, B2, C1, C2.
to learn about cell address, click on Microsoft Excel Terms 3 >
Microsoft Office Excel Enter Mode is used to:
- enter the data.
- enter the formula.
- type the reference directly in the cell or in the formula bar, or click the cell you want to refer to.
- edit the data.
- edit the formula.
- type the reference directly in the cell or in the formula bar, or click the cell you want to refer to.
- Select the reference in the formula, and then select another cell or range on the sheet.
- To include more or fewer cells in a reference, drag the color-coded border of the cell or range.
- Paste (Standard) The standard paste option is the most commonly used and is the default action when you press `Ctrl+V` or click the ‘Paste’ button. It copies the content, formatting, and comments from the source cells and pastes them into the destination cells.
- Paste Formulas
When you need to copy formulas from one cell to another, the ‘Paste Formulas’ option comes in handy. This option pastes only the formulas without any formatting or values. - Paste Values
Sometimes, you may want to paste only the values from a cell, discarding any underlying formulas. - Paste Formats
If you want to apply the formatting from one cell to another without copying the content. - Transpose
The ‘Transpose’ option is particularly useful when you need to switch the orientation of your data from rows to columns or vice versa.
Tidak ada komentar:
Posting Komentar