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
Next Tests: