BUS 1350 – Final Exam Key Terms, 2026 – Study guide and reference
material
tabs and contextual tabs - correct answer ✔✔ tabs are at the top of the tab row, contextual tabs
are hidden tabs that are displayed when an object such as an image is selected or highlighted
dialogue box launcher - correct answer ✔✔ on the ribbon, a button at the bottom of some
groups that opens a dialog box with features related to the group
purposes of the alt key - correct answer ✔✔ when pressed creates shortcut letters over
commands (ex alt =)
uses of the copy and shift keys - correct answer ✔✔ what
cell addresses - correct answer ✔✔ the location of a cell on a worksheet. At the intersection of
the column and row, is a cell that has a unique name such as A1. This is called a cell reference or
cell address
fill handle - correct answer ✔✔ black square in lower right corner used to copy content to
adjacent cells
ranges/named ranges - correct answer ✔✔ ranges are a group of cells in a color block. named
ranges have a name given to that entire range, can be changed in formula ribbon, under name
manager
name box - correct answer ✔✔ displays the cell reference of the active cell (ex A1) to the left of
the formula box
, formula bar - correct answer ✔✔ displays data or formula in cell; can enter/edit formula,
function, or data in cell.
naming worksheets - correct answer ✔✔ at bottom of page, double-click name and rename
moving around and navigation in a worksheet - correct answer ✔✔ 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
Ctrl+Enter = enter and stay on the current cell
default alignments for text and values - correct answer ✔✔ numbers to bottom right, text to
bottom left
######; scientific notation - correct answer ✔✔ will show up in the cell if the number is too
long (need to expand the cell)
truncated text - correct answer ✔✔ when one cell's contents continue through the next cell to
the right if it is empty
displaying numbers as text - correct answer ✔✔ click on the cell, in the numbers group, go to
the drop down menu, click text, and the number will also now start on the left side of the cell
line breaks - correct answer ✔✔ alt + enter gives you a line break
how excel handles dates - correct answer ✔✔ as a serial number of the number of days since
january 1st, 1900
material
tabs and contextual tabs - correct answer ✔✔ tabs are at the top of the tab row, contextual tabs
are hidden tabs that are displayed when an object such as an image is selected or highlighted
dialogue box launcher - correct answer ✔✔ on the ribbon, a button at the bottom of some
groups that opens a dialog box with features related to the group
purposes of the alt key - correct answer ✔✔ when pressed creates shortcut letters over
commands (ex alt =)
uses of the copy and shift keys - correct answer ✔✔ what
cell addresses - correct answer ✔✔ the location of a cell on a worksheet. At the intersection of
the column and row, is a cell that has a unique name such as A1. This is called a cell reference or
cell address
fill handle - correct answer ✔✔ black square in lower right corner used to copy content to
adjacent cells
ranges/named ranges - correct answer ✔✔ ranges are a group of cells in a color block. named
ranges have a name given to that entire range, can be changed in formula ribbon, under name
manager
name box - correct answer ✔✔ displays the cell reference of the active cell (ex A1) to the left of
the formula box
, formula bar - correct answer ✔✔ displays data or formula in cell; can enter/edit formula,
function, or data in cell.
naming worksheets - correct answer ✔✔ at bottom of page, double-click name and rename
moving around and navigation in a worksheet - correct answer ✔✔ 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
Ctrl+Enter = enter and stay on the current cell
default alignments for text and values - correct answer ✔✔ numbers to bottom right, text to
bottom left
######; scientific notation - correct answer ✔✔ will show up in the cell if the number is too
long (need to expand the cell)
truncated text - correct answer ✔✔ when one cell's contents continue through the next cell to
the right if it is empty
displaying numbers as text - correct answer ✔✔ click on the cell, in the numbers group, go to
the drop down menu, click text, and the number will also now start on the left side of the cell
line breaks - correct answer ✔✔ alt + enter gives you a line break
how excel handles dates - correct answer ✔✔ as a serial number of the number of days since
january 1st, 1900
