Microsoft Excel Exam Questions MCQs with Answers pdf - Set 08 - ObjectiveBooks

Microsoft Excel Exam Questions MCQs with Answers pdf - Set 08

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment