ISM 110 FINAL EXAM UNCG
Line chart - ✔️✔️Chart type that shows trends over time in which the value axis
indicates quantities and the horizontal axis indicates quantities and the horizontal axis
indicates time.
Increase the left and right margins. - ✔️✔️Assume that the data on a worksheet
consume a whole printed page and a couple of columns on a second page. You can do
all of the following except what to force the data to print all on one page?
Worksheet - ✔️✔️A spreadsheet that contains formulas, functions, values, text and
visual aids.
Workbook - ✔️✔️A file containing related worksheets.
Input area - ✔️✔️A range of cells containing values for variables used in formulas.
Output area - ✔️✔️A range of cells containing results based on manipulating the
variables.
Name box - ✔️✔️Identifies the address of the current cell.
Formula bar - ✔️✔️Displays the content (text, value, date, or formula) in the active cell.
Cell - ✔️✔️The intersection of a column and row.
Text - ✔️✔️Includes letters, numbers, symbols and spaces.
Value - ✔️✔️A number that represents a quantity or an amount.
Order of precedence - ✔️✔️Rules that control the sequence in which Excel performs
arithmetic operations.
Autofill - ✔️✔️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 - ✔️✔️A small green square at the bottom-right corner of a cell.
Column width - ✔️✔️The horizontal measurement of a column.
Row height - ✔️✔️The vertical measurement of a row.
Range - ✔️✔️A rectangular group of cells.
, Alignment - ✔️✔️The position of data between the cell margins.
Wrap Text - ✔️✔️Formatting that enables a label to appear on multiple lines within the
current cell.
Fill - ✔️✔️The background color appearing behind data in a cell.
Formula - ✔️✔️A combination of cell references, operators, values, and/or functions
used to perform a calculation.
State the purpose of the worksheet. - ✔️✔️What is the first step in planning an effective
worksheet?
Name box - ✔️✔️What Excel interface item displays the address of the current cell?
14 - ✔️✔️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 - ✔️✔️Why would you press Ctrl+` in Excel?
A1:A10, D1:D10 - ✔️✔️Which of the following is a nonadjacent range?
Merge and center the data over all columns. - ✔️✔️If you want to balance a title over
several columns, what do you do?
Dollar sign immediately on the left side of the value. - ✔️✔️Which of the following
characteristics is not applicable to the Accounting Number Format?
Click the Paste arrow in the Clipboard group and select Values & Source Formatting. -
✔️✔️You selected and copied worksheet data containing formulas. However, you want
the pasted copy to contain the current formula results rather than formulas. What do you
do?
Increase column width. - ✔️✔️What should you do if you see a column of pound signs
(###) instead of values or results of formulas?
Syntax - ✔️✔️A set of rules that governs the structure and components for properly
entering a function.
TODAY function - ✔️✔️Displays the current date.
Line chart - ✔️✔️Chart type that shows trends over time in which the value axis
indicates quantities and the horizontal axis indicates quantities and the horizontal axis
indicates time.
Increase the left and right margins. - ✔️✔️Assume that the data on a worksheet
consume a whole printed page and a couple of columns on a second page. You can do
all of the following except what to force the data to print all on one page?
Worksheet - ✔️✔️A spreadsheet that contains formulas, functions, values, text and
visual aids.
Workbook - ✔️✔️A file containing related worksheets.
Input area - ✔️✔️A range of cells containing values for variables used in formulas.
Output area - ✔️✔️A range of cells containing results based on manipulating the
variables.
Name box - ✔️✔️Identifies the address of the current cell.
Formula bar - ✔️✔️Displays the content (text, value, date, or formula) in the active cell.
Cell - ✔️✔️The intersection of a column and row.
Text - ✔️✔️Includes letters, numbers, symbols and spaces.
Value - ✔️✔️A number that represents a quantity or an amount.
Order of precedence - ✔️✔️Rules that control the sequence in which Excel performs
arithmetic operations.
Autofill - ✔️✔️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 - ✔️✔️A small green square at the bottom-right corner of a cell.
Column width - ✔️✔️The horizontal measurement of a column.
Row height - ✔️✔️The vertical measurement of a row.
Range - ✔️✔️A rectangular group of cells.
, Alignment - ✔️✔️The position of data between the cell margins.
Wrap Text - ✔️✔️Formatting that enables a label to appear on multiple lines within the
current cell.
Fill - ✔️✔️The background color appearing behind data in a cell.
Formula - ✔️✔️A combination of cell references, operators, values, and/or functions
used to perform a calculation.
State the purpose of the worksheet. - ✔️✔️What is the first step in planning an effective
worksheet?
Name box - ✔️✔️What Excel interface item displays the address of the current cell?
14 - ✔️✔️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 - ✔️✔️Why would you press Ctrl+` in Excel?
A1:A10, D1:D10 - ✔️✔️Which of the following is a nonadjacent range?
Merge and center the data over all columns. - ✔️✔️If you want to balance a title over
several columns, what do you do?
Dollar sign immediately on the left side of the value. - ✔️✔️Which of the following
characteristics is not applicable to the Accounting Number Format?
Click the Paste arrow in the Clipboard group and select Values & Source Formatting. -
✔️✔️You selected and copied worksheet data containing formulas. However, you want
the pasted copy to contain the current formula results rather than formulas. What do you
do?
Increase column width. - ✔️✔️What should you do if you see a column of pound signs
(###) instead of values or results of formulas?
Syntax - ✔️✔️A set of rules that governs the structure and components for properly
entering a function.
TODAY function - ✔️✔️Displays the current date.
