BUSI 520 Final Exam Questions and Answers Latest

BUSI 520 Final Exam Questions and Answers Latest 2025-2026

rank.eq - Answers 0 - descending order

1 - ascending order

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

What keystroke combination inserts cells? - Answers CTRL+Shift+Plus

What Keystroke combination closes the current workbook? - Answers CTRL+F4 and CTRL+W

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

What keystroke combination quickly removes a border from the selected cell or range? -
Answers CTRL_SHIFT_ (Ctrl, shift and underscore)