MCQ on Microsoft Excel with Answers - Set 09 - ObjectiveBooks
MCQ on Microsoft Excel with Answers - Set 09

MCQ on Microsoft Excel with Answers - Set 09

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
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: