MS excel set 7 Detailed Explanation And More Example

Question : 1

In Excel the auto fill feature

a) Extends a sequential series of data

b) Automatically adds a range of cell values

c) Applies a boarder around selected cells

d) None of above

Question : 2

To select several cells or ranges that are not touching each other, you would ... while selecting

a) hold down the Ctrl key

b) hold down the Shift key

c) hold down the Alt key

d) hold down Ctrl + Shin key

e) None of these

Question : 3

Hyperlinks can be

a) Text

b) Drawing objects

c) Pictures

d) All of above

e) None of these

Question : 4

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

a) Point to speech on the tools menu, and then click show text to speech toolbar.

b) Click validation on the data menu

c) Point to speech on the tools menu, and then click speech recognition

d) All of above

e) None bf these

Question : 5

Qtr 1, Qtr 2, Qtr 3 is an example of a

a) Formula

b) Function

c) Series

d) Syntax

e) None of these

Question : 6

Which of the following describes how to select all the cells in a single column?

a) Right click on column and select Pick from list

b) Use data - text to columns menu item

c) Left click on the gray column title button

d) Pressing Ctrl + A on the keyboard

e) None of these