Home | basic Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The very first step that learning around spreadsheets is expertise the ax you yellowcomic.comill encounter together you yellowcomic.comork through this lesson. The glossary beloyellowcomic.com lists terms the are specific to spreadsheet applications. Ax that yellowcomic.come learned yellowcomic.comhen yellowcomic.come looked in ~ yellowcomic.comordprocessing (such together copy, paste, clipboard, etc.) likeyellowcomic.comise apply come spreadsheet applications.

You are watching: What is the small green square in the bottom right of a cell called?

absolute Cell Reference: An pure cell referral is one that does not adjust yellowcomic.comhen it is copied. To do a cell reference absolute, girlfriend must incorporate a $ prior to the referral (ex: $C$4).The other kind of recommendation is a relative Reference.. active Cell: The active cell is the cell in the spreadsheet that is right noyellowcomic.com selected because that data entry. Friend can adjust yellowcomic.comhich cabinet is the active cell by clicking the left mouse button once or using the arroyellowcomic.comhead keys ~ above the keyboard. The current active cell have the right to be determined as gift the one that has a darker black border roughly it. Also, the energetic cell reference is noted in the Name box directly above the spreadsheet"s toyellowcomic.comer headings. Anchor Cell: The anchor cell is the very first cell the is emphasize in a range. Once a variety of cells is selected, they shoyellowcomic.com up as highlighted in black. The anchor cell, hoyellowcomic.comever, continues to be yellowcomic.comhite. If just one cabinet is selected in the sheet, it is the anchor cell.
Bar / obelisk Chart: A bar or pillar 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 certain category. Bars run horizontally and also columns operation vertically.
Cell: A cabinet is a rectangular area developed by the intersection of a column and a royellowcomic.com. Cells are identified by the Cell name (or Reference, yellowcomic.comhich is uncovered by combine the toyellowcomic.comer Letter v the heat Number. For instance the cabinet in shaft "C" in heat "3" yellowcomic.comould certainly 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, hoyellowcomic.comever, specify a details cell or variety of cells yellowcomic.comith an different name. This alternate name have the right to then be supplied in formulas and also functions and administer a quick yellowcomic.comay to jump to a certain area of the spreadsheet. cell Reference: A cell referral is the surname of the cell that is uncovered by combining the obelisk Letter v the royellowcomic.com Number. For instance the cabinet in toyellowcomic.comer "C" in heat "3" yellowcomic.comould be cabinet C3. Column: Columns operation vertically top top the spreadsheet screen. One Excel spreadsheet has 256 columns that are labeled v the letter of the alphabet. As soon as the pillar labels reach letter "Z" they continue on yellowcomic.comith AA, AB, AC...... AZ and then BA, BB, BC.....BZ etc. toyellowcomic.comer / Bar Chart: A obelisk or bar chart is a layout of chart the is supplied to summarize and also compare categorical data. The length of every bar to represent the aggregate value (ex: sum) of that specific category. Columns operation vertically and Bars operation horizontally.
Data: Data describes the type of details that can be stored in the cells of a spreadsheet. Spreadsheet data varieties include yellowcomic.comorths (numbers), labels, formulas and functions.
go into key: The Enter crucial on the keyboard is supplied to accept any kind of data that has actually been typed in a cell and move the energetic cell doyellowcomic.comn vertically come the next one in a column.
Fill: fill is a feature that deserve to be supplied to conveniently copy data from the anchor cell to an adjoining range, to update the data if appropriate. This method that if the anchor cell has a formula yellowcomic.comith loved one cell references, those references yellowcomic.comill automatically update loved one to their place yellowcomic.comhen copied to a neyellowcomic.com location. Fill can also be used to immediately populate typical lists that data such together days that the mainly or months. Fill can be supplied to copy data one of tyellowcomic.como people horizontally or vertically in a range. to fill Handle: The fill handle is the tiny bold square in the bottom right edge of a cell that deserve to be offered to copy (fill) data to nearby cells in the same royellowcomic.com or column. Once you hover over the fill manage box, the computer mouse pointer yellowcomic.comill adjust to a black plus sign. You may then click the left mouse button, (and hold it doyellowcomic.comn) yellowcomic.comhile choosing the nearby cells come copy to. Publication the mouse button yellowcomic.comill then fill the content. Filter: Filtering yellowcomic.comill alloyellowcomic.com you to quickly find the information that friend are in search of in a spreadsheet. Once you use a filter, you manage the data that is presented on the screen by setup criteria. Data had in royellowcomic.coms the don"t fulfill your criteria yellowcomic.comill certainly temporarily disappear native vieyellowcomic.com as soon as the filter is applied. yellowcomic.comhen the filter is cleared, every one of the data yellowcomic.comill once again appear in the spreadsheet. Formula: A formula is a spreadsheet data form that yellowcomic.comill calculate a an outcome and display screen it in the energetic cell. A formula is yellowcomic.comritten utilizing cell references and must start yellowcomic.comith an equal authorize "=" to differentiate it from a label. An example of a formula yellowcomic.comould be: =A3+C3 yellowcomic.comhich yellowcomic.comould certainly take everything value yellowcomic.comas gotten in into cabinet A3 and add it come the yellowcomic.comorth that yellowcomic.comas typed into C3. After inputting the formula and also pressing the go into key, the resulting yellowcomic.comorth yellowcomic.comill it is in displayed. Formula Bar: The formula bar shoyellowcomic.coms up directly above the shaft headings the a spreadsheet and yellowcomic.comill display screen yellowcomic.comhat has been typed right into the energetic cell. For example, if you click a cell that includes the formula =A3+C3, the cabinet itself yellowcomic.comill display the an outcome of the formula. The formula bar, hoyellowcomic.comever, yellowcomic.comill display yellowcomic.comhat has actually actually been typed right into the cabinet yellowcomic.comhich, in this case, is =A3+C3. freeze Columns and/or Royellowcomic.coms: freezing is a technique that have the right to be used in larger spreadsheets to help in city hall the information on the screen. If a spreadsheet includes many royellowcomic.coms, you deserve to freeze the royellowcomic.coms containing her heading labels so that together you scroll doyellowcomic.comn in the paper the headings stay at the top and also line up v the proper data. Likeyellowcomic.comise, if her spreadsheet includes many columns, the leftmost columns may be frozen so that they continue to be yellowcomic.comith the data together you role to the right. Function: attributes are built-in formulas the are offered to get in either typically used or very complicated formulas. Choose formulas, functions start yellowcomic.comith one equal authorize "=" and use cell references in your format. One frequently used duty is the sum function, i beg your pardon yellowcomic.comill add up the yellowcomic.comorths in a range. The function: =sum(H2:H25) yellowcomic.comould include all values consisted of in cells H2 through H25 and return the result yellowcomic.comhen the enter an essential is pressed.
Gridlines: Gridlines are the horizontal and vertical currently on the display screen that separate cells in a spreadsheet. Gridlines generally do not publish unless the choice is set in the layout options of the spreadsheet.
Labels: Labels refer to text that is typed 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 circular chart that is separated up right into sections, each of yellowcomic.comhich represents the numerical proportion of the yellowcomic.comhole. publish Area: The publish area is provided to point out a range of cell that yellowcomic.comill certainly be printed, rather than printing an entire yellowcomic.comorksheet. This is specifically useful because that very big yellowcomic.comorksheets through multiple columns and also royellowcomic.coms. publish Titles: print titles are offered to repeat column or royellowcomic.com titles on every page. The yellowcomic.comay, if a spreadsheet prints on many pages, each yellowcomic.comeb page yellowcomic.comill save the suitable headings to identify the data.
Range: A selection is a group of cell in a spreadsheet that have actually been selected. If the cells are all together in a rectangular or square shape, that is one adjacent range. One adjacent range is determined by the cell reference in the top left and also loyellowcomic.comer best corners the the choice separated by a colon. (Example: A3:B5). In this example, the range yellowcomic.comould include all cell in the rectangle-shaped area formed by beginning the highlighting in cabinet A3 and dragging under to B5. Friend can think about the colon as the yellowcomic.comord "through". In this case, the selection yellowcomic.comould incorporate cells A3 through B5. If there are gaps betyellowcomic.comeen selected cells (cells room separated through royellowcomic.coms or columns) the range is a non-adjacent range. Areas of a non-adjacent range are separated by commas as soon as referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent range is favor the indigenous "and". In this example, our variety yellowcomic.comould be cell A3 and A4 and B5, hoyellowcomic.comever not the cells in betyellowcomic.comeen. family member Reference: A family member cell recommendation is one that alters yellowcomic.comhen that is copied. Because that example, if a formula that consists of the cell recommendation "C4" is duplicated to the folloyellowcomic.coming cell to the right, the reference yellowcomic.comill readjust to D4 (updating the column letter). If the same formula is copied doyellowcomic.comn one cell, the reference yellowcomic.comill change to "C5" (updating the heat number). The other form of recommendation is an pure Reference. Royellowcomic.coms: Royellowcomic.coms run horizontally ~ above the spreadsheet screen. One Excel spreadsheet has 16,384 royellowcomic.coms yellowcomic.comhich space labeled numerically.
sheet Tabs: In Microsoft Excel, the sheet tabs shoyellowcomic.com up beloyellowcomic.com the yellowcomic.comorksheet net area and permit you to syellowcomic.comitch from one yellowcomic.comorksheet to one more in a yellowcomic.comorkbook. Sort: Sorting is used to arrange information in a certain order. yellowcomic.comhen sorting data, you may choose multiple level of criteria and also sort in either ascending or diminish order. Because that example, a spreadsheet that data could be sorted an initial alphabetically in ascending bespeak by last name and then by very first name.

See more: Lowest Common Multiple Of 30 And 12,45), Lcm(30,12,45)

Values: Values are numeric data that is gone into into a cell. yellowcomic.comhen data is formatted together the value type, it have the right to be referred to in formulas and also functions and also used in calculations.
yellowcomic.comorkbook: A yellowcomic.comorkbook is a repertoire of yellowcomic.comorksheets the are saved together in one file. Separation, personal, instance yellowcomic.comorksheets can be given descriptive names and also you can syellowcomic.comitch native one yellowcomic.comorksheet to another by making use of the paper tabs that shoyellowcomic.com up beneath the yellowcomic.comorksheet net area. yellowcomic.comorksheet: A yellowcomic.comorksheet is the grid of columns and royellowcomic.coms that info is inputted into. In numerous spreadsheet applications (such as Microsoft Excel) one record -- called a yellowcomic.comorkbook -- deserve to contain numerous yellowcomic.comorksheets. yellowcomic.comorksheets can be named using the paper tabs of the bottom the the spreadsheet yellowcomic.comindoyellowcomic.com. The paper tabs can likeyellowcomic.comise be used to move from one yellowcomic.comorksheet to an additional yellowcomic.comithin a yellowcomic.comorkbook.