BUSI 520 FINAL QUESTIONS AND ANSWERS

BUSI 520 FINAL QUESTIONS AND ANSWERS


The error message ###### means that there is (are) - Answers - Column width of a cell
is too narrow to display numeric data, or a formula in a cell results in a negative date, a
date prior to 1/1/1900

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

#N/A - Answers - No answer can be found

#REF! - Answers - Invalid cell reference

#VALUE! - Answers - Wrong argument type or operand

#NUM! - Answers - Invalid numeric values in a formula or function

#DIV/0! - Answers - Division by zero

COUNT(number1, [number2],..) - Answers - Determines the number of values in a list,
but it ignores blank cells and cells with text

COUNTA(number1,[number2]...) - Answers - Determines the number of values in a list
but does not ignore text cells

Absolute cell referencing - Answers - Indicates that a cell reference should remain
unchanged when copying. Ex: $A$19

Mixed Cell Reference - Answers - A cell reference that has only one $
Common when you need to copy a formula both down a column and across a row at the
same ti

What keystroke combination shows the format cells dialog window? - Answers -
CTRL+1 (CTRL and 1)

___ is(are) first in the order of precedence rules - Answers - Operations in parentheses

What Keystroke combination selects right, to the end of the current row of contiguous
(adjacent) cells? - Answers - CTRL+Shift+right arrow

What keystroke combination toggles between displaying formulas and displaying
values? - Answers - CTRL+`

,You should always adjust column width first before attempting to wrap text for the
column headings. - Answers - False; you should always wrap text for column headings
first before adjusting any column widths

What keystroke combination selects the current row? - Answers - Shift+space

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

A quick way to apply the percent format is to press Ctrl+shift+% - Answers - True

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; Format cells with formulas differently from cells with
inputs, so that it's easy for users to determine where values can be entered or edited.

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

After having copied something, what keystroke combination quickly performs a Paste
Special operation? - Answers - CTRL+ALT+v

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

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

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

COUNT(number1, number2,..) determines the sum of a list of values. - Answers - False;
COUNT(number1, number2,..) Determines the number of values in a list, but it ignores
blank cells and cells with text

If multiple horizontal cells are selected/highlighted, what keystorke combination copies
the formmula(s)/value(s) in the leftmost cell(s) of the selected. Uses the Fill Right
command to copy the contents and format of the leftmost cell of a selected range into
the cells to the right. - Answers - CTRL+R

What keystroke combination quickly applies the number format to two decimal places? -
Answers - CTRL+Shift+! (Ctrl, shift and exclamation mark)

, What keystroke combination quickly applies a border around the selected cell or range?
- Answers - CTRL+Shift+& (Ctrl, shift, and ampersand)

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

#REF! means invalid numerical values in a formula or function - Answers - False; #REF!
means invalid cell reference

The wrong argument type or operand is show by - Answers - #VALUE!

Using cell reference is preferable to directly inputting values into a formula - Answers -
Truee

The best way to center title is to use the merge & Center toolbar/ribbon button -
Answers - False; use Merge Center, use Center Across Selection

What Keystroke combination selects the current column? - Answers - CTRL+space

What Keystroke combination quickly inserts the current time? - Answers - CTRL+Shift+:
(CTRL, SHIFT and colon)

What keystroke Combination switches between currently open workbooks? - Answers -
CTRL+tab

What keystroke combination quickly inserts the current date - Answers - CTRL+; (CTRL
and semi-colon)

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

What keystroke combination moves one screen to the right within the current worksheet
- Answers - ALT + PG DN

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

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

After having copied something, what keystroke combination performs a past operation -
Answers - CTRL+V

What keystroke combination switches (The active worksheet) to the next worksheet (to
the right) ? - Answers - CTRL + PG DN