1. Workbook — A workbook is the name given to an Excel file and contains one or more worksheets. Although you're limited to 255 sheets in a new workbook, Excel doesn't limit how many worksheets you can add after you've created a workbook.
2. Worksheet — A Worksheet is a collection of cells organized in rows and columns. A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets.
3. Cell — A cell is a rectangle or block housed in a worksheet. Any data that you want to enter into your worksheet must be placed in a cell. An Active Cell is one that is currently opened for editing.
4. Columns and Rows — Columns and Rows refer to how your cells are aligned. Columns are aligned vertically while rows are aligned horizontally.
5. Ribbon — Above the workbook is a section of command tabs called the Ribbon. A multitude of options are found behind each tab of the ribbon
6. Cell Reference — A cell reference is a set of coordinates that identifies a specific cell. It's a combination of letters and numbers. A5, for example, would point to the cell located where column A and row 5 intersect.
7. Cell Range — A Cell range is a collection of cells that have been identified as a group based on a variety of criteria. By using a colon (:) between cell references. for example, A1:C1.
8. Merged Cell — When two or more cells are combined, it's become what is known as a merged cell.
9. Formula — A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign. This could be a mathematical equation, cell references, functions or operator. A formula is also known as an expression.
10. Formula Bar — The Formula Bar will display the contents of an active cell. In the case of formulas, the formula bar will display all components of the formula.
11. Function — Functions are formulas that are pre-built into Excel. They are designed to
help simplify potentially complex formulas in a worksheet.
0 Comments:
Post a Comment