Practice Test: Question Set - 08
1. You cannot link excel worksheet data to a word document
- (A) With the
right drag method
- (B) With a
hyperlink
- (C) With the
copy and paste special commands
- (D) With the
copy and paste buttons on the standard toolbar
2. Which of following is Not one of Excel’s what-if function?
- (A) Goal seek
- (B) Solver
- (C) Scenario
manager
- (D) Auto Outline
3. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
- (A) Press the
Erase key
- (B) Press Esc
- (C) Press the
Enter button
- (D) Press the
Edit Formula button
4. To delete an embedded objects, first
- (A) Double click
the object
- (B) Select the
object by clicking it
- (C) Press the
Shift + Delete keys
- (D) Select it
and then press the delete key
5. A worksheet range is a
- (A) A
command used for data modeling
- (B) A range of
values such as from 23 to 234
- (C) A group of
cells
- (D) A
group of worksheets
6. Which of the following is not a basic step in creating a worksheet?
- (A) Save
workbook
- (B) Modify
the worksheet
- (C) Enter
text and data
- (D) Copy
the worksheet
7. To activate the previous cell in a pre-selected range, press
- (A) The Alt key
- (B) The Tab key
- (C) The Enter
key
- (D) None of the
above
8. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
- (A) Unfreeze
panes command on the window menu
- (B) Freeze panes
command on the window menu
- (C) Hold titles
command on the edit menu
- (D) Split
command on the window menu
9. A circular reference is
- (A) Geometric
modeling tool
- (B) A cell that
points to a drawing object
- (C) A formula
that either directly or indirectly depends on itself
- (D) Always
erroneous
10. To view a cell comment
- (A) Click the
edit comment command on the insert menu
- (B) Click the
display comment command on the window menu
- (C) Position the
mouse pointer over the cell
- (D) Click the comment
command on the view menu
Next Tests: