Microsoft Excel MCQ Questions and Answers - Set 03 - ObjectiveBooks

Microsoft Excel MCQ Questions and Answers - Set 03

Practice Test: Question Set - 03

1. Which of the following is a correct order of precedence in formula calculation?
    (A) Multiplication and division exponentiation positive and negative values
    (B) Multiplication and division, positive and negative values, addition and subtraction
    (C) Addition and subtraction, positive and negative values, exponentiation
    (D) All of above

2. Which of the following options is not located in the Page Setup dialog box?
    (A) Page Break Preview
    (B) Page Orientation
    (C) Margins
    (D) Headers and Footers

3. When you want to insert a blank imbedded excel object in a word document you can
    (A) Click the object command on the insert menu
    (B) Click the office links button on the standard toolbar
    (C) Click the create worksheet button on the formatting toolbar
    (D) Click the import excel command on the file menu

4. You can use the drag and drop method to
    (A) Copy cell contents
    (B) Move cell contents
    (C) Add cell contents
    (D) Both ‘a’ and ‘b’

5. Comments can be added to cells using
    (A) Edit > Comments
    (B) Insert > Comments
    (C) File > Comments
    (D) View > Comments

6. Which of the following is an absolute cell reference?
    (A) !A!1
    (B) $A$1
    (C) #a#1
    (D) A1

7. A worksheet can have a maximum of _______ Number of rows
    (A) 256
    (B) 1024
    (C) 32000
    (D) 65535

8. Getting data from a cell located in a different sheet is called _________
    (A) Accessing
    (B) Referencing
    (C) Updating
    (D) Functioning

9. Excel uniquely identifies cells within a worksheet with a cell name
    (A) Cell names
    (B) Column numbers and row letters
    (C) Column letters and row numbers
    (D) Cell locator coordinates

10. All worksheet formula
    (A) Manipulate values
    (B) Manipulate labels
    (C) Return a formula result
    (D) Use the addition operator

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: