BUSI 520 LATEST 2026 TEST PAPER QUESTIONS AND
ANSWERS RATED A+
✔✔In Excel, what keystroke combination quickly applies a border around the selected
cell or range? - ✔✔Ctrl+Shift+& (Ctrl, Shift and ampersand)
✔✔_____ is(are) first in the order of precedence rules. - ✔✔Operations in parentheses
✔✔In Excel, what keystroke combination performs an "undo" of the last action? -
✔✔Ctrl+z
✔✔Always adjust column widths first, before attempting to Wrap Text for the column
headings. - ✔✔False
✔✔In Excel, 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) - ✔✔Ctrl+minus
✔✔Cells formatted with the Number Format (Ctrl+Shift+!) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔In Excel, what keystroke combination moves one screen to the right within the
current worksheet? - ✔✔Alt+Pg dn
✔✔While editing a cell, pressing F2 allows arrow key behavior to switch between
selecting cells or moving the cursor position within the current formula typed in the
formula bar. - ✔✔True
✔✔In Excel, what keystroke combination quickly removes a border from the selected
cell or range? - ✔✔Ctrl+Shift+_ (Ctrl, Shift and underscore)
✔✔In Excel, what keystroke combination selects the current row? - ✔✔Shift+space
✔✔If A1=2, the resulting value of =3*A1^3 is - ✔✔24
✔✔_____ is(are) last in the order of precedence rules. - ✔✔Addition and subtraction
✔✔In Excel, what keystroke combination quickly inserts the current time? -
✔✔Ctrl+Shift+: (Ctrl, Shift and colon)
✔✔If multiple cells 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? - ✔✔Ctrl+d
,✔✔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. - ✔✔False
✔✔In Excel, what keystroke combination shows the format cells dialog window? -
✔✔Ctrl+1 (Ctrl and 1)
✔✔In Excel, after having copied cells, what keystroke combination immediately
performs a Paste Values operation (in recent versions of Excel)? - ✔✔Ctrl+Shift+V
✔✔In Excel, what keystroke combination selects the current column? - ✔✔Ctrl+space
✔✔In the Windows version of Excel, the quickest way to left align data within the current
cell is to use what keystroke combination? - ✔✔Alt h, a, l
✔✔After summing cell to calculate total income, an error message of ########## is
shown in one of your cells. What does this indicate? - ✔✔the cell width is too small to
display the contents
✔✔In Excel, what keystroke combination closes the current workbook? - ✔✔Two of the
answers listed.
✔✔Cells formatted with the Currency format (Ctrl+Shift+$) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔In Excel, what keystroke combination switches (the active worksheet) to the next
worksheet (to the right)? - ✔✔Ctrl+Pg dn (or Ctrl+Fn+Pg dn)
✔✔B1 is an example of a(n) _____ cell reference. - ✔✔relative
✔✔In Excel, what keystroke combination toggles between displaying formulas and
displaying values? - ✔✔Ctrl+` (Ctrl and left quote/grave accent)
✔✔In Excel, what keystroke combination selects right, to the end of the current row of
contiguous (adjacent) cells? - ✔✔Ctrl+Shift+right arrow
✔✔To quickly insert a hyperlink for a particular cell, use what keystroke combination
can be used? - ✔✔Ctrl+k
✔✔Using cell references is preferable to directly inputting values into a formula. -
✔✔True
, ✔✔The formula = COUNT(number1, number 2, ...) determines the sum of a list of
values. - ✔✔False
✔✔The error message #NAME? means that there is (are) - ✔✔unrecognized text in a
formula.
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔To quickly show/hide the Home Ribbon use what keystroke combination? -
✔✔Ctrl+F1 (or Ctrl+Fn+F1)
✔✔In Excel, what keystroke combination jumps (changes the active cell) to the right, to
the end of the current row of contiguous (adjacent) cells with values? - ✔✔Ctrl+right
arrow
✔✔Cells formatted with the default Comma Style (Alt h, k) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔The best way to open a data file saved as a text file (*.txt) is to use the "Get &
Transform Data" features in the Data ribbon. - ✔✔True
✔✔$B1 is an example of a(n) _____ reference. - ✔✔mixed
✔✔If A1=2, B2=3, and C3=10, then what is =A1-B2+C3/10 - ✔✔0
✔✔To quickly toggle Wrap Text use what keystroke combination? - ✔✔Alt h, w
✔✔When renaming a module, a module cannot use the same name as a macro. -
✔✔False
✔✔A(n) _____ cell contains a value that is used in a formula. - ✔✔Precedent
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔The data validation default "Allow" option is _____. - ✔✔any value
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔False
ANSWERS RATED A+
✔✔In Excel, what keystroke combination quickly applies a border around the selected
cell or range? - ✔✔Ctrl+Shift+& (Ctrl, Shift and ampersand)
✔✔_____ is(are) first in the order of precedence rules. - ✔✔Operations in parentheses
✔✔In Excel, what keystroke combination performs an "undo" of the last action? -
✔✔Ctrl+z
✔✔Always adjust column widths first, before attempting to Wrap Text for the column
headings. - ✔✔False
✔✔In Excel, 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) - ✔✔Ctrl+minus
✔✔Cells formatted with the Number Format (Ctrl+Shift+!) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔In Excel, what keystroke combination moves one screen to the right within the
current worksheet? - ✔✔Alt+Pg dn
✔✔While editing a cell, pressing F2 allows arrow key behavior to switch between
selecting cells or moving the cursor position within the current formula typed in the
formula bar. - ✔✔True
✔✔In Excel, what keystroke combination quickly removes a border from the selected
cell or range? - ✔✔Ctrl+Shift+_ (Ctrl, Shift and underscore)
✔✔In Excel, what keystroke combination selects the current row? - ✔✔Shift+space
✔✔If A1=2, the resulting value of =3*A1^3 is - ✔✔24
✔✔_____ is(are) last in the order of precedence rules. - ✔✔Addition and subtraction
✔✔In Excel, what keystroke combination quickly inserts the current time? -
✔✔Ctrl+Shift+: (Ctrl, Shift and colon)
✔✔If multiple cells 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? - ✔✔Ctrl+d
,✔✔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. - ✔✔False
✔✔In Excel, what keystroke combination shows the format cells dialog window? -
✔✔Ctrl+1 (Ctrl and 1)
✔✔In Excel, after having copied cells, what keystroke combination immediately
performs a Paste Values operation (in recent versions of Excel)? - ✔✔Ctrl+Shift+V
✔✔In Excel, what keystroke combination selects the current column? - ✔✔Ctrl+space
✔✔In the Windows version of Excel, the quickest way to left align data within the current
cell is to use what keystroke combination? - ✔✔Alt h, a, l
✔✔After summing cell to calculate total income, an error message of ########## is
shown in one of your cells. What does this indicate? - ✔✔the cell width is too small to
display the contents
✔✔In Excel, what keystroke combination closes the current workbook? - ✔✔Two of the
answers listed.
✔✔Cells formatted with the Currency format (Ctrl+Shift+$) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔In Excel, what keystroke combination switches (the active worksheet) to the next
worksheet (to the right)? - ✔✔Ctrl+Pg dn (or Ctrl+Fn+Pg dn)
✔✔B1 is an example of a(n) _____ cell reference. - ✔✔relative
✔✔In Excel, what keystroke combination toggles between displaying formulas and
displaying values? - ✔✔Ctrl+` (Ctrl and left quote/grave accent)
✔✔In Excel, what keystroke combination selects right, to the end of the current row of
contiguous (adjacent) cells? - ✔✔Ctrl+Shift+right arrow
✔✔To quickly insert a hyperlink for a particular cell, use what keystroke combination
can be used? - ✔✔Ctrl+k
✔✔Using cell references is preferable to directly inputting values into a formula. -
✔✔True
, ✔✔The formula = COUNT(number1, number 2, ...) determines the sum of a list of
values. - ✔✔False
✔✔The error message #NAME? means that there is (are) - ✔✔unrecognized text in a
formula.
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔To quickly show/hide the Home Ribbon use what keystroke combination? -
✔✔Ctrl+F1 (or Ctrl+Fn+F1)
✔✔In Excel, what keystroke combination jumps (changes the active cell) to the right, to
the end of the current row of contiguous (adjacent) cells with values? - ✔✔Ctrl+right
arrow
✔✔Cells formatted with the default Comma Style (Alt h, k) can be aligned within a cell
using the following formats: - ✔✔Any/all of choices listed
✔✔The best way to open a data file saved as a text file (*.txt) is to use the "Get &
Transform Data" features in the Data ribbon. - ✔✔True
✔✔$B1 is an example of a(n) _____ reference. - ✔✔mixed
✔✔If A1=2, B2=3, and C3=10, then what is =A1-B2+C3/10 - ✔✔0
✔✔To quickly toggle Wrap Text use what keystroke combination? - ✔✔Alt h, w
✔✔When renaming a module, a module cannot use the same name as a macro. -
✔✔False
✔✔A(n) _____ cell contains a value that is used in a formula. - ✔✔Precedent
✔✔In Excel, what keystroke combination changes the cell reference type (to absolute,
mixed, mixed, relative) while entering/editing a formula? - ✔✔F4 (or Fn+F4)
✔✔The data validation default "Allow" option is _____. - ✔✔any value
✔✔The name of a macro can contain letters, numbers, spaces, and the underscore
symbol. - ✔✔False
