BUSI 520 ALL CHAPTERS QUESTIONS AND ANSWERS
$B1 is an example of a(n) _____ reference. - Answers - mixed
In Excel, after having copied something, what keystroke combination performs a Paste
operation? - Answers - Ctrl+v
In Excel, what keystroke combination quickly removes a border from the selected cell or
range? - Answers - Ctrl+Shift+_ (Ctrl, Shift and underscore)
If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the
resulting formula? - Answers - =$B$4-SUM(C2:C6)
Pressing Ctrl+Shift+# applies the number format. - Answers - False
In Excel, what keystroke combination moves one screen to the right within the current
worksheet? - Answers - Alt+Pg dn
In Excel, after selecting a range of cells, what keystroke combination deletes those
cells? (not just deletes the contents of cells, but deletes the actual cells, so that other
cells adjust to replace the deleted cells) - Answers - Ctrl+minus
#REF! means invalid numerical values in a formula or function. - Answers - False
In Excel, what keystroke combination selects the current row? - Answers - Shift+space
Using cell references is preferable to directly inputting values into a formula. - Answers -
True
In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - Answers - F4
In Excel, what keystroke combination selects right, to the end of the current row of
contiguous (adjacent) cells? - Answers - Ctrl+Shift+right arrow
In Excel, what keystroke combination performs an "undo" of the last action? - Answers -
Ctrl+z
If multiple cells are selected/highlighted, what keystroke combination copies the
formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s)
in the range of selected cells? - Answers - Ctrl+d
When using Excel to open a file that is in .csv format, formulas and formatting entered in
the sheet can be safely saved in either .csv, .xls or .xlsx format. - Answers - False
,You should always adjust column widths first, before attempting to Wrap Text for the
column headings. - Answers - False
The best way to center titles is to use the Merge & Center toolbar/ribbon button. -
Answers - False
In Excel, what keystroke combination moves (the active cell) right, to the end of the
current row of contiguous (adjacent) cells with values? - Answers - Ctrl+right arrow
COUNT(number1, number 2, ...) determines the sum of a list of values. - Answers -
False
It is okay to send your homework file to someone else in order to help the person
understand a particular topic. - Answers - False
In Excel, what keystroke combination switches (the active worksheet) to the next
worksheet (to the right)? - Answers - Ctrl+Pg dn
The COUNTA function ignores cells with text - Answers - False
In Excel, what keystroke combination quickly applies the number format to two decimal
places? - Answers - Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
If multiple horizontal cells are selected/highlighted, what keystroke combination copies
the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the
other cells in the range of selected cells? - Answers - Ctrl+r
B1 is an example of a(n) _____ cell reference. - Answers - relative
If A1=2, the resulting value of =3*A1^3 is - Answers - 24
In Excel, what keystroke combination closes the current workbook? - Answers - Ctrl+F4,
Ctrl+w
_____ is(are) last in the order of precedence rules. - Answers - Addition and subtraction
from left to right
In Excel, what keystroke combination inserts cells? - Answers - Ctrl+Shift+plus
In Excel, what keystroke combination shows the format cells dialog window? - Answers
- Ctrl+1 (Ctrl and 1)
In Excel, what keystroke combination selects the current column? - Answers -
Ctrl+space
, The wrong argument type or operand is shown by - Answers - #VALUE!
A quick way to apply the percent format is to press Ctrl+Shift+%. - Answers - True
The error message ###### means that there is(are) - Answers - insufficient width in cell
to display data, or negative date/time.
In Excel, after having copied something, what keystroke combination quickly performs a
Paste Special operation? - Answers - Ctrl+Alt+v
What keystroke combination switches between currently open workbooks? - Answers -
Ctrl+tab
The Accounting Format inserts a dollar sign directly in front of (and flush against) the
leftmost number in the cell, like this: $1.00 - Answers - False
_____ is(are) first in the order of precedence rules. - Answers - Operations in
parentheses
The error message #NAME? means that there is(are) - Answers - unrecognized text in
a formula.
A quick way to apply the currency format is to press Ctrl+Shift+$. - Answers - True
In Excel, what keystroke combination quickly inserts the current time? - Answers -
Ctrl+Shift+: (Ctrl, Shift and colon)
In Excel, what keystroke combination quickly applies a border around the selected cell
or range? - Answers - Ctrl+Shift+& (Ctrl, Shift and ampersand)
In Excel, what keystroke combination toggles between displaying formulas and
displaying values? - Answers - None of the answers listed. Ctrl + '
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is - Answers - 0
In Excel, what keystroke combination quickly applies the General format? - Answers -
Ctrl+Shift+~ (Ctrl, Shift and tilde)
In order to maintain consistency within your workbooks, it is important to format cells
with formulas (outputs) using the same colors as cells containing assumptions and/or
values (inputs). - Answers - False
A workbook's documentation sheet should always be showing when saving the file a
final time (right before submitting the file), so that when someone opens your file, the
documentation sheet will be the first sheet seen. - Answers - True
$B1 is an example of a(n) _____ reference. - Answers - mixed
In Excel, after having copied something, what keystroke combination performs a Paste
operation? - Answers - Ctrl+v
In Excel, what keystroke combination quickly removes a border from the selected cell or
range? - Answers - Ctrl+Shift+_ (Ctrl, Shift and underscore)
If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the
resulting formula? - Answers - =$B$4-SUM(C2:C6)
Pressing Ctrl+Shift+# applies the number format. - Answers - False
In Excel, what keystroke combination moves one screen to the right within the current
worksheet? - Answers - Alt+Pg dn
In Excel, after selecting a range of cells, what keystroke combination deletes those
cells? (not just deletes the contents of cells, but deletes the actual cells, so that other
cells adjust to replace the deleted cells) - Answers - Ctrl+minus
#REF! means invalid numerical values in a formula or function. - Answers - False
In Excel, what keystroke combination selects the current row? - Answers - Shift+space
Using cell references is preferable to directly inputting values into a formula. - Answers -
True
In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - Answers - F4
In Excel, what keystroke combination selects right, to the end of the current row of
contiguous (adjacent) cells? - Answers - Ctrl+Shift+right arrow
In Excel, what keystroke combination performs an "undo" of the last action? - Answers -
Ctrl+z
If multiple cells are selected/highlighted, what keystroke combination copies the
formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s)
in the range of selected cells? - Answers - Ctrl+d
When using Excel to open a file that is in .csv format, formulas and formatting entered in
the sheet can be safely saved in either .csv, .xls or .xlsx format. - Answers - False
,You should always adjust column widths first, before attempting to Wrap Text for the
column headings. - Answers - False
The best way to center titles is to use the Merge & Center toolbar/ribbon button. -
Answers - False
In Excel, what keystroke combination moves (the active cell) right, to the end of the
current row of contiguous (adjacent) cells with values? - Answers - Ctrl+right arrow
COUNT(number1, number 2, ...) determines the sum of a list of values. - Answers -
False
It is okay to send your homework file to someone else in order to help the person
understand a particular topic. - Answers - False
In Excel, what keystroke combination switches (the active worksheet) to the next
worksheet (to the right)? - Answers - Ctrl+Pg dn
The COUNTA function ignores cells with text - Answers - False
In Excel, what keystroke combination quickly applies the number format to two decimal
places? - Answers - Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
If multiple horizontal cells are selected/highlighted, what keystroke combination copies
the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the
other cells in the range of selected cells? - Answers - Ctrl+r
B1 is an example of a(n) _____ cell reference. - Answers - relative
If A1=2, the resulting value of =3*A1^3 is - Answers - 24
In Excel, what keystroke combination closes the current workbook? - Answers - Ctrl+F4,
Ctrl+w
_____ is(are) last in the order of precedence rules. - Answers - Addition and subtraction
from left to right
In Excel, what keystroke combination inserts cells? - Answers - Ctrl+Shift+plus
In Excel, what keystroke combination shows the format cells dialog window? - Answers
- Ctrl+1 (Ctrl and 1)
In Excel, what keystroke combination selects the current column? - Answers -
Ctrl+space
, The wrong argument type or operand is shown by - Answers - #VALUE!
A quick way to apply the percent format is to press Ctrl+Shift+%. - Answers - True
The error message ###### means that there is(are) - Answers - insufficient width in cell
to display data, or negative date/time.
In Excel, after having copied something, what keystroke combination quickly performs a
Paste Special operation? - Answers - Ctrl+Alt+v
What keystroke combination switches between currently open workbooks? - Answers -
Ctrl+tab
The Accounting Format inserts a dollar sign directly in front of (and flush against) the
leftmost number in the cell, like this: $1.00 - Answers - False
_____ is(are) first in the order of precedence rules. - Answers - Operations in
parentheses
The error message #NAME? means that there is(are) - Answers - unrecognized text in
a formula.
A quick way to apply the currency format is to press Ctrl+Shift+$. - Answers - True
In Excel, what keystroke combination quickly inserts the current time? - Answers -
Ctrl+Shift+: (Ctrl, Shift and colon)
In Excel, what keystroke combination quickly applies a border around the selected cell
or range? - Answers - Ctrl+Shift+& (Ctrl, Shift and ampersand)
In Excel, what keystroke combination toggles between displaying formulas and
displaying values? - Answers - None of the answers listed. Ctrl + '
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is - Answers - 0
In Excel, what keystroke combination quickly applies the General format? - Answers -
Ctrl+Shift+~ (Ctrl, Shift and tilde)
In order to maintain consistency within your workbooks, it is important to format cells
with formulas (outputs) using the same colors as cells containing assumptions and/or
values (inputs). - Answers - False
A workbook's documentation sheet should always be showing when saving the file a
final time (right before submitting the file), so that when someone opens your file, the
documentation sheet will be the first sheet seen. - Answers - True
