BUSI 520 FINAL EXAM QUESTIONS AND CORRECT ANSWERS. VERIFIED 2025/2026.

BUSI 520 FINAL EXAM QUESTIONS AND
CORRECT ANSWERS. VERIFIED
2025/2026.




Rank.eq - ANS 0 - descending order

1 - ascending order



The error message ###### means that there is (are) - ANS 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) - ANS Unrecognized text in a formula



#N/A - ANS No answer can be found



#REF! - ANS Invalid cell reference



#VALUE! - ANS Wrong argument type or operand



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



1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.

,#DIV/0! - ANS Division by zero



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



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



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



Mixed Cell Reference - ANS 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? - ANS CTRL+1 (CTRL and
1)



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



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



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



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

2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.

,What keystroke combination selects the current row? - ANS 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) - ANS CTRL+Minus



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



What keystroke combination quickly applies the general format - ANS 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)
- ANS 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 - ANS Relative



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



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



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




3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.

, 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 - ANS False



COUNT(number1, number2,..) determines the sum of a list of values. - ANS 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. -
ANS CTRL+R



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



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



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



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



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



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




4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.