BUS 1350 – Exam 1, Risinger, 2026 – Study guide and practice
material
active cell - correct answer ✔✔ The cell currently selected in the active worksheet
active sheet - correct answer ✔✔ The sheet currently displayed in the workbook window
arithmetic operator - correct answer ✔✔ A mathematical symbol representing the operations
of addition, subtraction, multiplication, division, or exponentiation
AutoComplete - correct answer ✔✔ The feature that helps make entering repetitive text easier;
as you type text into the active cell, Excel displays text that begins with the same letters as a
previous entry in the same column
AutoFit - correct answer ✔✔ The Excel feature that changes the column width or row height to
display its longest or tallest entry within the column or row
AutoSum - correct answer ✔✔ A 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 - correct answer ✔✔ The File tab of the ribbon, which provides access to
various screens with commands that allow you to manage files and Excel options
border - correct answer ✔✔ A line added along the edge of a cell to improve the readability of
the worksheet.
cell - correct answer ✔✔ The intersection of a single row and a single column
,cell range (or range) - correct answer ✔✔ A group of cells in a rectangular block, which can be
either adjacent or nonadjacent
cell reference - correct answer ✔✔ The column and row location that identifies a cell within a
worksheet
chart sheet - correct answer ✔✔ A sheet that contains only a chart that provides a visual
representation of worksheet data.
clear - correct answer ✔✔ To remove data from selected cells, but leave the blank cells in the
worksheet.
column headings - correct answer ✔✔ The letters along the top of the worksheet window that
identify the different columns of the worksheet
date data - correct answer ✔✔ A value in a recognized date format.
delete - correct answer ✔✔ To remove both the data and the selected cells from the worksheet.
drag and drop - correct answer ✔✔ The 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 - correct answer ✔✔ The mode in which you can edit cell contents
Excel - correct answer ✔✔ A spreadsheet program used to enter, analyze, and present
quantitative data.
Flash Fill - correct answer ✔✔ The Excel feature that enters text based on patterns in the data
, font size - correct answer ✔✔ A measurement of the size of text.
formatting - correct answer ✔✔ A process by which a workbook's appearance is changed to
make it easier to read
formula - correct answer ✔✔ A mathematical expression that calculates a value
formula bar - correct answer ✔✔ The bar located below the ribbon that displays the value or
formula entered into the active cell
function - correct answer ✔✔ A named operation that replaces the action of an arithmetic
expression.
group - correct answer ✔✔ A part of an Excel ribbon that organizes related commands within a
particular tab
hide - correct answer ✔✔ 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 - correct answer ✔✔ A key or combination of keys that you press to access a
feature or perform a command.
landscape orientation - correct answer ✔✔ The page orientation where the page is wider than
it is tall.
Maximize button - correct answer ✔✔ A button that expands the Excel window to fill the screen
material
active cell - correct answer ✔✔ The cell currently selected in the active worksheet
active sheet - correct answer ✔✔ The sheet currently displayed in the workbook window
arithmetic operator - correct answer ✔✔ A mathematical symbol representing the operations
of addition, subtraction, multiplication, division, or exponentiation
AutoComplete - correct answer ✔✔ The feature that helps make entering repetitive text easier;
as you type text into the active cell, Excel displays text that begins with the same letters as a
previous entry in the same column
AutoFit - correct answer ✔✔ The Excel feature that changes the column width or row height to
display its longest or tallest entry within the column or row
AutoSum - correct answer ✔✔ A 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 - correct answer ✔✔ The File tab of the ribbon, which provides access to
various screens with commands that allow you to manage files and Excel options
border - correct answer ✔✔ A line added along the edge of a cell to improve the readability of
the worksheet.
cell - correct answer ✔✔ The intersection of a single row and a single column
,cell range (or range) - correct answer ✔✔ A group of cells in a rectangular block, which can be
either adjacent or nonadjacent
cell reference - correct answer ✔✔ The column and row location that identifies a cell within a
worksheet
chart sheet - correct answer ✔✔ A sheet that contains only a chart that provides a visual
representation of worksheet data.
clear - correct answer ✔✔ To remove data from selected cells, but leave the blank cells in the
worksheet.
column headings - correct answer ✔✔ The letters along the top of the worksheet window that
identify the different columns of the worksheet
date data - correct answer ✔✔ A value in a recognized date format.
delete - correct answer ✔✔ To remove both the data and the selected cells from the worksheet.
drag and drop - correct answer ✔✔ The 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 - correct answer ✔✔ The mode in which you can edit cell contents
Excel - correct answer ✔✔ A spreadsheet program used to enter, analyze, and present
quantitative data.
Flash Fill - correct answer ✔✔ The Excel feature that enters text based on patterns in the data
, font size - correct answer ✔✔ A measurement of the size of text.
formatting - correct answer ✔✔ A process by which a workbook's appearance is changed to
make it easier to read
formula - correct answer ✔✔ A mathematical expression that calculates a value
formula bar - correct answer ✔✔ The bar located below the ribbon that displays the value or
formula entered into the active cell
function - correct answer ✔✔ A named operation that replaces the action of an arithmetic
expression.
group - correct answer ✔✔ A part of an Excel ribbon that organizes related commands within a
particular tab
hide - correct answer ✔✔ 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 - correct answer ✔✔ A key or combination of keys that you press to access a
feature or perform a command.
landscape orientation - correct answer ✔✔ The page orientation where the page is wider than
it is tall.
Maximize button - correct answer ✔✔ A button that expands the Excel window to fill the screen
