MS excel set 7 Detailed Explanation And More Example

Question : 1

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

a) Formula

b) Function

c) Series

d) Syntax

e) None of these

Question : 2

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

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

The autofill feature

a) extends a sequential series of data

b) automatically adds range of cell values

c) applies a boarder around the selected cells

d) All the above

e) None of these

Question : 5

How do you display current date only in MS Excel?

a) date ( )

b) Today ( )

c) now( )

d) time( )

e) None of these

Question : 6

What is the short cut key to replace a data with another in sheet?

a) Ctrl + R

b) Ctrl + Shift + R

c) Ctrl + H

d) Ctrl + F

e) None of these