Practice Test: Question Set - 05
1. How many characters can be typed in a single cell in Excel?
- (A) 256
- (B) 1024
- (C) 32000
- (D) 65535
2. Tab scrolling button
- (A) Allow you to
view a different worksheet
- (B) Allow you to
view additional worksheet rows down
- (C) Allow you to
view additional worksheet columns to the right
- (D) Allow you to
view additional sheets tabs
3. The auto calculate feature
- (A) Can only add
values in a range of cells
- (B) Provides a
quick way to view the result of an arithmetic operation on a range of cells
- (C) Automatically
creates formulas and adds them to a worksheet
- (D) Both A and C
4. Which of the following will not cut information?
- (A) Pressing
Ctrl + C
- (B) Selecting
Edit > Cut from the menu
- (C) Clicking the
Cut button on the standard
- (D) Pressing
Ctrl+X
5. How do you select an entire column?
- (A) Select Edit
> Select > Column from the menu
- (B) Click the
column heading letter
- (C) Hold down
the shift key as you click anywhere in the column
- (D) Hold down
the Ctrl key as you click anywhere in the column
6. How can you find specific information in a list?
- (A) Select Tools
> Finder from the menu
- (B) Click the
Find button on the standard toolbar
- (C) Select
Insert > Find from the menu
- (D) Select
Data > Form from the menu to open the Data Form dialog box and click the
Criteria button
7. Multiple calculations can be made in a single formula using
- (A) Standard
formulas
- (B) Array
formula
- (C) Complex
formulas
- (D) Smart
formula
8. When you link data maintained in an excel workbook to a word document
- (A) The word
document cannot be edit
- (B) The
word document contains a reference to the original source application
- (C) The word
document must contain a hyperlink
- (D) The word
document contains a copy of the actual data
9. Which of the following is the oldest spreadsheet package?
- (A) VisiCalc
- (B) Lotus 1-2-3
- (C) Excel
- (D) StarCalc
10. Excel files have a default extension of
- (A) Xls
- (B) Xlw
- (C) Wk1
- (D) 123
Next Tests: