Practice Test: Question Set - 07
1. To create a formula, you can use:
- (A) Values but
not cell references
- (B) Cell
references but not values
- (C) Values or
cell references although not both at the same time
- (D) Value and
cell references
2. You can use the formula palette to
- (A) Format cells
containing numbers
- (B) Create and
edit formulas containing functions
- (C) Enter
assumptions data
- (D) Copy a range
of cells
3. Which of the following is not a valid data type in excel
- (A) Number
- (B) Character
- (C) Label
- (D) Date/time
4. How can you delete a record?
- (A) Delete the
column from the worksheet
- (B) Select
Data > Form from the menu to open the Data Form dialog box, find the record
and Click the Delete button
- (C) Select Data
> Delete Record from the menu
- (D) Click the
Delete button on the Standard toolbar
5. Which menu option can be sued to split windows into two?
- (A) Format >
window
- (B) View >
window > split
- (C) Window >
split
- (D) View >
split
6. The chart wizard term data series refers to
- (A) A chart
legend
- (B) A collection
of chart data markers
- (C) A set of
values you plot in a chart
- (D) A data label
7. A numeric value can be treated as a label value if it proceeds with
- (A) Apostrophe
(&lsquo
- (B) Exclamation
(!)
- (C) Hash (#)
- (D) Ampersand
(&
8. You can activate a cell by
- (A) Pressing the
Tab key
- (B) Clicking the
cell
- (C) Pressing an
arrow key
- (D) All of the
above
9. When integrating word and excel, word is usually the
- (A) Server
- (B) Destination
- (C) Client
- (D) Both ‘b’ and
‘c’
10. Which button do you click to add up a series of numbers?
- (A) The autosum
button
- (B) The Formula
button
- (C) The
quicktotal button
- (D) The total
button
Next Tests: