MS excel set 7 Detailed Explanation And More Example

Question : 1

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

Which language is used to create macros in Excel?

a) Visual Basic 4

b) C

c) Visual C++

d) Java

e) None of these

Question : 3

How do you display current date and time In MS Excel?

a) date( )

b) Today ( )

c) now( )

d) time( )

e) None of these

Question : 4

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

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

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