BUSI 520 UPDATED EXAM 2 ACTUAL TEST
PAPER 2026 QUESTIONS SOLUTIONS GRADED
A+
◉ Shows format cells dialog window.
Answer: Ctrl+1 (Ctrl and 1)
◉ using cell reference is preferred to directly inputting values into a
formula.
Answer: true
◉ inserts cells.
Answer: Ctrl+Shift+plus
◉ documentation sheet should be showing when saving a file so its
seen first when opening it.
Answer: True
◉ ######.
Answer: cells not wide enough
◉ selects current row.
,Answer: Shift + space
◉ displays formulas.
Answer: Ctrl + `
◉ percent format.
Answer: Ctrl+Shift+%
◉ #REF.
Answer: invalid cell reference
◉ removes a border.
Answer: Ctrl+Shift+_ (Ctrl, Shift and underscore)
◉ wrap text first, then adjust width.
Answer: True
◉ best way to center titles is merge and center.
Answer: False
◉ switch between currently open workbooks.
Answer: Ctrl + tab
,◉ deletes the actual cell.
Answer: 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..
Answer: False
◉ Current Time.
Answer: Ctrl + shift + :
◉ The COUNTA function ignores cells with text.
Answer: 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?.
Answer: Ctrl+r
◉ adds a border.
Answer: Ctrl+Shift+& (Ctrl, Shift and ampersand)
, ◉ moves one screen (worth of columns) to the right within the
current worksheet?.
Answer: Alt+Pg dn
◉ COUNT(number1, number 2, ...) determines the sum of a list of
values..
Answer: False
◉ changes the cell reference type (to absolute, then mixed, then
mixed, then relative) while entering or editing a formula.
Answer: 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.
Answer: Ctrl + d
◉ applies the number format to two decimal places.
Answer: Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
◉ date format.
PAPER 2026 QUESTIONS SOLUTIONS GRADED
A+
◉ Shows format cells dialog window.
Answer: Ctrl+1 (Ctrl and 1)
◉ using cell reference is preferred to directly inputting values into a
formula.
Answer: true
◉ inserts cells.
Answer: Ctrl+Shift+plus
◉ documentation sheet should be showing when saving a file so its
seen first when opening it.
Answer: True
◉ ######.
Answer: cells not wide enough
◉ selects current row.
,Answer: Shift + space
◉ displays formulas.
Answer: Ctrl + `
◉ percent format.
Answer: Ctrl+Shift+%
◉ #REF.
Answer: invalid cell reference
◉ removes a border.
Answer: Ctrl+Shift+_ (Ctrl, Shift and underscore)
◉ wrap text first, then adjust width.
Answer: True
◉ best way to center titles is merge and center.
Answer: False
◉ switch between currently open workbooks.
Answer: Ctrl + tab
,◉ deletes the actual cell.
Answer: 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..
Answer: False
◉ Current Time.
Answer: Ctrl + shift + :
◉ The COUNTA function ignores cells with text.
Answer: 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?.
Answer: Ctrl+r
◉ adds a border.
Answer: Ctrl+Shift+& (Ctrl, Shift and ampersand)
, ◉ moves one screen (worth of columns) to the right within the
current worksheet?.
Answer: Alt+Pg dn
◉ COUNT(number1, number 2, ...) determines the sum of a list of
values..
Answer: False
◉ changes the cell reference type (to absolute, then mixed, then
mixed, then relative) while entering or editing a formula.
Answer: 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.
Answer: Ctrl + d
◉ applies the number format to two decimal places.
Answer: Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
◉ date format.
