BUSI 520 FINAL EXAM QUESTIONS WITH CORRECT ANSWERS LATEST UPDATE 2026

BUSI 520 FINAL EXAM QUESTIONS WITH CORRECT ANSWERS LATEST UPDATE 2026 Current date - Answers Ctrl+; (Ctrl and semi-colon) Shows format cells dialog window - Answers Ctrl+1 (Ctrl and 1) using cell reference is preferred to directly inputting values into a formula - Answers true inserts cells - Answers Ctrl+Shift+plus documentation sheet should be showing when saving a file so its seen first when opening it - Answers True ###### - Answers cells not wide enough selects current row - Answers Shift + space displays formulas - Answers Ctrl + ` percent format - Answers Ctrl+Shift+% #REF - Answers invalid cell reference removes a border - Answers Ctrl+Shift+_ (Ctrl, Shift and underscore) wrap text first, then adjust width - Answers True best way to center titles is merge and center - Answers False switch between currently open workbooks - Answers Ctrl + tab deletes the actual cell - Answers Ctrl + - (control plus minus) 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 Current Time - Answers Ctrl + shift + : The COUNTA function ignores cells with text - Answers False If multiple cells (in more than one column) are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of selected cells? - Answers Ctrl+r adds a border - Answers Ctrl+Shift+& (Ctrl, Shift and ampersand) moves one screen (worth of columns) to the right within the current worksheet? - Answers Alt+Pg dn COUNT(number1, number 2, ...) determines the sum of a list of values. - Answers False changes the cell reference type (to absolute, then mixed, then mixed, then relative) while entering or editing a formula - Answers F4 If multiple cells (in more than one row) are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of selected cells - Answers Ctrl + d applies the number format to two decimal places - Answers Ctrl+Shift+! (Ctrl, Shift and exclamation mark) date format - Answers Ctrl+Shift+# closes the current workbook - Answers Ctrl + F4 Ctrl + w moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values - Answers Ctrl+right arrow general number format - Answers Ctrl + shift + ~ switches (the active worksheet) to the next worksheet (to the right) - Answers Ctrl+Pg dn $B1 is an example of a(n) _____ reference - Answers mixed #NAME? - Answers unrecognized text in a formula #VALUE - Answers wrong argument type or operand is shown by B1 is an example of a(n) _____ cell reference. - Answers relative Currency format - Answers Ctrl + shift + $ select current column - Answers ctrl + space Paste Special operation - Answers ctrl + alt + v =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula - Answers =$B$4-SUM(C2:C6) selects left, to the beginning of the current row of contiguous (adjacent) cells - Answers ctrl + shift + left arrow selects left, to the beginning of the current row of contiguous (adjacent) cells - Answers FALSE The option of _____ displays a dialog box that provides all the different paste options. - Answers paste special The formula =TRUNC(4.6) results in the integer value of 5 - Answers False The formula _____ counts all product codes in the range H4:H25 with only a single character followed by QXZ. - Answers =COUNTIF(H4:H25,"?QXZ") To find the 10th largest value from a list of values in cells A1:A100, use _____. - Answers =LARGE(A1:A100,10) The formula =ROUND(10.59%,2) results in the value 0.11 (or 11%, if formatted as a %). - Answers TRUE The equation (New_Value - Old_Value)/Old_Value can be used to calculate the percent difference. - Answers True To count how many "A" grades there in the range C3:C100, use the formula _____. - Answers =COUNTIF(C3:C100,"A") When numbers containing zeros are entered in a cell, if 0 is used as one of the digits in the cell's custom formatting code, that digit displays _____. - Answers B. any digit, regardless of whether it affects the value of the number C. Standard deviation - Answers a measure of how widely the data values are dispersed from the arithmetic mean. The correct formula to count all items in the range E4:E20 that end with a "d" in the third to last position in the text value is _____. - Answers E. =COUNTIF(E4:E20,"*d??") To change the rows of the original cell range to become the columns in the pasted cell range, use the Paste (or Paste Special) Option of _____. - Answers transpose To find the relative position of values within a data set, use the _____ function. - Answers RANK.EQ/ RANK To fix the rows so that a number of rows are displayed in the top pane (and cannot be scrolled) while the bottom pane can be scrolled, ____ - Answers freeze panes A _____ exhibits an equal number of occurrences of data values both above and below the arithmetic mean. - Answers normal distribution The correct formula for counting values in the range D5:D25 that are greater than 90 is _____. - Answers B. =COUNTIF(D5:D25,"90") A professor is interested in comparing the grades for several pairs of students, so he wants to view their grades side-by-side, to see if the grades are similar. What Excel feature is best to use? (You should be able to scroll in both the top window and the bottom window, in order to easily view different pairs of students.) - Answers split window Locking cells or hiding formulas has no effect unless the worksheet is protected. - Answers true The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and is accepted or canceled. - Answers information Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references. - Answers trace precedents Use the _____ button on the Formula Auditing toolbar to keep track of cell properties such as name, value, and formula, even if the cell is out of view - Answers watch window A(n) _____ cell contains a value that is used in a formula. - Answers precedent To display tracer arrows that indicate which formulas use the value in the active cell, use the _____ button on the Formula Auditing toolbar. - Answers trace dependents The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and can be canceled, corrected, or accepted. - Answers warning To automate repetitive or difficult tasks, use a _____, which is a series of commands that you store and then run when you need to perform a task. - Answers macro The data validation default (list box) option is _____. - Answers any value A macro can be tested one step at a time by clicking the _____ button in the Macro dialog box. - Answers step into Data validation rules can contain formulas. - Answers true By changing the Error Checking Rules, you can specify that Excel will alert you about the following: _____. - Answers A. Cells containing years represented as 2 digits C. Formulas which omit cells in a region D. Unlocked cells containing formulas A validation rule can specify _____. - Answers dates, values such as between 1 and 100, decimal number When a worksheet is protected, by default, all cells in the worksheet are unlocked. - Answers false By choosing Protect Sheet, you can prevent a worksheet from being deleted from a workbook. - Answers False _____ prevents inserting, deleting, or renaming worksheets. - Answers workbook protection A _____ specifies the type of data that is appropriate/allowed as content in a cell (...for example, whole numbers, decimal numbers, dates, time, or text). - Answers validation rule _____ are items that are, in fact, incorrect, but are not flagged as such. - Answers false negatives To unlock cells in a protected workbook, click the Locked box to remove the check mark on the Protection tab of the __________. - Answers format cells menu/window The name of a macro can contain letters, numbers, spaces, and the underscore symbol. - Answers false The name of a macro can contain letters, numbers, spaces, and the underscore symbol. - Answers hiding cells so that users cannot see them specifying which actions users can perform locking cells so that users cannot change their contents A(n) _____ cell uses the value in the active cell in its formula. - Answers dependent After you create and test a macro, you can attach a _____ to vouch for its authenticity. - Answers D. digital certificat the Error Alert Style of _____ indicates the entry is incorrect and must be canceled or corrected before continuing. - Answers stop The data validation tool restricts the _____. - Answers data being entered _____ prevents changing, moving, or deleting data. - Answers worksheet protection The Circle Invalid Data button circles cells that _____. - Answers don't meet their data validation criteria Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open the infected document. - Answers true The comparison phrase of "not between" means to identify values outside of lower and upper limits. - Answers true The AND function results in a FALSE value if either Condition #1 or Condition #2 is ___ - Answers false It's usually okay to hard-code (enter) text phrases in IF functions and Conditional formatting rules in order to make the formulas more flexible. - Answers false Relational operators can be used to evaluate dates. - Answers true If the values in cells F3, F4, F5, and F6 are all less than 100, the function =OR(F3100,F4100,F5100,F6100) returns a value of ______. - Answers false The result of the formula =SUM(4,7)11 is _____. - Answers false (Ignoring the initial = that precedes a formula,) you cannot use two operators (=, =, =, etc.) within the same logical_test argument of an IF function unless you also use an additional function such as OR or AND. - Answers true To apply "Cell Value Is" conditional formatting, first _____. - Answers D. select the cells you want to conditionally format The formula =OR(B5:B25) returns a value of _____ if any of the values in B5 through B25 contain the value TRUE. - Answers TRUE When using a IF function, formulas can be used within a Value_if_true or Value_if_false argument if the formula is enclosed within quotation marks. - Answers false =AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct. - Answers only The logical construct =AND(A3:A30) is used when only one item must be TRUE to return a TRUE value. - Answers false Relational operators can only be used to evaluate numbers...not text. - Answers false TRUE and FALSE are Boolean values. - Answers true The relational operator for "not equal" is _____. - Answers If a cell contains the formula =GoodbyeHello the resulting value is _____. (Assume no range names have been defined.) - Answers #NAME? To find whether an integer in cell A1 is in the 20's (20, 21....29), you could use the following formula: =OR(A1=20,A1=29). - Answers false A(n) _____ function returns a value of TRUE if at least one argument is TRUE. - Answers OR to change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____ function. - Answers NOT To evaluate a logical test and return a TRUE or FALSE value, you need to use an IF function. - Answers false When using an OR function, if only one of two arguments equals FALSE (and the other argument equals TRUE), an OR function results in a value of _____. - Answers true If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula =OR(F3:F6100) will always return a value of TRUE - Answers false A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE. - Answers or The OR function evaluates logical arguments to determine if at least one argument is TRUE. - Answers true