MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
1. In Excel, what keystroke Ctrl + Shift + &
combination quickly applies a
border around the se- lected cell
or range?
Ctrl + r
2. If multiple horizontal cells are
select- ed/highlighted, what
keystroke com- bination 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?
3. COUNT function A function that determines how many cells
in a range contain a number.
4. What keystroke combination border from the se-
switches between currently open lected cell or range?
workbooks?
9. In Excel, what keystroke
5. A quick way to apply the combination closes the
currency for- mat is to press current workbook?
Ctrl+Shift+$.
6. The error message ######
means that there is(are)
7. In Excel, what keystroke
combination selects the current
row?
8. In Excel, what keystroke
combination quickly removes a
1/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
Ctrl + Tab Shift + space
True Ctrl + Shift + _
insuflcient width in the cell to display data, or negative
date/time Ctrl + F4 OR Ctrl + w
10. #REF! invalid cell reference
2/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
11. The error message #NAME? unrecognized text in a formula.
means that there is(are)
12. Do you wrap text or adjust You should always Wrap Text for column
column widths first? headings first, before adjusting any column
widths!
13. In Excel, after selecting a range of cells, Ctrl + minus
what keystroke combination
deletes those cells?
14. In Excel, what keystroke Ctrl+; (Ctrl and semi-colon)
combination quickly inserts the
current date?
15. COUNTA function A function that returns the number of cells
in the selected range that contain text or
values, but not blank cells.
16. B1 is an example of a(n) cell refer- Relative
ence.
17. If multiple cells are 19. $B1 is an example of
selected/high- lighted, what a(n)
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?
18. The wrong argument type or
operand is shown by
3/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
Ctrl + d
#VALUE!
Mixed
4/
35
Correct!!!
1. In Excel, what keystroke Ctrl + Shift + &
combination quickly applies a
border around the se- lected cell
or range?
Ctrl + r
2. If multiple horizontal cells are
select- ed/highlighted, what
keystroke com- bination 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?
3. COUNT function A function that determines how many cells
in a range contain a number.
4. What keystroke combination border from the se-
switches between currently open lected cell or range?
workbooks?
9. In Excel, what keystroke
5. A quick way to apply the combination closes the
currency for- mat is to press current workbook?
Ctrl+Shift+$.
6. The error message ######
means that there is(are)
7. In Excel, what keystroke
combination selects the current
row?
8. In Excel, what keystroke
combination quickly removes a
1/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
Ctrl + Tab Shift + space
True Ctrl + Shift + _
insuflcient width in the cell to display data, or negative
date/time Ctrl + F4 OR Ctrl + w
10. #REF! invalid cell reference
2/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
11. The error message #NAME? unrecognized text in a formula.
means that there is(are)
12. Do you wrap text or adjust You should always Wrap Text for column
column widths first? headings first, before adjusting any column
widths!
13. In Excel, after selecting a range of cells, Ctrl + minus
what keystroke combination
deletes those cells?
14. In Excel, what keystroke Ctrl+; (Ctrl and semi-colon)
combination quickly inserts the
current date?
15. COUNTA function A function that returns the number of cells
in the selected range that contain text or
values, but not blank cells.
16. B1 is an example of a(n) cell refer- Relative
ence.
17. If multiple cells are 19. $B1 is an example of
selected/high- lighted, what a(n)
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?
18. The wrong argument type or
operand is shown by
3/
35
, MAC 707 Final Exam Review Questions & Answers Rated 100%
Correct!!!
Ctrl + d
#VALUE!
Mixed
4/
35
