BUS 1350 – Exam 1 (Excel), 2026 – Study guide and practice material
Ribbon - correct answer ✔✔ Contains grouped command buttons that you click to interact with
Excel and execute commands (organized into tabs)
Tabs - correct answer ✔✔ Group of related commands for particular activities or tasks
Contextual Tab - correct answer ✔✔ Special tab that appears only when a specific object is
selected, contain commands specific to what object is selected
Dialog Box Launcher - correct answer ✔✔ Small icon in lower right corner, opens related dialog
boxes that provide more options that relate to the group
Copy and Shift Keys - correct answer ✔✔ CTRL+C (copy) SHIFT+Arrow Keys (selects the cells)
Workbook - correct answer ✔✔ File containing one or more worksheets to help you organize
data
Worksheet - correct answer ✔✔ Single sheet in a workbook file that is laid out in a grid of rows
and columns
Cell - correct answer ✔✔ Intersection of a row and column, each cell has its own name based
on its column and row (address)
Active Cell - correct answer ✔✔ Currently selected cell where you enter and store data, shown
by a thick green border
Cell Addresses - correct answer ✔✔ Location of a cell on a worksheet, defined by column letter
and row number
, Fill Handle - correct answer ✔✔ A small square in the lower, right corner of a selected cell or
range of cells, can copy contents into cells by clicking and dragging
Ranges - correct answer ✔✔ Block of cells that can be selected that can be selected, selected,
manipulated, named or formatted as a group
Named Ranges - correct answer ✔✔ One or more cells that have been given a name, can make
formulas easier to read and understand
Name Box - correct answer ✔✔ Located on the left of the formula bar, indicates the current
address of the active cell or cell range
Formula Bar - correct answer ✔✔ Located under the toolbars at the top of the screen, contains
the edit line for working with formulas, and provides info on selected cell
Naming Worksheets - correct answer ✔✔ Bottom tabs of page, double click to rename
Worksheet Views - correct answer ✔✔ Can view any worksheet in Normal view, Page Layout
view, or Page Break view, located in bottom right corner of page
Moving Around Excel - correct answer ✔✔ Home- column a of the current
CTRL+Home- A1
Enter- down one row
Shift+Enter-up one row
Tab- one column to the right
Shift+Tab-one column to the left
Ribbon - correct answer ✔✔ Contains grouped command buttons that you click to interact with
Excel and execute commands (organized into tabs)
Tabs - correct answer ✔✔ Group of related commands for particular activities or tasks
Contextual Tab - correct answer ✔✔ Special tab that appears only when a specific object is
selected, contain commands specific to what object is selected
Dialog Box Launcher - correct answer ✔✔ Small icon in lower right corner, opens related dialog
boxes that provide more options that relate to the group
Copy and Shift Keys - correct answer ✔✔ CTRL+C (copy) SHIFT+Arrow Keys (selects the cells)
Workbook - correct answer ✔✔ File containing one or more worksheets to help you organize
data
Worksheet - correct answer ✔✔ Single sheet in a workbook file that is laid out in a grid of rows
and columns
Cell - correct answer ✔✔ Intersection of a row and column, each cell has its own name based
on its column and row (address)
Active Cell - correct answer ✔✔ Currently selected cell where you enter and store data, shown
by a thick green border
Cell Addresses - correct answer ✔✔ Location of a cell on a worksheet, defined by column letter
and row number
, Fill Handle - correct answer ✔✔ A small square in the lower, right corner of a selected cell or
range of cells, can copy contents into cells by clicking and dragging
Ranges - correct answer ✔✔ Block of cells that can be selected that can be selected, selected,
manipulated, named or formatted as a group
Named Ranges - correct answer ✔✔ One or more cells that have been given a name, can make
formulas easier to read and understand
Name Box - correct answer ✔✔ Located on the left of the formula bar, indicates the current
address of the active cell or cell range
Formula Bar - correct answer ✔✔ Located under the toolbars at the top of the screen, contains
the edit line for working with formulas, and provides info on selected cell
Naming Worksheets - correct answer ✔✔ Bottom tabs of page, double click to rename
Worksheet Views - correct answer ✔✔ Can view any worksheet in Normal view, Page Layout
view, or Page Break view, located in bottom right corner of page
Moving Around Excel - correct answer ✔✔ Home- column a of the current
CTRL+Home- A1
Enter- down one row
Shift+Enter-up one row
Tab- one column to the right
Shift+Tab-one column to the left
