| A | B |
|---|
| Active cell | The active cell is the current cell. There is a green border around the active cell. |
| Backstage view | A feature of Microsoft Office 2016 from which you access file and management commands |
| Cell | A cell is the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet |
| Cell address or cell reference | The location of a cell in a worksheet as identified by its column letter and row number such as A1 |
| Formula bar | As you enter data in a cell it simultaneously appears in the formula bar which is located above the worksheet |
| OneDrive | a file hosting service that allows you to upload and sync files to a virtual or cloud storage environment. Files can then be accessed from a Web browser or a local device |
| Scroll | a way to view locations on the worksheet without changing the active cell |
| Sheet tabs | Tabs that appear at the bottom of the workbook window which display the name of each worksheet |
| Tab scrolling buttons | Buttons that appear to the left of the sheet tabs which allow you to scroll hidden tabs into view |
| Template | A document that contains formatting styles and sample text that you can use to create new documents |
| Workbook | An Excel file with one or more worksheets |
| Worksheet | The work area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet |
| 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 appears at the bottom of every page of a printout |
| Header | Descriptive text such as page number that appears at the top of every page of the printout |
| Label | Text entered to identify the type of data contained in a row or column |
| 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 a cell or range address |
| Undo | The command used to reverse one or a series of editing actions |
| AutoComplete | A feature used to complete an entry based on previous entries made in the column containing the active cell |
| AutoCorrect | A feature used to automate the correction of common typing errors |
| Numeric label | A number entered in the worksheet as a label not as a value- such as the year 2017 used as a column label |
| Pick From List | A shortcut used to insert repeated information |
| Spelling Checker | A tool used to assist you in finding and correcting typographical or spelling errors |
| Value | A cell entry that consists of a number and numeric formatting only |
| Accounting format | A style that vertically aligns dollar signs ($) thousands separators (comma) 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 (comma) |
| Currency format | A style that displays dollar signs ($) immediately preceding the number and includes a thousands separator (comma) |
| Fill | A color that fills a cell appearing behind the data |
| Font | The typeface or design of the text |
| Font size | The measurement of the typeface in point (1 point = 1/72 of an inch) |
| 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 the choice |
| Merge and Center | A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell |
| Number format | a format that controls how numerical data is displayed including the use of commas dollar signs (or other symbols) and the number of decimal places |
| Percent format | A style that displays decimal numbers in 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 box 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 |
| Formula | An instruction Excel used 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 used |
| 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 data from 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 to one row down it becomes A6 |
| Cut | The command used to remove data from a cell or range of cells and place it on the Clipboard |
| Drag-and-drop | A method used to move or copy the contents of a range of cells by dragging the border of a selection from one location in a worksheet and dropping it in another location |
| Transpose | A method to rearrange data by switching the positions of columns and rows |
| Orientation | The position for displaying and printing text either horizontally across the shorter side of a page the default Portrait orientation or along the wider side of the page Landscape orientation |
| Print titles | Row and column labels that reprint on each page of a printout |
| Scale | Adjust the size proportionately |
| Show Formulas | A command that enables you to display the formulas in a worksheet so that you can check them |
