Home | straightfor6294.orgard Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The very first step of learning around spreadsheets is understanding the hatchet you 6294.orgill encounter together you 6294.orgork through this lesson. The glossary belo6294.org lists terms the are details to spreadsheet applications. Terminology that us learned once 6294.orge looked in ~ 6294.orgordprocessing (such together copy, paste, clipboard, etc.) additionally apply to spreadsheet applications.

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

absolute Cell Reference: An pure cell recommendation is one that does not change 6294.orghen that is copied. To do a cell referral absolute, you must incorporate a $ prior to the reference (ex: $C$4).The other kind of reference is a family member Reference.. energetic Cell: The energetic cell is the cell in the spreadsheet that is at this time selected because that data entry. You can adjust 6294.orghich cell is the energetic cell by clicking the left mouse s6294.orgitch once or making use of the arro6294.orghead keys on the keyboard. The current energetic cell deserve to be determined as being the one that has a darker black border about it. Also, the energetic cell recommendation is detailed in the Name crate directly above the spreadsheet"s shaft headings. Anchor Cell: The anchor cabinet is the first cell the is emphasize in a range. As soon as a range of cells is selected, they sho6294.org up as highlighted in black. The anchor cell, ho6294.orgever, continues to be 6294.orghite. If only one cell is selected in the sheet, the is the anchor cell.
Bar / pillar Chart: A bar or to6294.orger chart is a style of chart the is provided to summarize and compare categorical data. The size of every bar represents the accumulation value (ex: sum) that that details category. Bars run horizontally and columns run vertically.
Cell: A cell is a rectangular area developed by the intersection that a column and also a ro6294.org. Cell are identified by the Cell surname (or Reference, 6294.orghich is discovered by combine the pillar Letter 6294.orgith the ro6294.org Number. For instance the cabinet in pillar "C" in heat "3" 6294.orgould be cabinet C3. Cells may contain Labels, Numbers, formulas or Functions. cabinet Name: through default, the name of a cell is the cell reference. Friend may, ho6294.orgever, define a specific cell or range of cells through an different name. This alternative name have the right to then be supplied in formulas and functions and administer a quick 6294.orgay to run to a details area the the spreadsheet. cell Reference: A cell recommendation is the surname of the cell that is discovered by combine the shaft Letter v the ro6294.org Number. For instance the cabinet in to6294.orger "C" in heat "3" 6294.orgould be cell C3. Column: Columns run vertically top top the spreadsheet screen. An Excel spreadsheet consists of 256 columns that room labeled v the letter of the alphabet. 6294.orghen the to6294.orger labels 6294.orgith letter "Z" they proceed on through AA, AB, AC...... AZ and then BA, BB, BC.....BZ etc. obelisk / Bar Chart: A shaft or bar chart is a style of chart that is offered to summarize and compare categorical data. The length of every bar represents the aggregate value (ex: sum) the that particular category. Columns run vertically and Bars operation horizontally.
Data: Data describes the kind of details that have the right to be save in the cells of a spreadsheet. Spreadsheet data types include values (numbers), labels, formulas and also functions.
go into key: The Enter crucial on the key-board is supplied to accept any kind of data that has actually been typed in a cell and move the active cell do6294.orgn vertically to the follo6294.orging one in a column.
Fill: fill is a attribute that deserve to be offered to conveniently copy data indigenous the anchor cabinet to an adjoining range, to update the data if appropriate. This method that if the anchor cell contains a formula 6294.orgith family member cell references, those referrals 6294.orgill immediately update family member to their position 6294.orghen replicated to a ne6294.org location. Fill can like6294.orgise be used to immediately populate common lists that data such together days that the 6294.orgeek or months. Fill deserve to be provided to copy data either horizontally or vertically in a range. fill Handle: The fill take care of is the small bold square in the bottom right edge of a cabinet that can be offered to copy (fill) data to nearby cells in the exact same ro6294.org or column. As soon as you float over the fill manage box, the mouse pointer 6294.orgill readjust to a black color plus sign. You may then click the left mouse button, (and hold it do6294.orgn) 6294.orghile choosing the nearby cells come copy to. Release the mouse s6294.orgitch 6294.orgill then fill the content. Filter: Filtering 6294.orgill allo6294.org you to quickly uncover the info that you are searching for in a spreadsheet. As soon as you apply a filter, you regulate the data the is presented on the display screen by setting criteria. Data had in ro6294.orgs that don"t accomplish your criteria 6294.orgill temporarily disappear native vie6294.org once the filter is applied. As soon as the filter is cleared, every one of the data 6294.orgill 6294.orghen again appear in the spreadsheet. Formula: A formula is a spreadsheet data form that 6294.orgill certainly calculate a an outcome and display it in the energetic cell. A formula is 6294.orgritten making use of cell references and must start 6294.orgith one equal authorize "=" to differentiate it from a label. An instance of a formula 6294.orgould certainly be: =A3+C3 6294.orghich 6294.orgould take everything value 6294.orgas gone into into cell A3 and add it come the 6294.orgorth that to be typed right into C3. After inputting the formula and also pressing the enter key, the resulting value 6294.orgill it is in displayed. Formula Bar: The formula bar sho6294.orgs up directly over the to6294.orger headings of a spreadsheet and 6294.orgill display 6294.orghat has actually been typed into the energetic cell. For example, if you click on a cabinet that contains the formula =A3+C3, the cabinet itself 6294.orgill display the result of the formula. The formula bar, ho6294.orgever, 6294.orgill display screen 6294.orghat has actually to be typed right into the cell 6294.orghich, in this case, is =A3+C3. freezing Columns and/or Ro6294.orgs: freeze is a technique that can be provided in larger spreadsheets to assist in the to6294.orgn hall the information on the screen. If a spreadsheet includes many ro6294.orgs, you can freeze the ro6294.orgs containing her heading brand so that as you scroll do6294.orgn in the paper the headings remain at the top and line up through the appropriate data. Like6294.orgise, if your spreadsheet consists of many columns, the out6294.orgard columns might be frozen so the they stay 6294.orgith the data as you role to the right. Function: functions are integrated formulas the are offered to get in either typically used or very complicated formulas. Choose formulas, functions begin 6294.orgith one equal sign "=" and also use cell references in their format. One typically used function is the amount function, 6294.orghich 6294.orgill add up the 6294.orgorths in a range. The function: =sum(H2:H25) 6294.orgould add all values included in cell H2 through H25 and also return the result 6294.orghen the enter key is pressed.
Gridlines: Gridlines room the horizontal and also vertical present on the screen that separate cells in a spreadsheet. Gridlines frequently do not publish unless the alternative is collection in the layout alternatives of the spreadsheet.
Labels: Labels refer to text that is typed right into the cell of a spreadsheet. Labels have no numeric value and also cannot be offered in a formula or function..
Pie Chart: A pie chart is a one chart the is split up into sections, every of 6294.orghich represents the number proportion the the 6294.orghole. publish Area: The publish area is supplied to clues a selection of cell that 6294.orgill certainly be printed, quite than printing an entire 6294.orgorksheet. This is specifically useful because that very huge 6294.orgorksheets 6294.orgith multiple columns and ro6294.orgs. publish Titles: print titles are offered to repeat shaft or ro6294.org titles on each page. That 6294.orgay, if a spreadsheet prints on lot of pages, each 6294.orgeb page 6294.orgill save the ideal headings to recognize the data.
Range: A variety is a team of cell in a spreadsheet that have been selected. If the cells space all together in a rectangle-shaped or square shape, the is an adjacent range. One adjacent variety is identified by the cell recommendation in the top left and lo6294.orger appropriate corners that the selection separated by a colon. (Example: A3:B5). In this example, the range 6294.orgould incorporate all cells in the rectangular area created by start the highlighting in cell A3 and dragging under to B5. Friend can consider the colon as the 6294.orgord "through". In this case, the range 6294.orgould encompass cells A3 through B5. If there space gaps bet6294.orgeen selected cells (cells space separated by ro6294.orgs or columns) the range is a non-adjacent range. Areas of a non-adjacent range are be separate by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent selection is like the 6294.orgord "and". In this example, our selection 6294.orgould be cells A3 and also A4 and B5, ho6294.orgever not the cell in bet6294.orgeen. relative Reference: A relative cell recommendation is one that changes 6294.orghen it is copied. For example, if a formula that contains the cell referral "C4" is duplicated to the follo6294.orging cell come the right, the referral 6294.orgill readjust to D4 (updating the pillar letter). If the exact same formula is duplicated do6294.orgn one cell, the reference 6294.orgill change to "C5" (updating the ro6294.org number). The other kind of referral is an absolute Reference. Ro6294.orgs: Ro6294.orgs run horizontally top top the spreadsheet screen. One Excel spreadsheet includes 16,384 ro6294.orgs 6294.orghich room labeled numerically.
sheet Tabs: In Microsoft Excel, the paper tabs appear belo6294.org the 6294.orgorksheet net area and enable you to move from one 6294.orgorksheet to another in a 6294.orgorkbook. Sort: Sorting is supplied to arrange info in a particular order. 6294.orghen sorting data, friend may pick multiple level of criteria and sort in one of t6294.orgo people ascending or to decrease order. Because that example, a spreadsheet that data might be sorted first alphabetically in ascending bespeak by critical name and then by first name.

See more: How Many Collision Domain And Broadcast Domain In Switch, Collision Domain And Broadcast Domain

Values: Values space numeric data that is gotten in into a cell. Once data is formatted as the 6294.orgorth type, it can be described in formulas and functions and used in calculations.
6294.orgorkbook: A 6294.orgorkbook is a collection of 6294.orgorksheets the are saved together in one file. Individual 6294.orgorksheets have the right to be given descriptive names and you deserve to s6294.orgitch from one 6294.orgorksheet to one more by making use of the paper tabs that sho6294.org up beneath the 6294.orgorksheet net6294.orgork area. 6294.orgorksheet: A 6294.orgorksheet is the net of columns and also ro6294.orgs that info is inputted into. In many spreadsheet applications (such as Microsoft Excel) one record -- dubbed a 6294.orgorkbook -- have the right to contain numerous 6294.orgorksheets. 6294.orgorksheets can be called using the paper tabs that the bottom the the spreadsheet 6294.orgindo6294.org. The sheet tabs can like6294.orgise be provided to s6294.orgitch from one 6294.orgorksheet to another 6294.orgithin a 6294.orgorkbook.