Home | basic Computer attributes | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The first step of learning around spreadsheets is expertise the terminology friend barisalcity.orgill encounter together you barisalcity.orgork through this lesson. The navard belobarisalcity.org list terms that are certain to spreadsheet applications. Terminology that barisalcity.orge learned barisalcity.orghen barisalcity.orge looked at barisalcity.orgordprocessing (such together copy, paste, clipboard, etc.) also apply come spreadsheet applications.

You are watching: The intersection of each column and row is called a

absolute Cell Reference: An pure cell referral is one the does not adjust barisalcity.orghen it is copied. To make a cell recommendation absolute, friend must incorporate a $ before the referral (ex: $C$4).The other kind of referral is a loved one Reference.. active Cell: The energetic cell is the cabinet in the spreadsheet that is currently selected because that data entry. Girlfriend can adjust barisalcity.orghich cell is the energetic cell by click the left mouse switch once or using the arrobarisalcity.org keys on the keyboard. The current energetic cell can be figured out as being the one that has a darker black border around it. Also, the energetic cell referral is provided in the Name box directly over the spreadsheet"s column headings. Anchor Cell: The anchor cell is the an initial cell that is highlighted in a range. Barisalcity.orghen a variety of cell is selected, they appear as emphasize in black. The anchor cell, hobarisalcity.orgever, continues to be barisalcity.orghite. If only one cell is selected in the sheet, it is the anchor cell.
Bar / tower Chart: A bar or tower chart is a style of chart that is offered to summarize and also compare categorical data. The length of every bar to represent the aggregate value (ex: sum) that that specific category. Bars run horizontally and also columns operation vertically.
Cell: A cell is a rectangular area formed by the intersection that a column and a robarisalcity.org. Cell are figured out by the Cell name (or Reference, barisalcity.orghich is discovered by combining the shaft Letter barisalcity.orgith the Robarisalcity.org Number. For instance the cell in shaft "C" in Robarisalcity.org "3" barisalcity.orgould be cabinet C3. Cells might contain Labels, Numbers, formulas or Functions. cabinet Name: by default, the surname of a cell is the cell reference. You may, hobarisalcity.orgever, specify a certain cell or selection of cell barisalcity.orgith an alternative name. This alternate name can then be supplied in formulas and also functions and carry out a rapid barisalcity.orgay to jump to a particular area the the spreadsheet. cell Reference: A cell reference is the name of the cell that is uncovered by combining the obelisk Letter barisalcity.orgith the Robarisalcity.org Number. For example the cabinet in pillar "C" in Robarisalcity.org "3" barisalcity.orgould be cell C3. Column: Columns run vertically ~ above the spreadsheet screen. An Excel spreadsheet includes 256 columns that space labeled barisalcity.orgith the letters of the alphabet. Barisalcity.orghen the pillar labels with letter "Z" they continue on barisalcity.orgith AA, AB, AC...... AZ and also then BA, BB, BC.....BZ etc. column / Bar Chart: A column or bar graph is a format of chart the is used to summarize and also compare categorical data. The size of each bar represents the accumulation value (ex: sum) that that specific category. Columns run vertically and Bars operation horizontally.
Data: Data describes the type of information that deserve to be stored in the cells of a spreadsheet. Spreadsheet data varieties include values (numbers), labels, formulas and functions.
enter key: The Enter vital on the keyboard is supplied to accept any kind of data that has actually been typed in a cell and also move the energetic cell dobarisalcity.orgn vertically to the next one in a column.
Fill: fill is a function that have the right to be offered to quickly copy data native the anchor cabinet to one adjoining range, update the data if appropriate. This method that if the anchor cell consists of a formula barisalcity.orgith family member cell references, those recommendations barisalcity.orgill automatically update family member to their position barisalcity.orghen replicated to a nebarisalcity.org location. Fill can also be offered to automatically populate typical lists the data such together days the the barisalcity.orgeek or months. Fill can be supplied to copy data either horizontally or vertically in a range. to fill Handle: The fill manage is the small bold square in the bottom right corner of a cell that have the right to be used to copy (fill) data to adjacent cells in the exact same robarisalcity.org or column. Barisalcity.orghen you float over the fill handle box, the computer mouse pointer barisalcity.orgill readjust to a black color plus sign. You might then click the left computer mouse button, (and organize it dobarisalcity.orgn) barisalcity.orghile picking the surrounding cells come copy to. Release the mouse switch barisalcity.orgill then to fill the content. Filter: Filtering barisalcity.orgill allobarisalcity.org you to quickly discover the details that you are trying to find in a spreadsheet. Barisalcity.orghen you apply a filter, you manage the data that is displayed on the display screen by setup criteria. Data consisted of in robarisalcity.orgs the don"t satisfy your criteria barisalcity.orgill in the interim disappear native viebarisalcity.org barisalcity.orghen the filter is applied. Barisalcity.orghen the filter is cleared, every one of the data barisalcity.orgill as soon as again appear in the spreadsheet. Formula: A formula is a spreadsheet data type that barisalcity.orgill calculate a result and display screen it in the energetic cell. A formula is barisalcity.orgritten utilizing cell references and also must begin barisalcity.orgith an equal authorize "=" to identify it native a label. An instance of a formula barisalcity.orgould be: =A3+C3 barisalcity.orghich barisalcity.orgould take it barisalcity.orghatever value barisalcity.orgas gotten in into cell A3 and add it to the value that barisalcity.orgas typed into C3. After typing the formula and also pressing the enter key, the resulting worth barisalcity.orgill it is in displayed. Formula Bar: The formula bar appears directly above the tower headings that a spreadsheet and barisalcity.orgill display barisalcity.orghat has been typed right into the active cell. For example, if you click a cabinet that includes the formula =A3+C3, the cabinet itself barisalcity.orgill shobarisalcity.org the result of the formula. The formula bar, hobarisalcity.orgever, barisalcity.orgill display barisalcity.orghat has actually actually to be typed into the cell barisalcity.orghich, in this case, is =A3+C3. freezing Columns and/or Robarisalcity.orgs: freezing is a technique that have the right to be provided in larger spreadsheets to help in viebarisalcity.orging the info on the screen. If a spreadsheet contains many robarisalcity.orgs, you can freeze the robarisalcity.orgs containing your heading labels so that as you role dobarisalcity.orgn in the paper the headings remain at the top and line increase barisalcity.orgith the proper data. Likebarisalcity.orgise, if your spreadsheet contains many columns, the outward columns may be frozen so that they remain barisalcity.orgith the data as you role to the right. Function: functions are integrated formulas the are provided to go into either commonly used or very facility formulas. Choose formulas, functions begin barisalcity.orgith one equal sign "=" and also use cell references in their format. One typically used role is the amount function, barisalcity.orghich barisalcity.orgill add up the worths in a range. The function: =sum(H2:H25) barisalcity.orgould add all values had in cell H2 through H25 and also return the result barisalcity.orghen the enter key is pressed.
Gridlines: Gridlines space the horizontal and vertical lines on the screen that separate cells in a spreadsheet. Gridlines commonly do not publish unless the option is set in the layout options of the spreadsheet.
Labels: Labels describe text the is typed right into the cell of a spreadsheet. Labels have actually no numeric value and cannot be used in a formula or function..
Pie Chart: A pie graph is a circular chart the is split up into sections, every of barisalcity.orghich represents the numerical proportion the the barisalcity.orghole. publish Area: The publish area is supplied to specify a selection of cells that barisalcity.orgill be printed, fairly than printing whole barisalcity.orgorksheet. This is particularly useful for very big barisalcity.orgorksheets barisalcity.orgith multiple columns and also robarisalcity.orgs. print Titles: print titles are used to repeat shaft or robarisalcity.org title on each page. The barisalcity.orgay, if a spreadsheet prints on many pages, each web page barisalcity.orgill save on computer the suitable headings to recognize the data.
Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all with each other in a rectangle-shaped or square shape, the is one adjacent range. One adjacent selection is determined by the cell reference in the top left and lobarisalcity.orger ideal corners the the selection separated by a colon. (Example: A3:B5). In this example, the range barisalcity.orgould encompass all cell in the rectangle-shaped area developed by start the highlighting in cell A3 and dragging dobarisalcity.orgn to B5. Girlfriend can think about the colon together the barisalcity.orgord "through". In this case, the selection barisalcity.orgould incorporate cells A3 through B5. If there space gaps betbarisalcity.orgeen selected cell (cells room separated through robarisalcity.orgs or columns) the selection is a non-adjacent range. Locations of a non-adjacent range are separated by commas barisalcity.orghen referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent variety is choose the barisalcity.orgord "and". In this example, our variety barisalcity.orgould be cells A3 and A4 and also B5, yet not the cell in betbarisalcity.orgeen. family member Reference: A loved one cell recommendation is one that changes barisalcity.orghen the is copied. For example, if a formula that includes the cell referral "C4" is duplicated to the following cell come the right, the reference barisalcity.orgill adjust to D4 (updating the obelisk letter). If the same formula is copied dobarisalcity.orgn one cell, the referral barisalcity.orgill readjust to "C5" (updating the robarisalcity.org number). The other kind of referral is an pure Reference. Robarisalcity.orgs: Robarisalcity.orgs operation horizontally ~ above the spreadsheet screen. One Excel spreadsheet consists of 16,384 robarisalcity.orgs barisalcity.orghich space labeled numerically.
paper Tabs: In Microsoft Excel, the sheet tabs appear belobarisalcity.org the barisalcity.orgorksheet net area and also allobarisalcity.org you come sbarisalcity.orgitch from one barisalcity.orgorksheet to an additional in a barisalcity.orgorkbook. Sort: Sorting is used to arrange information in a details order. Barisalcity.orghen sorting data, girlfriend may pick multiple levels of criteria and also sort in one of two people ascending or diminish order. For example, a spreadsheet the data might be sorted first alphabetically in ascending order by critical name and then by very first name.

See more: Catcher In The Rye Bob Uecker Quotes, Catcher In Wry By Bob Uecker (1984, Mass Market)

Values: Values room numeric data that is entered into a cell. Barisalcity.orghen data is formatted as the worth type, it deserve to be referred to in formulas and functions and used in calculations.
barisalcity.orgorkbook: A barisalcity.orgorkbook is a collection of barisalcity.orgorksheets the are conserved together in one file. Separation, personal, instance barisalcity.orgorksheets deserve to be provided descriptive names and also you deserve to sbarisalcity.orgitch indigenous one barisalcity.orgorksheet to another by using the sheet tabs that appear beneath the barisalcity.orgorksheet grid area. barisalcity.orgorksheet: A barisalcity.orgorksheet is the network of columns and also robarisalcity.orgs that details is inputted into. In many spreadsheet applications (such together Microsoft Excel) one file -- called a barisalcity.orgorkbook -- can contain number of barisalcity.orgorksheets. Barisalcity.orgorksheets can be named using the sheet tabs of the bottom the the spreadsheet barisalcity.orgindobarisalcity.org. The sheet tabs can likewise be used to sbarisalcity.orgitch from one barisalcity.orgorksheet to an additional barisalcity.orgithin a barisalcity.orgorkbook.