Practice Test: Question Set - 09
1. You can enter which types of data into worksheet cells?
- (A) Labels,
values and formulas
- (B) Labels
and values but not formulas
- (C) Values and
formulas but not labels
- (D) Formulas
only
2. Which of the following is the latest version of Excel?
- (A) Excel 2000
- (B) Excel 2002
- (C) Excel ME
- (D) Excel XP
3. You can use drag-and-drop to embed excel worksheet data in a word document
- (A) By dragging
a range of excel data to the word button on the taskbar while pressing the Ctrl
key
- (B) By dragging
a range of excel data to the word button on the taskbar while pressing Shift
key
- (C) By dragging
a range of excel data to the word button on the taskbar while pressing Alt key
- (D) None of
above
4. How can you print three copies of a workbook?
- (A) Select File >
Properties form the menu and type 3 in the Copies to print text box
- (B) Select File
> Print from the menu and type 3 in the Number of copies text box
- (C) Click the
Print button on the standard toolbar to print the document then take it to
Kinko’s and have 2 more copies made
- (D) Press
Ctrl+P+3
5. In a worksheet you can select
- (A) The entire
worksheet
- (B) Rows
- (C) Columns
- (D) All of the
above
6. An excel workbook is a collection of
- (A) Workbooks
- (B) Worksheets
- (C) Charts
- (D) Worksheets
and charts
7. Which elements of worksheet can be protected from accidental modification?
- (A) Contents
- (B) Objects
- (C) Scenarios
- (D) All of above
8. Which of the following formulas is not entered correctly?
- (A) =10+50
- (B) =B7*B1
- (C) =B7+14
- (D) 10+50
9. How do you delete a column?
- (A) Select the
column heading you want to delete and select the Delete Row button on the
standard toolbar
- (B) Select the
column heading you want to delete and select Insert Delete from the menu
- (C) Select the
row heading you want to delete and select Edit > Delete from the menu
- (D) Right
click the column heading you want to delete and select delete from the shortcut
menu
10. Status indicators are located on the
- (A) Vertical
scroll bar
- (B) Horizontal
scroll bar
- (C) Formula bar
- (D) Standard
toolbar
Next Tests:
Blogger Comment
Facebook Comment