BUSI 520 EXAM AND PRACTICE EXAM NEWEST 2024 ACTUAL EXAM 150 QUESTIONS AND CORREC
DETAILED ANSWERS
Current date - (answer) Ctrl+; (Ctrl and semi-colon)
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
,BUSI 520 EXAM AND PRACTICE EXAM NEWEST 2024 ACTUAL EXAM 150 QUESTIONS AND CORREC
DETAILED ANSWERS
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)
, BUSI 520 EXAM AND PRACTICE EXAM NEWEST 2024 ACTUAL EXAM 150 QUESTIONS AND CORREC
DETAILED ANSWERS
date format - (answer) Ctrl+Shift+#
closes the current workbook - (answer) Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values -
(answer) Ctrl+right arrow
general number format - (answer) Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right) - (answer) Ctrl+Pg dn
$B1 is an example of a(n) _____ reference - (answer) mixed
#NAME? - (answer) unrecognized text in a formula
#VALUE - (answer) wrong argument type or operand is shown by
B1 is an example of a(n) _____ cell reference. - (answer) relative
Currency format - (answer) Ctrl + shift + $
select current column - (answer) ctrl + space
Paste Special operation - (answer) ctrl + alt + v
=$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula - (answer) =$B$4-
SUM(C2:C6)
DETAILED ANSWERS
Current date - (answer) Ctrl+; (Ctrl and semi-colon)
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
,BUSI 520 EXAM AND PRACTICE EXAM NEWEST 2024 ACTUAL EXAM 150 QUESTIONS AND CORREC
DETAILED ANSWERS
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)
, BUSI 520 EXAM AND PRACTICE EXAM NEWEST 2024 ACTUAL EXAM 150 QUESTIONS AND CORREC
DETAILED ANSWERS
date format - (answer) Ctrl+Shift+#
closes the current workbook - (answer) Ctrl + F4
Ctrl + w
moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values -
(answer) Ctrl+right arrow
general number format - (answer) Ctrl + shift + ~
switches (the active worksheet) to the next worksheet (to the right) - (answer) Ctrl+Pg dn
$B1 is an example of a(n) _____ reference - (answer) mixed
#NAME? - (answer) unrecognized text in a formula
#VALUE - (answer) wrong argument type or operand is shown by
B1 is an example of a(n) _____ cell reference. - (answer) relative
Currency format - (answer) Ctrl + shift + $
select current column - (answer) ctrl + space
Paste Special operation - (answer) ctrl + alt + v
=$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula - (answer) =$B$4-
SUM(C2:C6)
