ISM 110 FINAL EXAM UNCG QUESTIONS
WITH ACCURATE ANSWERS
Worksheet - ANSWER A spreadsheet that contains formulas, functions,
values, text and visual aids.
Workbook - ANSWER A file containing related worksheets.
Input area - ANSWER A range of cells containing values for variables used
in formulas.
Output area - ANSWER A range of cells containing results based on
manipulating the variables.
Name box - ANSWER Identifies the address of the current cell.
Formula bar - ANSWER Displays the content (text, value, date, or formula)
in the active cell.
Cell - ANSWER The intersection of a column and row.
Text - ANSWER Includes letters, numbers, symbols and spaces.
Value - ANSWER A number that represents a quantity or an amount.
Order of precedence - ANSWER Rules that control the sequence in which
Excel performs arithmetic operations.
Autofill - ANSWER Enables you to copy the contents of a cell or cell range
or to continue a sequence by dragging the fill handle over an adjacent cell
or range of cells.
, Fill handle - ANSWER A small green square at the bottom-right corner of a
cell.
Column width - ANSWER The horizontal measurement of a column.
Row height - ANSWER The vertical measurement of a row.
Range - ANSWER A rectangular group of cells.
Alignment - ANSWER The position of data between the cell margins.
Wrap Text - ANSWER Formatting that enables a label to appear on
multiple lines within the current cell.
Fill - ANSWER The background color appearing behind data in a cell.
Formula - ANSWER A combination of cell references, operators, values,
and/or functions used to perform a calculation.
State the purpose of the worksheet. - ANSWER What is the first step in
planning an effective worksheet?
Name box - ANSWER What Excel interface item displays the address of
the current cell?
14 - ANSWER Given the formula =B1*B2+B3/B4^2 where B1 contains 3,
B2 contains 4, B3 contains 32, and B4 contains 4, what is the result?
To display cell formulas - ANSWER Why would you press Ctrl+` in Excel?
A1:A10, D1:D10 - ANSWER Which of the following is a nonadjacent
range?
Merge and center the data over all columns. - ANSWER If you want to
balance a title over several columns, what do you do?
Dollar sign immediately on the left side of the value. - ANSWER Which of
the following characteristics is not applicable to the Accounting Number
Format?
WITH ACCURATE ANSWERS
Worksheet - ANSWER A spreadsheet that contains formulas, functions,
values, text and visual aids.
Workbook - ANSWER A file containing related worksheets.
Input area - ANSWER A range of cells containing values for variables used
in formulas.
Output area - ANSWER A range of cells containing results based on
manipulating the variables.
Name box - ANSWER Identifies the address of the current cell.
Formula bar - ANSWER Displays the content (text, value, date, or formula)
in the active cell.
Cell - ANSWER The intersection of a column and row.
Text - ANSWER Includes letters, numbers, symbols and spaces.
Value - ANSWER A number that represents a quantity or an amount.
Order of precedence - ANSWER Rules that control the sequence in which
Excel performs arithmetic operations.
Autofill - ANSWER Enables you to copy the contents of a cell or cell range
or to continue a sequence by dragging the fill handle over an adjacent cell
or range of cells.
, Fill handle - ANSWER A small green square at the bottom-right corner of a
cell.
Column width - ANSWER The horizontal measurement of a column.
Row height - ANSWER The vertical measurement of a row.
Range - ANSWER A rectangular group of cells.
Alignment - ANSWER The position of data between the cell margins.
Wrap Text - ANSWER Formatting that enables a label to appear on
multiple lines within the current cell.
Fill - ANSWER The background color appearing behind data in a cell.
Formula - ANSWER A combination of cell references, operators, values,
and/or functions used to perform a calculation.
State the purpose of the worksheet. - ANSWER What is the first step in
planning an effective worksheet?
Name box - ANSWER What Excel interface item displays the address of
the current cell?
14 - ANSWER Given the formula =B1*B2+B3/B4^2 where B1 contains 3,
B2 contains 4, B3 contains 32, and B4 contains 4, what is the result?
To display cell formulas - ANSWER Why would you press Ctrl+` in Excel?
A1:A10, D1:D10 - ANSWER Which of the following is a nonadjacent
range?
Merge and center the data over all columns. - ANSWER If you want to
balance a title over several columns, what do you do?
Dollar sign immediately on the left side of the value. - ANSWER Which of
the following characteristics is not applicable to the Accounting Number
Format?
