click below
click below
Normal Size Small Size show me how
Computers Semester 1
| Term | Definition |
|---|---|
| Active pane | The pane in which the insertion point is currently located. |
| Default | A standard setting. |
| Footer | text or graphics printed at the bottom of all pages in a document. |
| Header | Text or graphics printed at the bottom of all pages in a document. |
| Insertion point | The flashing vertical line that indicates where the next action will occur. |
| Nonprinting characters | Character such as paragraph marks and tab symbols that are not printed on a document but that can be displayed on a screen. |
| Paragraph mark | A nonprinting character inserted in a document to indicate where a paragraph ends. |
| Word wrap | A feature that causes text to move automatically from the end of the line to the beginning of the next line. |
| Horizontal alignment | The position of text in relation to the width of the page. |
| Style | A collection of formatting settings that can be applied to characters or paragraphs. |
| Style set | A collection of styles that have coordinated colors and fonts. |
| Template | A document that contains formatting, styles, and sample text that you can use to create new documents. |
| Theme | A set of coordinated colors, fonts, and effects that ca be applied to office documents. |
| Blank Workbook | A new, empty workbook contains one worksheet (sheet). |
| Clear | To remove a cell’s contents and/or formatting. |
| Default | The standard settings Excel uses in its software, such as column width or bottom alignment of text in a cell. |
| Footer | Descriptive text, such as page numbers, that appear at the bottom of every page of a printout. |
| Header | Descriptive text, such as page numbers, that appear at the bottom of every page of a printout. |
| Label | Text entered to identify the type of data contained in a row or column. |
| Metadata | Data about data. |
| Preview | To see how a worksheet will look when printed. |
| Redo | The command used to redo an action you have undone. |
| Text | An alphanumeric entry in a worksheet that is not in a cell or range address. |
| Undo | The command used to reverse one or a series of editing actions. |
| Accounting Format | A style that vertically aligns dollar signs, thousands separators, and decimal points. |
| Cell Style | A combination of a font, text color, cell color, and other font attributes applied to a single cell. |
| Comma Format | A style that displays numbers with a thousands separator. |
| Currency Format | A style that displays dollar signs immediately preceding the number and includes a thousands separator. |
| Fill | A color that fills a cell, appearing behind the data. |
| Front | The typeface or design of the text. |
| Font Size | The measurements of the typeface in points. |
| Format | To apply attributes to cell data to change the appearance of the worksheet. |
| Live Preview | A feature that shows you how a gallery formatting choice will appear in the worksheet when you move the mouse pointer over that choice. |
| Merge and Center | A feature that enables you to combine cells and center the contents of the original far left cell in the new call. |
| Number Format | A format that controls how numerical data is displayed, including the use of commas, dollar signs, and the number of decimal places. |
| Percent Format | A style that displays decimal numbers as a percentage. |
| Theme | A collection of coordinated fonts, colors, and effects for graphic elements, such as charts and images, that can be quickly applied to all sheets in a workbook. |
| Auto Fill | The feature that enables Excel to create a series automatically. |
| Date | A cell entry that indicates a date or time and is stored as a date code in Excel. |
| Default Column Width | The default number of characters that display in a column based on the default font. |
| Fill Handle | A green box on the lower right corner of the selected cell or range that you can use to fill (copy) a series or formula. |
| Key Tips | Keyboard shortcuts for choosing ribbon commands that you display by pressing ALT. |
| Keyboard Shortcuts | Specific keyboard keys that you press together or in sequence to execute commands or apply settings. |
| Series | A list of sequential numbers, dates, times, or text. |
| Wrap Text | A feature that causes long cell entries to appear on multiple lines. |
| Contiguous Range | A block of adjacent cells in a worksheet. |
| Noncontiguous Range | Cells in a worksheet that act as a block, but are not necessarily adjacent to each other. |
| Collapse Dialog Button | A button in a dialog box that you click to downsize a dialog box to make a selection on the sheet. |
| Expand Dialog Button | A button that you click to restore a dialog box to its normal size after using the collapse dialog button to make a selection on the sheet. |
| Range | A block of cells in an Excel worksheet. |
| Arithmetic (mathematical Operators | Symbols used in mathematical operations: + for addition, |
| Formula | An instruction Excel uses to calculate a result. |
| Order Of Precedence | The order in which Excel performs the mathematical operations specified in a formula, based on the types of mathematical operators. |
| SUM Function | A built in calculation used to add a range of values together. |
| Absolute Reference | A cell address in a formula that will not change when you copy the formula to another location. Dollar signs indicate an absolute cell reference. |
| Clipboard | A windows feature that holds data or graphics you cut or copy prior to pasting to another location. |
| Copy | The command used to place a copy of data from the selected cell or range on the clipboard. |
| Format Painter | A tool that enables you to copy formatting from a cell and apply it to another cell or range. |
| Paste | The command used to place date fr5om the clipboard to a location on the worksheet. |
| Relative Reference | A cell address that can change in a copied formula, so the new address is expressed in relation to the cell containing the copied formula. For example, if you copy a relative reference to A5 one row down, it becomes A6. |