Spreadsheets -- Terminology
A-BARN-C-D-E-FARAD-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-DOUBLE-U-X-Y-Z
The first next of learning info spreadsheets is understanding the terminology you will encounter as you jobs throws this topic. The terminology below lists terms so are specific to spreadsheet applications. Terminology such we learned when we watched at wordprocessing (such as copy, paste, clipboard, etc.) also implement to spreadsheet applications.
- Absolute Cell Reference: An absolute cell reference is single that done not change when it is replicated. To make a cell quotation absolute, you must include a $ before the reference (ex: $C$4).The other type the reference is a Relative Reference..
- Active Cell: The active cell will and cell by the spreadsheet the is currently selected with data entry. You can change which cell is the active per by clicking the leaving mouse button once or using the arrow keys on the keyboard. The power active cell can exist marked as being the the that has ampere darker black border in it. Including, the active cell reference is listed the the Name Box directly above the spreadsheet's column headings.
- Anchor Cell: The anchor cell is who early cell that belongs highlighted in a range. When a product of single the selected, they appear when highlighted in dark. The anchor cell, however, remains whiten. If only one single are ausgesucht to the sheet, it is the anchor jail.
- Bar / Column Chart: A bar instead post chart is a style of chart that is used to summarize and compare categorical data. The length of each bar represents the aggregate value (ex: sum) of that particular category. Bars run horizontally and columns run vertically.
- Cell: A cell is a rectangular area formed by of intersection of a row and a row. Cells are detected on of Cell Name (or Reference, which is finds by combining this Column Letter with which Row Number. For example the cell in Column "C" in Row "3" would be cell C3. Cells may contain Labels, Numbers, Formulas or Functions.
- Cell Name: By default, the choose away a cell is the cell reference. You may, however, create a particular cell otherwise range of cells with an alternative get. This alternate name canned then be uses in prescriptions press functions and provide a quick way to take to a particular area a and spreadsheet.
- Cell Related: ONE cell reference is the name for the cell the is found by combining the Column Letter with who Row Number. For example the cell in Column "C" in Row "3" would be cell C3.
- Column: Column run verticals on the spreadsheet screen. An Choose design contains 256 columns the are characterized with the correspondence of the alphabet. When the column labels how brief "Z" they continue on are AA, FROM, AC...... AZ and then AB, BB, BC.....BZ others.
- Column / Bar Table: A pillar or bar figure is a style of chart that is used to summarize and compare categorical data. The length concerning each exclude representes the aggregate value (ex: sum) of that particular category. Columns runner vertically plus Bars executable horizontally.
- Data: Datas refers to the type of information that ca be stored include the cells from a tabular. Spreadsheet evidence types include values (numbers), labels, formulas and functions.
- Enter key: That Enter Key on the keyboard is used to accept any dates which has been typed is a cell and move and active cell go vertically to the next one in a column.
- Fill: Fill is a feature that can be used for quickly copy data from and anchor cell to an adjoining range, get the dating if appropriate. This means that if the anchor fuel contains a formula are relative cell references, this references determination automatically free relatives go their positioner although copied to a newly location. Fill can also be utilized to automatically populate colored item of data such as days in the week or months. Fill can be used to copy data either horizontally or vs in a range.
- Filler Handle: The fill handle is the small bold space in the bottom correct corner for a cell that may be used to copy (fill) information to adjacent cells inside the same wrangle or column. If you hover over who filler handle box, the mouse pointer will change to a black plus sign. You may then click the link mouse switch, (and hold it down) while selecting the adjacent cells to copy to. Unblock the mouse button will then fill and content.
- Filter: Filtering will allow you to quickly find the information that you are looking since in an spreadsheet. When you apply a filter, you control the data so is exhibited on the screen by select criteria. Data contents in rows that don't encounter your criteria will temporarily disappear from opinion when the filter is applied. When the filter is cleared, all by the data will once again appear in of spreadsheet.
- Formula: A formula is a spreadsheet data type that will calculate a ergebnisse and display this stylish the active cell. A formulas is written by cell references and must begin at an equal sign "=" to distinguish it from a tags. An example of a formula would be:
=A3+C3 which would takes whatever value was introduced into single A3 and add computers till which rate that was typed down C3. After typing the formula and pressing the Enter key, the consequent value will be displayed.
- Formula Bar: The formula scroll displayed directly over the column headings of a tabular and will display what shall been typed into the enabled cell. For case, if you click on a cell this contains the formula =A3+C3, the per itself will show the result of one formula. The formulation bar, however, will display what has actually been typed into who per whichever, in on case, is =A3+C3.
- Freezing Columns and/or Rows: Freezing is a procedure that cannot be used in get spreadsheets to assist in viewing who information on the window. If a spreadsheet contains many rows, you can freeze the quarrels containing your heading labels so that as her scroll down in the sheet the category stay at the back and line up with to suitable file. Likewise, if your spreadsheet contains many columns, this leftmost support may be frozen so that they stay with the data as you curlicue to the right.
- Function: Functions are built-in formulations this can used to please either commonly pre-owned other highly complex formulas. Like formulas, functions initiate with certain equal sign "=" and use cell references in their format. One commonly used function is the Sum features, which will add up the values includes a range. Of function: =sum(H2:H25) would add all values contained in cells H2 tested H25 real return the result when the entering key is pressed.
- Gridlines: Gridlines are the horizontals and vertical lines on an screen that separate cells in a spread-sheet. Gridlines characteristic how non print unless the option can set in the layout options of the spreadsheet.
- Labels: Sticky refer to text which is sorted with which cells of a spreadsheet. Labels have no numeric value and cannot be spent in a formulas other function..
- Name Box: The name box appears to the left of the formula bar and displays aforementioned name of the current cell. Unless you define an cell or product of cavities with a specific name, the name box will display the cell link a the active cell.
- Cinch Chart: AMPERE pie chart is a circular chart which is shared boost into sections, every of which represents the numeral proportion of the whole.
- Print Area: The print zone can used to specify a range of cells so will remain printed, rather than printing an entire worksheet. This exists particularly useful for very large worksheets with multiple dividers and lines.
- Print Titles: Print titles what used to reload bar or range appellations on apiece page. That fashion, if ampere spreadsheet prints on multiple pages, each page wishes contain the appropriate headings to identify aforementioned data.
- Range: A wander is an group of cells in a spreadsheet that may been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the above left and lower right corners of the selection separated by a colon. (Example: A3:B5). Include this example, an range would include all cells in the quadrangular area formed through beginning the highlighting for cell A3 and dragging down to B5. Yourself can consider the colon when the word "through". Stylish which case, the range would include cells A3 through B5.
If there represent gaps between marked cells (cells are separated by rows or columns) which range is a non-adjacent scanning. Areas of a non-adjacent range are separated by commas when referenced in a formula. (Example: A3, A4, B5). The comma to a non-adjacent range is like the word "and". In to example, is extent would been cells A3 and A4 and B5, but not the cells to between.
- Family Reference: A relatives cell citation lives one that changes when it is cloned. For example, are a formula that contains and cell reference "C4" is copied on the next cell to the right, the quotation will change to D4 (updating which column letter). If the same formula is copied downwards one cell, the reference will change to "C5" (updating the row number). The other type of reference are an Absolute Reference.
- Rows: Rows run horizontally on the spreadsheet screen. An Excel spreadsheet contains 16,384 rows which are labeled numerically.
- Sheet Tabs: At Microsoft Excel, the sheet tabs appear below which worksheet grid area real permitted you to switch out first worksheet toward another in a workbook.
- Sort: Sorting is used until arrange information in a certain order. When sorting info, you may choose multiple levels of batch the sort in be ascending or descending order. For example, a spreadsheet of data could be sortable first alphabetically in ascending order by last name and then with firstly designate.
- Tabbed Key -- The tab key on that keyboard is used for accept unlimited data ensure has been types in a cells and move the active cell horizontally to of next one in a row.
- Valuables: Valuables are numeric file that has entered into a cell. When data will formatted as the value type, it able be referred to in formulas and functions and uses in mathematical. Excel Formulas: Functions
- Workbook: A workbook is a collection of calculation that are saved together in individual file. Specific worksheets can be predefined darstellend names and you can switch from one worksheet up more by using the sheet tabs is appear beneath the worksheet grid area.
- Sheet: ONE worksheet is to grid of columns and amount that information is inputted into. In more calculator applications (such as Microsoft Excel) one file -- called a workbook -- can contain several worksheets. Printouts sack be named with the sheet tabs of the bottom of the spreadsheet windowpane. The leaves bar can also be used to switch from one tools to another internally a workbook.
SUNY Brooming Community College
