MS excel set 7 Detailed Explanation And More Example

Question : 1

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 : 2

Hyperlinks can be

a) Text

b) Drawing objects

c) Pictures

d) All of above

e) None of these

Question : 3

Which is not an advantage of using computerized spread sheets?

a) flexibility of moving entries

b) speed of calculation

c) ability of generate tables

d) cost of initial setup

e) None of these

Question : 4

There are three types of data found in a spreadsheet.

a) data, words, numbers

b) equations, data, numbers

c) words, numbers, labels

d) numbers formulas, labels

e) None of these

Question : 5

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 : 6

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

a) Formula

b) Function

c) Series

d) Syntax

e) None of these