Excel Unit 1-3

active cell

• A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
• A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
• In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
• A box on the grid identified by the intersection of a column and a row.

Backstage view

• A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
• A word assigned to a document's properties that makes it easier to organize and file documents
• Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
• Cells that run from top to bottom in a worksheet and are identified by letters.

cell

• A box on the grid identified by the intersection of a column and a row.
• Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
• A toolbar that gives you fast and easy access to the tools you use most often in Excel.
• Task-specific groups divided among the command tabs appropriate to the work a user currently performs.

column

• Cells that run from top to bottom in a worksheet and are identified by letters.
• A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
• A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
• Task-oriented tabs that are organized on the ribbon.

command group

• Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
• A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
• A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
• An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.

command tabs

• Task-oriented tabs that are organized on the ribbon.
• A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
• A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
• In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.

Dialog Box Launcher

• An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
• To insert data from the Clipboard to a new location in a worksheet
• A collection of worksheets in a single file.
• Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.

FILE tab

• In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
• Highlighting that is to be changed
• A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
• A toolbar that gives you fast and easy access to the tools you use most often in Excel.

Name Box

• Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
• Items you directly change, such as keyword
• Highlighting that is to be changed
• A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.

Quick Access Toolbar

• A toolbar that gives you fast and easy access to the tools you use most often in Excel.
• A box on the grid identified by the intersection of a column and a row.
• Items you directly change, such as keyword
• A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.