BUSI 520: WEEK 3 (EXCEL FUNDAMENTALS)
QUESTIONS AND ANSWERS
If multiple horizontal cells 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?
Ctrl+r
In Excel, what keystroke combination moves (the active cell) right, to the end of the
current row of contiguous (adjacent) cells with values?
Ctrl+right arrow
In Excel, what keystroke combination closes the current workbook?
Ctrl+F4 and Ctrl+w
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
If A1=2, the resulting value of =3*A1^3 is
24
True/False: In order to maintain consistency within your workbooks, it is important to
format cells with formulas (outputs) using the same colors as cells containing
assumptions and/or values (inputs).
False (Format cells with formulas differently from cells with inputs, so that it's easy for
users to determine where values can be entered or edited. (For example, use a blue
font (and/or a green cell background) for all assumptions. Cells containing formulas
could be left with a black font (and/or "no fill"...a white background.)
True/False: A quick way to apply the percent format is to press Ctrl+Shift+%.
True
True/False: Pressing Ctrl+Shift+# applies the number format.
False
, True/False: You should always adjust column widths first, before attempting to Wrap
Text for the column headings.
False (You should typically Wrap Text for column headings first, before adjusting any
column widths. If you adjust column widths to fit all the data in the columns first, then
some columns will be really, really wide to accommodate long column headings. But
then if you wrap text, it won't appear to wrap because all of the column widths are
already wide enough to fit all the column headings.)
In Excel, what keystroke combination performs an "undo" of the last action?
Ctrl+z
True/False: The best way to center titles is to use the Merge & Center toolbar/ribbon
button.
False (Certain Excel features do not work with Merged cells, and can cause other
annoyances as well. Rather than Merge Center, use Center Across Selection. (Format
cells, Alignment, Horizontal Alignment: Center Across Selection.)
In Excel, what keystroke combination quickly inserts the current time?
Ctrl+Shift+: (Ctrl, Shift and colon)
True/False; A quick way to apply the currency format is to press Ctrl+Shift+$.
True
True/False: The keyboard shortcut sequence of "Alt h, o, y" will autofit the column width
of the active cell or range of cells.
False
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is
0
In Excel, after having copied something, what keystroke combination performs a Paste
operation?
Ctrl+v
True/False: A workbook's documentation sheet should always be showing when saving
the file a final time (right before submitting the file), so that when someone opens your
file, the documentation sheet will be the first sheet seen.
QUESTIONS AND ANSWERS
If multiple horizontal cells 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?
Ctrl+r
In Excel, what keystroke combination moves (the active cell) right, to the end of the
current row of contiguous (adjacent) cells with values?
Ctrl+right arrow
In Excel, what keystroke combination closes the current workbook?
Ctrl+F4 and Ctrl+w
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
If A1=2, the resulting value of =3*A1^3 is
24
True/False: In order to maintain consistency within your workbooks, it is important to
format cells with formulas (outputs) using the same colors as cells containing
assumptions and/or values (inputs).
False (Format cells with formulas differently from cells with inputs, so that it's easy for
users to determine where values can be entered or edited. (For example, use a blue
font (and/or a green cell background) for all assumptions. Cells containing formulas
could be left with a black font (and/or "no fill"...a white background.)
True/False: A quick way to apply the percent format is to press Ctrl+Shift+%.
True
True/False: Pressing Ctrl+Shift+# applies the number format.
False
, True/False: You should always adjust column widths first, before attempting to Wrap
Text for the column headings.
False (You should typically Wrap Text for column headings first, before adjusting any
column widths. If you adjust column widths to fit all the data in the columns first, then
some columns will be really, really wide to accommodate long column headings. But
then if you wrap text, it won't appear to wrap because all of the column widths are
already wide enough to fit all the column headings.)
In Excel, what keystroke combination performs an "undo" of the last action?
Ctrl+z
True/False: The best way to center titles is to use the Merge & Center toolbar/ribbon
button.
False (Certain Excel features do not work with Merged cells, and can cause other
annoyances as well. Rather than Merge Center, use Center Across Selection. (Format
cells, Alignment, Horizontal Alignment: Center Across Selection.)
In Excel, what keystroke combination quickly inserts the current time?
Ctrl+Shift+: (Ctrl, Shift and colon)
True/False; A quick way to apply the currency format is to press Ctrl+Shift+$.
True
True/False: The keyboard shortcut sequence of "Alt h, o, y" will autofit the column width
of the active cell or range of cells.
False
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is
0
In Excel, after having copied something, what keystroke combination performs a Paste
operation?
Ctrl+v
True/False: A workbook's documentation sheet should always be showing when saving
the file a final time (right before submitting the file), so that when someone opens your
file, the documentation sheet will be the first sheet seen.
