BUS 1350 EXAM 1 – RISINGER EXAM
QUESTIONS & ACCURATE
COMPLETE SOLUTIONS
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.
QUESTIONS & ACCURATE
COMPLETE SOLUTIONS
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.
