Microsoft Excel MCQ Questions and Answers - Set 03 - ObjectiveBooks
Hello everybody! You can translate the content of this page by selecting a language in the select box.

# 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

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
(D) Both ‘a’ and ‘b’

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