test 1 module 1 vocab

• Active cell: The cell currently selected in the active worksheet
• Active sheet: The sheet currently displayed in the workbook window
• Arithmetic operator: A mathematical symbol representing addition, subtraction, multiplication, division, or exponentiation
• AutoComplete: Feature that helps entering repetitive text easier by displaying text that begins with the same letters as a previous entry in the same column
• AutoFit: Excel feature that changes the column width or row height to display its longest or tallest entry within the column or row
• AutoSum: Button that inserts Excel functions to sum, average, or count all the values in a range, or find the minimum or maximum value in a range
• Backstage view: The File tab of the ribbon providing access to various screens with commands to manage files and Excel options
• Border: A line added along the edge of a cell to improve the readability of the worksheet
• Cell: The intersection of a single row and a single column
• Cell range (or range): A group of cells in a rectangular block, which can be either adjacent or nonadjacent
• Cell reference: The column and row location that identifies a cell within a worksheet
• Chart sheet: A sheet that contains only a chart providing a visual representation of worksheet data
• Clear: To remove data from selected cells, but leave the blank cells in the worksheet
• Column headings: The letters along the top of the worksheet window that identify the different columns of the worksheet
• Date data: A value in a recognized date format
• Delete: To remove both the data and the selected cells from the worksheet
• Drag and drop: Technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, and then dragging the selection to a new location
• Edit mode: The mode in which you can edit cell contents
• Excel: A spreadsheet program used to enter, analyze, and present quantitative data
• Flash Fill: Excel feature that enters text based on patterns in the data
• Font size: A measurement of the size of text
• Formatting: A process by which a workbook’s appearance is changed to make it easier to read
• Formula: A mathematical expression that calculates a value
• Formula bar: The bar located below the ribbon that displays the value or formula entered into the active cell
• Function: A named operation that replaces the action of an arithmetic expression
• Group: A part of an Excel ribbon that organizes related commands within a particular tab
• Hide: A process by which a row or column is removed from a worksheet by essentially decreasing its height or weight to 0 pixels
• Keyboard shortcut: A key or combination of keys that you press to access a feature or perform a command
• Landscape orientation: The page orientation where the page is wider than it is tall
• Maximize button: A button that expands the Excel window to fill the screen
• Minimize button: A button that hides the Excel window so that only its program button is available on the taskbar
• Name box: The box located at the left side of the formula bar that displays the cell reference of the active cell
• Nonadjacent range: Two or more adjacent ranges that are not connected
• Normal view: The Excel view that shows the contents of the active sheet in the workbook window
• Numeric data: Any number that can be used in a mathematical calculation
• Operator: A mathematical symbol used in a formula to combine different values, resulting in a single value displayed within the cell
• Order of operations: The sequence in which operators are applied in a calculation

  • PEMDAS
• Page Break Preview: The Excel view that shows the location of page breaks in the printed sheet
• Page Layout view: The Excel view that shows how the sheet will appear when printed
• Page orientation: The direction in which content is printed