BUS 1350 Final Exam Questions with Correct Answers 100% Verified by Experts| 2025/2026
Latest Update
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 the operations of addition,
subtraction, multiplication, division, or exponentiation
AutoComplete 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 The Excel feature that changes the column width or row height to display its longest
or tallest entry within the column or row
AutoSum 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 The File tab of the ribbon, which provides access to various screens with
commands that allow you to manage files and Excel options.
border A line added along the edge of a cell to improve the readability of the worksheet. (EX
30)
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 that provides 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 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 The mode in which you can edit cell contents.
Excel A spreadsheet program used to enter, analyze, and present quantitative data.
Flash Fill The 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
Microsoft Excel 2016 (Excel) A spreadsheet program used to enter, analyze, and present
quantitative data.
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 that is displayed within the cell
order of operations The sequence in which operators are applied in a calculation
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.
portrait orientation The page orientation where the page is taller than it is wide.
range A group of cells in a rectangular block, which can be either adjacent or nonadjacent.
range reference The cell reference of the upper-left cell of the rectangular block and the cell
reference of the lower-right cell separated by a colon.
Latest Update
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 the operations of addition,
subtraction, multiplication, division, or exponentiation
AutoComplete 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 The Excel feature that changes the column width or row height to display its longest
or tallest entry within the column or row
AutoSum 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 The File tab of the ribbon, which provides access to various screens with
commands that allow you to manage files and Excel options.
border A line added along the edge of a cell to improve the readability of the worksheet. (EX
30)
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 that provides 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 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 The mode in which you can edit cell contents.
Excel A spreadsheet program used to enter, analyze, and present quantitative data.
Flash Fill The 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
Microsoft Excel 2016 (Excel) A spreadsheet program used to enter, analyze, and present
quantitative data.
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 that is displayed within the cell
order of operations The sequence in which operators are applied in a calculation
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.
portrait orientation The page orientation where the page is taller than it is wide.
range A group of cells in a rectangular block, which can be either adjacent or nonadjacent.
range reference The cell reference of the upper-left cell of the rectangular block and the cell
reference of the lower-right cell separated by a colon.
