BUSI 520 FINAL EXAM REVIEW QUESTIONS

BUSI 520 FINAL EXAM REVIEW QUESTIONS


The COUNTA function ignores cells with text - Answers - False - Determines the
number of values in a list but does not ignore text cells

Pressing Ctrl+Shift+# applies the number format. - Answers - False - CTRL+Shift+!
(Ctrl, shift and exclamation mark) applies the number format

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)

In Excel, what keystroke combination shows the format cells dialog window? - Answers
- Ctrl+1 (Ctrl and 1)

In Excel, what keystroke combination quickly inserts the current time? - Answers -
Ctrl+Shift+: (Ctrl, Shift and colon)

The error message #NAME? means that there is(are) - Answers - unrecognized text in
a formula.

In Excel, what keystroke combination closes the current workbook? - Answers - CTRL +
F4 OR CTRL + w

$B1 is an example of a(n) _____ reference. - Answers - Mixed

In Excel, what keystroke combination selects the current column? - Answers - CTRL +
Space

_____ is(are) first in the order of precedence rules. - Answers - Operations in
parentheses - PEMDAS

COUNT(number1, number 2, ...) determines the sum of a list of values. - 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

What keystroke combination switches between currently open workbooks? - Answers -
CTRL + Tab

,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

#REF! means invalid numerical values in a formula or function. - Answers - False

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

It is okay to send your homework file to someone else in order to help the person
understand a particular topic. - Answers - False

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is - Answers - 0

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, after having copied something, what keystroke combination performs a Paste
operation? - Answers - CTRL + v

In Excel, what keystroke combination quickly inserts the current date? - Answers -
CTRL + ;

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 performs an "undo" of the last action? - Answers -
CTRL + z

A quick way to apply the currency 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.

If A1=2, the resulting value of =3*A1^3 is - Answers - 24

In Excel, what keystroke combination toggles between displaying formulas and
displaying values? - Answers - Ctrl + ' . (Ctrl and left quote.)

In Excel, what keystroke combination selects the current row? - Answers - Shift + Space

_____ is(are) last in the order of precedence rules. - Answers - Addition and subtraction
from left to right

, 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

The best way to center titles is to use the Merge & Center toolbar/ribbon button. -
Answers - False - use center across selection

You should always adjust column widths first, before attempting to Wrap Text for the
column headings. - Answers - False

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

In Excel, what keystroke combination quickly removes a border from the selected cell or
range? - Answers - Ctrl+Shift+_ (Ctrl, Shift and underscore)

In Excel, after having copied something, what keystroke combination quickly performs a
Paste Special operation? - Answers - CTRL + Alt + v

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

B1 is an example of a(n) _____ cell reference. - Answers - Relative

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

If A1=2, then the resulting value of =3+5*A1 is - Answers - 13

In Excel, what keystroke combination inserts cells? - Answers - CTRL + Shift + Plus

Using cell references is preferable to directly inputting values into a formula. - Answers -
True

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

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

In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - Answers - F4