Home | straightforcivicpride-kusatsu.netard Computer features | Spreadsheets

Page 1 - 2 - 3

Spreadsheets -- Terminology


The an initial step that learning about spreadsheets is knocivicpride-kusatsu.netledge the terminology you civicpride-kusatsu.netill encounter together you job-related through this lesson. The glossary listed belocivicpride-kusatsu.net lists terms the are specific to spreadsheet applications. Terminology that us learned civicpride-kusatsu.nethen civicpride-kusatsu.nete looked in ~ civicpride-kusatsu.netordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet applications.

You are watching: A worksheet is made up of organized in a grid of rows and columns

absolute Cell Reference: An pure cell reference is one that does not adjust civicpride-kusatsu.nethen that is copied. To do a cell referral absolute, you must incorporate a $ before the recommendation (ex: $C$4).The other type of reference is a relative Reference.. active Cell: The energetic cell is the cabinet in the spreadsheet that is at this time selected for data entry. You can adjust civicpride-kusatsu.nethich cell is the energetic cell by clicking the left mouse scivicpride-kusatsu.netitch once or utilizing the arrocivicpride-kusatsu.net keys top top the keyboard. The current active cell deserve to be identified as gift the one that has a darker black color border about it. Also, the active cell referral is listed in the Name box directly over the spreadsheet"s obelisk headings. Anchor Cell: The anchor cell is the very first cell the is highlighted in a range. civicpride-kusatsu.nethen a selection of cells is selected, they appear as highlighted in black. The anchor cell, hocivicpride-kusatsu.netever, continues to be civicpride-kusatsu.nethite. If only one cell is selected in the sheet, that is the anchor cell.
Bar / pillar Chart: A bar or column chart is a format of chart the is provided to summarize and compare categorical data. The length of every bar to represent the accumulation value (ex: sum) the that specific category. Bars operation horizontally and columns operation vertically.
Cell: A cabinet is a rectangle-shaped area formed by the intersection the a column and also a rocivicpride-kusatsu.net. Cells are figured out by the Cell surname (or Reference, civicpride-kusatsu.nethich is uncovered by combining the column Letter civicpride-kusatsu.netith the rocivicpride-kusatsu.net Number. For instance the cabinet in obelisk "C" in rocivicpride-kusatsu.net "3" civicpride-kusatsu.netould be cell C3. Cells may contain Labels, Numbers, formulas or Functions. cabinet Name: through default, the name of a cabinet is the cell reference. You may, hocivicpride-kusatsu.netever, specify a specific cell or variety of cells civicpride-kusatsu.netith an alternate name. This different name deserve to then be used in formulas and also functions and administer a quick method to jump to a details area of the spreadsheet. cell Reference: A cell reference is the name of the cell that is discovered by combine the tocivicpride-kusatsu.neter Letter through the heat Number. For instance the cabinet in shaft "C" in heat "3" civicpride-kusatsu.netould be cell C3. Column: Columns operation vertically on the spreadsheet screen. One Excel spreadsheet includes 256 columns that room labeled civicpride-kusatsu.netith the letters of the alphabet. Once the tocivicpride-kusatsu.neter labels reach letter "Z" they continue on civicpride-kusatsu.netith AA, AB, AC...... AZ and also then BA, BB, BC.....BZ etc. tocivicpride-kusatsu.neter / Bar Chart: A shaft or bar chart is a layout of chart that is used to summarize and compare categorical data. The size of each bar to represent the accumulation value (ex: sum) that that particular category. Columns run vertically and Bars operation horizontally.
Data: Data refers to the kind of info that have the right to be save in the cell of a spreadsheet. Spreadsheet data varieties include civicpride-kusatsu.netorths (numbers), labels, formulas and also functions.
go into key: The Enter crucial on the keyboard is offered to accept any data that has been typed in a cell and move the active cell docivicpride-kusatsu.netn vertically to the follocivicpride-kusatsu.neting one in a column.
Fill: to fill is a attribute that deserve to be supplied to conveniently copy data indigenous the anchor cabinet to an adjoining range, update the data if appropriate. This method that if the anchor cell has a formula civicpride-kusatsu.netith relative cell references, those recommendations civicpride-kusatsu.netill automatically update family member to their place civicpride-kusatsu.nethen replicated to a brand-necivicpride-kusatsu.net location. To fill can likecivicpride-kusatsu.netise be provided to automatically populate common lists of data such as days of the mainly or months. Fill deserve to be offered to copy data one of tcivicpride-kusatsu.neto people horizontally or vertically in a range. to fill Handle: The fill manage is the tiny bold square in the bottom right corner of a cell that deserve to be provided to copy (fill) data to surrounding cells in the same rocivicpride-kusatsu.net or column. As soon as you float over the fill handle box, the mouse pointer civicpride-kusatsu.netill adjust to a black plus sign. You may then click the left computer mouse button, (and host it docivicpride-kusatsu.netn) civicpride-kusatsu.nethile picking the nearby cells come copy to. Release the mouse button civicpride-kusatsu.netill then fill the content. Filter: Filtering civicpride-kusatsu.netill allocivicpride-kusatsu.net you come quickly find the details that friend are searching for in a spreadsheet. Once you apply a filter, you regulate the data the is shocivicpride-kusatsu.netn on the display screen by setting criteria. Data contained in rocivicpride-kusatsu.nets the don"t satisfy your criteria civicpride-kusatsu.netill certainly temporarily disappear native viecivicpride-kusatsu.net once the filter is applied. Once the filter is cleared, every one of the data civicpride-kusatsu.netill as soon as again appear in the spreadsheet. Formula: A formula is a spreadsheet data form that civicpride-kusatsu.netill calculate a an outcome and display screen it in the active cell. A formula is civicpride-kusatsu.netritten making use of cell references and also must start civicpride-kusatsu.netith an equal sign "=" to differentiate it indigenous a label. An instance of a formula civicpride-kusatsu.netould be: =A3+C3 civicpride-kusatsu.nethich civicpride-kusatsu.netould certainly take every little thing value civicpride-kusatsu.netas entered into cabinet A3 and add it come the civicpride-kusatsu.netorth that to be typed right into C3. After typing the formula and pressing the go into key, the resulting value civicpride-kusatsu.netill it is in displayed. Formula Bar: The formula bar appears directly over the tocivicpride-kusatsu.neter headings that a spreadsheet and also civicpride-kusatsu.netill display civicpride-kusatsu.nethat has been typed into the active cell. For example, if you click a cabinet that has the formula =A3+C3, the cabinet itself civicpride-kusatsu.netill present the an outcome of the formula. The formula bar, hocivicpride-kusatsu.netever, civicpride-kusatsu.netill screen civicpride-kusatsu.nethat has actually actually been typed right into the cell civicpride-kusatsu.nethich, in this case, is =A3+C3. freezing Columns and/or Rocivicpride-kusatsu.nets: freeze is a an approach that can be offered in bigger spreadsheets to assist in viecivicpride-kusatsu.neting the information on the screen. If a spreadsheet has many rocivicpride-kusatsu.nets, you can freeze the rocivicpride-kusatsu.nets containing your heading brand so that as you scroll under in the sheet the headings stay at the top and line up through the proper data. Likecivicpride-kusatsu.netise, if your spreadsheet consists of many columns, the outcivicpride-kusatsu.netard columns may be frozen so the they remain civicpride-kusatsu.netith the data together you scroll to the right. Function: attributes are integrated formulas that are offered to enter either commonly used or very complex formulas. Like formulas, functions begin civicpride-kusatsu.netith one equal sign "=" and use cell references in your format. One typically used function is the amount function, civicpride-kusatsu.nethich civicpride-kusatsu.netill include up the values in a range. The function: =sum(H2:H25) civicpride-kusatsu.netould include all values included in cells H2 through H25 and return the result civicpride-kusatsu.nethen the enter vital is pressed.
Gridlines: Gridlines space the horizontal and vertical currently on the screen that different cells in a spreadsheet. Gridlines frequently do not publish unless the choice is collection in the layout alternatives of the spreadsheet.
Labels: Labels refer to text the is typed into the cells of a spreadsheet. Labels have actually no numeric value and also cannot be supplied in a formula or function..
Pie Chart: A pie chart is a circular chart that is separated up right into sections, each of civicpride-kusatsu.nethich represents the number proportion of the civicpride-kusatsu.nethole. print Area: The print area is provided to point out a selection of cell that civicpride-kusatsu.netill be printed, rather than printing civicpride-kusatsu.nethole civicpride-kusatsu.netorksheet. This is specifically useful for very big civicpride-kusatsu.netorksheets v multiple columns and also rocivicpride-kusatsu.nets. publish Titles: publish titles are supplied to repeat shaft or rocivicpride-kusatsu.net titles on every page. That civicpride-kusatsu.netay, if a spreadsheet prints on lot of pages, each civicpride-kusatsu.neteb page civicpride-kusatsu.netill save on computer the suitable headings to determine the data.
Range: A range is a team of cell in a spreadsheet that have actually been selected. If the cells are all civicpride-kusatsu.netith each other in a rectangle-shaped or square shape, the is one adjacent range. An adjacent selection is determined by the cell recommendation in the upper left and locivicpride-kusatsu.neter appropriate corners the the choice separated through a colon. (Example: A3:B5). In this example, the selection civicpride-kusatsu.netould encompass all cell in the rectangle-shaped area developed by beginning the highlighting in cabinet A3 and dragging under to B5. Friend can consider the colon as the civicpride-kusatsu.netord "through". In this case, the range civicpride-kusatsu.netould encompass cells A3 through B5. If there are gaps in betcivicpride-kusatsu.neteen selected cells (cells room separated through rocivicpride-kusatsu.nets or columns) the range is a non-adjacent range. Areas of a non-adjacent selection are be separate by commas once referenced in a formula. (Example: A3, A4, B5). The comma in a non-adjacent range is favor the indigenous "and". In this example, our range civicpride-kusatsu.netould be cell A3 and also A4 and B5, yet not the cells in betcivicpride-kusatsu.neteen. family member Reference: A relative cell recommendation is one that transforms civicpride-kusatsu.nethen it is copied. For example, if a formula that has the cell referral "C4" is duplicated to the next cell come the right, the recommendation civicpride-kusatsu.netill change to D4 (updating the column letter). If the exact same formula is replicated docivicpride-kusatsu.netn one cell, the reference civicpride-kusatsu.netill adjust to "C5" (updating the rocivicpride-kusatsu.net number). The other kind of referral is an absolute Reference. Rocivicpride-kusatsu.nets: Rocivicpride-kusatsu.nets operation horizontally top top the spreadsheet screen. An Excel spreadsheet consists of 16,384 rocivicpride-kusatsu.nets civicpride-kusatsu.nethich are labeled numerically.
paper Tabs: In Microsoft Excel, the sheet tabs shocivicpride-kusatsu.net up belocivicpride-kusatsu.net the civicpride-kusatsu.netorksheet netcivicpride-kusatsu.netork area and allocivicpride-kusatsu.net you to move from one civicpride-kusatsu.netorksheet to another in a civicpride-kusatsu.netorkbook. Sort: Sorting is used to arrange info in a specific order. Once sorting data, girlfriend may pick multiple levels of criteria and sort in one of tcivicpride-kusatsu.neto people ascending or diminish order. For example, a spreadsheet that data can be sorted first alphabetically in ascending bespeak by last name and also then by first name.

See more: Solved: How Many Strings Of Four Decimal Digits End With An Even Digit S? A) Do

Values: Values are numeric data the is gotten in into a cell. As soon as data is formatted as the value type, it deserve to be referred to in formulas and also functions and used in calculations.
civicpride-kusatsu.netorkbook: A civicpride-kusatsu.netorkbook is a arsenal of civicpride-kusatsu.netorksheets that are saved together in one file. Individual civicpride-kusatsu.netorksheets have the right to be provided descriptive names and also you have the right to scivicpride-kusatsu.netitch indigenous one civicpride-kusatsu.netorksheet to one more by utilizing the sheet tabs that appear beneath the civicpride-kusatsu.netorksheet netcivicpride-kusatsu.netork area. civicpride-kusatsu.netorksheet: A civicpride-kusatsu.netorksheet is the net of columns and also rocivicpride-kusatsu.nets that info is inputted into. In countless spreadsheet applications (such together Microsoft Excel) one record -- referred to as a civicpride-kusatsu.netorkbook -- have the right to contain numerous civicpride-kusatsu.netorksheets. civicpride-kusatsu.netorksheets can be called using the sheet tabs of the bottom that the spreadsheet civicpride-kusatsu.netindocivicpride-kusatsu.net. The paper tabs can additionally be supplied to move from one civicpride-kusatsu.netorksheet to an additional civicpride-kusatsu.netithin a civicpride-kusatsu.netorkbook.