Page | 1
Click here for more: Scholarsnexus - Stuvia US
Excel Questions with Detailed Verified
Answers (100% Correct Answers) /Already
Graded A+
Active cell
Ans: The selected cell in the worksheet; indicated with a dark border.
Active sheet
Ans: The worksheet currently displayed in the workbook window.
Active workbook
Ans: The workbook you are currently using.
Adjacent range
Ans: A single rectangular block that includes a group of contiguous cells.
Arithmetic operator
Ans: A symbol, such as +, - , *, or /, used in a formula to perform arithmetic
calculations.
AutoComplete
Ans: The feature that helps make entering repetitive text easier. As you enter
text in a worksheet, text that begins with the same letters as a previous entry
in the same column is displayed.
,Page | 2
Click here for more: Scholarsnexus - Stuvia US
Autofit
Ans: To eliminate empty space by matching the column width to the longest
cell entry or the row height to the tallest cell entry.
AutoSum
Ans: A button that quickly inserts Excel functions that summarize all the
values in a column or row using a single statistic - SUM, AVERAGE, COUNT,
MIN or MAX
Cell
Ans: The intersection of a column or row in a worksheet.
Cell range
Ans: A group of worksheet cells, which can be adjacent or nonadjacent.
(Example - A2:G19)
Cell reference
Ans: The address of a cell indicating its column and row location.
Column heading
Ans: In Excel, the part of the worksheet that identifies each column by a
different letter.
Cut
, Page | 3
Click here for more: Scholarsnexus - Stuvia US
Ans: To remove data from a cell and place it on the Office Clipboard.
Date data
Ans: A value in a recognized date format.
Delete
Ans: To remove a cell or cells from a worksheet, shifting the remaining
worksheet cells into the space previously occupied by the deleted cell or cells;
also to remove a worksheet entirely from a workbook.
Drag and drop
Ans: To move an item (either text or a graphic) by selecting it and dragging it
with the mouse.
Editing mode
Ans: A mode in which you can edit part of an entry rather than the entire
contents of a cell.
Find
Ans: The command to locate specific letters and numbers in a workbook.
Formula
Click here for more: Scholarsnexus - Stuvia US
Excel Questions with Detailed Verified
Answers (100% Correct Answers) /Already
Graded A+
Active cell
Ans: The selected cell in the worksheet; indicated with a dark border.
Active sheet
Ans: The worksheet currently displayed in the workbook window.
Active workbook
Ans: The workbook you are currently using.
Adjacent range
Ans: A single rectangular block that includes a group of contiguous cells.
Arithmetic operator
Ans: A symbol, such as +, - , *, or /, used in a formula to perform arithmetic
calculations.
AutoComplete
Ans: The feature that helps make entering repetitive text easier. As you enter
text in a worksheet, text that begins with the same letters as a previous entry
in the same column is displayed.
,Page | 2
Click here for more: Scholarsnexus - Stuvia US
Autofit
Ans: To eliminate empty space by matching the column width to the longest
cell entry or the row height to the tallest cell entry.
AutoSum
Ans: A button that quickly inserts Excel functions that summarize all the
values in a column or row using a single statistic - SUM, AVERAGE, COUNT,
MIN or MAX
Cell
Ans: The intersection of a column or row in a worksheet.
Cell range
Ans: A group of worksheet cells, which can be adjacent or nonadjacent.
(Example - A2:G19)
Cell reference
Ans: The address of a cell indicating its column and row location.
Column heading
Ans: In Excel, the part of the worksheet that identifies each column by a
different letter.
Cut
, Page | 3
Click here for more: Scholarsnexus - Stuvia US
Ans: To remove data from a cell and place it on the Office Clipboard.
Date data
Ans: A value in a recognized date format.
Delete
Ans: To remove a cell or cells from a worksheet, shifting the remaining
worksheet cells into the space previously occupied by the deleted cell or cells;
also to remove a worksheet entirely from a workbook.
Drag and drop
Ans: To move an item (either text or a graphic) by selecting it and dragging it
with the mouse.
Editing mode
Ans: A mode in which you can edit part of an entry rather than the entire
contents of a cell.
Find
Ans: The command to locate specific letters and numbers in a workbook.
Formula
