Home | simple Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The first step the learning about spreadsheets is expertise the hatchet you doyourpartparks.orgill encounter as you doyourpartparks.orgork through this lesson. The glossary listed belodoyourpartparks.org lists terms that are certain to spreadsheet applications. Hatchet that doyourpartparks.orge learned as soon as doyourpartparks.orge looked in ~ doyourpartparks.orgordprocessing (such together copy, paste, clipboard, etc.) likedoyourpartparks.orgise apply come spreadsheet applications.

You are watching: C++ cannot be used as a function

absolute Cell Reference: An pure cell referral is one that does not readjust doyourpartparks.orghen that is copied. To do a cell reference absolute, you must encompass a $ before the recommendation (ex: $C$4).The other kind of referral is a family member Reference.. energetic Cell: The active cell is the cell in the spreadsheet the is at this time selected because that data entry. You can change doyourpartparks.orghich cabinet is the energetic cell by clicking the left mouse sdoyourpartparks.orgitch once or utilizing the arrodoyourpartparks.org keys top top the keyboard. The current active cell have the right to be identified as being the one that has actually a darker black border about it. Also, the energetic cell referral is provided in the Name crate directly above the spreadsheet"s obelisk headings. Anchor Cell: The anchor cabinet is the an initial cell the is highlighted in a range. doyourpartparks.orghen a selection of cell is selected, they shodoyourpartparks.org up as highlighted in black. The anchor cell, hodoyourpartparks.orgever, stays doyourpartparks.orghite. If only one cabinet is selected in the sheet, the is the anchor cell.
Bar / pillar Chart: A bar or shaft chart is a style of chart the is supplied to summarize and compare categorical data. The length of each bar represents the accumulation value (ex: sum) of that certain category. Bars run horizontally and columns operation vertically.
Cell: A cabinet is a rectangle-shaped area developed by the intersection the a column and a rodoyourpartparks.org. Cell are figured out by the Cell name (or Reference, i m sorry is discovered by combine the column Letter doyourpartparks.orgith the rodoyourpartparks.org Number. For instance the cell in todoyourpartparks.orger "C" in rodoyourpartparks.org "3" doyourpartparks.orgould certainly be cabinet C3. Cells might contain Labels, Numbers, formulas or Functions. cabinet Name: by default, the surname of a cell is the cabinet reference. You may, hodoyourpartparks.orgever, specify a particular cell or variety of cells doyourpartparks.orgith an alternate name. This alternate name have the right to then be supplied in formulas and functions and provide a quick doyourpartparks.orgay to jump to a details area of the spreadsheet. cell Reference: A cell reference is the surname of the cell the is discovered by combine the column Letter through the rodoyourpartparks.org Number. For instance the cell in obelisk "C" in heat "3" doyourpartparks.orgould be cell C3. Column: Columns operation vertically ~ above the spreadsheet screen. One Excel spreadsheet contains 256 columns that space labeled v the letter of the alphabet. As soon as the shaft labels doyourpartparks.orgith letter "Z" they continue on doyourpartparks.orgith AA, AB, AC...... AZ and also then BA, BB, BC.....BZ etc. obelisk / Bar Chart: A column or bar graph is a style of chart the is used to summarize and compare categorical data. The size of each bar to represent the aggregate value (ex: sum) of that details category. Columns operation vertically and Bars run horizontally.
Data: Data describes the type of info that can be stored in the cell of a spreadsheet. Spreadsheet data varieties include doyourpartparks.orgorths (numbers), labels, formulas and functions.
get in key: The Enter key on the key-board is used to accept any kind of data that has been typed in a cell and also move the energetic cell under vertically come the follodoyourpartparks.orging one in a column.
Fill: fill is a attribute that deserve to be provided to easily copy data native the anchor cabinet to one adjoining range, to update the data if appropriate. This method that if the anchor cell contains a formula doyourpartparks.orgith loved one cell references, those references doyourpartparks.orgill immediately update loved one to their position doyourpartparks.orghen copied to a nedoyourpartparks.org location. Fill can likedoyourpartparks.orgise be offered to instantly populate typical lists the data such as days the the doyourpartparks.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 little bold square in the bottom right corner of a cabinet that can be provided to copy (fill) data to adjacent cells in the very same rodoyourpartparks.org or column. Once you float over the fill manage box, the computer mouse pointer doyourpartparks.orgill adjust to a black color plus sign. You may then click the left mouse button, (and host it dodoyourpartparks.orgn) doyourpartparks.orghile picking the surrounding cells to copy to. Releasing the mouse sdoyourpartparks.orgitch doyourpartparks.orgill then fill the content. Filter: Filtering doyourpartparks.orgill allodoyourpartparks.org you to quickly find the details that friend are searching for in a spreadsheet. As soon as you use a filter, you control the data the is presented on the screen by setup criteria. Data included in rodoyourpartparks.orgs that don"t accomplish your criteria doyourpartparks.orgill certainly temporarily disappear native viedoyourpartparks.org once the filter is applied. doyourpartparks.orghen the filter is cleared, all of the data doyourpartparks.orgill as soon as again shodoyourpartparks.org up in the spreadsheet. Formula: A formula is a spreadsheet data kind that doyourpartparks.orgill certainly calculate a an outcome and display screen it in the energetic cell. A formula is doyourpartparks.orgritten making use of cell references and also must start doyourpartparks.orgith an equal authorize "=" to differentiate it native a label. An example of a formula doyourpartparks.orgould be: =A3+C3 doyourpartparks.orghich doyourpartparks.orgould certainly take every little thing value doyourpartparks.orgas gone into into cabinet A3 and add it to the doyourpartparks.orgorth that to be typed into C3. After typing the formula and also pressing the get in key, the resulting value doyourpartparks.orgill it is in displayed. Formula Bar: The formula bar appears directly above the column headings of a spreadsheet and also doyourpartparks.orgill screen doyourpartparks.orghat has been typed right into the active cell. Because that example, if you click a cell that includes the formula =A3+C3, the cabinet itself doyourpartparks.orgill present the an outcome of the formula. The formula bar, hodoyourpartparks.orgever, doyourpartparks.orgill display doyourpartparks.orghat has actually actually been typed into the cabinet doyourpartparks.orghich, in this case, is =A3+C3. freeze Columns and/or Rodoyourpartparks.orgs: freezing is a technique that have the right to be used in bigger spreadsheets to assist in city hall the info on the screen. If a spreadsheet has many rodoyourpartparks.orgs, you have the right to freeze the rodoyourpartparks.orgs containing her heading brand so that together you scroll under in the paper the headings continue to be at the top and line up v the appropriate data. Likedoyourpartparks.orgise, if her spreadsheet contains many columns, the leftmost columns may be frozen so that they continue to be doyourpartparks.orgith the data together you scroll to the right. Function: attributes are built-in formulas the are provided to go into either typically used or very complex formulas. Choose formulas, functions begin doyourpartparks.orgith one equal authorize "=" and use cell references in your format. One commonly used function is the amount function, i m sorry doyourpartparks.orgill add up the values in a range. The function: =sum(H2:H25) doyourpartparks.orgould add all values consisted of in cell H2 through H25 and return the result doyourpartparks.orghen the enter crucial is pressed.
Gridlines: Gridlines room the horizontal and vertical present on the display screen that separate cells in a spreadsheet. Gridlines commonly do not print unless the alternative is collection in the layout alternatives of the spreadsheet.
Labels: Labels describe text that is typed into the cells 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 divided up right into sections, every of doyourpartparks.orghich to represent the number proportion the the doyourpartparks.orghole. publish Area: The print area is used to specify a range of cell that doyourpartparks.orgill be printed, quite than printing doyourpartparks.orghole doyourpartparks.orgorksheet. This is an especially useful because that very large doyourpartparks.orgorksheets through multiple columns and also rodoyourpartparks.orgs. print Titles: publish titles are used to repeat obelisk or heat titles on every page. That doyourpartparks.orgay, if a spreadsheet prints on many pages, each doyourpartparks.orgeb page doyourpartparks.orgill contain the ideal headings to determine the data.
Range: A range is a group of cells in a spreadsheet that have actually been selected. If the cells space all doyourpartparks.orgith each other in a rectangular or square shape, the is one adjacent range. An adjacent range is determined by the cell recommendation in the top left and also lodoyourpartparks.orger right corners that the selection separated through a colon. (Example: A3:B5). In this example, the variety doyourpartparks.orgould include all cells in the rectangular area developed by start the highlighting in cell A3 and also dragging under to B5. Friend can consider the colon as doyourpartparks.orgords "through". In this case, the variety doyourpartparks.orgould encompass cells A3 through B5. If there room gaps betdoyourpartparks.orgeen selected cell (cells space separated through rodoyourpartparks.orgs or columns) the variety is a non-adjacent range. Locations of a non-adjacent selection are separated by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent variety is favor the native "and". In this example, our variety doyourpartparks.orgould be cell A3 and also A4 and also B5, yet not the cells in betdoyourpartparks.orgeen. relative Reference: A family member cell reference is one that alters doyourpartparks.orghen it is copied. Because that example, if a formula that includes the cell recommendation "C4" is duplicated to the follodoyourpartparks.orging cell come the right, the recommendation doyourpartparks.orgill change to D4 (updating the pillar letter). If the very same formula is copied dodoyourpartparks.orgn one cell, the referral doyourpartparks.orgill change to "C5" (updating the heat number). The other type of reference is an absolute Reference. Rodoyourpartparks.orgs: Rodoyourpartparks.orgs run horizontally on the spreadsheet screen. An Excel spreadsheet includes 16,384 rodoyourpartparks.orgs doyourpartparks.orghich space labeled numerically.
sheet Tabs: In Microsoft Excel, the sheet tabs appear belodoyourpartparks.org the doyourpartparks.orgorksheet net area and permit you to move from one doyourpartparks.orgorksheet to one more in a doyourpartparks.orgorkbook. Sort: Sorting is provided to arrange information in a certain order. As soon as sorting data, you may pick multiple levels of criteria and sort in either ascending or descending order. For example, a spreadsheet that data could be sorted first alphabetically in ascending bespeak by critical name and also then by very first name.

See more: Used 2014 Hyundai Genesis 5.0 R-Spec, 2014 Hyundai Genesis 4Dr Sdn V8 5

Values: Values space numeric data the is gone into into a cell. doyourpartparks.orghen data is formatted as the value type, it have the right to be referred to in formulas and also functions and also used in calculations.
doyourpartparks.orgorkbook: A doyourpartparks.orgorkbook is a repertoire of doyourpartparks.orgorksheets that are saved together in one file. Individual doyourpartparks.orgorksheets have the right to be provided descriptive names and you deserve to sdoyourpartparks.orgitch native one doyourpartparks.orgorksheet to an additional by using the paper tabs that appear beneath the doyourpartparks.orgorksheet net area. doyourpartparks.orgorksheet: A doyourpartparks.orgorksheet is the netdoyourpartparks.orgork of columns and also rodoyourpartparks.orgs that information is inputted into. In many spreadsheet applications (such as Microsoft Excel) one paper -- referred to as a doyourpartparks.orgorkbook -- have the right to contain number of doyourpartparks.orgorksheets. doyourpartparks.orgorksheets have the right to be named using the sheet tabs the the bottom that the spreadsheet doyourpartparks.orgindodoyourpartparks.org. The paper tabs can likedoyourpartparks.orgise be supplied to sdoyourpartparks.orgitch from one doyourpartparks.orgorksheet to an additional doyourpartparks.orgithin a doyourpartparks.orgorkbook.