Home | straightforwgc2010.orgard Computer functions | Spreadsheets
Page 1 - 2 - 3
Spreadsheets -- Terminology
The very first step of learning around spreadsheets is knowgc2010.orgledge the ax you wgc2010.orgill certainly encounter as you wgc2010.orgork through this lesson. The glossary listed belowgc2010.org lists terms that are certain to spreadsheet applications. Hatchet that us learned once wgc2010.orge looked in ~ wgc2010.orgordprocessing (such together copy, paste, clipboard, etc.) also apply come spreadsheet applications.
You are watching: ____ below the worksheet grid let you switch from sheet to sheet in a workbook.
pure Cell Reference: An absolute cell reference is one that does not change wgc2010.orghen the is copied. To make a cell referral absolute, you must encompass a $ before the reference (ex: $C$4).The other form of referral is a relative Reference.. active Cell: The active cell is the cabinet in the spreadsheet that is currently selected because that data entry. You can adjust wgc2010.orghich cabinet is the active cell by click the left mouse swgc2010.orgitch once or using the arrowgc2010.orghead keys on the keyboard. The current active cell can be figured out as gift the one that has actually a darker black border roughly it. Also, the active cell reference is provided in the Name crate directly over the spreadsheet"s shaft headings. Anchor Cell: The anchor cabinet is the very first cell the is emphasize in a range. wgc2010.orghen a range of cell is selected, they showgc2010.org up as emphasize in black. The anchor cell, howgc2010.orgever, stays wgc2010.orghite. If just one cabinet is selected in the sheet, the is the anchor cell.
Bar / column Chart: A bar or column chart is a layout of chart the is provided to summarize and also compare categorical data. The size of each bar to represent the aggregate value (ex: sum) of that specific category. Bars run horizontally and also columns run vertically.
Cell: A cabinet is a rectangular area formed by the intersection of a column and also a rowgc2010.org. Cell are established by the Cell name (or Reference, i m sorry is found by combining the pillar Letter through the rowgc2010.org Number. For instance the cabinet in shaft "C" in heat "3" wgc2010.orgould be cabinet C3. Cells may contain Labels, Numbers, recipe or Functions. cabinet Name: by default, the surname of a cell is the cell reference. Friend may, howgc2010.orgever, define a details cell or selection of cells through an different name. This alternative name can then be provided in formulas and functions and carry out a quick means to run to a particular area the the spreadsheet. cell Reference: A cell reference is the surname of the cell that is discovered by combining the shaft Letter v the rowgc2010.org Number. For example the cell in obelisk "C" in heat "3" wgc2010.orgould certainly be cabinet C3. Column: Columns operation vertically ~ above the spreadsheet screen. An Excel spreadsheet has 256 columns that space labeled through the letters of the alphabet. Once the column labels reach letter "Z" they continue on through AA, AB, AC...... AZ and also then BA, BB, BC.....BZ etc. towgc2010.orger / Bar Chart: A obelisk or bar graph is a layout of chart that is provided to summarize and also compare categorical data. The size of every bar represents the accumulation value (ex: sum) the that details category. Columns run vertically and Bars operation horizontally.
Data: Data refers to the form of information that deserve to be save in the cells of a spreadsheet. Spreadsheet data varieties include values (numbers), labels, formulas and also functions.
enter key: The Enter an essential on the keyboard is used to accept any type of data that has actually been typed in a cell and move the energetic cell under vertically to the next one in a column.
Fill: to fill is a feature that can be offered to easily copy data from the anchor cell to an adjoining range, to update the data if appropriate. This method that if the anchor cell includes a formula wgc2010.orgith family member cell references, those recommendations wgc2010.orgill immediately update loved one to their position wgc2010.orghen replicated to a brand-newgc2010.org location. To fill can also be offered to automatically populate usual lists of data such as days the the mainly or months. Fill deserve to be offered to copy data either horizontally or vertically in a range. fill Handle: The fill handle is the little bold square in the bottom right edge of a cell that have the right to be supplied to copy (fill) data to adjacent cells in the same rowgc2010.org or column. Once you float over the fill take care of box, the mouse pointer wgc2010.orgill readjust to a black plus sign. You might then click the left mouse button, (and organize it dowgc2010.orgn) wgc2010.orghile selecting the nearby cells come copy to. Publication the mouse swgc2010.orgitch wgc2010.orgill then to fill the content. Filter: Filtering wgc2010.orgill enable you to quickly find the information that friend are searching for in a spreadsheet. Once you use a filter, you regulate the data the is displayed on the display by setup criteria. Data consisted of in rowgc2010.orgs the don"t satisfy your criteria wgc2010.orgill temporarily disappear indigenous viewgc2010.org wgc2010.orghen the filter is applied. wgc2010.orghen the filter is cleared, every one of the data wgc2010.orgill wgc2010.orghen again showgc2010.org up in the spreadsheet. Formula: A formula is a spreadsheet data kind that wgc2010.orgill calculate a result and display screen it in the active cell. A formula is wgc2010.orgritten using cell references and must begin wgc2010.orgith an equal sign "=" to differentiate it native a label. An example of a formula wgc2010.orgould be: =A3+C3 wgc2010.orghich wgc2010.orgould take everything value wgc2010.orgas gotten in into cabinet A3 and include it come the wgc2010.orgorth that to be typed into C3. After inputting the formula and also pressing the enter key, the resulting value wgc2010.orgill be displayed. Formula Bar: The formula bar showgc2010.orgs up directly above the pillar headings that a spreadsheet and wgc2010.orgill display wgc2010.orghat has actually been typed into the energetic cell. Because that example, if you click a cell that consists of the formula =A3+C3, the cell itself wgc2010.orgill present the result of the formula. The formula bar, howgc2010.orgever, wgc2010.orgill display wgc2010.orghat has actually actually been typed into the cell wgc2010.orghich, in this case, is =A3+C3. freeze Columns and/or Rowgc2010.orgs: freezing is a an approach that have the right to be used in bigger spreadsheets to assist in the towgc2010.orgn hall the information on the screen. If a spreadsheet has many rowgc2010.orgs, you can freeze the rowgc2010.orgs containing your heading brand so that as you scroll dowgc2010.orgn in the paper the headings continue to be at the top and also line up wgc2010.orgith the appropriate data. Likewgc2010.orgise, if your spreadsheet consists of many columns, the leftmost columns may be frozen so the they continue to be wgc2010.orgith the data together you scroll to the right. Function: attributes are built-in formulas the are provided to get in either frequently used or very complex formulas. Choose formulas, functions begin wgc2010.orgith an equal authorize "=" and use cell referrals in their format. One commonly used duty is the amount function, i beg your pardon wgc2010.orgill include up the wgc2010.orgorths in a range. The function: =sum(H2:H25) wgc2010.orgould include all values consisted of in cells H2 through H25 and return the result wgc2010.orghen the enter key is pressed.
Gridlines: Gridlines are the horizontal and also vertical currently on the screen that separate cells in a spreadsheet. Gridlines generally do not publish unless the option is set in the layout options of the spreadsheet.
Labels: Labels refer to text that is typed right into the cells of a spreadsheet. Labels have no numeric value and cannot be provided in a formula or function..
Pie Chart: A pie chart is a circular chart that is separated up into sections, each of wgc2010.orghich to represent the numerical proportion that the wgc2010.orghole. print Area: The publish area is offered to specify a selection of cell that wgc2010.orgill be printed, fairly than printing wgc2010.orghole wgc2010.orgorksheet. This is particularly useful because that very huge wgc2010.orgorksheets through multiple columns and rowgc2010.orgs. publish Titles: print titles are supplied to repeat column or heat titles on each page. That wgc2010.orgay, if a spreadsheet prints on many pages, each page wgc2010.orgill save the appropriate headings to recognize the data.
Range: A variety is a team of cell in a spreadsheet that have actually been selected. If the cells space all together in a rectangle-shaped or square shape, the is one adjacent range. One adjacent range is determined by the cell referral in the upper left and lowgc2010.orger ideal corners the the an option separated by a colon. (Example: A3:B5). In this example, the selection wgc2010.orgould encompass all cells in the rectangle-shaped area developed by beginning the highlighting in cell A3 and also dragging under to B5. You can consider the colon as the wgc2010.orgord "through". In this case, the range wgc2010.orgould include cells A3 through B5. If there room gaps betwgc2010.orgeen selected cell (cells space separated by rowgc2010.orgs or columns) the range is a non-adjacent range. Locations of a non-adjacent variety are be separated by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent variety is prefer the indigenous "and". In this example, our range wgc2010.orgould be cell A3 and also A4 and B5, but not the cells in betwgc2010.orgeen. relative Reference: A family member cell referral is one that changes wgc2010.orghen it is copied. For example, if a formula that consists of the cell referral "C4" is duplicated to the next cell come the right, the reference wgc2010.orgill change to D4 (updating the shaft letter). If the same formula is copied dowgc2010.orgn one cell, the reference wgc2010.orgill readjust to "C5" (updating the heat number). The other form of recommendation is an absolute Reference. Rowgc2010.orgs: Rowgc2010.orgs run horizontally top top the spreadsheet screen. An Excel spreadsheet has 16,384 rowgc2010.orgs wgc2010.orghich are labeled numerically.
paper Tabs: In Microsoft Excel, the paper tabs showgc2010.org up belowgc2010.org the wgc2010.orgorksheet net area and enable you to swgc2010.orgitch from one wgc2010.orgorksheet to another in a wgc2010.orgorkbook. Sort: Sorting is provided to arrange info in a certain order. wgc2010.orghen sorting data, friend may pick multiple level of criteria and sort in one of twgc2010.orgo people ascending or diminish order. For example, a spreadsheet that data can be sorted very first alphabetically in ascending bespeak by critical name and then by an initial name.
See more: The Price Renaissance Mysteries Volume Ii, Price Revolution
Values: Values space numeric data the is gone into into a cell. Once data is formatted as the value type, it have the right to be referred to in formulas and functions and used in calculations.
wgc2010.orgorkbook: A wgc2010.orgorkbook is a repertoire of wgc2010.orgorksheets that are conserved together in one file. Individual wgc2010.orgorksheets can be offered descriptive names and also you can swgc2010.orgitch indigenous one wgc2010.orgorksheet to one more by using the paper tabs that appear beneath the wgc2010.orgorksheet grid area. wgc2010.orgorksheet: A wgc2010.orgorksheet is the net of columns and rowgc2010.orgs that info is inputted into. In numerous spreadsheet applications (such together Microsoft Excel) one document -- dubbed a wgc2010.orgorkbook -- can contain numerous wgc2010.orgorksheets. wgc2010.orgorksheets have the right to be named using the sheet tabs of the bottom of the spreadsheet wgc2010.orgindowgc2010.org. The sheet tabs can additionally be provided to swgc2010.orgitch from one wgc2010.orgorksheet to an additional wgc2010.orgithin a wgc2010.orgorkbook.