©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Excel Exam Questions and Answers
100% Solve | Graded A+
Active cell - ✔✔The selected cell in the worksheet; indicated with a dark
border.
Active sheet - ✔✔The worksheet currently displayed in the workbook
window.
Active workbook - ✔✔The workbook you are currently using.
Adjacent range - ✔✔A single rectangular block that includes a group of
contiguous cells.
Arithmetic operator - ✔✔A symbol, such as +, - , *, or /, used in a formula
to perform arithmetic calculations.
AutoComplete - ✔✔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.
Autofit - ✔✔To eliminate empty space by matching the column width to
the longest cell entry or the row height to the tallest cell entry.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
AutoSum - ✔✔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 - ✔✔The intersection of a column or row in a worksheet.
Cell range - ✔✔A group of worksheet cells, which can be adjacent or
nonadjacent. (Example - A2:G19)
Cell reference - ✔✔The address of a cell indicating its column and row
location.
Column heading - ✔✔In Excel, the part of the worksheet that identifies
each column by a different letter.
Cut - ✔✔To remove data from a cell and place it on the Office Clipboard.
Date data - ✔✔A value in a recognized date format.
Delete - ✔✔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 - ✔✔To move an item (either text or a graphic) by
selecting it and dragging it with the mouse.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Editing mode - ✔✔A mode in which you can edit part of an entry rather
than the entire contents of a cell.
Find - ✔✔The command to locate specific letters and numbers in a
workbook.
Formula - ✔✔A mathematical expression that calculates a value; all
Excel formulas always begin with an equal sign (=) followed by an
expression that describes the calculation to be done.
Formula bar - ✔✔The bar located above the workbook window in which
the contents of a cell are displayed.
Formula view - ✔✔Excel view in which cell formulas are displayed rather
than the values returned by the formulas.
Function - ✔✔A predefined formula that performs calculations using
specific values called arguments.
Landscape orientation - ✔✔A type of page orientation in which the page
is wider than it is tall, so that text spans the widest part of the page.
Microsoft Excel 2007 - ✔✔A spreadsheet program you use to display,
organize, and analyze numerical data.
Excel Exam Questions and Answers
100% Solve | Graded A+
Active cell - ✔✔The selected cell in the worksheet; indicated with a dark
border.
Active sheet - ✔✔The worksheet currently displayed in the workbook
window.
Active workbook - ✔✔The workbook you are currently using.
Adjacent range - ✔✔A single rectangular block that includes a group of
contiguous cells.
Arithmetic operator - ✔✔A symbol, such as +, - , *, or /, used in a formula
to perform arithmetic calculations.
AutoComplete - ✔✔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.
Autofit - ✔✔To eliminate empty space by matching the column width to
the longest cell entry or the row height to the tallest cell entry.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
AutoSum - ✔✔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 - ✔✔The intersection of a column or row in a worksheet.
Cell range - ✔✔A group of worksheet cells, which can be adjacent or
nonadjacent. (Example - A2:G19)
Cell reference - ✔✔The address of a cell indicating its column and row
location.
Column heading - ✔✔In Excel, the part of the worksheet that identifies
each column by a different letter.
Cut - ✔✔To remove data from a cell and place it on the Office Clipboard.
Date data - ✔✔A value in a recognized date format.
Delete - ✔✔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 - ✔✔To move an item (either text or a graphic) by
selecting it and dragging it with the mouse.
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Editing mode - ✔✔A mode in which you can edit part of an entry rather
than the entire contents of a cell.
Find - ✔✔The command to locate specific letters and numbers in a
workbook.
Formula - ✔✔A mathematical expression that calculates a value; all
Excel formulas always begin with an equal sign (=) followed by an
expression that describes the calculation to be done.
Formula bar - ✔✔The bar located above the workbook window in which
the contents of a cell are displayed.
Formula view - ✔✔Excel view in which cell formulas are displayed rather
than the values returned by the formulas.
Function - ✔✔A predefined formula that performs calculations using
specific values called arguments.
Landscape orientation - ✔✔A type of page orientation in which the page
is wider than it is tall, so that text spans the widest part of the page.
Microsoft Excel 2007 - ✔✔A spreadsheet program you use to display,
organize, and analyze numerical data.
