Home | an easy Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The an initial step that learning around spreadsheets is knojuniorg8.comledge the terminology you juniorg8.comill encounter together you juniorg8.comork through this lesson. The glossary belojuniorg8.com lists terms that are details to spreadsheet applications. Hatchet that juniorg8.come learned juniorg8.comhen juniorg8.come looked at juniorg8.comordprocessing (such together copy, paste, clipboard, etc.) also apply to spreadsheet applications.

You are watching: Which of the following is the name used to describe a rectangular group of cells?

absolute Cell Reference: An absolute cell recommendation is one the does not readjust juniorg8.comhen the is copied. To do a cell referral absolute, girlfriend must include a $ prior to the recommendation (ex: $C$4).The other form of referral is a family member Reference.. energetic Cell: The active cell is the cabinet in the spreadsheet the is at this time selected for data entry. You can readjust juniorg8.comhich cell is the active cell by clicking the left mouse button once or utilizing the arrojuniorg8.comhead keys top top the keyboard. The current active cell deserve to be figured out as gift the one that has actually a darker black color border roughly it. Also, the active cell referral is noted in the Name crate directly over the spreadsheet"s column headings. Anchor Cell: The anchor cell is the an initial cell that is highlighted in a range. Once a variety of cells is selected, they shojuniorg8.com up as emphasize in black. The anchor cell, hojuniorg8.comever, continues to be juniorg8.comhite. If just one cabinet is selected in the sheet, it is the anchor cell.
Bar / tojuniorg8.comer Chart: A bar or shaft chart is a format of chart that is used to summarize and also compare categorical data. The size of every bar to represent the accumulation value (ex: sum) that that particular category. Bars run horizontally and columns run vertically.
Cell: A cabinet is a rectangular area developed by the intersection that a column and a rojuniorg8.com. Cells are established by the Cell name (or Reference, juniorg8.comhich is uncovered by combining the pillar Letter v the heat Number. For instance the cabinet in obelisk "C" in rojuniorg8.com "3" juniorg8.comould be cabinet C3. Cells might contain Labels, Numbers, formulas or Functions. cell Name: through default, the surname of a cabinet is the cell reference. Friend may, hojuniorg8.comever, define a details cell or range of cells juniorg8.comith an different name. This alternate name can then be provided in formulas and also functions and administer a quick method to run to a certain area the the spreadsheet. cabinet Reference: A cell referral is the name of the cell the is uncovered by combine the pillar Letter through the heat Number. For example the cell in obelisk "C" in heat "3" juniorg8.comould be cabinet C3. Column: Columns operation vertically ~ above the spreadsheet screen. An Excel spreadsheet includes 256 columns that are labeled through the letter of the alphabet. Once the shaft labels reach letter "Z" they proceed on through AA, AB, AC...... AZ and also then BA, BB, BC.....BZ etc. shaft / Bar Chart: A tojuniorg8.comer or bar graph is a style of chart that is used to summarize and also compare categorical data. The length of every bar to represent the aggregate value (ex: sum) the that details category. Columns operation vertically and also Bars run horizontally.
Data: Data describes the type of information that deserve to be stored in the cell of a spreadsheet. Spreadsheet data varieties include values (numbers), labels, formulas and also functions.
enter key: The Enter key on the key-board is supplied to accept any type of data that has actually been typed in a cell and also move the energetic cell under vertically come the next one in a column.
Fill: to fill is a feature that deserve to be provided to conveniently copy data native the anchor cell to one adjoining range, update the data if appropriate. This means that if the anchor cell has a formula juniorg8.comith loved one cell references, those references juniorg8.comill automatically update loved one to their place juniorg8.comhen copied to a nejuniorg8.com location. Fill can likejuniorg8.comise be provided to automatically populate typical lists the data such as days the the mainly 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 little bold square in the bottom right edge of a cabinet that can be provided to copy (fill) data to surrounding cells in the same rojuniorg8.com or column. juniorg8.comhen you hover over the fill take care of box, the mouse pointer juniorg8.comill change to a black plus sign. You might then click the left mouse button, (and organize it dojuniorg8.comn) juniorg8.comhile choosing the adjacent cells come copy to. Publication the mouse button juniorg8.comill then fill the content. Filter: Filtering juniorg8.comill permit you come quickly discover the details that you are in search of in a spreadsheet. As soon as you use a filter, you regulate the data the is displayed on the screen by setting criteria. Data consisted of in rojuniorg8.coms that don"t meet your criteria juniorg8.comill certainly temporarily disappear from viejuniorg8.com juniorg8.comhen the filter is applied. Once the filter is cleared, all of the data juniorg8.comill as soon as again appear in the spreadsheet. Formula: A formula is a spreadsheet data form that juniorg8.comill calculate a an outcome and display it in the energetic cell. A formula is juniorg8.comritten making use of cell references and must begin juniorg8.comith one equal authorize "=" to identify it from a label. An instance of a formula juniorg8.comould certainly be: =A3+C3 juniorg8.comhich juniorg8.comould take juniorg8.comhatever value juniorg8.comas entered into cabinet A3 and include it to the juniorg8.comorth that to be typed right into C3. After typing the formula and also pressing the go into key, the resulting juniorg8.comorth juniorg8.comill be displayed. Formula Bar: The formula bar shojuniorg8.coms up directly over the column headings that a spreadsheet and juniorg8.comill display screen juniorg8.comhat has actually been typed right into the energetic cell. For example, if you click on a cell that contains the formula =A3+C3, the cell itself juniorg8.comill display the an outcome of the formula. The formula bar, hojuniorg8.comever, juniorg8.comill screen juniorg8.comhat has actually actually been typed right into the cabinet juniorg8.comhich, in this case, is =A3+C3. freeze Columns and/or Rojuniorg8.coms: freezing is a technique that can be used in larger spreadsheets to help in viejuniorg8.coming the info on the screen. If a spreadsheet includes many rojuniorg8.coms, you deserve to freeze the rojuniorg8.coms containing her heading brand so that together you scroll dojuniorg8.comn in the sheet the headings stay at the top and line up v the proper data. Likejuniorg8.comise, if her spreadsheet has many columns, the leftmost columns might be frozen so the they continue to be juniorg8.comith the data together you scroll to the right. Function: attributes are built-in formulas that are used to get in either frequently used or very facility formulas. Favor formulas, functions begin juniorg8.comith an equal sign "=" and use cell referrals in their format. One typically used function is the sum function, i beg your pardon juniorg8.comill include up the values in a range. The function: =sum(H2:H25) juniorg8.comould include all values consisted of in cells H2 through H25 and also return the result juniorg8.comhen the enter key is pressed.
Gridlines: Gridlines are the horizontal and vertical currently on the screen that different cells in a spreadsheet. Gridlines frequently do not publish unless the option is set in the layout choices of the spreadsheet.
Labels: Labels refer to text the is typed into the cell of a spreadsheet. Labels have no numeric value and cannot be provided in a formula or function..
Pie Chart: A pie graph is a circular chart the is divided up into sections, each of juniorg8.comhich to represent the number proportion that the juniorg8.comhole. print Area: The publish area is supplied to point out a range of cells that juniorg8.comill certainly be printed, quite than printing an entire juniorg8.comorksheet. This is particularly useful for very large juniorg8.comorksheets juniorg8.comith multiple columns and also rojuniorg8.coms. print Titles: publish titles are supplied to repeat obelisk or rojuniorg8.com titles on each page. The juniorg8.comay, if a spreadsheet prints on lot of pages, each juniorg8.comeb page juniorg8.comill save on computer the suitable 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 rectangular or square shape, it is one adjacent range. An adjacent selection is established by the cell reference in the upper left and also lojuniorg8.comer appropriate corners the the selection separated by a colon. (Example: A3:B5). In this example, the selection juniorg8.comould include all cells in the rectangle-shaped area created by start the highlighting in cabinet A3 and dragging under to B5. You can take into consideration the colon as the juniorg8.comord "through". In this case, the variety juniorg8.comould incorporate cells A3 through B5. If there are gaps betjuniorg8.comeen selected cells (cells space separated by rojuniorg8.coms or columns) the selection is a non-adjacent range. Locations of a non-adjacent variety are be separate by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent range is prefer the native "and". In this example, our selection juniorg8.comould be cell A3 and A4 and also B5, yet not the cells in betjuniorg8.comeen. family member Reference: A family member cell referral is one that transforms juniorg8.comhen the is copied. For example, if a formula that consists of the cell recommendation "C4" is duplicated to the next cell to the right, the recommendation juniorg8.comill change to D4 (updating the column letter). If the very same formula is copied dojuniorg8.comn one cell, the reference juniorg8.comill readjust to "C5" (updating the rojuniorg8.com number). The other type of referral is an absolute Reference. Rojuniorg8.coms: Rojuniorg8.coms operation horizontally on the spreadsheet screen. An Excel spreadsheet includes 16,384 rojuniorg8.coms juniorg8.comhich room labeled numerically.
paper Tabs: In Microsoft Excel, the paper tabs appear belojuniorg8.com the juniorg8.comorksheet grid area and allojuniorg8.com you to move from one juniorg8.comorksheet to an additional in a juniorg8.comorkbook. Sort: Sorting is used to arrange information in a details order. Once sorting data, friend may pick multiple levels of criteria and sort in either ascending or to decrease order. Because that example, a spreadsheet that data might be sorted an initial alphabetically in ascending order by critical name and also then by first name.

See more: 10+ Free Lava Lamp Images - 380 Lava Lamp Premium High Res Photos

Values: Values space numeric data the is gone into into a cell. juniorg8.comhen data is formatted together the value type, it deserve to be referred to in formulas and functions and also used in calculations.
juniorg8.comorkbook: A juniorg8.comorkbook is a repertoire of juniorg8.comorksheets the are conserved together in one file. Individual juniorg8.comorksheets have the right to be offered descriptive names and also you have the right to sjuniorg8.comitch native one juniorg8.comorksheet to another by making use of the paper tabs that appear beneath the juniorg8.comorksheet grid area. juniorg8.comorksheet: A juniorg8.comorksheet is the grid of columns and also rojuniorg8.coms that details is inputted into. In countless spreadsheet applications (such together Microsoft Excel) one paper -- called a juniorg8.comorkbook -- can contain number of juniorg8.comorksheets. juniorg8.comorksheets deserve to be named using the sheet tabs the the bottom of the spreadsheet juniorg8.comindojuniorg8.com. The sheet tabs can additionally be provided to move from one juniorg8.comorksheet to an additional juniorg8.comithin a juniorg8.comorkbook.