BUSI 520 Final Exam Review 2026/2027

BUSI 520
Final Exam
Review
2026/2027

,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




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 k




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




If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula? - correct
k k k k k k k k k k k k k k k k k k k




answer =$B$4-SUM(C2:C6) k




In Excel, what keystroke combination shows the format cells dialog window? - correct answer Ctrl+1 (Ctrl and
k k k k k k k k k k k k k k k k k




1)



In Excel, what keystroke combination quickly inserts the current time? - correct answer Ctrl+Shift+: (Ctrl, Shift
k k k k k k k k k k k k k k k k




and colon) 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




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




$B1 is an example of a(n) _____ reference. - correct answer Mixed
k k k k k k k k k k k




In Excel, what keystroke combination selects the current column? - correct answer CTRL + Space
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 - PEMDAS
k k k k k k k k k k k k k k k k




COUNT(number1, number 2, ...) 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 k




A workbook's documentation sheet should always be showing when saving the file a final time (right before
k k k k k k k k k k k k k k k k k




submitting the file), so that when someone opens your file, the documentation sheet will be the first sheet
k k k k k k k k k k k k k k k k k k




seen. - correct answer True
k k k k

, What keystroke combination switches between currently open workbooks? - correct answer CTRL + Tab
k k k k k k k k k k k k k




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




formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of k k k k k k k k k k k k k k k k k k k k




selected cells? - correct answer CTRL + r k k k k k k k




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




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




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




- correct answer False
k k k k




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




In Excel, what keystroke combination selects right, to the end of the current row of contiguous (adjacent)
k k k k k k k k k k k k k k k k k




cells? - correct answer CTRL + Shift + Right Arrow
k k k k k k k k k




In Excel, after having copied something, what keystroke combination performs a Paste operation? - correct
k k k k k k k k k k k k k k k




answer CTRL + v k k k




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




In Excel, what keystroke combination quickly applies a border around the selected cell or range? - correct
k k k k k k k k k k k k k k k k k




answer Ctrl+Shift+& (Ctrl, Shift and ampersand)
k k k k k




In Excel, what keystroke combination performs an "undo" of the last action? - correct answer CTRL + z
k k k k k k k k k k k k k k k k k




A quick way to apply the currency format is to press Ctrl+Shift+$. - correct answer True
k k k k k k k k k k k k k k k