Microsoft Excel Terminologies
Cards (32)
- Refers to an Excel spreadsheet file. The workbook houses all of the data that you have entered and allows you to sort or calculate the results. Is available to be viewed and edited by multiple users on a network is known as a Shared Workbook.
- Within the workbook is where you'll find documents called___. Also known as spreadsheets, you can have multiple nestled in a workbook. Tabs at the bottom of the of the screen will indicate which of your ___ you are currently working on. This is also known as an active ___ or active sheet.
- A rectangle or block housed in a worksheet. Any data that you want to enter into your worksheet must be placed in. can be color coded, display text, numbers and the results of calculations, based on what you want to accomplish. An Active ___ is one that is currently opened for editing.
- Refer to how your cells are aligned. ___ aligned vertically while ___ are aligned horizontally.
- The vertical direction in spreadsheets are called ___.
- Spreadsheets are built in grids with horizontal ___.
- These headings are the lettered and numbered gray areas found just outside of columns and rows. Clicking on a heading will select the entire row or column. You can also alter the row height or column width using the headings.
- Much like worksheets in a workbook, allows you to open numerous files simultaneously.
- Above the workbook is a section of command tabs. A multitude of options are found behind each tab.
- 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.
- Is a collection of cells that have been identified as a group based on a variety of criteria.
- When two or more cells are combined
- Is a formatted workbook or worksheet designed to help users fulfill a specific need in Excel. Examples of this include stock analysis, process map, and calendar.
- Are symbols or signs that indicate which calculation must be made in an expression. Do not necessarily refer to simple mathematical types; comparison, text concatenation or reference operators also exist.
- 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. Is also known as an expression.
- Nestled between the ribbon and workbook, will display the contents of an active cell. In the case of formulas, will display all components of the formula.
- Formatting is applied only when the cell meets determined criteria such as duplicate values or values above or below a threshold.
- Are formulas that are pre-built into Excel. They are designed to help simplify potentially complex formulas in a worksheet.
- Appear if Excel finds a problem with a provided formula.
- This is the act of changing the in which cell data is displayed in the spreadsheet. When you format cells, only the visual appearance of the cells is changed; the value within the cells remains constant.
- Are rules that you can employ to decide which rows in a worksheet to display. These can use data such as conditions or values.
- Allows you to select specific columns and/or rows to remain visible on the worksheet, even if you are scrolling, such as header cells that label a column.
- This enables you to effortless copy data to more than one cell.
- his feature will add up the numbers you have entered in your sheet and displays the total in a cell of your choosing.
- This is an automated format application to cells that match pre-determined criteria. This could be as simple as font alignment and size.
- This feature helps to prevent incorrect data from being entered into your worksheet. This most commonly used to create drop-down lists for common terms. promotes consistency and accuracy in the data to be entered.
- This is a data summarization tool most commonly used to sort, average to sum up data automatically. The information is pulled from one table while the results are displayed in another. makes it easy to retrieve specific information from a large source of data.
- This type of chart provides a visual aid for pivot tables. By providing graphical representations of the pivot table data, the user can provide a level of interactivity with the data.
- Is a point on the worksheet where you would drag a Pivot Table field in order to reorganize how a report is displayed.
- This is the information used to create your pivot table. It can either exist within the worksheet or from and an external database.
- In a pivot table, are identified as the cells that contain the summary information.
- These are sub-categories of fields in your pivot table. If you have a field that is marked State, the items could be Alabama, Alaska and so on.