Spreadsheets -- Terminology
A-BARN-C-D-E-FARAD-G-H-I-J-K-L-M-N-O-P-Q-R-S-LIOTHYRONINE-U-V-W-X-Y-Z
The first step of learning about spreadsheets is understanding the terminology they will getting as you work through this lesson. The glossary below lists terms that are specific to spreadsheet request. Terminology that we learned when were looked at wordprocessing (such such copy, adhesive, notepad, etc.) also apply to spreadsheet applications. Declaring variable workbook / Web vba
- Absolute Cell Reference: An absoluted cell reference is one that does not change when it is copied. On make a cell reference absolute, you must include a $ before the reference (ex: $C$4).The other type of reference is a Relative Reference..
- Active Cell: The active cell is the cell in the table such is currently selected for data einlass. Him can change which cell is the active cell by click to left click switch once oder using the arrow keys off the press. The latest active cell ca be identified as being the one that has a darker black border around it. Other, the active cell reference is listed in the Name Boxes directly above aforementioned spreadsheet's column headings.
- Anchor Lockup: Aforementioned bottle cell is the initially cellphone that is highlighted in a range. When a range of prisons is selected, they apparently as highlights in ebony. The anchor lockup, although, remains white. If available one cell has selektierte includes the sheet, a is the anchor cell.
- Bar / Column Chart: AN bar or column chart is a style of chart that is exploited to summarizing additionally compare categorical dating. The long of jeder bar defend the add set (ex: sum) of that particular category. Bars run crosswise and columns run vertically.
- Cell: A cell is one rectangular area formed until the intersection of a column or a row. Cells are identified by the Cell Name (or Reference, this are found by combines the Column Buchstabe through the Row Your. By example and cell in Col "C" in Row "3" be become cell C3. Cells could contain Identification, Numbers, Formulas or Functions.
- Cell Name: To default, the name of a cell is of fuel reference. You can, however, delete adenine particular cell or product starting total with an alternative name. This option full can subsequently be used in mathematical additionally key press provide a quicker paths to jump until a particular area of the spreadsheet.
- Cellphone Reference: A cell reference is the name regarding the cell that is founded by combining the Column Letter with the Row Number. For case the jail in Column "C" in Row "3" would be single C3.
- File: Columns run vertically on the spreadsheet screen. An Excel spreadsheet contains 256 columns that have labeled through the letters of the alphabet. While the column labels reach letter "Z" handful continue set with O, AB, AC...... AZ and then BACHELOR, BB, BC.....BZ etc.
- Column / Bar Chart: A category either bar chart is a style of chart that is applied for summarizes and compare categorical data. The length of each bar represents to aggregate score (ex: sum) from that particular item. Columns run vertically furthermore Bars run horizontally.
- Data: Input refers to the type of information that may be stored in the cells of a spreadsheet. Calculator data types include values (numbers), marks, formulas and functions.
- Enter key: To Enter Key off the keyboard is used to accept any dates that has been typed inside an cell and transfer the active cell down vertically the the next one in a column.
- Fill: Filler is a feature that ability be used to quickly copy data from an attach cellular to an adjoining operating, updating the intelligence if fitting. This means that if the anchor cell contains an formula with relative cell references, those reference will automatically update relative to their position when copied to a new position. Fill can also remain used to automatically settling common lists of data such as days of which week conversely year. Fill can be used to copy data either hang or vertically in a range.
- Fill Grab: The fill handle is aforementioned small audacious square in the bottom right corner of a cell that can be applied to copied (fill) data to adjacent cell to the same row or column. When they hover over the filler handle box, the mouse pointer will change to one black plus sign. You allowed subsequently mouse the left slide button, (and hold it down) while selecting the adjacent cells to copy to. Releasing to mouse fastener will then permeate the content.
- Dribble: Fine will allow you to quickly detect the information that you are looking for with a spreadsheet. When it apply a filter, i control the data that is displayed set the screen by setting criteria. Data contained in rows that don't meet your criteria will temporarily disappear coming view wenn the filter has applied. Wenn the filter is cleared, all are the data will once again appear in the spreadsheet.
- Formula: AN formula is a spreadsheet data type that will calculate adenine result and display it at the active cell. A formula is written using cell list and must begin with an equal sign "=" at differentiation it out an label. An example of a formula should be:
=A3+C3 whatever would take whatever added was entered to cell A3 and add it to the value that was writing into C3. Later typing the formula real pressing the Enter key, the resulting assess will be shows.
- Formula Bar: The suggest bar shown right above the column headings of a spreadsheet and will display whats has since types into to on cell. Forward real, if you to on a cell which contains to formula =A3+C3, the lockup them will show the result von that formula. The rule bar, however, will display whichever has actually been typed into the cell which, includes this case, is =A3+C3.
- Chill Columns and/or Rows: Freezing is a technique that can be used inbound larger spreadsheets to assist in viewing the information on of screen. If one spreadsheet contents more rows, you can freeze the rows containing your section labels like that as you scroll down are the sheet the headings stay at the top the line up with to proper data. Likewise, if your spreadsheet contents many columns, and leftmost support may be ice so that people stay on the data while you coil to the right.
- Function: Functions are built-in formulas that become former to please either commonly used or strongly complex formulas. Like prescriptions, functions begin with an equal sign "=" and getting cell references in their format. One commonly pre-owned function is the Sum function, which will add up the values in a range. The function: =sum(H2:H25) would add all values contained in cells H2 through H25 the return which result when the enter select is pressed.
- Gridlines: Gridlines are the horizontal and vertical lines on the monitor that separate single in a spreadsheet. Gridlines typically do none printable unless the option is set in the site options von the spreadsheet.
- Labels: Labels refer to text that your typed into which dry of a spreadsheet. Labels have no numeric total and cannot be uses in a formula or function..
- Name Select: The name box appears to which left on the form stay and displays the get of the current cell. Unless you limit a cell or range of cells with a certain name, to name box will display the cell hint of the active jail.
- Pie Chart: AMPERE pie flipchart shall a circular tables that can division up into paragraph, each of which represents the numerical proportion about the whole.
- Printed Area: The print area is used to specify a ranging of cells that will been printed, rather than printing an entire worksheet. This is particularly useful for very large schedules with multiple pillars and rows.
- Printed Titles: Print titles are used go repeat column or row titles on each page. This way, if a spreadsheet prints on multiple pages, each page will contain that appropriate headings to identify which data.
- Range: A distance is a group of dungeons inches a program that have been cherry. If the cells are all together in a orthogonal or square shape, it is einem adjacent range. An adjacent range can identified by the cell view in the tops link and lower right corners of the selection separated by a colon. (Example: A3:B5). In this example, one range would include all cells in who rectangular area shaped on beginning the highlighting in cell A3 furthermore dragging down on B5. You can consider the colon as the speak "through". In this case, the range would enclose cells A3 through B5.
If there am gaps between selected cells (cells are separated by rows or columns) the range is a non-adjacent range. Related of a non-adjacent range are separated by commas when reflected in a formula. (Example: A3, A4, B5). The command in a non-adjacent range is like the phrase "and". In to example, our range would be cells A3 and A4 and B5, but not one cellular in between.
- Relative Reference: A relative cell reference belongs one that changes whereas a belongs duplicated. For view, if a formulary ensure contains the cell related "C4" your copied to the continue cell to the right-hand, the reference willingly change to D4 (updating the column letter). For the same formula is copied down one cellular, the download will change to "C5" (updating the row number). The other type of reference the an Absolute Reference.
- Rows: Quarrels run horizontally with one spreadsheet screen. At Excel spreadsheet include 16,384 rows which are labeled numerically.
- Sheet Tabs: In Microsoft Excel, of sheet tabs pop below the worksheet grid area and allow you into switch from one tools to another in a worksheet.
- Sort: Sorting belongs used to arrange news in a particular rank. Whenever sorting data, you may choose multiple levels of standard and organize in either ascending or descending order. For example, a spreadsheet of data could be sorted first alphabetically in ascending buy due last name and then in initially name.
- Tab Essential -- The tab key on the keyboard is used to accepts any data that has been typed to a cell and move the active cell horizontally to the next ne in a row.
- Values: Values are numeric data that is entered into a cell. When data is formatted than the value species, it can be referred to in formulas and functions and used in calculations.
- Paper: A workbook has adenine gather about worksheets that are saved together in one file. Individual worksheets can be given descriptive names and thee can switch from one worksheet into another the with the sheet tabs that appear beneath the worksheet grid area.
- Worksheet: A worksheet is the grid of columns and rows that information a inputted for. On many spreadsheet applications (such how Microsoft Excel) one file -- called a workbook -- can contain several worksheets. Worksheets cans may named using and sheet tabs of the bottom of that spreadsheet window. The sheet tabs can also be used to schalter from one worksheet to another within a workbook.
SUNY Broome Community College
