Practice Test: Question Set - 10
1. When a label is too long to fit within a worksheet cell, you typically must
- (A) Shorten the
label
- (B) Increase the
column width
- (C) Decrease the
column width
- (D) Adjust the
row height
2. You can use the horizontal and vertical scroll bars to
- (A) Split a
worksheet into two panes
- (B) View
different rows and columns edit the contents of a cell
- (C) Edit the
contents of a cell
- (D) View
different worksheets
3. Which area in an excel window allows entering values and formulas
- (A) Title bar
- (B) Menu bar
- (C) Formula bar
- (D) Standard
toolbar
4. Which of the following is a popular DOS based spreadsheet package?
- (A) Word
- (B) Smart cell
- (C) Excel
- (D) Lotus 1-2-3
5. The Paste Special command lets you copy and paste:
- (A) Multiply the
selection by a copied value
- (B) Cell
comments
- (C) Formatting
options
- (D) The
resulting values of a formula instead of the actual formula
6. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
- (A) Press Ctrl
+Home
- (B) Press Home
- (C) Press Shift
+ Home
- (D) Press Alt +
Home
7. Files created with Lotus 1-2-3 have an extension
- (A) DOC
- (B) XLS
- (C) 123
- (D) WK1
8. Which of the following is not a worksheet design criterion?
- (A) Efficiency
- (B) Aditibility
- (C) Description
- (D) Clarity
9. Which symbol must all formula begin with?
- (A) =
- (B) +
- (C) (
- (D) @
10. Which of the following is not an example of a value?
- (A) 350
- (B) May 10, 2001
- (C) 0.57
- (D) Serial
Number 50771
Next Tests: