click below
click below
Normal Size Small Size show me how
GHS 2011-2012Vocab 4
| Question | Answer |
|---|---|
| Clear contents | Used to clear contents, format, or both without deleting cells. Rt. Click & select clear contents |
| Delete command | Deletes contents, format, and cell; remaining cells shift to replace deleted cell. Rt. click cell & select delete |
| Moving Data | Select data, hover over edge of a cell until you have a four-headed arrow. Drag to new location. |
| Range | (Add to previously created card) Identified by cell in upper left corner and cell in lower right corner; separated by a colon (:). |
| Adjusting row height | 1. Click row header, select row height, type in desired height. 2. Automatically adjusts if you use larger font size. 3. Click boundary and drag to desired size. |
| Adjusting column width | 1. DC a boundary to "best fit" 2. Rt. click column header, select column width, type desired width 3. Click boundary and drag to desired size. |
| Clear button | Home tab, Editing group, "eraser" icon. Used to clear contents, clear format, or clear both. |
| Insert and delete columns and/or rows | Home/cells/Insert or delete Inserts (1) row above selected cell or (2) column to left of selected cell. Deletes row or column of selected cell. |
| adjacent cells | Cells that are next to each other, either in rows or columns |
| source | selected cells to be copied or moved |
| destination | the upper left cell of a range where data is to be pasted; you only have to click that one cell to paste a range |
| fill handle | the solid square in the lower right corner of a selected cell that is used to copy the contents of a cell to adjacent cells |
| formula | mathematical statement used to calculate a value, always preceded by an =(equal sign) |
| formula bar | displays the active cell's contents, located below the ribbon |
| order of operations | precedence excel follows to perform a calculation: multiplication, division, addition, subtraction |
| relative cell reference | cell references that change when you copy and paste them |
| cell style | a defined collection of formats for font, font size, font color, font attributed, numeric formats, shading, borders, etc. home/styles/cell styles |
| center align | center button to center horizontally middle align button to center vertically home/font/alignment |
| function | built-in predefined formulas in a spreadsheet - SUM, COUNT, etc. 3 parts: =, FUNCTION NAME, ARGUMENT |
| argument | defines the numbers to be used in a calculation; usually a cell range |
| SUM | adds the numbers in specified cells (a1:a10) adds all cells from A1 to A10; (a1,a10) adds only 2 cells |
| AVERAGE | averages all values in specified cells |
| COUNT | counts the number of cells that contain numbers in the specified range |
| MIN | identifies and prints the smallest number in specified cells |
| MAX | identifies and prints the largest number in specified cells |
| DAYS360 | counts the number of days between two dates, based on a 360 day year |