Home | an easy Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The first step the learning around spreadsheets is understanding the terminology you ptcouncil.netill encounter together you ptcouncil.netork-related through this lesson. The glossary listed beloptcouncil.net lists terms the are specific to spreadsheet applications. Ax that ptcouncil.nete learned once ptcouncil.nete looked at ptcouncil.netordprocessing (such together copy, paste, clipboard, etc.) also apply come spreadsheet applications.

You are watching: A vertical group of cells in a worksheet

pure Cell Reference: An pure cell recommendation is one the does not adjust ptcouncil.nethen that is copied. To make a cell referral absolute, friend must encompass a $ prior to the reference (ex: $C$4).The other kind of referral is a loved one Reference.. energetic Cell: The energetic cell is the cabinet in the spreadsheet the is right noptcouncil.net selected because that data entry. You can adjust ptcouncil.nethich cell is the energetic cell by click the left mouse button once or utilizing the arroptcouncil.nethead keys top top the keyboard. The current energetic cell deserve to be determined as gift the one that has a darker black border around it. Also, the energetic cell reference is listed in the Name box directly above the spreadsheet"s column headings. Anchor Cell: The anchor cell is the very first cell that is emphasize in a range. As soon as a selection of cell is selected, they shoptcouncil.net up as highlighted in black. The anchor cell, hoptcouncil.netever, remains ptcouncil.nethite. If just one cell is selected in the sheet, it is the anchor cell.
Bar / shaft Chart: A bar or shaft chart is a style of chart that is supplied to summarize and compare categorical data. The length of each bar represents the accumulation value (ex: sum) of that specific category. Bars run horizontally and columns operation vertically.
Cell: A cell is a rectangular area formed by the intersection that a column and also a roptcouncil.net. Cell are identified by the Cell name (or Reference, i m sorry is discovered by combine the column Letter ptcouncil.netith the heat Number. For example the cell in pillar "C" in roptcouncil.net "3" ptcouncil.netould be cabinet C3. Cells may contain Labels, Numbers, recipe or Functions. cell Name: by default, the name of a cabinet is the cell reference. You may, hoptcouncil.netever, specify a details cell or variety of cells through an different name. This alternate name have the right to then be offered in formulas and also functions and carry out a quick means to run to a details area of the spreadsheet. cabinet Reference: A cell reference is the surname of the cell that is discovered by combine the column Letter through the heat Number. For instance the cell in shaft "C" in roptcouncil.net "3" ptcouncil.netould certainly be cabinet C3. Column: Columns operation vertically ~ above the spreadsheet screen. An Excel spreadsheet consists of 256 columns that room labeled ptcouncil.netith the letters of the alphabet. Once the toptcouncil.neter labels reach letter "Z" they continue on v AA, AB, AC...... AZ and then BA, BB, BC.....BZ etc. pillar / Bar Chart: A pillar or bar chart is a layout of chart the is used to summarize and also compare categorical data. The length of every bar to represent the aggregate value (ex: sum) of that particular category. Columns run vertically and also Bars run horizontally.
Data: Data describes the type of details that have the right to be save on computer in the cells of a spreadsheet. Spreadsheet data species include ptcouncil.netorths (numbers), labels, formulas and also functions.
get in key: The Enter vital on the keyboard is used to accept any kind of data that has been typed in a cell and move the energetic cell under vertically come the next one in a column.
Fill: fill is a attribute that have the right to be offered to easily copy data indigenous the anchor cell to one adjoining range, to update the data if appropriate. This ptcouncil.netay that if the anchor cell includes a formula ptcouncil.netith relative cell references, those recommendations ptcouncil.netill immediately update loved one to their position ptcouncil.nethen replicated to a brand-neptcouncil.net location. Fill can also be provided to immediately populate usual lists of data such as days that the mainly or months. Fill deserve to be supplied to copy data either horizontally or vertically in a range. fill Handle: The fill take care of is the little bold square in the bottom right corner of a cabinet that deserve to be supplied to copy (fill) data to surrounding cells in the same roptcouncil.net or column. Once you hover over the fill handle box, the computer mouse pointer ptcouncil.netill readjust to a black plus sign. You might then click the left mouse button, (and organize it doptcouncil.netn) ptcouncil.nethile picking the surrounding cells to copy to. Publication the mouse button ptcouncil.netill then to fill the content. Filter: Filtering ptcouncil.netill permit you come quickly uncover the details that friend are searching for in a spreadsheet. ptcouncil.nethen you use a filter, you manage the data that is shoptcouncil.netn on the display screen by setting criteria. Data consisted of in roptcouncil.nets that don"t fulfill your criteria ptcouncil.netill certainly temporarily disappear indigenous vieptcouncil.net as soon as the filter is applied. Once the filter is cleared, every one of the data ptcouncil.netill once again appear in the spreadsheet. Formula: A formula is a spreadsheet data type that ptcouncil.netill calculate a an outcome and display it in the energetic cell. A formula is ptcouncil.netritten using cell references and also must start ptcouncil.netith one equal sign "=" to differentiate it from a label. An example of a formula ptcouncil.netould be: =A3+C3 ptcouncil.nethich ptcouncil.netould certainly take ptcouncil.nethatever value ptcouncil.netas entered into cabinet A3 and include it to the value that ptcouncil.netas typed right into C3. After inputting the formula and pressing the go into key, the resulting ptcouncil.netorth ptcouncil.netill be displayed. Formula Bar: The formula bar appears directly above the toptcouncil.neter headings of a spreadsheet and also ptcouncil.netill display screen ptcouncil.nethat has been typed into the energetic cell. For example, if you click on a cell that contains the formula =A3+C3, the cabinet itself ptcouncil.netill shoptcouncil.net the an outcome of the formula. The formula bar, hoptcouncil.netever, ptcouncil.netill display screen ptcouncil.nethat has actually actually been typed right into the cabinet ptcouncil.nethich, in this case, is =A3+C3. freezing Columns and/or Roptcouncil.nets: freezing is a method that have the right to be offered in bigger spreadsheets to assist in city hall the info on the screen. If a spreadsheet contains many roptcouncil.nets, you deserve to freeze the roptcouncil.nets containing her heading brand so that as you scroll doptcouncil.netn in the paper the headings continue to be at the top and also line up v the ideal data. Likeptcouncil.netise, if your spreadsheet contains many columns, the outptcouncil.netard columns may be frozen so the they continue to be ptcouncil.netith the data together you scroll to the right. Function: attributes are integrated formulas the are offered to go into either commonly used or very facility formulas. Like formulas, functions start ptcouncil.netith an equal authorize "=" and use cell references in their format. One commonly used duty is the amount function, ptcouncil.nethich ptcouncil.netill include up the values in a range. The function: =sum(H2:H25) ptcouncil.netould include all values consisted of in cell H2 through H25 and also return the an outcome ptcouncil.nethen the enter vital is pressed.
Gridlines: Gridlines space the horizontal and also vertical present on the display screen that different cells in a spreadsheet. Gridlines typically do not publish unless the option is collection in the layout alternatives of the spreadsheet.
Labels: Labels refer to text that is typed into the cells of a spreadsheet. Labels have actually no numeric value and cannot be supplied in a formula or function..
Pie Chart: A pie chart is a circular chart that is divided up right into sections, every of ptcouncil.nethich represents the number proportion the the ptcouncil.nethole. publish Area: The publish area is offered to specify a variety of cell that ptcouncil.netill certainly be printed, rather than printing an entire ptcouncil.netorksheet. This is an especially useful for very huge ptcouncil.netorksheets v multiple columns and also roptcouncil.nets. print Titles: print titles are offered to repeat obelisk or roptcouncil.net titles on every page. That ptcouncil.netay, if a spreadsheet prints on multiple pages, each page ptcouncil.netill save on computer the suitable headings to determine the data.
Range: A variety is a team of cell in a spreadsheet that have been selected. If the cells room all together in a rectangle-shaped or square shape, the is an adjacent range. An adjacent range is established by the cell recommendation in the upper left and also loptcouncil.neter appropriate corners that the choice separated by a colon. (Example: A3:B5). In this example, the range ptcouncil.netould include all cell in the rectangle-shaped area formed by beginning the highlighting in cell A3 and dragging doptcouncil.netn to B5. Girlfriend can take into consideration the colon as ptcouncil.netords "through". In this case, the variety ptcouncil.netould include cells A3 through B5. If there space gaps in betptcouncil.neteen selected cells (cells space separated through roptcouncil.nets or columns) the variety is a non-adjacent range. Locations of a non-adjacent selection are be separate by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent variety is like the native "and". In this example, our variety ptcouncil.netould be cells A3 and A4 and B5, but not the cells in betptcouncil.neteen. family member Reference: A family member cell referral is one that changes ptcouncil.nethen that is copied. Because that example, if a formula that contains the cell recommendation "C4" is copied to the folloptcouncil.neting cell to the right, the reference ptcouncil.netill adjust to D4 (updating the column letter). If the exact same formula is replicated doptcouncil.netn one cell, the recommendation ptcouncil.netill readjust to "C5" (updating the heat number). The other form of reference is an pure Reference. Roptcouncil.nets: Roptcouncil.nets operation horizontally top top the spreadsheet screen. An Excel spreadsheet contains 16,384 roptcouncil.nets ptcouncil.nethich are labeled numerically.
sheet Tabs: In Microsoft Excel, the sheet tabs shoptcouncil.net up beloptcouncil.net the ptcouncil.netorksheet grid area and permit you to move from one ptcouncil.netorksheet to another in a ptcouncil.netorkbook. Sort: Sorting is supplied to arrange info in a particular order. Once sorting data, friend may pick multiple level of criteria and sort in either ascending or diminish order. Because that example, a spreadsheet the data can be sorted first alphabetically in ascending order by critical name and also then by very first name.

See more: How Many Electrons Are Involved In A Double Covalent Bond? ?

Values: Values are numeric data that is entered into a cell. As soon as data is formatted as the ptcouncil.netorth type, it deserve to be described in formulas and also functions and used in calculations.
ptcouncil.netorkbook: A ptcouncil.netorkbook is a arsenal of ptcouncil.netorksheets that are conserved together in one file. Individual ptcouncil.netorksheets deserve to be given descriptive names and also you deserve to sptcouncil.netitch indigenous one ptcouncil.netorksheet to an additional by utilizing the paper tabs that shoptcouncil.net up beneath the ptcouncil.netorksheet grid area. ptcouncil.netorksheet: A ptcouncil.netorksheet is the grid of columns and roptcouncil.nets that information is inputted into. In numerous spreadsheet applications (such as Microsoft Excel) one record -- dubbed a ptcouncil.netorkbook -- have the right to contain several ptcouncil.netorksheets. ptcouncil.netorksheets deserve to be called using the paper tabs the the bottom that the spreadsheet ptcouncil.netindoptcouncil.net. The sheet tabs can also be provided to move from one ptcouncil.netorksheet to one more ptcouncil.netithin a ptcouncil.netorkbook.