test

Sunday, 25 September 2022

Explain the basic Microsoft Excel terminology.

 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. 

• 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. 

• 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. 

• Columns and Rows — Columns and Rows refer to how your cells are aligned. Columns are aligned vertically while rows are aligned horizontally. 

• 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 

• 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. 

• 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.


Merged Cell — When two or more cells are combined, it's become what is known as a merged cell. 

• 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. 

• 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. 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