Microsoft Office Excel is a spreadsheet application. It is a fantastic application for holding values, making calculations, building tables and graphing. Microsoft Office Excel is very popular among the business sector for its strong financial tracking, and is used by many teachers to track performance progress; it is also a great tool for household budgeting. These features are not MS Excel’s limitations. The software has numerous abilities and benefits for all industries and sectors.
Common Excel Terms and Tools
Alphabet – The alphabet or font on a worksheet, chart or graph can determine the level of professionalism or fun of a Microsoft Excel document. Learn how to change font in a data sheet (style, size, and color) and get additional fonts for every occasion.
Borders – Borders around cells in a Microsoft Excel worksheet will put emphasis on the data within the cell. Borders will also separate like data from other data. Learn how to apply and work with borders.
Charts – Charts contain related data in a worksheet. Learn how to create charts for work, school, or personal use.
Databases – This is an organized collection of information.
Exit – The Exit command is located in the File menu. This is used to close the document.
Gridlines – These are lines that can be applied so the cells are easier to see.
Hide – Rows and columns can be hidden within a worksheet.
Insert – Rows and columns can be inserted into a worksheet.
Justify – This is used to refer to aligning text in a cell evenly centered within the right and left margins.
Merging – This is taking two or more cells and combining them to create one cell.
Name Box – This is a box located at the end of the formula bar. It identifies a selected cell. A cell or cell group can be titled by typing in the Name Box and pressing the Enter key.
Range – This is multiple cells in a worksheet.
Sort Order – This allows the user to arrange data in cells based on data type or value. I.e., by date, numerically, or alphabetically in ascending or descending order.
Unhide – Rows and columns can be unhidden and viewable within a worksheet.
Value – This is text, a number, a date, or any input within a cell that meets a condition that a field needs to filter or search.
Workbook – This is a basic Microsoft Excel document that contains one or more spreadsheets.
Zoom – This enables a user to increase or decrease the size of a worksheet.
Formulas – Formulas are expressions used to calculate values. These are simple calculations to the very complex. Formulas will calculate and show a result of data from multiple cells values.
Operations – These are mathematical, logical, comparison, and reference operators. They are made up of a symbol or sign specifying a type of calculation performed within an expression.
Template – A Microsoft Excel template can be used to create a spreadsheet or the user can create and save it.
Password – A password can be created to protect a worksheet or entire workbook.
Locked – Cells, objects, and/or entire worksheets can be locked making it a “read only" field or document.
