BUSI 520 Comprehensive Business Final Exam Practice Questions 2026

BUSI 520
Comprehensive
Business Final Exam
Practice Questions
2026

,The error message ###### means that there is (are) - correct answer Column width of a cell is too narrow to
k k k k k k k k k k k k k k k k k k k k k




display numeric data, or a formula in a cell results in a negative date, a date prior to 1/1/1900
k k k k k k k k k k k k k k k k k k




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




#N/A - correct answer No answer can be found
k k k k k k k k




#REF! - correct answer Invalid cell reference
k k k k k k




#VALUE! - correct answer Wrong argument type or operand k k k k k k k k




#NUM! - correct answer Invalid numeric values in a formula or function
k k k k k k k k k k k




#DIV/0! - correct answer Division by zero k k k k k k




COUNT(number1, [number2],..) - correct answer Determines the number of values in a list, but it ignores k k k k k k k k k k k k k k k k




blank cells and cells with text
k k k k k




COUNTA(number1,[number2]...) - correct answer Determines the number of values in a list but does not k k k k k k k k k k k k k k k




ignore text cells k k




Absolute cell referencing - correct answer Indicates that a cell reference should remain unchanged when
k k k k k k k k k k k k k k k




copying. Ex: $A$19 k k




Mixed Cell Reference - correct answer A cell reference that has only one $
k k k k k k k k k k k k k




Common when you need to copy a formula both down a column and across a row at the same ti
k k k k k k k k k k k k k k k k k k k




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




___ is(are) first in the order of precedence rules - correct answer Operations in parentheses
k k k k k k k k k k k k k k

,What Keystroke combination selects right, to the end of the current row of contiguous (adjacent) cells? -
k k k k k k k k k k k k k k k k k




correct answer CTRL+Shift+right arrow k k k




What keystroke combination toggles between displaying formulas and displaying values? - correct answer
k k k k k k k k k k k k k




CTRL+`



You should always adjust column width first before attempting to wrap text for the column headings. - correct
k k k k k k k k k k k k k k k k k k




answer False; you should always wrap text for column headings first before adjusting any column widths
k k k k k k k k k k k k k k k




What keystroke combination selects the current row? - correct answer Shift+space
k k k k k k k k k k




After selecting a range of cells, what keystroke combination deletes those cells? (Not just deletes the contents
k k k k k k k k k k k k k k k k k




of cells, but deletes the actual cells, so that other cells adjust to replace the deleted cells) - correct answer
k k k k k k k k k k k k k k k k k k k k




CTRL+Minus



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




What keystroke combination quickly applies the general format - correct answer CTRL+Shift+~ (Ctrl, Shift and
k k k k k k k k k k k k k k k




tilde)



In order to maintain consistency within your workbooks, it is important to format cells with formulas
k k k k k k k k k k k k k k k k




(outputs) using the same colors as cells containing assumptions and/or values (inputs) - correct answer False;
k k k k k k k k k k k k k k k k




Format cells with formulas differently from cells with inputs, so that it's easy for users to determine where
k k k k k k k k k k k k k k k k k k




values can be entered or edited. k k k k k




B1 is an example of a(n) ___ cell reference - correct answer Relative
k k k k k k k k k k k k




After having copied something, what keystroke combination quickly performs a Paste Special operation? -
k k k k k k k k k k k k k k




correct answer CTRL+ALT+v k k




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

, The COUNTA function ignores cells with text - correct answer False ; Determines the number of values in a list
k k k k k k k k k k k k k k k k k k k k




but does not ignore text cells
k k k k k




When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely
k k k k k k k k k k k k k k k k k k k k k




saved in either .csv, .xls or xlsx format - correct answer False
k k k k k k k k k k k k




COUNT(number1, number2,..) determines the sum of a list of values. - correct answer False; k k k k k k k k k k k k k k




COUNT(number1, number2,..) Determines the number of values in a list, but it ignores blank cells and cells k k k k k k k k k k k k k k k k k




with text k




If multiple horizontal cells are selected/highlighted, what keystorke combination copies the
k k k k k k k k k k k




formmula(s)/value(s) in the leftmost cell(s) of the selected. Uses the Fill Right command to copy the contents k k k k k k k k k k k k k k k k k




and format of the leftmost cell of a selected range into the cells to the right. - correct answer CTRL+R
k k k k k k k k k k k k k k k k k k k




What keystroke combination quickly applies the number format to two decimal places? - correct answer
k k k k k k k k k k k k k k k




CTRL+Shift+! (Ctrl, shift and exclamation mark) k k k k k




What keystroke combination quickly applies a border around the selected cell or range? - correct answer
k k k k k k k k k k k k k k k k




CTRL+Shift+& (Ctrl, shift, and ampersand) k k k k




Pressing CTRL+Shift+# applies the number format - correct answer False, CTRL+Shift+! (Ctrl, shift and
k k k k k k k k k k k k k k




exclamation mark) applies the number format k k k k k




#REF! means invalid numerical values in a formula or function - correct answer False; #REF! means invalid cell
k k k k k k k k k k k k k k k k k k




reference



The wrong argument type or operand is show by - correct answer #VALUE!
k k k k k k k k k k k k




Using cell reference is preferable to directly inputting values into a formula - correct answer Truee
k k k k k k k k k k k k k k k




The best way to center title is to use the merge & Center toolbar/ribbon button - correct answer False; use
k k k k k k k k k k k k k k k k k k k k




Merge Center, use Center Across Selection
k k k k k